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('添加完成')
});
