ibatis 自带分页方法
关键字: ibatis
ibatis自带函数:
java 代码
PaginatedList paginatedList=sqlMap.queryForPaginatedList(statementName, parameterObject, pageSize);
基于Spring框架来实现的分页
java 代码
public List getAllList(String flag) {
PaginatedList paginatedList = this.getSqlMapClientTemplate()
.queryForPaginatedList("getAllList", null, 5);
if ("privious".equals(flag)) {
paginatedList.previousPage();
} else if ("next".equals(flag)) {
paginatedList.nextPage();
}
return paginatedList;
}
在JSP中,如下调用:
<button οnclick="location.href = 'test.shtml?flag=privious'">上一页button>
<button οnclick="location.href = 'test.shtml?flag=next'">下一页button>
PS:此方法只可以用于小数量的数据查询,大数量此法不可行,速度慢的无法忍受。