var express = require('express');
var router = express.Router();
var mysql = require('mysql');
//统一返回格式
var responseData;
router.use(function (req,res,next) {
responseData = {
code:0,
message:''
};
next();
});
router.get('/user',function (req,res,next) {
});
/*
用户注册
注册逻辑
用户名的验证
数据库的验证
*/
var connection = mysql.createConnection({
host:'localhost',
user :'root',
password:'1234',
database:'blog'
});
connection.connect();
router.post('/user/register',function(req,res,next){
var username = req.body.username;
var password = req.body.password;
var repassword = req.body.repassword;
//用户名是否为空
if(username == ''){
responseData.code = 1;
responseData.message = '用户名不能为空';
res.json(responseData);
return;
}
//密码不能为空
if(password == ''){
responseData.code = 2;
responseData.message = '密码不能为空';
res.json(responseData);
return;
}
//两次密码不一致
if(password != repassword){
responseData.code = 3;
responseData.message = '两次密码不一致';
res.json(responseData);
return;
}
//数据库的判断，如果数据库中已经存在和我们要注册的用户名同名，表示已经被注册了
var sql = 'SELECT * FROM users WHERE username = "' + username + '"';
connection.query(sql,function(err,result){
if(err){
console.log('[SELECT ERROR] - ',err.message);
return;
}
console.log('--------------------------SELECT----------------------------');
console.log(result);
console.log('------------------------------------------------------------\n\n');
});
responseData.message = '注册成功';
res.json(responseData);
});
module.exports = router;

已解决。。