使用回掉大坑进行取数据

 能看明白的就看，看不明白的手动滑稽

/*** 首页控制器*/var router=express.Router();/*每页条数*/var pageSize=5;router.get('/',function(req,res,next){    var currentPage=parseInt(req.params.page);    var cid=0;        var categoryModel=F.model("category");    var articleModel=F.model("article");    // 分类数据    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

文章模型：

/*** 文章模型文件*/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);    }};