14.RowBounds分页

RowBounds分页

不再使用sql实现分页

1. 接口

 //分页2
    List<User> getUserByRowBounds();

2. mapper.xml

<!--分页实现查询-->
    <select id="getUserByRowBounds"  resultMap="UserMap">
        select * from mybatis.user
    </select>

3. 测试

@Test
    public void getUserByRowBounds(){
        SqlSession sqlSession = MybatisUtils.getsqlSession();
        //RowBounds实现
        RowBounds rowBounds = new RowBounds(1, 2);
        //通过Java代码层面实现分页
        List<User> userList = sqlSession.selectList("com.faq.dao.UserMapper.getUserByRowBounds",null,rowBounds);
        for (User user : userList) {
            System.out.println(user);
        }
        sqlSession.close();
    }

分页插件PageHelper(了解)