1、根目录下创建文件夹util,在其下新建文件dbConfig.js内容如下:
const conn = require("mysql");
module.exports = {
//数据库配置
config: {
host: "localhost",
port: "3306",
username: "root",
password: "root@547548847",
database: "express",
},
//使用连接池的方式进行连接
sqlConnection: function (sql, sqlAttr, callBack) {
var pool = conn.createPool(this.config);
pool.getConnection((err, data) => {
if (err) {
console.log("连接错误");
return;
}
//事件驱动回调
conn.query(sql, sqlAttr, callBack);
//释放连接
conn.release();
});
},
};
2、测试数据库是否连接成功,修改routes目录下的index.js。修改后内容如下:
var express = require("express");
var router = express.Router();
var dbCon = require("../util/dbConfig");
/* GET home page. */
router.get("/", function (req, res, next) {
res.render("index", { title: "Express" });
});
//测试数据库是否连接成功
router.get("/test", (req, res, next) => {
var sql = "select * from user";
var sqlAttr = [];
var callBack = function (err, data) {
if (err) {
console.log("连接出错了!!");
} else {
res.json({
total: data.length,
data: data,
});
}
};
dbCon.sqlConnection(sql, sqlAttr, callBack);
});
module.exports = router;
3、用postman测试