Express处理post请求，并将值加入MySQL数据库

db.js

// 创建数据库连接
const mysql = require("mysql")
const connection = mysql.createConnection({
    host: 'localhost',
    port: 3306,
    user: "root",
    password: "root",
    database: "test"
})
connection.connect((err) => {
    if (err) {
        console.log(err)
        console.log('连接失败')
    } else {
        console.log('连接成功')
    }
})


const query = (sql, callback) => {
    connection.query(sql, function (err, rows) {
        console.log(rows)
        console.log(err)
    });
}
exports.query = query

处理请求.js

var query = require('../server/config/db')
router.post('/insertUserDetail',function(req,res){
  console.log(JSON.stringify(req.body))
  var sql=`insert into userdetail (userName, userPassword) values ('${req.body.userName}','${req.body.userPassword}')`;
  console.log(sql)
  query.query(sql,res);
  res.send('添加完成')
});