nodejs个人博客开发第四步 数据模型

 /*查询*/  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); }

 /*添加*/ add:function(tableName,tableData,callback){   var sql="insert into "+this.C.DB_PRE+tableName;   var clumn='';   var value='';   for(var key in tableData){    clumn+=","+key;    value+=",'"+tableData[key]+"'";   }   clumns="("+clumn.substr(1)+")";  values="("+value.substr(1)+")";  sql=sql+clumns+"values"+values;  console.log(sql);  this.db.query(sql,callback);   }

 /*修改*/ update:function(tableName,tableData,where,callback){   var sql="update "+this.C.DB_PRE+tableName+" set ";   var clumns="";   for(var key in tableData){    clumns+=","+key+"='"+tableData[key]+"'";   }  clumns=clumns.substr(1);  sql+=clumns+" where "+where;  console.log(sql);  this.db.query(sql,callback);   }

 /*删除*/ delete:function(tableName,where,callback){   var sql="delete from "+this.C.DB_PRE+tableName+" where "+where;  console.log(sql);  this.db.query(sql,callback);   }

/***分类模型**/module.exports={ getAllList:function(){  db.select("category",function(err,list){   console.log(list);  }); }, /*添加*/ addCate:function(data){  db.add("category",data,function(err,list){   console.log(err);  }); }, /*修改*/ saveCate:function(data,where){  db.update("category",data,where,function(err,list){   console.log(err);  }); }, /*删除*/ delCate:function(where){  db.delete("category",where,function(err,list){   //console.log(err);  }); }};

 /*实例化模型*/ model:function(name){  return require("../model/"+name); }

/*** 首页控制器*/var router=express.Router();router.get('/',function(req,res,next){ F.model("category").getAllList(); //F.model("category").addCate({"name":"测试"}); //F.model("category").saveCate({"name":"测试1"},"id=4"); //F.model("category").delCate("id=4"); /*渲染模板*/ res.render("home/index");});module.exports=router;