MyBatis:分页

Posted on

用Limit控制分页

UserMapper.xml:

1
2
3
<select id="getUserByLimit" parameterType="map" resultType="User">
    select * from user limit #{startIndex},#{pageSize}
</select>

Test.java:

1
2
3
4
5
6
7
8
9
10
11
12
13
@Test
   public void getUserByLimit() {
       SqlSession sqlSession = MybatisUtil.getSqlSession();
       UserMapper mapper = sqlSession.getMapper(UserMapper.class);
       Map<String, Integer> map = new HashMap<String, Integer>();
       map.put("startIndex",1);
       map.put("pageSize",2);
       List<User> userByLimit = mapper.getUserByLimit(map);
       for (User user : userByLimit) {
           System.out.println(user);
       }
       sqlSession.close();
   }