MyBatis分页

为什么需要分页

减少数据的处理量

使用Limit分页

• 语法：select * from user limit startIndex,pageSize
• select * from user limit 3;#[0,3]

使用MyBatis实现分页，核心哈还是sql

1. 接口

 List<User> getUserByLimit(Map<String,Integer> map);

2. Mapper.xml

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

3. 测试

public void test3(){
        SqlSession sqlSession =MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        Map<String,Integer> map=new HashMap<String,Integer>();
        map.put("startIndex",1);
        map.put("pageSize",3);
        List< User > userByLimit = mapper.getUserByLimit(map);
        for (User user: userByLimit
             ) {
            System.out.println(user);
        }
        sqlSession.close();
}