分页查询核心代码

public List find(final String hql, final Map parameters,final PaginationList paginationList) {
int startIndex = (paginationList.getCurrentPage() - 1)
* paginationList.getPageSize();
List list = this.getSqlMapClientTemplate().queryForList(hql,
parameters, startIndex, paginationList.getPageSize());
Long count;
if ("true".equals(paginationList.getShowCount())) {
count = this.getRowCount(hql + "Count", parameters);
} else {
count = 10000L;
}
paginationList.setRecordCount(count.longValue());
paginationList.setRecordList(list);
if (list == null || list.size() == 0) {
long recordCount = paginationList.getRecordCount();
long pageSize = paginationList.getPageSize();
long currentPage = paginationList.getCurrentPage();
long nCount = recordCount % pageSize;
long maxPage = 0;
if (nCount == 0) {
maxPage = recordCount / pageSize;
} else {
maxPage = (recordCount - nCount) / pageSize + 1;
}
if (currentPage > maxPage) {
currentPage = maxPage;
paginationList.setCurrentPage(Integer.valueOf(
String.valueOf(currentPage)).intValue());
startIndex = (paginationList.getCurrentPage() - 1)
* paginationList.getPageSize();
list = this.getSqlMapClientTemplate().queryForList(hql,
parameters, startIndex, paginationList.getPageSize());
count = this.getRowCount(hql + "Count", parameters);
paginationList.setRecordCount(count.longValue());
paginationList.setRecordList(list);
}
}
return list;
}

转载于:https://www.cnblogs.com/zhao-long/p/6700066.html