mybatis limit分页

@Test
public void getUserByLimit(){
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);

    HashMap<String, Object> map = new HashMap<>();
    map.put("startIndex",0);
    map.put("pageSize",2);

    List<User> userList = mapper.getUserByLimit(map);
    for (User user : userList) {
        System.out.println(user);
    }


    sqlSession.close();

xml中注册：

<select id="getUserByLimit" parameterType="map" resultType="User">
    select * from mybatis.user limit #{startIndex},#{pageSize}
</select>

startIndex开始下标 从第几个开始
pageSIze页面东西的多少 也就是一页几个

第二种分页：RowBounds

 

 

 

 

 

 

 

第三种方式：还可以使用分页插件：搜索Mybatis分页插件就OK