var express=require('express'); var router=express.Router(); var mysql=require('../mysql'); var moment=require('moment');
var bodyParser = require('body-parser');
var multer=require('multer');
const storage=multer.diskStorage({ destination:function(req,file,cb){ cb(null,'./public/upimg'); }, filename:function(req,file,cb){ let oldfilename=file.originalname; console.log('原文件名:'+oldfilename);
let newfilename=(new Date()).getTime()+"_"+oldfilename; cb(null,newfilename); } }) const upload=multer({storage:storage});
router.use(bodyParser.urlencoded({ extended: false }));
router.get('/', function(req, res){ mysql.query("select * from nodestudent",function(err,result,fields){ if(err){ console.log("查询错误!"+err); return; } res.render('index.html',{ student:result }) }) })
router.get('/addstudent',function(req, res){ res.render("post.html"); })
router.get('/edit/:id',function(req, res){ mysql.query("select * from nodestudent where stid="+parseInt(req.params.id),function(err,result){ if(err){ console.log("修改查询错误!"); return; } console.log(result); res.render("edit.html",{ stu:result }); }) })
router.post('/stu/edit',function(req, res){ let ssex=req.body.sex; let sex; if(ssex=="男"){ sex=1; }else{ sex=0; } let stime = moment().format('yyyy-MM-D h:mm:ss'); let up="update nodestudent set stname=?,stpwd=?,stage=?,stsex=?,sttime=? where stid=?"; var szup=[""+req.body.name+"",""+req.body.pwd+"",parseInt(req.body.age),sex,""+stime+"",parseInt(req.body.id)]; mysql.query(up,szup,function(err,result){ if(err){ console.log("修改错误!"); res.render("edit.html"); } res.redirect("/"); }); })
router.post('/stu/create',function(req, res){ let inst="insert into nodestudent(stname,stpwd,stage,stsex,sttime) VALUES(?,?,?,?,?)"; let ssex=req.body.sex; let sex; if(ssex=="男"){ sex=1; }else{ sex=0; } var sttime = moment().format('yyyy-MM-D h:mm:ss'); var student = [""+req.body.name+"",""+req.body.pwd+"",parseInt(req.body.age),sex,""+sttime+""]; console.log(student); console.log("name:"+req.body.name); console.log("pwd:"+req.body.pwd); console.log("age:"+req.body.age); console.log("sex:"+req.body.sex); mysql.query(inst,student,function(err,result){ if(err){ console.log("添加错误!"); console.log("err:"+err); return; } console.log("result:"+result); res.redirect("/"); }) })
router.get('/stu/:id',function(req,res){ console.log("ID:"+req.params.id); mysql.query("delete from nodestudent where stid="+req.params.id,function(err,result){ if(err){ console.log("删除错误!"); return; } res.redirect("/"); }) })
router.get("/login",function(req,res){ res.render("login.html"); })
router.get('/register',function(req,res){ res.render("register.html"); })
router.post('/login',function(req,res){ let log="select * from nodestudent where stname='"+req.body.uname+"' and stpwd='"+req.body.pwd+"'"; console.log(log); mysql.query(log,function(err,result,fields){ if(err){ console.log("登入查询错误!"); console.log(err); res.render("login.html"); } if(result.length==0){ res.render("login.html"); }else{ res.redirect("/"); } }) })
router.post('/register',upload.single('upimg'),function(req, res){ let re="insert into nodestudent(stname,stpwd,stage,stsex,sttime) VALUES(?,?,?,?,?)"; let ssex=req.body.sex; let sex; if(ssex=="男"){ sex=1; }else{ sex=0; } var sttime = moment().format('yyyy-MM-D h:mm:ss'); var student = [""+req.body.username+"",""+req.body.password+"",parseInt(req.body.age),sex,""+sttime+""]; mysql.query(re,student,function(err,result){ if(err){ console.log("注册失败!"); res.render("register.html"); } res.redirect("/"); }) })
module.exports = router;
|