varexpress=require('express');varmysql=require('mysql');varapp=express();varbodyParser=require('body-parser');//链接数据库varconnection=mysql.createConnection({host:'localhost',user:'root',password:'123456',database:'school'});connection.connect();//创建application/x-www-form-urlencoded编码解析(post方法)varurlencodedParser=bodyParser.urlencoded({extended:false})//设置跨域访问app.all('*',function(req,res,next){res.header("Access-Control-Allow-Origin","*");res.header("Access-Control-Allow-Headers","X-Requested-With");res.header("Access-Control-Allow-Methods","PUT,POST,GET,DELETE,OPTIONS");res.header("Content-Type","application/json;charset=utf-8");next();});//登录app.post('/login',urlencodedParser,function(req,res){varusername=req.body.username;varpassword=req.body.password;varsql=`select*fromloginwhereusername='${username}'andpassword='${password}'`；连接ion.query(sql,function(err,result){console.log(result)if(err||result.length==0){res.status(200),res.json("登陆失败")}else{res.status(200),res.json("登陆成功")}});})//查询app.get('/query',function(req,res){varsql='select*fromstudent';connection.query(sql,function(err,result){if(err){console.log('err:',err.message);}console.log(result);res.status(200),res.json(result)});});//修改app.get('/change',function(req,res){varSNO=req.query.SNO;varSNAME=req.query.SNAME;varSDEPT=req.query.SDEPT;varsql=`updatestudentsetSNAME='${SNAME}',SDEPT='${SDEPT}'whereSNO='${SNO}'`;connection.query(sql,function(err,result){if(err){console.log('err:',err.message);}console.log(result);res.status(200),res.json("修改成功")});})//新增app.get('/add',function(req,res){console.log(req.query)varSNO=req.query.SNO;varSNAME=req.query.SNAME;varSDEPT=req.query.SDEPT;varsql=`插入学生值('${SNO}','${SNAME}','${SDEPT}')`;connection.query(sql,function(err,result){if(err){console.log('err:',err.message);}console.log(result);res.status(200),res.json("添加成功")});})//删除app.get('/delete',function(req,res){console.log(req.query)varSNO=req.query.SNO;varsql=`deletefromstudentwhereSNO='${SNO}'`;connection.query(sql,function(err,result){if(err){console.log('err:',err.message);}console.log(result);res.status(200),res.json("移除成功")});})//connection.end();){varhost=server.address().address;arport=server.address().port;console.log('http://',host,port);})github：https://github.com/Rossy11/no...
