分页查询

1、sql语句limit分页

1. sql语句：

select * from tbuser limit #{startIndex},#{pageSize}

2. maper：

List getUserRowBounds(Map<String,Object> map);

3. test类：

        public void test5(){SqlSession sqlSession=MybatisUtil.getSqlSession();UserDaoMapper mapper = sqlSession.getMapper(UserDaoMapper.class);Map map=new HashMap<String,Object>();map.put("startIndex",5);map.put("pageSize",4);
List<User> list=mapper.getUserlimit(map);
for (User user:list){System.out.println(user);
}
sqlSession.close();}

2、java代码实现RowBounds
sql语句：

   <select id="getUserRowBounds" resultMap="resultMap">select * from tbuser</select>

test类：

      @Testpublic void testRowBounds(){SqlSession sqlSession=MybatisUtil.getSqlSession();UserDaoMapper mapper = sqlSession.getMapper(UserDaoMapper.class);
//        通过RowBounds实现RowBounds rowBounds = new RowBounds(98, 4);//通过java实现List<User> userlist = sqlSession.selectList("dao.UserDaoMapper.getUserRowBounds",null,rowBounds);for (User user:userlist){System.out.println(user);}sqlSession.close();}

3，插件分页MyBatis-PageHelper
查官网学习