1、方式一:limit分页
<select id="queryUserList" resultMap="userMap">
select * from tb_user limit 0,3
</select>
2、方式二:RowBounds分页
@Test
public void test01(){
SqlSession sqlSession = MybatisUtil.getSqlSession();
RowBounds rowBounds = new RowBounds(0,3);
List<User> users = sqlSession.selectList("com.study.dao.UserMapper.queryUserList", null, rowBounds);
users.forEach(System.out::println);
sqlSession.close();
}
3、一些分页插件
之后在插件学习中单独写