数据库的封装代码
const mysql = require("mysql");
class DBUtil {
static getConn() {
let conn = mysql.createConnection({
host: "0.0.0.0",
port: 3306,
user: "dev_h2001",
password: "123456",
database: "h2001",
multipleStatements: true
});
conn.connect();
return conn;
}
static executeSql(strSql, params = []) {
return new Promise((resolve, reject) => {
let conn = this.getConn();
conn.query(strSql, params, (err, results) => {
if (err) {
reject(err);
}
else {
resolve(results);
}
})
conn.end();
})
}
}
module.exports = DBUtil;