分页查询

1.Limit方法

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

测试：

 @Test
    public void getUserByLimit(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        Map<String, Integer> map = new HashMap<>();
        map.put("startIndex", 0);
        map.put("pageSize", 2);
        List<User> userByLimit = mapper.getUserByLimit(map);
        for (User user : userByLimit) {
            logger.info(user);
        }
        sqlSession.close();
    }

2.RowBounds方法

<select id="getUserByRowBounds" resultMap="UserMap">
        select * from user
</select>

测试：

@Test
    public void getUserByRowBounds(){
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        //RowBound方法
        String method = "com.shao.dao.UserMapper.getUserByRowBounds";
        RowBounds rowBounds = new RowBounds(0, 2);
//        JAVA方法
        List<User> userList = sqlSession.selectList(method,null, rowBounds);
        for (User user : userList) {
            logger.info(user);
        }
        sqlSession.close();
    }