config.js:

    1. const mysqlConfig = {
    2.     host: 'localhost',
    3.     port: 3306,
    4.     database: 'test',
    5.     user: 'root',
    6.     password: 'root'
    7. }
    8. module.exports = {
    9.     mysqlConfig
    10. }

    mysql.js:

    1. const mysqlConfig = require('../config/config.js');
    2. //创建并使用连接池对象
    3. const mysql = require('mysql');
    4. const pool = mysql.createPool(mysqlConfig);
    6. // 封装函数，调用
    7. function doSQL(sql, params = []) {
    8.     return new Promise((resolve, reject) => {
    9.         pool.getConnection(function (error, connection) {
    10.             if (error) {
    11.                 reject(error)
    12.             } else {
    13.                 connection.query(sql, params, function (err, data, fields) {
    14.                     connection.release()
    15.                     resolve({
    16.                         err,
    17.                         data,
    18.                         fields
    19.                     })
    20.                 })
    21.             }
    22.         })
    23.     })
    24. }
    25. module.exports = doSQL;