[nodejs] nodejs开发个人博客（六）数据分页详解编程语言

/** 
* 首页控制器 
*/ 
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',function(req,res,next){ 
    var currentPage=parseInt(req.params.page); 
    var cid=0; 
    F.model("article").assignIndexData(cid,currentPage,pageSize,res); 
});

/*分类页*/ 
router.get('/category/:cid/:page',function(req,res,next){ 
    var cid=req.params.cid; 
    var currentPage=parseInt(req.params.page); 
    F.model("article").assignIndexData(cid,currentPage,pageSize,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,currentPage,pageSize,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,callback); 
    }, 
    /*归档*/ 
    getArchives:function(callback){ 
        db.query("select time from article order by time desc",callback); 
    }, 
    /*分配首页数据*/ 
    assignIndexData:function(cid,currentPage,pageSize,res){ 
        var categoryModel=F.model("category"); 
        var articleModel=this; 
        // 分类数据 
        categoryModel.getAllList(function(err,categoryList){ 
            // 文章条数 
            articleModel.getCount(cid,function(err,nums){ 
                // 文章分页 
                articleModel.getArticlePager(cid,currentPage,pageSize,function(err,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);     
                    });             
                }); 
            }); 
 
        }); 
    } 
};

          <nav> 
            <ul class="pager"> 
              <li><a class="btn <%if(currentPage==prePage){%>disabled<%}%>"  
                href="/<%if(cid!=0){%>category/<%=cid%>/<%}else{%>index/<%}%><%=prePage%>">上一页</a></li> 
              <li><a class="btn <%if(currentPage==nextPage){%>disabled<%}%>"  
                href="/<%if(cid!=0){%>category/<%=cid%>/<%}else{%>index/<%}%><%=nextPage%>">下一页</a></li> 
            </ul> 
          </nav>