Node.js连接mysql

---

下载

npm install --save mysql

为了方便，我先封装成Util类

MysqlClient.js

require('./util/CommonUtil');var mysql = require('mysql');var config = require('./config/config').mysql;MysqlClient = function() {};MysqlClient.query = function(dataBase, sql, callback) {    var pool = mysql.createPool({        host: config.host,        port: config.port,        user: config.user,        password: config.password,        database: dataBase    });    pool.getConnection(function(err, connection) {        console.log('##    sql: ' + sql);        connection.query(sql, "", function(err, result) {            if (err) {                console.log('[queryBySql error] - ', err.message);                return;            }            callback(result);        });        connection.release();    });};