java把list数据改为分页

//把list转化为分页
    public List getListByPage(List list,int page,int pageSize) {
        if(list.size() > 0 ){
            int firstIndex = (page - 1) * pageSize;
            int lastIndex = page * pageSize;
            int actualLastIndex = 0;
            if(list.size() > lastIndex || list.size() == lastIndex){
                actualLastIndex = lastIndex;
            }else{
                actualLastIndex = list.size();
            }
            return list.subList(firstIndex,actualLastIndex);
        }
        return list;
    }

 

 

page模型

public class Page<T extends Serializable> implements Serializable {
   private static final long serialVersionUID = -5764853545343945831L;

   /**
    * 当前分页的数据集
    */
   private List<T> list = null;

   /**
    * 总记录数
    */
   private int totalCount = 0;

   /**
    * 总页数
    */
   private int totalPage = 0;

   /**
    * 当前页
    */
   private int pageCurrent = 1;

   /**
    * 每页记录数
    */
   private int pageSize = 20;

   /**
    * 默认构造函数
    */
   public Page() {
   }

   /**
    * 构造函数
    * 
    * @param totalCount
    *            总记录数
    * @param totalPage
    *            总页数
    * @param pageCurrent
    * @param pageSize
    * @param list
    */
   public Page(int totalCount, int totalPage, int pageCurrent, int pageSize, List<T> list) {
      this.totalCount = totalCount;
      this.totalPage = totalPage;
      this.pageCurrent = pageCurrent;
      this.pageSize = pageSize;
      this.list = list;
   }

   public List<T> getList() {
      return list;
   }

   public void setList(List<T> list) {
      this.list = list;
   }

   public int getTotalCount() {
      return totalCount;
   }

   public void setTotalCount(int totalCount) {
      this.totalCount = totalCount;
   }

   public int getTotalPage() {
      return totalPage;
   }

   public void setTotalPage(int totalPage) {
      this.totalPage = totalPage;
   }

   public int getPageCurrent() {
      return pageCurrent;
   }

   public void setPageCurrent(int pageCurrent) {
      this.pageCurrent = pageCurrent;
   }

   public int getPageSize() {
      return pageSize;
   }

   public void setPageSize(int pageSize) {
      this.pageSize = pageSize;
   }

   @Override
   public String toString() {
      return "Page [list=" + list + ", totalCount=" + totalCount + ", totalPage=" + totalPage + ", pageCurrent=" + pageCurrent + ", pageSize=" + pageSize + "]";
   }

}

 

list转page工具类

 

public final class PageUtil<T extends Serializable> implements Serializable {

    private static final Logger logger = LoggerFactory.getLogger(PageUtil.class);

    private static final long serialVersionUID = 1L;

    /**
     * 默认每页记录数(20)
     */
    public static final int DEFAULT_PAGE_SIZE = 20;

    /**
     * 最大每页记录数(1000)
     */
    public static final int MAX_PAGE_SIZE = 1000;

    private PageUtil() {
    }

    public static <T extends Serializable> Page<T> transform(Page<?> page, Class<T> classType) {
        Page<T> pb = new Page<>();
        try {
            pb.setList(copyList(page.getList(), classType));
        } catch (Exception e) {
            logger.error("transform error", e);
        }
        pb.setPageCurrent(page.getPageCurrent());
        pb.setPageSize(page.getPageSize());
        pb.setTotalCount(page.getTotalCount());
        pb.setTotalPage(page.getTotalPage());
        return pb;
    }

    /**
     * 分页集合复制
     *
     * @param page
     * @param list
     * @param classType
     * @param <T>
     * @return
     */
    public static <T extends Serializable> Page<T> transform(Page<?> page, List<?> list, Class<T> classType) {
        Page<T> pb = new Page<>();
        try {
            pb.setList(copyList(list, classType));
        } catch (Exception e) {
            logger.error("transform error", e);
        }
        pb.setPageCurrent(page.getPageCurrent());
        pb.setPageSize(page.getPageSize());
        pb.setTotalCount(page.getTotalCount());
        pb.setTotalPage(page.getTotalPage());
        return pb;
    }

    /**
     * @param source
     * @param clazz
     * @return
     * @throws IllegalAccessException
     * @throws InvocationTargetException
     * @throws InstantiationException
     */
    public static <T> List<T> copyList(List<?> source, Class<T> clazz) {
        if (source == null || source.size() == 0) {
            return Collections.emptyList();
        }
        List<T> res = new ArrayList<>(source.size());
        for (Object o : source) {
            try {
                T t = clazz.newInstance();
                res.add(t);
                BeanUtils.copyProperties(o, t);
            } catch (Exception e) {
                logger.error("copyList error", e);
            }
        }
        return res;
    }

    /**
     * 检测sql,防止sql注入
     *
     * @param sql sql
     * @return 正常返回sql;异常返回""
     */
    public static String checkSql(String sql) {
        String inj_str = "'|and|exec|insert|select|delete|update|count|*|%|chr|mid|master|truncate|char|declare|;|or|+|,";
        String inj_stra[] = inj_str.split("\\|");
        for (int i = 0; i < inj_stra.length; i++) {
            if (sql.indexOf(inj_stra[i]) >= 0) {
                return "";
            }
        }
        return sql;
    }

    /**
     * 计算总页数
     *
     * @param totalCount 总记录数.
     * @param pageSize   每页记录数.
     * @return totalPage 总页数.
     */
    public static int countTotalPage(final int totalCount, final int pageSize) {
        if (totalCount == 0) {
            return 1;
        }
        if (totalCount % pageSize == 0) {
            return totalCount / pageSize; // 刚好整除
        } else {
            return totalCount / pageSize + 1; // 不能整除则总页数为:商 + 1
        }
    }

    /**
     * 校验当前页数pageCurrent<br/>
     * 1、先根据总记录数totalCount和每页记录数pageSize,计算出总页数totalPage<br/>
     * 2、判断页面提交过来的当前页数pageCurrent是否大于总页数totalPage,大于则返回totalPage<br/>
     * 3、判断pageCurrent是否小于1,小于则返回1<br/>
     * 4、其它则直接返回pageCurrent
     *
     * @param totalCount  要分页的总记录数
     * @param pageSize    每页记录数大小
     * @param pageCurrent 输入的当前页数
     * @return pageCurrent
     */
    public static int checkPageCurrent(int totalCount, int pageSize, int pageCurrent) {
//    int totalPage = countTotalPage(totalCount, pageSize); // 最大页数
//    if (pageCurrent > totalPage) {
//       // 如果页面提交过来的页数大于总页数,则将当前页设为总页数
//       // 此时要求totalPage要大于获等于1
//       if (totalPage < 1) {
//          return 1;
//       }
//       return totalPage;
//    } else
        if (pageCurrent < 1) {
            return 1; // 当前页不能小于1(避免页面输入不正确值)
        } else {
            return pageCurrent;
        }
    }

    /**
     * 校验页面输入的每页记录数pageSize是否合法<br/>
     * 1、当页面输入的每页记录数pageSize大于允许的最大每页记录数MAX_PAGE_SIZE时,返回MAX_PAGE_SIZE
     * 2、如果pageSize小于1,则返回默认的每页记录数DEFAULT_PAGE_SIZE
     *
     * @param pageSize 页面输入的每页记录数
     * @return checkPageSize
     */
    public static int checkPageSize(int pageSize) {
        if (pageSize > MAX_PAGE_SIZE) {
            return MAX_PAGE_SIZE;
        } else if (pageSize < 1) {
            return DEFAULT_PAGE_SIZE;
        } else {
            return pageSize;
        }
    }

    /**
     * 计算当前分页的开始记录的索引
     *
     * @param pageCurrent 当前第几页
     * @param pageSize    每页记录数
     * @return 当前页开始记录号
     */
    public static int countOffset(final int pageCurrent, final int pageSize) {
        return (pageCurrent - 1) * pageSize;
    }

    /**
     * 根据总记录数,对页面传来的分页参数进行校验,并返分页的SQL语句
     *
     * @param pageCurrent 当前页
     * @param pageSize    每页记录数
     * @param pageBean    DWZ分页查询参数
     * @return limitSql
     */
    public static String limitSql(int totalCount, int pageCurrent, int pageSize) {
        // 校验当前页数
        pageCurrent = checkPageCurrent(totalCount, pageSize, pageCurrent);
        pageSize = checkPageSize(pageSize); // 校验每页记录数
        return new StringBuffer().append(" limit ").append(countOffset(pageCurrent, pageSize)).append(",").append(pageSize).toString();
    }

    /**
     * 根据分页查询的SQL语句,获取统计总记录数的语句
     *
     * @param sql 分页查询的SQL
     * @return countSql
     */
    public static String countSql(String sql) {
        String countSql = sql.substring(sql.toLowerCase().indexOf("from")); // 去除第一个from前的内容
        return new StringBuffer().append("select count(*) ").append(removeOrderBy(countSql)).toString();
    }

    /**
     * 移除SQL语句中的的order by子句(用于分页前获取总记录数,不需要排序)
     *
     * @param sql 原始SQL
     * @return 去除order by子句后的内容
     */
    private static String removeOrderBy(String sql) {
        Pattern pat = Pattern.compile("order\\s*by[\\w|\\W|\\s|\\S]*", Pattern.CASE_INSENSITIVE);
        Matcher mc = pat.matcher(sql);
        StringBuffer strBuf = new StringBuffer();
        while (mc.find()) {
            mc.appendReplacement(strBuf, "");
        }
        mc.appendTail(strBuf);
        return strBuf.toString();
    }
    //把list转化为分页
    public static List getListByPage(List list, int page, int pageSize) {
        if (list.size() > 0) {
            int firstIndex = (page - 1) * pageSize;
            int lastIndex = page * pageSize;
            int actualLastIndex = 0;
            if (list.size() > lastIndex || list.size() == lastIndex) {
                actualLastIndex = lastIndex;
            } else {
                actualLastIndex = list.size();
            }
            return list.subList(firstIndex, actualLastIndex);
        }
        return list;
    }

    /**
     * 模糊查询
     *
     * @param str
     * @return
     */
    public static String like(String str) {
        return new StringBuffer().append("%").append(str).append("%").toString();
    }

    /**
     * 模糊查询
     *
     * @param str
     * @return
     */
    public static String rightLike(String str) {
        return new StringBuffer().append(str).append("%").toString();
    }

}

 

 

 

最后实现代码

 

 

 

List<SchoolFileInfo> listByTimeAndTypeAndUserNo = schoolFileInfoDao.getListByTimeAndTypeAndUserNo(times, qo.getUserNo(), byUserNo.getOrgId());
List<SchoolFileInfoDTO> schoolFileInfoDTOS = BeanUtil.copyProperties(listByTimeAndTypeAndUserNo, SchoolFileInfoDTO.class);
int totalPage;
if (schoolFileInfoDTOS.size() == 0) {
    totalPage = 0;

} else if (qo.getPageSize() > schoolFileInfoDTOS.size()) {
    totalPage = 1;
} else {
    totalPage = (int) Math.ceil(1.0 * schoolFileInfoDTOS.size() / qo.getPageSize());
}
//分页
List listByPage = this.getListByPage(schoolFileInfoDTOS, qo.getPageCurrent(), qo.getPageSize());
Page<SchoolFileInfoDTO> page = new Page<SchoolFileInfoDTO>(schoolFileInfoDTOS.size(), totalPage, qo.getPageCurrent(), qo.getPageSize(), listByPage);
Page<SchoolFileInfoDTO> listForPage = PageUtil.transform(page, SchoolFileInfoDTO.class);
return Result.success(listForPage);
  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值