/*模板引擎*/ application.set('views',__dirname+'/views');application.engine('.html',require("ejs").__express);application.set('view engine','html');

/*** 首頁(yè)控制器*/var router=express.Router();router.get('/',function(req,res,next){  /*渲染模板*/  res.render("home/index");});module.exports=router;

/*鏈接數(shù)據(jù)庫(kù)*/ global.db=require("./model/db").getInstances();

/*** 數(shù)據(jù)庫(kù)操作類(lèi)*/var db={  /*數(shù)據(jù)庫(kù)對(duì)象*/  db:null,  /*構(gòu)造函數(shù)*/  getInstances:function(){    this.connectDatabase();    return this;  },  /*鏈接數(shù)據(jù)庫(kù)*/  connectDatabase:function(){    var mysql=require('mysql');    var db=mysql.createConnection({      host:C.DB_HOST,      user:C.DB_USER,      password:C.DB_PASS,      database:C.DB_NAME    });    db.connect();    this.db=db;    this.C=C;  },  select:function(tableName,callback,where,field){    field=field ? field : '*';    var sql="select "+field+" from "+this.C.DB_PRE+tableName;    if(where){      sql+=" where "+where;    }    this.db.query(sql,callback);  }}module.exports=db;