nodejs之mysql查询

阿里云国内75折回扣微信号：monov8

阿里云国际，腾讯云国际，低至75折。AWS 93折免费开户实名账号代冲值优惠多多微信号：monov8 飞机：@monov6

示例代码中的mysql版本 2.14.1

参考代码

 /**

  * 测试mysql连接

  */

 var mysql = require('mysql');

 var connection = mysql.createConnection({

   host     : 'localhost',  //服务器

   user     : 'root', //用户名

   password : 'root', //密码

   database : 'mysql' //数据库

 });

 connection.connect(function(err) {

     if(err) {

         console.error('error connecting: ' + err.stack);

         return;

     }

     console.log('connected as id ' + connection.threadId);

 });

 var http = require('http');

 var server = http.createServer(function(request, response){

     response.writeHeader(200, {'Content-type': 'text/html'});

     // 查询User为root的用户

     connection.query('SELECT * FROM user WHERE User = ?', ['root'], function(err, results, fields){

         if(err) {

             throw err;

         }

         var data = '';

         for (var i = 0; i < results.length; i++) {

             var firstResult = results[i];

             data += 'User: '+ firstResult['User'] + '&nbsp;&nbsp;Password: ' + firstResult['Password'] + '<br>';

         }

         response.write(data);

         response.end();

     });

 });

 server.listen(8080);

 var sys = require('util');

 sys.puts('Server running at http://localhost:8080/');