前端之家收集整理的这篇文章主要介绍了
nodejs个人博客开发第六步 数据分页,
前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
@H_301_0@本文为大家分享了nodejs个人博客开发的数据分页,具体内容如下
@H_
3010@控制器路由定义
@H301_0@
首页路由:
http://localhost:8888/
@H_
301_0@
首页分页路由:
http://localhost:8888/index/2
<div class="jb51code">
<pre class="brush:js;">
/**
- 首页控制器
/
var router=express.Router();
/每页条数/
var pageSize=4;
/首页/
router.get('/',function(req,res,next){
var cid=0;
F.model("article").assignIndexData(cid,1,pageSize,res);
});
/首页分页*/
router.get('/index/:page',next){
var currentPage=parseInt(req.params.page);
var cid=0;
F.model("article").assignIndexData(cid,currentPage,res);
});
分类页*/
router.get('/category/:cid/:page',next){
var cid=req.params.cid;
var currentPage=parseInt(req.params.page);
F.model("article").assignIndexData(cid,res);
});
-
文章模型文件
/
module.exports={
/获取条数/
getCount:function(categoryId,callback){
var condition="";
if(categoryId!=0){
condition="where category_id="+categoryId;
}
var sql="select count() num from article "+condition;
db.query(sql,callback);
},/获取分页数据/
getArticlePager:function(categoryId,callback){
if(currentPage<=0||!currentPage) currentPage=1;
var start=(currentPage-1)pageSize;
var end=pageSize;
var condition="";
if(categoryId!=0){
condition="where category_id="+categoryId;
}
var sql="select from article "+condition+" order by time desc limit "+start+","+end;
db.query(sql,/归档/
getArchives:function(callback){
db.query("select time from article order by time desc",/分配首页数据/
assignIndexData:function(cid,res){
var categoryModel=F.model("category");
var articleModel=this;
// 分类数据
categoryModel.getAllList(function(err,categoryList){
// 文章条数
articleModel.getCount(cid,function(err,nums){
// 文章分页
articleModel.getArticlePager(cid,articleList){
var nextPage=(currentPage+1)>=Math.ceil(nums[0].num/pageSize) ? Math.ceil(nums[0].num/pageSize) : currentPage+1;
var prePage=(currentPage-1)<=0 ? 1 : currentPage-1;
// 归档
articleModel.getArchives(function(err,allArticleTime){
var newArticleTime=[];
for(var i=0;i<allArticleTime.length;i++){
newArticleTime.push(F.phpDate("y年m月",allArticleTime[i].time));
}
/分配数据/
var data={
categoryList:categoryList,articleList:articleList,cid:cid,nextPage:nextPage==0 ? 1 : nextPage,prePage:prePage,allArticleTime:newArticleTime,currentPage:currentPage
};
/*渲染模板*/
res.render("home/index",data);
});
});
});
});
}
};