//npm install mysql --save
const mysql = require('mysql');
const connection = mysql.createConnection({
host:'', //域名
user:'', //mysql用户名
password: '', //数据库密码
database:'', //数据库名
});
function requestQuery(sql){ //参数sql为sql语句
return new Promise((resolve,reject)=>{ //resolve为异步promise成功时的回调,reject为失败时的回调
connection.query(sql,(err,data)=>{
if(err){
reject(err)
}
resolve(data)
})
})
};
module.exports = { //暴露方法
connection,
requestQuery
}
*特别鸣谢 火花----潘老师,许老师