6. MyBatis分页

limit

UserMapper.java

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

UserMapper.xml

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

UserMapperTest.java

    @Test
    public void getUserListByPage(){
        Map<String,Integer> map = new HashMap<String, Integer>();
        map.put("startIndex",0);
        map.put("pageSize",2);
        userMapper.getUserListByPage(map).forEach(System.out::println);
        sqlSession.close();       
    }

Rowbounds

无需修改SQL语句，通过对象设置分页 【不推荐】

UserMapper.java

    List<User> getUserList();

UserMapper.xml

    <select id="getUserList" resultMap="UserMap">
        select * from mybatis.user;
    </select>

UserMapperTest.java

    @Test
    public void getUserList(){
        RowBounds rowBounds = new RowBounds(0,2);
        List<User> list = sqlSession.selectList("com.indi.dao.UserMapper.getUserList",null,rowBounds);
        list.forEach(System.out::println);
        sqlSession.close();
    }