mybatis でのページングにはどのような方法がありますか?

sql使用的核心语句

-- 语法：表示从startIndex下标开始，一页显示pageSize个 select * from users limit startIndex,pageSize; -- 语法：表示显示[0,n]范围的数据 select * from users limit n;

//分页查询 List getUserLImit(Map map);

  select * from firend_mq.users limit #{startIndex},#{pageSize} 

//测试分页查询 @Test public void getUserLImit(){ SqlSession sqlSession = Mybatisutil.getSqlSession(); UserDao mapper = sqlSession.getMapper(UserDao.class); Map map = new HashMap<>(); map.put("startIndex",0); map.put("pageSize",3); List userLImit = mapper.getUserLImit(map); for (User user : userLImit) { System.out.println(user); } sqlSession.close(); }

//RowBounds实现分页查询 List getUserLRowBounds();

  select * from firend_mq.users 

//RowBounds分页查询 @Test public void getUserLRowBounds(){ SqlSession sqlSession = Mybatisutil.getSqlSession(); //RowBounds对象 参数（起点，个数） RowBounds rowBounds = new RowBounds(2, 3); //通过java代码层面实现分页,第一个参数是接口类的方法路径 List userlist = sqlSession.selectList("dao.UserDao.getUserLRowBounds", null, rowBounds); for (User user : userlist) { System.out.println(user); } sqlSession.close(); }