nodejs(5)crypto加密解密使用实例

const express = require("express");
const app = express();
const mysql = require("mysql");
const crypto = require("crypto");

app.listen(3000, function (err) {
  if (!err) {
    console.log("监听成功");
  }
});
//链接数据库
var db = mysql.createConnection({
  host: "**************",
  user: "root",
  password: "***",
  database: "****",
});

db.connect((err) => {
  if (!err) {
    console.log("数据库连接成功");
  }
  console.log(err);
});

app.post("/register", (req, res, next)=> {
  let username = req.body.username;
  let password = req.body.password;

  let md5 = crypto.createHash("md5");
  let newpass = md5.update(password).digest("hex");
  let sql = `insert into wangtinguser values('${username}','${newpass}')`;
  db.query(sql, (err, result) => {
    if (err) {
      console.log(err);
    } else {
      console.log("注册成功");
    }
  });
});

app.get('login',(req,res,next)=>{
    let username = req.query.username;
    let password = req.query.password;
  
    let md5 = crypto.createHash("md5");
    let newpass = md5.update(password).digest("hex");
    let sql = `select * from wangtinguser where 1=1 username = '${username}' and password ='${newpass}')`;
    db.query(sql, (err, result) => {
      if (err) {
        console.log(err);
      } else {
        console.log("登录成功");
      }
    });
})