我们知道,Ibatis为我们提供了可以直接实现分页的方法
queryForList(String statementName, Object parameterObject, int skipResults, int maxResults)
参数:
statementName :要调用的statement
parameterObject: 参数对象
skipResults :要查询的起始记录 ((page.getPageNo()-1)*page.getPageSize())
maxResults: 返回的最大记录条数 (page.getPageSize())
private void handleResults(RequestScope request, ResultSet rs, int skipResults, int maxResults, RowHandlerCallback callback) throws SQLException {
try {
request.setResultSet(rs);
ResultMap resultMap = request.getResultMap();
if (resultMap != null) {
// Skip Results
if (rs.getType() != ResultSet.TYPE_FORWARD_ONLY) {
if (skipResults > 0) {
rs.absolute(skipResults);
}
} else {
for (int i &#