Express连接Mysql数据库
安装mysql2 库
const mysql = require('mysql2')
function getConfig () {
return {
host: 'localhost',
user: 'root',
password: '',
database: 'test', // 数据库名不区分大小写
waitForConnections: true,
connectionLimit: 10,
queueLimit: 0
}
}
const pool = mysql.createPool(getConfig())
const promisePool = pool.promise()
module.exports = promisePool
const promisePool = require('../utils/index')
const queryUpgradeMessage = (mac) => {
return new Promise((resolve, reject) => {
promisePool
.query(`SELECT * FROM mac_config WHERE mac=?`, [mac])
.then((result) => {
resolve(result[0][0])
})
.catch((err) => {
reject(err)
})
})
}