把对mysql的封装,使用ES7。
代码目录结构如图 -->
1.DB.js
```javascript
class DB {
constructor() {
this.mysql = require("mysql")
this.dbConfig = require("./db.config.js")
}
query(sql, params) {
return new Promise((resolve, reject) => {
const connection = this.mysql.createConnection(
this.dbConfig
)
connection.connect(err => {
if (err) {
console.log("数据库连接失败!")
reject(err)
}
console.log("数据库连接成功!");
})
connection.query(sql, params, (err, results, fileds) => {
if (err) {
console.log("数据库连接失败!")
reject(err)
}
resolve({ results, fileds })
})
connection.end(err => {
if (err) {
console.log("数据库关闭失败!")
reject(err)
}
console.log("数据库关闭成功!")
})
})
}
}
module.exports = new DB()
2.db.coinfig.js
module.exports = {
host: "localhost",
user: "root",
password: "123456",
database: "ceshi"
}