nodejs创建server,连接mysql操作

2019独角兽企业重金招聘Python工程师标准>>>

/*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);

});

转载于:https://my.oschina.net/sharesuiyue/blog/414606