//每页显示五条
protected static final int PAGE_SIZE = 8;
/**
* 通过条件查询,查询分页结果
*/
public Pagination<T> getPage(int currentPage, Query query) {
//获取总条数
long totalCount = this.mongoTemplate.count(query, this.getEntityClass());
//总页数
int totalPage = (int) (totalCount/PAGE_SIZE);
int skip = (currentPage-1)*PAGE_SIZE;
Pagination<T> page = new Pagination<T>(currentPage, totalPage, (int)totalCount);
query.skip(skip);// skip相当于从那条记录开始
query.limit(PAGE_SIZE);// 从skip开始,取多少条记录
List<T> datas = this.find(query);
page.build(datas);//获取数据
return page;
}
@Service
public class VideoMongodbDao extends MongodbBaseDao<Video> {
@Override
protected Class<Video> getEntityClass() {
return Video.class;
}
}
public class Pagination<T> {
/** 每页显示条数 */
private Integer pageSize = 8;
/** 当前页 */
private Integer currentPage = 1;
/** 总页数 */
private Integer totalPage = 1;
/** 查询到的总数据量 */
private Integer totalNumber = 0;
/** 数据集 */
private List items;
public Integer getPageSize() {
return pageSize;
}
/**
* 处理查询后的结果数据
*
* @param items
* 查询结果集
* @param count
* 总数
*/
public void build(List items) {
this.setItems(items);
int count = this.getTotalNumber();
int divisor = count / this.getPageSize();
int remainder = count % this.getPageSize();
this.setTotalPage(remainder == 0 ? divisor == 0 ? 1 : divisor : divisor + 1);
}
Query query = new Query();
Criteria channleIdCri = Criteria.where("channelId").is(channel_id);
query.addCriteria(channleIdCri);
//获取当前页
String currentPageStr = request.getParameter("currentPage");
int currentPage = 0;
if (currentPageStr != null ){
currentPage = Integer.valueOf(currentPageStr);
}
Pagination<Video> videos = dao.getPage(currentPage, query);
m.addAttribute("videos", videos);//from
public class PaginationTag extends TagSupport {
/** 列表页面的form标签id值 */
private String form;
/** 与后台交互,保存在request中的 数据,该数据包含l */
private String pageInfo;//request对应的bean包含了分页的一些数据
/** 分页显示可点击页数的长度 */
private int size;
public PaginationTag(){
this.form = "form";
this.size = 5;
}
@Override
public int doStartTag() throws JspException {
int half = size / 2;
int point = size / 2 + size % 2;
int start = 1;
int loop = size;
Pagination query = (Pagination) this.pageContext.getRequest().getAttribute(pageInfo);
int pageSize = query.getPageSize();
int currentPage = query.getCurrentPage();
int totalPage = query.getTotalPage();
long totalNumber = query.getTotalNumber();
if(totalPage <= size){
start = 1;
loop = totalPage;
}else{
if(currentPage > point && currentPage < totalPage - half + 1){
start = 1 + (currentPage - point);
}else if(currentPage > totalPage - half){
start = totalPage - size + 1;
}
}
if(currentPage<=0){
currentPage = 1;
}
StringBuilder sb = new StringBuilder();
sb.append("<div class=\"box-ttl\"><div class=\"g4\">共 <span class=\"text-info\">");
sb.append(totalNumber).append("</span> 条数据");
sb.append("/共 <span class=\"text-info\">");
if(totalNumber!=0){
sb.append(totalPage).append("</span> 页!</div><div class=\"box collapsed g6 flt-r\"><ul class=\"nav-menu\">");
}else{
sb.append(0).append("</span> 页!</div><div class=\"box collapsed g6 flt-r\"><ul class=\"nav-menu\">");
}
// 处理上一页
if(currentPage == 1){
sb.append("<li class=\"disabled\"><a href=\"#\">上一页</a></li>");
}else{
sb.append("<li><a href=\"javascript:dopage(" + (currentPage - 1) + ",'" + form + "');\">上一页</a></li>");
}
// 处理中间数据
for(int i = start; i < start + loop; i++){
//<li class="active"><a href="#" rel="external nofollow" rel="external nofollow" >1</a></li>
if(currentPage == i){
sb.append("<li class=\"active\"><a href=\"#\">" + i + "</a></li>");
}else{
//<li><a href="#" rel="external nofollow" rel="external nofollow" >2</a></li>
sb.append("<li><a href=\"javascript:dopage(" + i + ",'" + form + "');\">" + i + "</a></li>");
}
}
// 处理下一页
if(currentPage == totalPage){
sb.append("<li class=\"disabled\"><a href=\"#\">下一页</a></li>");
}else{
sb.append("<li><a href=\"javascript:dopage(" + (currentPage + 1) + ",'" + form + "');\">下一页</a></li>");
}
sb.append("</ul></div></div>");
sb.append("<input type=\"hidden\" id=\"currentPage\" name=\"currentPage\" value=\"" + currentPage + "\"/>");
try {
pageContext.getOut().write(sb.toString());
} catch (IOException e) {
throw new JspException(e.toString(), e);
}
return super.doStartTag();
}
function dopage(currentPage,formid){
$("#currentPage").val(currentPage);
$("#" + formid).submit();
}
<div> <tv:pagination pageInfo="videos" form="video-form" size="5"></tv:pagination> </div>
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有