第一个文件config.js
/* 配置类*/
var path = require('path');
exports.config = {
debug: true,
name: '数据中心',
db: { "host": '192.168.222.133', "database": 'chidata', "port": 3306, "user": 'goyoo', "password": "123456" }, //数据库连接
domain: "localhost",
host: 3000, //启动端口
loginurl: "http://localhost:2700"
};
另外一个文件data.js
var configs = require('./config').config;
var cn = require('mysql');
exports.mysqlCnn = function(sql,callback){
var mysqlcn = cn.createConnection(configs.db);
mysqlcn.connect();
mysqlcn.query(sql,function(err,results,fields){
if(err){
console.log(err);
mysqlcn.end();
callback(err,undefined);
};
mysqlcn.end();
callback(undefined,results);
});
} ;