mybatis中mapper.xml分页查询oracle的sql语句,按字段查询

Question

mybatis中mapper.xml分页查询oracle的sql语句,按字段查询

Answer 1

mybatis中有分页查询的处理如下，page是你自定义的分页对象

 String querySql = "selectManager";//查询语句
String countSql = "countManager";//查询语句统计记录数
page.setTotalCount(((Long) getSqlSession().selectOne(countSql, parameter)).intValue());//设置分页对象
RowBounds rowBounds = new RowBounds(page.getFirstResult(), page.getPageSize());
List<T> list = getSqlSession().selectList(querySql, parameter, rowBounds);
page.setResult(list);
return page;