基于nodejs搭建express服務(wù)框架
1.框架結(jié)構(gòu)
- 框架實現(xiàn)
2-1 node_modules
`npm install express --save
2-2 index.js
const express = require("express");
const app = express();
const router = require("./router.js")
/**
- 參數(shù)1：全局路徑
- 參數(shù)2：router
- **/
app.use("/api",router)
app.listen(3000,() =>{
console.log("服務(wù)器運行在3000端口上");
})
2-3 package.json
{
"dependencies": {
"body-parser": "^1.20.2",
"cors": "^2.8.5",
"express": "^4.18.2",
"mysql": "^2.18.1"
}
}
自動生成
2-4 router.js
const express = require("express");
const router = express.Router();
// 添加接口
router.get("/list",(req,res) =>{
res.send({
status:200,
message:"測試服務(wù)器"
})
})
module.exports = router;
2-5 SQLConnect.js
// 1.創(chuàng)建MySQL實例
const mysql = require("mysql");
// 2.創(chuàng)建MySQL對象
const MySQLObj = {
host:"localhost",
user:"root",
password:"",
database:"vue3_itbaizhan"
}
// 3.創(chuàng)建連接池
const pool = mysql.createPool(MySQLObj);
// 4.編寫操作DB的相關(guān)邏輯
function SQLConnect(sql,arr,callback){
pool.getConnection((err,connection) =>{
if (err){
console.log(err);
return
}
connection.query(sql,arr,(err,result) =>{
// 釋放連接
connection.release();
if (err){
console.log(err);
return
}
callback(result)
})
})
}
module.exports = SQLConnect
