用node和express连接mysql实现登录注册的实现代码

var express = require('express');var user = require('./controll/user'); var app = new express();app.use(express.static('public')); //静态资源的入口app.use('/user',user);    //这样写是为了以后如果改变了请求路径，也不用改逻辑js而是改这行的路径即可var server = app.listen(3000)

$("#signup").click(function(){  $.ajax({   url: "/user/signup",   type: 'post',   data: $("#formid").serialize(),   success: function(data) {    if(data.status == 99999) {     alert("3秒后跳转到首页");     setTimeout(function() {      location.href='http://'+window.location.host+'/html/index.html';     },3000)    }else {     alert('登录名或密码错误')    }   }  })   }) $("#register").click(function(){  $.ajax({   url: "/user/register",   type: 'post',   data: $("#formRegister").serialize(),   success: function(data) {    console.log(data);    if(data.status == 99999) {     alert("注册成功")    }else {     alert("登录名已经有人用")    }   }  })   })

var mysql = require('mysql');var express = require('express');var bodyParser = require('body-parser');var cookieParser = require('cookie-parser');var session = require('cookie-session');function select(sql) { var promise = new Promise(function(resolve,reject) {  var result = null;  var mysql = require('mysql');  var connection = mysql.createConnection({   host: 'localhost',   user: 'root',   password: 'root'  });  connection.connect();  connection.query("USE test");  connection.query(sql, function (err, results, fields) {    if (err) {     console.log("err");    reject(err);    }else {    console.log("yes");    if(results.length > 0) {     resolve({status: 99999});    }else {     resolve({status: 00000});    }      }    }   );  connection.end();  }) return promise; }var router = express.Router();router.use(bodyParser.urlencoded({ extended: true }));router.use(cookieParser())router.use(session({ secret: 'blog'}))router.use(function timeLog(req,res,next) { var _user = req.session.user; if(_user) {  //router.locals.user = user; } next();})//登录router.post('/signup',function(req, res) { var _user = req.body.user; var name = _user.name; var password = _user.password; select('SELECT * FROM name WHERE name = "'+ name + '" AND password = "' + password + '";').then(function(data) {  //session存user name和userid  req.session.user = name;  data.status > 50 ? data.url = '/html/index.html' : null;  res.json(data);  res.end();  req.redirect("/"); }).catch(function(err){})})//注册router.post('/register',function(req, res) { var _user = req.body.user; var name = _user.name; var password = _user.password; console.log(name+"  "+password) select('SELECT * FROM name WHERE name = "'+ name + '";')  .then(function(data) {   if(data.status == 99999) {    console.log("已有此用户名")    res.json({status:00000});    res.end();   }else {    select('INSERT INTO name(name,password) VALUES ("'+name+'", "'+password+'");')    .then(function(data) {      res.json({status:99999});     res.end();    }).catch(function(err){})   }     }).catch(function(err){  })});//退出router.get("/logout",function(req, res) { delete req.session.user; res.end();})//获取sessionrouter.get("/session",function(req, res) { console.log("user in session"); console.log(req.session.user); res.json({user:req.session.user}); res.end();})module.exports = router;