mysql = require("mysql")
var config = {
host :"127.0.0.1",
port : 3306,
user:"root",
database:"project",
password:"123456"
}
//1.连接数据库
var connection =mysql.createConnection(config);
//2.监听是否连接成功
connection.connect(function(err){
console.log(err)
})
//3、执行sql语句,进行数据库操作
let sql = ` select * from users`
connection.query(sql,function(qerr,results,fields){
//关闭数据库
connection.end(function(err){console.log(err)});
//事件驱动回调
callback(qerr,rows,fields)
})
config/config.js
config/mysqlConfig.js
页面/index.js