express数据库连接池(mysql)

//mysql模块引用
const mysql = require('mysql');

//创建链接
const pool = mysql.createPool({
    'host':'127.0.0.1',
    'post':'3306',
    'user':'root',
    'password':'password',
    'database':'database',
});

exports.query = (sql, params = []) => {
    return new Promise((resolve, reject) => {
        //从连接池中取出连接。
        pool.getConnection((err, connection) => {
            if (err) return reject(err);
            connection.query(sql, params, (err, result) => {
                connection.release();//释放连接
                if (err) return reject(err);
                resolve(result);
            })
        })
    })
};