1.创建数据库及user表
2.安装mysql
3.连接数据库
// 登录
router.post('/api/login', function (req, res, next) {
//前端给后端的数据
let params = {
userName: req.body.account,
passWord: req.body.pwd
}
console.log(params);
connection.query(user.queryUserName(params), function (error, results, fields) {
if (results.length > 0) {
connection.query(user.queryUserPwd(params), function (err, result) {
if (results.length > 0) {
res.send({
code: 200,
data: {
success: true,
msg: "登录成功",
}
})
} else {
res.send({
code: 400,
data: {
success: false,
msg: "密码错误",
}
})
}
})
}
})
});