node里mySQL的封装

var db = {};
var mysql = require('mysql');
var pool = mysql.createPool({
  host: 'localhost',
  user: '123456',
  password: '123456',
  database: "serve",
  multipleStatements: true
});
db.query = function () {
  var sql, para, callback;
  if (arguments.length == 2) {
    sql = arguments[0];
    callback = arguments[1];
  } else {
    sql = arguments[0];
    para = arguments[1];
    callback = arguments[2];
  }
  if (!sql) {
    callback();
    return;
  }
  if (!para) {
    para = [];
  }
  pool.query(sql, para, function (err, rows, fields) {
    if (err) {
      //console.log(err);
      callback(err, null);
      return;
    };
    callback(null, rows, fields);
  });
}

module.exports = db;

使用

let db = require('./mysql.js');
let addSql ='INSERT INTO users(Id,content,createTime) VALUES (0,?,NOW())'
 let modSqlParams = [obj.content];
      db.query(addSql, modSqlParams, function (err, result) {
        if (err) {
          console.log('[INSERT ERROR] - ', err.message);
          return;
        }
          console.log('[INSERT success] - ', result);
      });