006 nodejs服务端mysql常见增删改查操作

一、创建mysql连接模块

https://blog.csdn.net/qq_15980721/article/details/101437730

二、引入针对于MySQL连接模块

var db = require("../config/db");

三、数据库操作：增加数据

router.post("/add", function (req, res, next) {
  var date = new Date().getTime();
  var key = md5(date).substring(5);
  var kdid = md5(key + date).substring(10);
  var username = req.body.username;
  var password = req.body.password;
  db.query("insert into user(kdid,username,password,key,temp) values('" + kdid + "','" + username +"','" + password + "','" + key+ "','1')", function (err, rows) {
    if (err) {
      res.send("新增失败" + err);
    } else {
      res.redirect("/login");
    }
  });
});

四、数据库操作：查询数据

router.post("/login", function (req, res, next) {
  var username = req.body.username;
  var password = req.body.password;
  var sql = "SELECT * FROM user WHERE username='" + username + "' AND password='"+password+"'";
  db.query(sql, function (err, rows) {
    if (err||rows == '') {
      res.send("登录失败");
      console.log(err)
    } else {
  console.log(rows)

      // res.redirect("/");
      res.send({title: "登录成功", data:rows})
    }
  });
});

五、数据库操作：改变数据

router.post("/update", function (req, res, next) {
  var id = req.body.id;
  var name = req.body.name;
  var age = req.body.age;
  var sql = "update user set name = '" + name + "',age = '" + age + "' where id = " + id;
  console.log(sql);
  db.query(sql, function (err, rows) {
    if (err) {
      res.send("修改失败 " + err);
    } else {
      res.redirect("/users");
    }
  });
});

六、数据库操作：删除数据

router.get("/del/:id", function (req, res) {
  var id = req.params.id;
  db.query("delete from user where id = " + id, function (err, rows) {
    if (err) {
      res.send("删除失败" + err);
    } else {
      res.redirect("/users");
    }
  });
});