nodejs mysql 连接池初始化_Nodejs学习笔记-Mysql连接池

安装mysqlpool模块

npm install -g node-mysql

代码

//models/OptPool.js

var mysql = require("mysql");

function OptPool() {

this.flag = false;

this.pool = mysql.createPool({

host : "localhost",

user : "root",

password : "123456",

database : "test",

port : "3306"

});

this.getPool = function() {

if (!this.flag) {

this.pool.on("connection", function(connection) {

connection.query("SET SESSION auto_increment_increment=1");

this.flag = true;

});

}

return this.pool;

}

}

module.exports = OptPool;

//mysqlPool.js

var OptPool = require("./models/OptPool");

var optPool = new OptPool();

var pool = optPool.getPool();

pool.getConnection(function(err, conn) {

var userAddSql = "insert into user(uname, pwd) values(?, ?)";

var param = ["eee", "eee"];

conn.query(userAddSql, param, function(err, rs) {

if (err) {

console.log("insert failed:" + err);

return;

}

console.log("insert ok");

});

conn.query("select * from user", function(err, rs) {

if (err) {

console.log("select failed:" + err);

return;

}

for (var i=0; i

console.log(rs[i].uname);

}

conn.release();

});

});

参考文档