controller

const { exec } = require(’…/db/mysql’)

const loginCheck = (username, password) => {
const sql = select username, realname from users where username='${username}' and password='${password};'
return exec(sql).then(rows => {
return rows[0] || {}
})
}
module.exports = {
loginCheck
}

router

const { loginCheck } = require(’…/controller/user’)
const { SuccessModel, ErrorModel } = require(’…/model/resModel’)

const handleUserRouter = (req, res) => {
const method = req.method //GET POST

//登陆
if (method === 'POST' && req.path === '/api/user/login') {
    const { username, password } = req.body
    const result = loginCheck(username, password)
    return result.then(data => {
        if (data.username) {
            return new SuccessModel()
        }
        return new ErrorModel('登陆失败')
    })
}

}

module.exports = handleUserRouter

不管用户名密码是否正确，都返回的登录失败，不知到底是哪里的原因