NodeJS示例分享

#创建 app服务器
const express = require("express");  //引入第三方express模块
const bodyParse = require("body-parser"); //引入bodyparser模块
const url = require("./router/user")   //引入user路由
const app = express();    
app.listen(8080);  //端口
// 托管静态资源
app.use( express.static("./public"));
//应用body-parser
app.use (bodyParse.urlencoded({
    extended:false
}))
// 将用户路由器挂载到web服务器
app.use("/user",url);

#创建连接池
const mysql = require("mysql");
const pool=mysql.createConnection({
    host:'127.0.0.1',
    port:'3306',
    user:"root",
    password:'',
    database:"abc",
    connectionLimit:20
})

module.exports = pool;

#user 路由器
const express = require("express");
const querystring = require("querystring");
const pool = require("../pool");

const users = express.Router();
#获取post请求
users.post("/reg",(req,res)=>{
// 获取post请求的数据;
let obj = req.body;
console.log(obj)
if(!obj.uname){
   res.send({code:401,msg:'uname required'})
   return 
   };
if(!obj.upwd){
   res.send({code:402,msg:"upwd required"})
   return ;
   };
if(!obj.email){
   res.send({code:403,msg:"email required"})
   return ;
   }
if(!obj.phone){
   res.send({code:404,msg:"phone required"})
    return 
    }
// 执行sql命令
pool.query("insert into xz_user SET ?",[obj],(err,result)=>{
    if(err) throw err;
    })
    res.send("注册成功")
	});

#获取get请求
users.get("/update",(req,res)=>{
    let obj = req.query;
    let i=400;
    for(var key in obj){
     i++;
    if(!obj[key]){
    res.send({code:i,msg:key+" required"});
    return;
   }
   }
pool.query("update xz_user set ? WHERE uid=?",[obj,obj.uid],(err,result)=>{
   if(err) throw err;
   console.log(result);
   if(result.affectedRows===0){
   res.send({code:301,msg:"update err"});
   }else{res.send({code:200,msg:"update success"});
   }})
})