-
Notifications
You must be signed in to change notification settings - Fork 8
/
userApi.js
94 lines (89 loc) · 2.11 KB
/
userApi.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
var models = require('../db');
var express = require('express');
var router = express.Router();
var mysql = require('mysql');
var $sql = require('../sqlMap');
// 连接数据库
var conn = mysql.createConnection(models.mysql);
conn.connect();
//中间件
var jsonWrite = function(res, ret) {
if(typeof ret === 'undefined') {
res.send('err')
} else {
res.json(ret);
// res.send('ok')
}
};
// 增加用户接口
router.post('/addUser', (req, res) => {
var sql_name = $sql.user.select_name
var sql = $sql.user.add;
var params = req.body;
console.log(params);
conn.query(sql_name,params.username,function(err,result) {
if(err) {
console.log(err)
}
if(result[0]===undefined) {
conn.query(sql,[params.username,params.password], function(err, result) {
if(err) {
console.log(err)
}
if(result) {
jsonWrite(res, result)
}
})
}else {
res.send('-1')
}
})
});
//查找用户接口
router.post('/selectUser', (req,res) => {
var sql_name = $sql.user.select_name;
var sql_password = $sql.user.select_password;
var params = req.body;
conn.query(sql_name,params.username,function(err, result) {
if(err) {
console.log(err)
}
if(result[0]===undefined) {
res.send('-1')
}else {
conn.query(sql_password,params.password, function(err, result) {
if(err) {
console.log(err)
}
if(result[0]===undefined) {
res.send('0')
}else {
// Set-Cookie
// 如果是https环境必须添加 { secure: true }
res.cookie('isAuth', 1, {maxAge: 7 * 24 * 60 * 1000, secure: true, signed: true});
jsonWrite(res, result);
}
})
}
})
});
//修改密码 目前未提供页面,可以用接口测试工具测试
router.put('/updateUser', (req,res) => {
var sql_update = $sql.user.update_password;
var params = req.body;
if(req.cookies.isAuth){
conn.query(sql_update,[params.password,params.id], function(err, result) {
if(err) {
console.log(err)
}
if(result[0]===undefined) {
res.send('0')
}else {
jsonWrite(res, result);
}
})
}else {
res.send('no auth')
}
});
module.exports = router;