Mybatis的分页

Limit分页

Mapper 接口

添加方法

//分页查询
List getUserByLimit(Mapmap);

Mapper.xml中

   select * from mybatis.user limit #{startIndex},#{pageSize}

测试类

@Test
public void limitquery(){
    SqlSession session=MybatisUtils.getsqlsession();
    UserDao mapper=session.getMapper(UserDao.class);
    HashMap map=new HashMap();
    map.put("startIndex",0);
    map.put("pageSize",2);
    List userByLimit = mapper.getUserByLimit(map);
    System.out.println(userByLimit);
    session.close();
}

RowBounds分页

Mapper接口UserDao.java中添加方法

//RowBounds分页
List getUserByRowBounds();

Mapper.xml文件添加

   select * from mybatis.user

测试类

@Test
public void RowBounds(){
    SqlSession session=MybatisUtils.getsqlsession();
    RowBounds rowBounds = new RowBounds(1, 2);
    List list = session.selectList("com.shuo.dao.UserDao.getUserByRowBounds",null,rowBounds);
    for (User user:list){
        System.out.println(user);
    }

    session.close();
}