路由拆分的步驟
一艇抠、在根目錄新建router文件
創(chuàng)建productRouter.js 和 userRouter.js
二岁歉、在productRouter.js中完成商品的業(yè)務(wù)邏輯
- 創(chuàng)建路由對(duì)象
const express = require("express")
//創(chuàng)建路由對(duì)象硝全，來管理路由
const router = express.Router()
- 創(chuàng)建數(shù)據(jù)庫(kù)連接
const mysql = require("mysql")
const conn = mysql.createConnection({
host: 'localhost',
user: 'root',
password: 'root',
database: "yunheshop",
port: '3306'
})
- 數(shù)據(jù)接口邏輯
// 數(shù)據(jù)接口邏輯 （Mock數(shù)據(jù) 模擬數(shù)據(jù)）
router.get("/product", (req, res) => {
let { productName } = req.query;
let sql = "select * from product where productName = ?"
conn.query(sql, [productName], function (err, result) {
if (err) {
console.log('查詢數(shù)據(jù)庫(kù)失敗');
} else {
let data;
if (result.length) {
data = {
code: 0,
list: result
}
} else {
data = {
code: 1,
msg: '沒有結(jié)果 '
}
}
res.send(data)
}
})
})
router.post('/product',()=>{})
router.delete('/product',()=>{})
router.put('/product',()=>{})
module.exports = router
在app.js引入路由模塊蔬芥，并使用
//引入商品路由模塊
const productRouter = require("./router/productRouter")
const userRouter = require("./router/userRouter")
......
app.use(express.static("./public"))
//所有以"/"開始的路徑甲抖，都會(huì)去執(zhí)行productRouter
app.use("/",productRouter)
app.use("/",userRouter)
