创建连接池
function SqlPool() { this.flag = true;//是否连接过 this.pool = mysql.createPool({ host : 'localhost', user : 'root', password : password, database : 'mydb', port : '3306', }); this.getPool = function () { if(this.flag) { // 监听connection事件 this.pool.on('connection', function (connection) { connection.query('set session auto_increment_increment=1'); this.flag = false; }); } return this.pool; }; }
使用
var SqlPool = require('./mysql'); var Pool = new SqlPool(); var pool = Pool.getPool(); pool.getConnection(function (err, conn) { if(err) { console.log(err); return ; } conn.query('select * from user',function (err, rs) { if(err) { console.log(err); return ; } for(var i = 0; i < rs.length; i++) { console.log('id : ' + rs[i].id); console.log('name : ' + rs[i].name); console.log('pwd : ' + rs[i].pwd); } conn.release(); }); });
关闭
pool.releaseConnection(conn);