mysql server nodejs_nodejs创建server,连接mysql操作

/*var http = require('http');

http.createServer(function (req, res) {

res.writeHead(200, {'Content-Type': 'text/plain'});

res.end('Hello World1111111\n');

}).listen(1337, '127.0.0.1');*/

var Client = require('easymysql');

var mysql = Client.create({

'maxconnections' : 10

});

mysql.addserver({

'host' : '127.0.0.1',

'user' : 'root',

'password' : '',

'database' : 'aaaa',

'port' : 3306

});

mysql.on('busy', function (queuesize, maxconnections, which) {

// XXX: write log and monitor it

});

/*mysql.query('SHOW DATABASES', function (error, res) {

console.log(res);

});*/

// bind params

mysql.query({

sql: 'select * from reserve limit 0,2',

params: {user: 'xxoo'}

}, function (err, rows) {

console.log(rows);

});