三种分页技术

分页查询

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类：

      @Test
    public 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
查官网学习