node js 数据库链接池

1.引入数据库
let mysql = require(“mysql”)
2.创建链接池
let pool = mysql.createPool({
host:‘127.0.0.1’,
user:‘root’,
password:‘12345678’,
database:‘newshop’,
port:3306
})
3.
let query = function(sql,data){
return new Promise(function(resolve,reject){
pool.getConnection(function(err,connection){
if(!err){
connection.query(sql,data,function(error,result){
if(!error){
resolve(result)
}else{

                     reject(error)
                 }
                 connection.release()
            })    
       
        }else{
            
            reject(err)
        }
    })
})

}