1.
const mysql=require('mysql')
const config={
database:'dblog',
user:'root',
password:'123456'
}
exports.db=(sql,sqlParams)=>{
return new Promise((resolve,resject)=>{
const pool=mysql.createPool(config)
pool.getConnection((err,conn)=>{
if(!err){
conn.query(sql,sqlParams,(e,result)=>{
if(!e){
console.log(result)
resolve(result)
conn.destroy()
}
else{
resject(e)
}
})
}
else{
console.log('sql:',err)
resject(err)
}
})
})
}
