node.js 访问mysql

首先在用express引擎安装mysql模块：

在项目工程的package.json 文件中的dependencies中添加  "mysql":"*"

然后执行命令：npm install

mysql_module.js

/**
 * Created by bloodchilde on 2015/6/1.
 */

var mysql = require("mysql");

var mysqlConn = mysql.createConnection({
    host: '127.0.0.1',
    user: "root", //数据库用户名
    password: "root", //数据库密码
    database: "php", //数据库
    port: 3306
});

function mysqlClient(){

    this.conn = mysqlConn;

};

mysqlClient.prototype.NewConnect=function(){

    console.log("new connect");

    mysqlConn.connect(function(err,results){
        if(err){
                return -1;
            }else{
                return 0;
        }
    });
};

module.exports= new mysqlClient();

test.js

var mysql_client= require('mysql_module');  
     
var mysqlClient = mysql_client;

mysqlClient.NewConnect();

 var mysqlConn = mysqlClient.conn;

var statusArray= new Array();

var queryString=[
      'show status like "com_insert"',
      'show status like "com_delete"',
      'show status like "com_update"',
      'show status like "com_select"'
];

for(var i=0;i < 4;i++){
        console.log(queryString[i]);

        mysqlConn.query(queryString[i],function(err,rows,fields){

         	if(err){
                    statusInfo="err";
                    console.log("err");

                    mysqlConn.end();
                }else{

                    console.log(rows[0]);

                    var value = parseInt(rows[0].Value);
                    statusArray.push(value);

                    if(statusArray.length == 4){

                        console.log(statusArray);
                    }
                }
            });
        }