mysql 连接池

最新推荐文章于 2024-08-26 15:58:45 发布

A浪里小白龙A

最新推荐文章于 2024-08-26 15:58:45 发布

阅读量614

点赞数

分类专栏：个人总结文章标签： mysql pool

本文链接：https://blog.csdn.net/lxd875697126/article/details/38350243

版权

个人总结专栏收录该内容

20 篇文章 0 订阅

订阅专栏

 
 
  
  //mysql.js
 
 
 
 
  
  var 
  
  mysql 
  
  = 
  
  require
  
  (
  
  "mysql"
  
  );
 
 
 
 

 
 
 
 
  
   
 
 
 
 
  
  var 
  
  pool 
  
  = 
  
  mysql
  
  .
  
  createPool
  
  ({
 
 
 
         
  
  host     
  
  : 
  
  'localhost'
  
  ,
 
 
 
         
  
  user     
  
  : 
  
  'root'
  
  ,
 
 
 
         
  
  password 
  
  : 
  
  '123456'
  
  ,
 
 
 
         
  
  database 
  
  : 
  
  require
  
  (
  
  "../config"
  
  ).
  
  mysql_db
  
  ,
 
 
 
         
  
  connectionLimit 
  
  :
  
  40
 
 
 
 
  
  });
 
 
 
 
  
   
 
 
 
 
  
  exports
  
  .
  
  getConnection 
  
  = 
  
  function
  
  (
  
  func
  
  ) 
  
  {
 
 
 
         
  
  pool
  
  .
  
  getConnection
  
  (
  
  func
  
  );
 
 
 
 
  
  };
 
 
 
 
  
   
 
 
 
 
  
  exports
  
  .
  
  query 
  
  = 
  
  function
  
  (
  
  sql
  
  , 
  
  params
  
  , 
  
  func
  
  ) 
  
  {
 
 
 
         
  
  pool
  
  .
  
  getConnection
  
  (
  
  function
  
  (
  
  err
  
  , 
  
  conn
  
  ) 
  
  {
 
 
 
                 
  
  var 
  
  q 
  
  = 
  
  conn
  
  .
  
  query
  
  (
  
  sql
  
  , 
  
  params
  
  , 
  
  func
  
  );
 
 
 
                 
  
  console
  
  .
  
  log
  
  (
  
  q
  
  .
  
  sql
  
  );
 
 
 
                 
  
  conn
  
  .
  
  release
  
  ();
 
 
 
         
  
  });
 
 
 
 
  
  };
 
 
 
 
  
   
 
 
 
 
  
  //use.js
 
 
 
 
  
     
   
    
    //调用
   
   
   
   
    
    var 
    
    db 
    
    = 
    
    require
    
    (
    
    "mysql.js"
    
    );
   
   
   
   
    
    //查询
   
   
   
   
    
    exports
    
    .
    
    get 
    
    = 
    
    function
    
    (
    
    req
    
    , 
    
    res
    
    ){
   
   
   
       
    
    db
    
    .
    
    query
    
    (
    
    "select * from user"
    
    ,,
    
    function
    
    (
    
    err
    
    , 
    
    users
    
    ){
   
   
   
   	    
    
    return 
    
    res
    
    .
    
    render
    
    (
    
    'userList'
    
    ,{
    
    users	
    
    :	
    
    users
    
    );
   
   
   
       
    
    });
   
   
   
   
    
    };