MyBatis—使用limit分页查询

• 接口

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

• Mapper.xml

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

• 测试

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