[nodejs] nodejs开发个人博客（三）载入页面详解编程语言

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

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

/*链接数据库*/  
global.db=require("./model/db").getInstances();

/** 
* 数据库操作类 
*/ 
var db={ 
    /*数据库对象*/ 
    db:null, 
    /*构造函数*/ 
    getInstances:function(){ 
        this.connectDatabase(); 
        return this; 
    }, 
    /*链接数据库*/ 
    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;