Mybatis学习笔记4：分页

一、limit实现分页

1.编写userMapper.xml文件

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

2.UserDao接口，参数为map

//选择全部用户实现分页
List<User> selectUser(Map<String,Integer> map);

3.测试

//分页查询 , 两个参数startIndex , pageSize
@Test
public void test() {
   SqlSession session = MybatisUtils.getSession();
   UserDao userDao= session.getMapper(UserDao.class);

   int currentPage = 1;  //第几页
   int pageSize = 2;  //每页显示几个
   Map<String,Integer> map = new HashMap<String,Integer>();
   map.put("startIndex",(currentPage-1)*pageSize);
   map.put("pageSize",pageSize);

   List<User> users = userDao.selectUser(map);

   for (User user: users){
       System.out