前后端交互注册 数据储存到数据库

后端注册：

写在路由级别里

var express = require('express');
var router = express.Router();
const db = require("../db/index");

/* GET users listing. */
router.post('/reg', async function (req, res, next) {
  let { username = '', age = 0, addr = '', tel = '' } = req.body;
  console.log(username,age,addr,tel);
  //表单校验
  if (!username || !tel) {
    res.send({
      code: 501, msg: "用户名、电话为必填项"
    })
    return;
  }
  //注册流程
  //将数据放入数据库中
  //1.检测用户名是否重复
  let [err0, rst0] = await db.operator(`SELECT * FROM user WHERE name=?`,[username])  ;//占位符
  if (err0) {
    res.send({ code: 502, msg: "数据库操作失败：" + err0 })
    return;
  }
  if (rst0.length > 0) {
    res.send({ code: 503, msg: "用户名已注册" })
    return;
  }
  //2.不重复的用户名，可以注册
  let [err, data] = await db.operator(`INSERT INTO user (name,age