// 功能
router.get(’/dologin’, function(req, res, next) {
let {username,pwd} = req.query;
// console.log([username,pwd])
var sql = ‘select * from login where username=? && pwd=?’;
req.db.query(sql,[username,pwd],function (err, result) {
if(err){
console.log(’[SELECT ERROR] - ‘,err.message);
res.send(’{“code”:“err”,“status”:201,“message”:“登录失败”}’)
return;
}else{
let obj = {“code”:“ok”,“status”:200,“message”:“登录成功”,“data”:result};
res.send(obj);
}
});
});
// 渲染
router.get(’/apply’, function(req, res, next) {
var sql = ‘select * from staff’;
req.db.query(sql,function (err, result) {
if(err){
console.log(’[SELECT ERROR] - ‘,err.message);
res.send(’{“code”:“err”,“status”:201,“message”:“请求失败”}’)
return;
}else{
let obj = {“code”:“ok”,“status”:200,“message”:“请求成功”,“data”:result};
res.send(obj);
}
});
});
// 添加
router.get(’/add’, function(req, res, next) {
//数据库中想要添加数据的功能模块
let {name,sex1,status1,like1,wife1,date1,address,time1}=req.query;
var sql = ‘insert into staff(name,sex1,status1,like1,wife1,date1,address,time1) values(?,?,?,?,?,?,?,?)’;
req.db.query(sql,[name,sex1,status1,like1,wife1,date1,address,time1],function (err,result) {
if(err){
res.send(’{“code”:“err”,“status”:201,“message”:“添加失败”}’)
console.log(’[SELECT ERROR] - ‘,err.message);
return;
}else{
res.send(’{“code”:“ok”,“status”:200,“message”:“添加成功”}’);
}
});
});
// 删除
router.get(’/del’,function(req,res,next){
let {id} = req.query;
let sql=“delete from staff where id in (?)”;
req.db.query(sql,[id],(err,result)=>{
if (err){
res.send(’{“code”:“no”,“status”:201,“message”:“删除失败”}’)
}else{
res.send(’{“code”:“ok”,“status”:200,“message”:“删除成功”}’)
}
})
})
// 编辑
router.all(’/edit’, function(req, res, next) {
let {name,sex1,status1,like1,wife1,date1,address,time1,id}=req.query;
let sql=“UPDATE staff SET name = ?,sex1 = ?,status1 = ?,like1 = ?,wife1 = ?,date1 = ?,address = ?,time1 = ? WHERE id = ?”
req.db.query(sql,[name,sex1,status1,like1,wife1,date1,address,time1,id],(err,result)=>{
if (err) {
res.send(’{“code”:“err”,“status”:201,“message”:“error失败”}’);return;
} else{
let obj={“code”:“ok”,“status”:200,“message”:“success修改成功”,“data”:result}
res.send(obj)
}
})
});
// 查询
router.get(’/find’,function(req,res,next){
var name = req.query.name;
var sex1 = req.query.sex1;
console.log(name,sex1);
var sql=“select * from staff where name like '%”+name+"%’ && sex1 like ‘%"+sex1+"%’" ;
// var sql=select * from two where name like ‘%${value}%’;
req.db.query(sql,function(err,result){
if(err){
res.send(’{“code”:“err”,“status”:201,“message”:“error失败”}’);return;
}else{
let obj={“code”:“ok”,“status”:200,“message”:“success查询成功”,“data”:result}
res.send(obj);
}
})
});