本文共 1554 字,大约阅读时间需要 5 分钟。
server.js(入口文件)
const express = require("express");let app = express();let allRouter = require("./router/index");app.use(express.static("./"));app.use(allRouter);app.listen(2000, () => { console.log("服务器开启");})
router/index.js(主路由)
const express = require("express");let router = express.Router();let home = require("./home");router.use("/home", home);module.exports = router;
router/home.js(home路由)
const express = require("express");const bodyParser = require("body-parser");let query = require("../db/index");let urlencodedParser = bodyParser.urlencoded({ extended: false});let router = express.Router();//测试数据router.get("/testData", async (req, res, next) => { try { var data = await query("SELECT * FROM listdata"); } catch (err) { console.log(err); } let result = ""; if (data.length) { result = { msg: "success", data, } } else { result = { msg: "err", } } res.send(result)});module.exports = router;
db/index.js(mySql数据库)
const mysql = require("mysql");let pool = mysql.createPool({ host: "localhost", port: "3306", user: "root", password: "", database: "xfc", multipleStatements: true,});let query = function (sql) { return new Promise((resolve, reject) => { pool.query(sql, (err, data) => { if (err) { reject(err); } else { resolve(data); } }); });};module.exports = query;
具体查看githuo链接地址:
https://github.com/await-lfq/nodeJsPlugin转载地址:http://heug.baihongyu.com/