github nodejs mysql_GitHub - Jackie-Zhong/CRUD_nodejs_mysql: 用nodejs+mysql简单实现的增删改查，后续有更完整深入的学习可以在此基...

*1、CRUD_nodejs_mysql*

*1.1、查*

*简要描述*

· 查询

*请求URL*

· 127.0.0.1:8989/queryById

*请求方式*

· POST

*请求示例*

{ "id":3}

*返回示例*

[ { "id": 3, "weight": "80", "color": "yellow" }]

*1.2、改*

*简要描述*

· 修改

*请求URL*

· 127.0.0.1:8989/update

*请求方式*

· POST

*请求示例*

{ "id":1, "weight":"190", "color":"white"}

*返回示例*

{ "msg": "ok", "weight": "190", "color": "white"}

*1.3、查*

*简要描述*

· 查询

*请求URL*

· 127.0.0.1:8989/queryById

*请求方式*

· POST

*请求示例*

{ "id":3}

*返回示例*

[ { "id": 3, "weight": "80", "color": "yellow" }]

*1.4、增*

*简要描述*

· 增加

*请求URL*

· 127.0.0.1:8989/add

*请求方式*

· POST

*请求示例*

{ "weight":"80", "color":"blue"}

*返回示例*

{ "msg": "ok", "weight": "66", "color": "blue"}