Nodejs+mysql返回查询的数据结果

const mysqlDAO = require('./mysql.js');

//result为查询返回的结果
function processData(result) {
    var data = JSON.stringify(result)
    console.log("JSON:" + data);

    var json = JSON.parse(data);
    //自定义用户内容
}

function dbTrainInfo() {
    var sql = `select * from stationtrain limit 2 `;
    //processData为回调方法
    mysqlDAO.queryDataBySQL(sql, processData);
}

mysql.js

var mysql = require("mysql");

var pool = mysql.createPool({
    host: 'localhost',
    user: 'root',
    password: '******',
    database: 'station',
    port: 3306
});

//callback为回调方法
function queryDataBySQL(sql, callback) {
    pool.getConnection(function (err, connection) {
        connection.query(sql, function (err, result) {
            if (err) {
                console.log(err);
            } else {
                //console.log("query:" + result);
                callback(result);
            }
        });
        connection.release();
        //console.log("close mysql connection");
    });
};

module.exports = {
    queryDataBySQL: queryDataBySQL
}