mybatis-分页

Linit分页

语法：SELECT * from user limit startIndex, pageSze;
SELECT * from user limit 0, 3;

mapper.java

public interface UserMapper {
    //分页
    List<User> getUserByLimit(Map<String, Object> map);
}

mapper.xml

<!-- 分页-->
    <select id="getUserByLimit" parameterType="map" resultType="com.xxx.pojo.User">
        select * from mybatis.user limit #{startIndex},#{pageSize}
    </select>

Test.java

@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();
    }