1.
/*
* @Descripttion: hanxu的代码
* @version: 1.0.0
* @Author: 韩
* @Date: 2022-06-22 10:17:36
* @LastEditors: 韩
* @LastEditTime: 2022-06-22 16:43:43
*/
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)
}
})
})
}