/**
* Created by web-01 on 2018/1/4.
*/
const mysql=require("mysql");
var pool=mysql.createPool({
host:'127.0.0.1',
user:"root",
password:"",
database:"test",
port:3306,
connectionLimit:25 //连接数量限制
});
//连接池会常驻内存,所以程序不会停止
var sql="SELECT * FROM test WHERE tid=3";
pool.getConnection((err,conn)=>{
conn.query(sql,(err,res)=>{
console.log(res);
console.log(res[0]);
console.log(res[0].tid);
console.log(res[0].tname);
//释放连接 必须要释放,否则很快占满连接数!!!
conn.release();
});
});