Node.js 操作mysql数据库

Node.js 操作mysql数据库

const mysql = require('mysql');
let connection = mysql.createConnection({
	host:'xxxxx',
	user:'root',
	password:"111222333",
	database:'vue-tea'
})
module.exports = connection;

connection.query(sql语句, function (error, results){}

增
`insert into address (uId,name,tel,province,city,county,addressDetail,isDefault,areaCode) values (${uId},"${name}","${tel}","${province}","${city}","${county}","${addressDetail}","${isDefault}","${areaCode}"`
删
`delete from goods_cart where id = ${arrId[i]}`
改
`update goods_cart set goods_num = replace(goods_num,${num},${changeNum}) where id = ${id}`
查
`select * from goods_cart where id = ${id}`

api接口
var express = require('express');
var router = express.Router();
router.post('/api/list', function (req, res, next) {
	let token = req.headers.token; //请求头数据
	let id = req.body.id;//请求体数据
	let id = req.query.id;//路径数据
	connection.query(sql,function(err,data){
		res.send({
			data: {
				code: 200,
				success: true,
				data: data
			}
		})
	})
})