nodejs—router

最新推荐文章于 2024-12-12 12:15:00 发布

spfLinux

最新推荐文章于 2024-12-12 12:15:00 发布

阅读量1k

点赞数

分类专栏： node.js 文章标签： nodejsrouter

node.js 专栏收录该内容

16 篇文章

订阅专栏

05_pool_1.js

/**
 * Created by web-01 on 2018/1/10.
 */
const mysql=require("mysql");
var pool=mysql.createPool({
    host:"127.0.0.1",
    user:"root",
    password:"",
    database:"test",
    port:3306,
    connectionLimit:25
});

module.exports=pool;

02_users_1.js

/**
 * Created by web-01 on 2018/1/10.
 */
const express=require("express");
const pool=require("./05_pool_1");
var router=express.Router();

router.get("/list",(req,res)=>{
    pool.getConnection((err,conn)=>{
       if(err) throw err;
       var sql="SELECT * FROM t_user";
       conn.query(sql,(err,result)=>{
          if(err) throw err;
          res.json(result);
          conn.release();
       });
    });
});

router.get("/del",(req,res)=>{
   res.json({code:1,msg:"user_del"})
});

router.get("/update",(req,res)=>{
   res.json({code:1,msg:"user_update"})
});

module.exports=router;

03_product_1.js

/**
 * Created by web-01 on 2018/1/10.
 */
const express=require("express");
const pool=require("./05_pool_1");
var router=express.Router();

router.get("/list",(req,res)=>{
    pool.getConnection((err,conn)=>{
       if(err) throw err;
       var sql="SELECT * FROM t_user";
       conn.query(sql,(err,result)=>{
          if(err) throw err;
          res.json(result);
          conn.release();
       });
    });
});

router.get("/del",(req,res)=>{
   res.json({code:1,msg:"user_del"})
});

router.get("/update",(req,res)=>{
   res.json({code:1,msg:"user_update"})
});

module.exports=router;

04_app.js

/**
 * Created by web-01 on 2018/1/10.
 */
const http=require("http");
const express=require("express");
const routerUsers=require("./02_users_1");
const routerProduct=require("./03_product_1");
var app=express();
var server=http.createServer(app);
server.listen(3001);
app.use("/users",routerUsers);
app.use("/product",routerProduct);