Vue + Node 手机号、密码登录 后端逻辑

//***Server > db > userSql.js >
//验证数据库中的用户相关内容
const User = {
    //查询用户手机号
    queryUserTel(option) {
        return 'select * from user where tel = ' + option.userTel + '';
    },
    queryUserPwd(option) {
        return 'select * from user where (tel = ' + option.userTel + ') and pwd = ' + option.userPwd + '';
    }
}

exports = module.exports = User;

//***Server > routes > index.js >
const User = require('../db/userSql.js')
//登录接口
router.post('/api/login', function (req, res, next) {
  //后端要接收前端传递过来的值
  let params = {
    userTel: req.body.userTel,
    userPwd: req.body.userPwd
  };
  //用户手机号是否存在
  connection.query(User.queryUserTel(params), function (error, results) {
    if (results.length > 0) {
      //手机号存在
      connection.query(User.queryUserPwd(params), function (error, results) {
        if (results.length > 0) {
          //手机号和密码都对
          res.send({
            code: 200,
            data: {
              success: true,
              msg: '登录成功',
              data: results[0]
            }
          })
        } else {
          //密码不对
          res.send({
            code: 302,
            data: {
              success: false,
              msg: '密码不对'
            }
          })
        }
      })
    } else {
      //不存在
      res.send({
        code: 301,
        data: {
          success: false,
          msg: '手机号不存在'
        }
      })
    }
  })
});