//连接数据库池 安装之前是需要安装 npm install -g node-mysql 这个包的
//mysql_mode.js
var mysql = require("mysql");
//创建一个连接池的模块 然后导出
function OptPool(){
this.flag = true;
this.pool = createPool({
host:'localhost',
user:'root',
password:'mysql',
database:'cms',
port:'3306',
})
this.getPool = function(){
if(this.flag){
this.pool.on('connection',function(){
// 这是不太完整
connection.query('set session auto_increment_increment')
})
}
}
}
module.exports = OptPool;//导出模块
//另起一个页面 引入
var outpool = require("mysql_mode.js");
var optpool = new outpool();
var pool = optpool.getpool();
pool.getConnection(function(err,connection){
//增
var userAddSql = "insert into wp_user(nickname,mobile) values(?,?)";
var param = ['tom','18201262635'];
connection.query(userAddSql,param,function(err,res){
if(err){
console.log("错误是"+err.message)
}else{
console.log(res)
}
})
// 查
var select = "select nickname,mobile from wp_user";
connection.query(select,function(err,res){
if(err){
console.log("错误是"+err.message)
return;
}
console.log(res)
})
// 改
var update = "update wp_user set nickname=?,mobile=? where uid=2";
var param = ['bob','13492458551'];
connection.query(update,param,function(err,res){
if(err){
console.log("错误是"+err.message)
return;
}
console.log(res)
})
// 删
var select = "delete from wp_user where uid = 5";
connection.query(select,function(err,res){
if(err){
console.log("错误是"+err.message)
return;
}
console.log(res)
})
connection.release()//放回连接池
})
nodejs连接数据库二--连接数据库池
最新推荐文章于 2024-07-04 09:16:19 发布