dbcon.js
import mysql from "mysql";
import config from "../config/config.js";
// 创建连接池
var pool = mysql.createPool(config.mysqlCon);
const query = (sql,params,fn)=>{
// 获取连接
pool.getConnection((err,conn)=>{
if (err) {
fn(err,null,null);
}else{
conn.query(sql,params,(err,result,fields)=>{
conn.release();
fn(err,result,fields);
})
}
})
}
module.exports={
query
};
config.js
module.exports = {
mysqlCon: {
host: '127.0.0.1',
user: 'root',
password: '***',
database: 'test',
port: '3306'
}
}