node.js的generic-pool与mysql结合，mysql连接池

最新推荐文章于 2022-09-30 17:31:16 发布

youyudehexie

最新推荐文章于 2022-09-30 17:31:16 发布

阅读量4.1k

点赞数

分类专栏： node.js 文章标签： generic-pool node.js mysql 连接池

本文链接：https://blog.csdn.net/youyudehexie/article/details/8760992

版权

node.js 专栏收录该内容

47 篇文章 4 订阅

订阅专栏

var generic_pool = require('generic-pool');



var pool = generic_pool.Pool({

    name: 'mysql',

    max: 10,

    create: function(callback) {

        var Client = require('mysql').createConnection({

            host:'127.0.0.1',

            user:'root',

            password:'123456',

            database: 'weibo_gs'

        });



        callback(null,Client);

    },

    destroy: function(db) {

        db.disconnect();

    }

});



pool.acquire(function(err, client) {



    if (err) {

        // handle error - this is generally the err from your

        // factory.create function  

    }

    else {

        client.query("select * from gs_scrapy", [], function(err,data) {

            console.log(data);

            // return object back to pool

            pool.release(client);

        });

    }

});