04-Mybatis-分页

接口实现

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

接口对应的配置文件

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

测试

 @Test
  public void PageTest(){
    SqlSession session = MybatisUtils.getSession();
    UserDao mapper = session.getMapper(UserDao.class);
    HashMap<String,Integer> map= new HashMap<String,Integer>();
    map.put("startIndex",0);
    map.put("pageSize",3);
    List<User> users = mapper.getUserByLimit(map);
    for (User user : users) {
      System.out.println(user);
    }
    session.close();

  }

运行结果