๐Ÿ“ฆ fghpdf / nodejs-ppt

๐Ÿ“„ mysql-select.js ยท 19 lines
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19var pool = require('./mysql-pooling');

var query = function(select, table ,callback){
    var selectSQL = "select " + select + " from " + table + ";";
    console.log(selectSQL);
    pool.getConnection(function(err, conn){
        if(err){
            callback(err, null, null);
        }else{
            conn.query(selectSQL, function(qerr, vals, fields){
                conn.release();
                console.log(vals);
                callback(qerr, vals, fields);
            });
        }
    });
};

module.exports = query;