List集合自定义分页插件。级联查询时，不能再mapper层分页

zhengTornado

已于 2022-02-07 14:51:36 修改

阅读量260

点赞数

分类专栏： java开发常用工具类文章标签： list List分页 java

于 2021-12-21 17:56:50 首次发布

本文链接：https://blog.csdn.net/zhengTornado/article/details/122070005

版权

java开发常用工具类专栏收录该内容

29 篇文章 2 订阅

订阅专栏

list集合调用自定义分页接口

package org.jeecg.modules.lecoo.outModalApp.autoPage;

import lombok.Data;

import java.io.Serializable;
import java.util.List;


@Data
public class PagingResult implements Serializable {

    private static final long serialVersionUID = 1L;
    //总共条数
    private long total;
    //每页条数
    private int size;
    //当前页
    private int current;
    //分了多少页
    private long pages;
    //分页数据
    private List records;


    public PagingResult() {
    }


    @Override
    public String toString() {
        return "PagingResult{" +
                "total=" + total +
                ", size=" + size +
                ", current=" + current +
                ", pages=" + pages +
                ", records=" + records +
                '}';
    }
}

package org.jeecg.modules.lecoo.outModalApp.autoPage;

import org.jeecg.modules.lecoo.outModalApp.entity.OutTaskNewEntity;

import java.util.List;

public class PageUtil {

    /**
     * @param pageInfo
     * @param list
     * @return
     */
    public static PagingResult getPage(PageInfo pageInfo, List<OutTaskNewEntity> list) {
        //实例化分页结果对象
        PagingResult result = new PagingResult();
        //总条数
        result.setTotal(list.size());
        //当前页
        result.setCurrent(pageInfo.getCurrent());
        //每页大小
        result.setSize(pageInfo.getLimit());
        //分多少页
        if (pageInfo.getLimit() == 0) {
            result.setPages(0);
        } else {
            long pages = result.getTotal() / pageInfo.getLimit();
            if ( result.getTotal() % pageInfo.getLimit() != 0) {
                ++pages;
            }
            result.setPages(pages);

        }
        //第一条标记
        int start = Integer.parseInt(String.valueOf(pageInfo.getLimit() * (pageInfo.getCurrent() - 1)));
        //最后一条标记
        int end = Integer.parseInt(String.valueOf(pageInfo.getLimit() * pageInfo.getCurrent()));
        if (end >= list.size()) {
            end = list.size();
        }
        //根据标记取数据
        List newList = list.subList(start, end);
        //回填数据
        result.setRecords(newList);
        return result;
    }
}

package org.jeecg.modules.lecoo.outModalApp.autoPage;

import java.io.Serializable;


public class PageInfo implements Serializable {

    private static final long serialVersionUID = 1L;
    //页数
    private int current;
    //每页条数
    private int limit;

    public PageInfo() {
    }

    public PageInfo(int current, int limit) {
        this.current = current;
        this.limit = limit;
    }

    public int getCurrent() {
        return current;
    }

    public void setCurrent(int current) {
        this.current = current;
    }

    public int getLimit() {
        return this.limit;
    }

    public void setLimit(int limit) {
        this.limit = limit;
    }

    public String toString() {
        StringBuffer sb = new StringBuffer("PageInfo{");
        sb.append("current = ").append(this.current);
        sb.append(", limit = ").append(this.limit);
        sb.append(" }");
        return sb.toString();
    }
}

业务代码层，List集合处理好业务，直接分页
在这里插入图片描述

自定义分页，解决级联查询时，每次翻页只返回10条数据

思路：先按jeecgboot框架中的分页查询。取出10条数据的主键ID。再次级联查询，处理中间的各种业务数据。

    public static PagingResult getPage(PageInfo pageInfo, Integer listTotal, List<OutTaskNewEntity> tasklist) {
        //实例化分页结果对象
        PagingResult result = new PagingResult();
        //总条数
        result.setTotal(listTotal);
        //当前页
        result.setCurrent(pageInfo.getCurrent());
        //每页大小
        result.setSize(pageInfo.getLimit());
        //分多少页
        if (pageInfo.getLimit() == 0) {
            result.setPages(0);
        } else {
            long pages = result.getTotal() / pageInfo.getLimit();
            if (result.getTotal() % pageInfo.getLimit() != 0) {
                ++pages;
            }
            result.setPages(pages);

        }
//        //第一条标记
//        int start = Integer.parseInt(String.valueOf(pageInfo.getLimit() * (pageInfo.getCurrent() - 1)));
//        //最后一条标记
//        int end = Integer.parseInt(String.valueOf(pageInfo.getLimit() * pageInfo.getCurrent()));
//        if (end >= listTotal) {
//            end = listTotal;
//        }
        //根据标记取数据
        // List newList = list.subList(start, end);
        //回填数据
        result.setRecords(tasklist);
        return result;
    }