实战 Node 第6天:开发更新商品接口
前言
在前面《实战 Node 第5天:开发商品查询(模糊查询与条件查询)接口》已经学习了开发商品查询接口。 今天来学习如何开发更新商品接口。
一、创建更新商品接口
根据商品编号进行商品更新。
var logger = require('../logConfig');
var connection = require('../sqlConfig');
var Response = require('./response');
function updateProduct(req, res) {
//打印请求报文
logger.info(req.body);
var param = req.body;
var productId = param.productId;
var productName = param.productName;
var productType = param.productType;
var productPrice = param.productPrice;
var productImg = param.productImg;
var productDes = param.productDes;
var response = new Response(false, '', -1,[]);
if(productId!=''){
connection.query("update product set product_name ="+productName+
",product_type = "+productType+
",product_price = "+productPrice+
",product_img = "+productImg+
",product_des = "+productDes+
" where product_id = "+ productId,function (error, results, fields) {
if (error) throw error;
response = new Response(true, '更新成功', 1, results);
});
}
logger.info(response);
res.send(response);
}
module.exports = updateProduct;
二、更新统一服务入口
var express = require('express');
var app = express();
var bodyParser = require('body-parser');
app.use(bodyParser.json());
var register = require('./api/register');
var login = require('./api/login');
var addProduct = require('./api/addProduct');
var getProductList = require('./api/getProductList');
var getListByKey = require('./api/getListByKey');
var getListByCondition = require('./api/getListByCondition');
var updateProduct = require('./api/updateProduct');
app.post('/register',(req, res)=> register(req, res));
app.post('/login',(req, res)=> login(req, res));
app.post('/addProduct',(req, res)=> addProduct(req, res));
app.post('/getProductList',(req, res)=> getProductList(req, res));
app.post('/getListByKey',(req, res)=> getListByKey(req, res));
app.post('/getListByCondition',(req, res)=> getListByCondition(req, res));
app.post('/updateProduct',(req, res)=> updateProduct(req, res));
//监听 8081 端口
app.listen(8081);
项目目录如下:
三、测试接口是否成功
- 使用 postman 验证接口。
- 验证商品更新接口
1)选择请求方式为 POST, 在地址栏中输入 http://localhost:8080/updateProduct 在 Body 中添加相关参数。
2)查看数据库数据是否相符。
四、sql 语句总结
- 更新商品 sql 语句如下。
"update product set product_name ="+productName+
",product_type = "+productType+
",product_price = "+productPrice+
",product_img = "+productImg+
",product_des = "+productDes+
" where product_id = "+ productId,