Java实现List的分页
最近在项目中遇到一个问题,需要两个sql查询查询出两个list的集合,然后插入到一个list中,这时候会发现通过pagehelper分页只对最近的那个list有效,不能够实现分页的需求,所以我想到了通过list分页来完成这个需求。
public class PageInfoUtils {
public <T> PageInfo<T> list2PageInfo(List<T> arrayList, Integer pageNum, Integer pageSize) {
//实现list分页
PageHelper.startPage(pageNum, pageSize);
int pageStart = pageNum == 1 ? 0 : (pageNum - 1) * pageSize;
int pageEnd = arrayList.size() < pageSize * pageNum ? arrayList.size() : pageSize * pageNum;
List<T> pageResult = new LinkedList<T>();
if (arrayList.size() > pageStart) {
pageResult = arrayList.subList(pageStart, pageEnd);
}
PageInfo<T> pageInfo = new PageInfo<T>(pageResult);
//获取PageInfo其他参数
pageInfo.setTotal(arrayList.size());
int endRow = pageInfo.getEndRow() == 0 ? 0 : (pageNum - 1) * pageSize + pageInfo.getEndRow() + 1;
pageInfo.setEndRow(endRow);
boolean hasNextPage = arrayList.size() <= pageSize * pageNum ? false : true;
pageInfo.setHasNextPage(hasNextPage);
boolean hasPreviousPage = pageNum == 1 ? false : true;
pageInfo.setHasPreviousPage(hasPreviousPage);
pageInfo.setIsFirstPage(!hasPreviousPage);
boolean isLastPage = (arrayList.size() > pageSize * (pageNum - 1) && arrayList.size() <= pageSize * pageNum) ? true : false;
pageInfo.setIsLastPage(isLastPage);
int pages = arrayList.size() % pageSize == 0 ? arrayList.size() / pageSize : (arrayList.size() / pageSize) + 1;
pageInfo.setNavigateLastPage(pages);
int[] navigatePageNums = new int[pages];
for (int i = 1; i < pages; i++) {
navigatePageNums[i - 1] = i;
}
pageInfo.setNavigatepageNums(navigatePageNums);
int nextPage = pageNum < pages ? pageNum + 1 : 0;
pageInfo.setNextPage(nextPage);
pageInfo.setPageNum(pageNum);
pageInfo.setPageSize(pageSize);
pageInfo.setPages(pages);
pageInfo.setPrePage(pageNum - 1);
pageInfo.setSize(pageInfo.getList().size());
int starRow = arrayList.size() < pageSize * pageNum ? 1 + pageSize * (pageNum - 1) : 0;
pageInfo.setStartRow(starRow);
PageHelper.clearPage();
return pageInfo;
}
}
之后是调用这个的代码
List<Map<String, Object>> mapList = testMapper.oneList(map);
List<Map<String, Object>> mapList1 = testMapper.twoList(map);
list.addAll(mapList);
list.addAll(mapList1);
this.ListSort(list);
PageInfoUtils pageInfoUtils = new PageInfoUtils();
PageInfo<Map<String, Object>> mapPageInfo = pageInfoUtils.list2PageInfo(list,pageNum,pageSize);
resultMap.put("list", mapPageInfo);
resultMap.put("total", mapPageInfo.getTotal());
其中ListSort这个方法是对合并后的list进行排序
void ListSort(List<Map<String,Object>> list) {
Collections.sort(list, new Comparator<Map<String,Object>>() {
@Override
public int compare(Map<String,Object> map1, Map<String,Object> map2) {
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
try {
Date dt1 = formatter.parse(map1.get("checkStartTime").toString());
Date dt2 = formatter.parse(map2.get("checkStartTime").toString());
if (dt1.getTime() < dt2.getTime()) {
return 1;
} else if (dt1.getTime() > dt2.getTime()) {
return -1;
} else {
return 0;
}
} catch (Exception e) {
e.printStackTrace();
}
return 0;
}
});
}
以上就是完成list分页的方法了,希望对大家有所帮助。