node.js健壮性问题及打印错误日志

var moment = require('moment'); var express = require('express'); var bodyparser = require('body-parser'); var app = express(); //var router = express.Router(); var mysql = require('mysql'); var querystring = require('querystring'); var port = process.env.PORT || 8080; var domain = require('domain'); var d = domain.create(); app.use(bodyparser.urlencoded({ extended: true })); //本地请求跨域 app.all('*', function(req, res, next) { res.header("Access-Control-Allow-Origin", "*"); res.header("Access-Control-Allow-Headers", "X-Requested-With"); res.header("Access-Control-Allow-Methods", "PUT,POST,GET,DELETE,OPTIONS"); res.header("X-Powered-By", ' 3.2.1') res.header("Content-Type", "application/json;charset=utf-8"); next(); }); var mysql = require('mysql'); //打印错误日志 var log4js = require('log4js'); //注意log4js的module位置引用是否正确 //log the cheese logger messages to a file, and the console ones as well. //通过configure()配置log4js log4js.configure({ appenders: { cheeseLogs: { type: 'file', filename: 'cheese.log' }, console: { type: 'console' } }, categories: { cheese: { appenders: ['cheeseLogs'], level: 'error' }, another: { appenders: ['console'], level: 'info' }, default: { appenders: ['console', 'cheeseLogs'], level: 'trace' } } }); const logger = log4js.getLogger('anotner'); //应用级路由 //--------------------------------------新版WIFI运营监控-------------------------------------- d.on('error', function(err) { console.log("68行" + err); }); d.run(function() { app.post("/newwifi", function(req, res) { var connection = mysql.createConnection({ host: '10.1.0.25', user: 'mysql', password: 'mysql123', port: '3306', database: 'wifi20dw' }); d.on('error', function(err) { console.log("80行" + err); }); d.run(function() { connection.connect(); }); var begintime = moment(req.body.begintime, "MM/DD/YYYY").format('YYYY-MM-DD'); var endtime = moment(req.body.endtime, "MM/DD/YYYY").format('YYYY-MM-DD'); let getList = "select WIFINO,DATE_FORMAT(min(mindaytime),'%Y-%m-%d %T') as `MIN TIME`,DATE_FORMAT(max(maxdaytime),'%Y-%m-%d %T') as `MAX TIME` from wifi20dw.wifidaystatic where recday between '" + begintime + "' and '" + endtime + "' group by wifino"; connection.query(getList, function(err, rows, fields) { if(err) { logger.info("90行" + err); } logger.info(rows); var a = rows; var obj = { data: [], cols: [] } var ending = false; a.forEach(function(v, i) { var arr = [] for(var i in v) { arr.push(v[i]); if(ending == false) { obj.cols.push({ title: i }); } } ending = true; obj.data.push(arr); }); res.send(obj); }); connection.end(function(err) { if(err) { console.log("118行"+err); } else { console.log("断开连接"); } }); }); }); //var newwifi = require('../../routes/newwifi'); //app.use('/newwifi', newwifi); //--------------------------------------新版路由器功能监控-------------------------------------- d.on('error', function(err) { console.log(err); }); d.run(function() { app.post("/newroutermon", function(req, res) { var connection = mysql.createConnection({ host: '10.1.0.25', user: 'mysql', password: 'mysql123', port: '3306', database: 'wifi20dw' }); d.on('error', function(err) { console.log("145行" + err); }); d.run(function() { connection.connect(); }); let getList = "select wifino,DATE_FORMAT(maxdaytime,'%Y-%m-%d %T')as maxdaytime,TIMESTAMPDIFF(DAY,now(),maxdaytime) as DIFFDAYS from wifi20dw.wifidaystatic group by wifino order by DIFFDAYS desc;"; connection.query(getList, function(err, rows, fields) { if(err) { logger.info(err); } logger.info(rows); var a = rows; var obj = { data: [], cols: [] } var ending = false; a.forEach(function(v, i) { var arr = [] for(var i in v) { arr.push(v[i]); if(ending == false) { obj.cols.push({ title: i }); } } ending = true; obj.data.push(arr); }); res.send(obj); }); connection.end(function(err) { if(err) { console.log("180行"+err); } else { console.log("断开连接"); } }); }); }); //--------------------------------------旧版WIFI运营监控-------------------------------------- d.on('error', function(err) { console.log(err); }); d.run(function() { app.post("/oldwifi", function(req, res) { var connection = mysql.createConnection({ host: '10.1.0.25', user: 'mysql', password: 'mysql123', port: '3306', database: 'wifi20dw' }); d.on('error', function(err) { console.log("203行" + err); }); d.run(function() { connection.connect(); }); var begintime = moment(req.body.begintime, "MM/DD/YYYY").format('YYYY-MM-DD'); var endtime = moment(req.body.endtime, "MM/DD/YYYY").format('YYYY-MM-DD'); let getList = "select WIFINO,DATE_FORMAT(min(mindaytime),'%Y-%m-%d %T') as `MIN TIME`,DATE_FORMAT(max(maxdaytime),'%Y-%m-%d %T') as `MAX TIME` from wifi20dw.wifidaystatv1 where recday between '" + begintime + "' and '" + endtime + "' group by wifino"; connection.query(getList, function(err, rows, fields) { if(err) { logger.info(err); } logger.info(rows); var a = rows; var obj = { data: [], cols: [] } var ending = false; a.forEach(function(v, i) { var arr = [] for(var i in v) { arr.push(v[i]); if(ending == false) { obj.cols.push({ title: i }); } } ending = true; obj.data.push(arr); }); res.send(obj); }); connection.end(function(err) { if(err) { console.log("242行"+err); } else { console.log("断开连接"); } }); }); }); //--------------------------------------旧版路由器功能监控-------------------------------------- d.on('error', function(err) { console.log(err); }); d.run(function() { app.post("/oldroutermon", function(req, res) { var connection = mysql.createConnection({ host: '10.1.0.25', user: 'mysql', password: 'mysql123', port: '3306', database: 'wifi20dw' }); d.on('error', function(err) { console.log("145行" + err); }); d.run(function() { connection.connect(); }); let getList = "select wifino,DATE_FORMAT(maxdaytime,'%Y-%m-%d %T')as maxdaytime,TIMESTAMPDIFF(DAY,now(),maxdaytime) as DIFFDAYS from wifi20dw.wifidaystatv1 group by wifino order by DIFFDAYS desc;"; connection.query(getList, function(err, rows, fields) { if(err) { logger.info(err); } logger.info(rows); var a = rows; var obj = { data: [], cols: [] } var ending = false; a.forEach(function(v, i) { var arr = [] for(var i in v) { arr.push(v[i]); if(ending == false) { obj.cols.push({ title: i }); } } ending = true; obj.data.push(arr); }); res.send(obj); }); connection.end(function(err) { if(err) { console.log("180行"+err); } else { console.log("断开连接"); } }); }); }); //端口监听 app.listen(8282);