网上找的mysql操作函数,我使用的是express框架,放到项目目录下的 plugin/db.js
var mysql = require("mysql");
//填写数据库连接信息,可查询数据库详情页
var username = 'root';
var password = '123456';
var db_host = 'localhost';
var db_port = 3306;
var db_name = 'go';
var option = {
host: db_host,
port: db_port,
user: username,
password: password,
database: db_name
};
function _exec(sqls,values,after) {
var client = mysql.createConnection(option);
client.connect(function(err){
if (err) {
console.log(err);
return;
}
client.query(sqls || '', values || [],function(err,r){
after(err,r);
});
client.end();
});
client.on('error',function(err) {
if (err.errno != 'ECONNRESET') {
after("err01",false);
throw err;
} else {
after("err02",false);
}
});
}
exports.exec = _exec;
var db = require("../plugin/db.js");
db.exec("select * from go_user2 where id=?",[156],function(err,r){
console.log(err,r);
});