function db(callback){ var mysql = require('mysql'); var connection = mysql.createConnection({
host : 'localhost',
user : 'root',
password : '',
port: '3306',
database: 'test',
}); connection.connect(); var sql = 'SELECT * FROM uer';
var sql1 = 'SELECT * FROM member';
//查
var rr;
var tt;
connection.query(sql,function (err, result) {
if(err){
console.log('[SELECT ERROR] - ',err.message);
return;
} rr=JSON.stringify(result)
//callback(rr);
});
connection.query(sql1,function (err, result) {
if(err){
console.log('[SELECT ERROR] - ',err.message);
return;
} tt=JSON.stringify(result)
if (rr && tt) {
callback(rr,tt);
} });
/*connection.query(sql,function (err, result) {
if(err){
console.log('[SELECT ERROR] - ',err.message);
return;
}
var r=2;
json=JSON.stringify(result)
callback(json);
});*/ connection.end();
}
exports.db=db;
var a;
var b;
var c;
/*function callback1(type,result){ c[type]=result; if (c[1] && c[2]) { res.end(c); } }*/