express和mysqlPool连接池连接数据库mysql

1. app.js读取文件模块

var express = require('express');
var router = express.Router();
var app = express();
var fs = require('fs');
var PATH = './public/data/'

// 静态资源映射
app.use("/login.html", express.static("login.html"));

router.all('/meetingList', function (req, res) {
    res.header("Access-Control-Allow-Origin", "*");
    res.header('Access-Control-Allow-Methods', 'PUT, GET, POST, DELETE, OPTIONS');
    res.header("Access-Control-Allow-Headers", "X-Requested-With");
    res.header('Access-Control-Allow-Headers', 'Content-Type');
    var type = req.param('type') || '';
    
    // 读文件
    fs.readFile(PATH + 'list.json', function (err, data) {
        if (err) {
            return res.send({
                status: 'fail',
                info: '读取文件异常'
            });
        }
        // var COUNT = 50;//返回最多50行数据
        var obj = [];
        try {
            obj = JSON.parse(data.toString());//这里做异常处理，如果文件中存储的不是json格式的字符串（比如空文件）这里会抛出异常
        } catch (e) {
            obj = [];
        }

        // if (obj.length > COUNT) {
        //     obj = obj.slice(0, COUNT);//返回前50行数据

        // }
        return res.send({
            status: 'ok',
            data: obj
        });
    });
})

module.exports = router;

2. app.js 进行mysqlPool数据库操作

var express = require('express');
var app = express();
const pool = require("./pool.js");

 //数据库使用
    pool.query("select * from user where uname = ? and upws = ?",[obj.uname,                 
    obj.upwd], function (err, results) {
        if(results && results.length > 0){
             return res.send({
                status: 'ok',
             });
        } else {
            res.send('失败，请重试');
        }
    });

pool.js文件的配置

// pool.js文件
const mysql=require("mysql");
var pool=mysql.createPool({
host:"127.0.0.1",
port:3306,
user:"root",
password:"xxxxx",
database:"mysql1",
connectLimit:15
});

pool.query=function(sql,options,callback){
    pool.getConnection(function(err,conn){
        if(err){
            callback(err,null,null);
        }else{
            conn.query(sql,options,function(err,results){
                //释放连接  
                conn.release();
                //事件驱动回调  
                callback(err,results);
            });
        }
    });
};

module.exports=pool;