nodejs实现分页功能

1. find 方法修改

db.collection(collectionName).find(json1,{fields:attr}).skip(slipNum).limit(pageSize);

2.封装 count 方法

var result=db.collection(collection).count(json);//nodejs封装mongodb知识
result.then(data=>{
	resolve(data);
	}

3.数据结合 jqPaginator 实现分页
http://jqpaginator.keenwon.com/
a.引入js文件jqPaginator.js，并声明

<script src="{{_HOST_}}/admin/jqPaginator.js"></script>

b.引入js分页逻辑

<script>
		$('#page').jqPaginator({
			totalPages: {{totalPages}},
			visiblePages: 8,
			currentPage: {{page}},
			onPageChange: function (num, type) {
				console.log(num, type);
//
				if(type=='change'){
					location.href="{{_HOST_}}/admin/focus?page="+num;
				}
			}
		});
	</script>

c.在表格下加上分页html

<div id="page" class="pagination"></div>

d.在后台引入分页所需数据

var result=await DB.find('article',{},{},{
        page,pageSize,
        sortJson:{
            'add_time':-1
        }
    });
    await ctx.render('admin/article/list',{
        list:result,
        page:page,
        totalPages:Math.ceil(count/pageSize)
    });