node 连接mysql（连接池）

/**

 * @name: 

 * @test: test font

 * @msg: Mysql 数据库连接

 * @param {type} 

 * @return: 

 */

let Mysql = require('mysql');

module.exports = {

    config: {

        host: '',

        password: '’',

        user: '',

        database: ''

    },

 

    SqlConnection(sql, SqlArr) {

        return new Promise((resolve, reject) => {

            var pool = Mysql.createPool(this.config)

            pool.getConnection((err, data) => {

                if (err) {

                    reject(err)

                } else {

                    data.query(

                        sql, SqlArr, function (err, result) {

                            if (err) {

                                reject(err)

                            } else {

                                resolve(result)

                            }

                        }

                    )

            data.release();

                }

            })

        })

    },

 

}