// db-util.js
var mysql = require('mysql');
var pool = mysql.createPool({
connectionLimit : 10,
host: 'localhost',
user: 'root',
password: '',
database: 'test',
port: 3306
});
exports.dataCenter = function(sql, fn) {
// (callback && typeof(callback) === "function")
pool.getConnection(function (err, conn) {
if (err) {
console.log("POOL ==> " + err);
return fn(err);
} else {
conn.query(sql, function (err, res) {
conn.release();
return fn(res);
});
}
});
};
// 利用回调函数达到同步操作数据并获取信息的效果
var mysql = require('mysql')
, dbUtil = require('./db-util');