封装数据库访问模块-data.js

/**
 * 封装数据库访问模块
 */
const mysql = require("mysql")
// const { connect } = require(".")

const pool = mysql.createPool({
    connectionLimit:    10,
    host:               "localhost",
    user:               "root",
    password:           "root",
    database:           "webblog"
})
function Query(sql,args){
    return new Promise((resolve,reject) =>{
        pool.getConnection ((error,connection) =>{
            connection.query(sql,args,(err,result) =>{
                if(err){
                    console.log("执行sql语句出现了错误",err)
                   reject(err)
                }else{
                    resolve(result)
                }
               
            })
            connection.release()
        })
    })
}
module.exports = Query