java分页技巧

KFControllerFH -->list

列表页序号以递增显示条数

${page.pernum*(page.currentPage-1)+bean_index+1}

后台分页

KFMsgExample example = new KFMsgExample();
if (StringUtils.isEmpty(date)) {// 如果查询日期为空则默认显示一年的数据
example.clear();
example.setOrderByClause(" send_time DESC");
Criteria criteria = example.createCriteria();
criteria.andComNoEqualTo(comNo);
int year = DateUtils.year();
int month = DateUtils.month();
// 先前推12个月
StringBuffer dateStr = new StringBuffer("");
int num = 0;
for (int i = month;; i--) {
if (i == 0) {
year -= 1;
i = 12;
}
num += 1;
if (num > 12) {
break;
}
String moth = i < 10 ? "0" + i : i + "";
dateStr.append(year + "_" + moth + ",");
}


String[] dateStr1 = dateStr.toString().split(",");
logger.info("dateStr=================================" + dateStr);
List<KFMsg> kfMsgs = new ArrayList<>();
for (int i = 0; i < dateStr1.length; i++) {
String table_name = "kf_msg_".concat(dateStr1[i]);
boolean isExist = kFMsgService.existTable(table_name);
if (isExist) {
kfMsgs.addAll(kFMsgService.selectByExample(table_name, example));
}
}
kfMsgs.sort((n1, n2) -> n2.getSendTime().compareTo(n1.getSendTime()));
Page<KFMsg> page = new Page<>(kfMsgs.size(), currentPage, pageSize);
int fromIndex = pageSize * (currentPage - 1);
int toIndex = pageSize * currentPage;
if (toIndex > kfMsgs.size()) {
toIndex = kfMsgs.size();
}
List<KFMsg> subList = kfMsgs.subList(fromIndex, toIndex);
page.setRecordList(subList);
model.addAttribute("page", page);
model.addAttribute("date", date);
model.addAttribute("comNo", comNo);


return "bank/kf/msgListFH";