Mybatis的分页

Limit分页

Mapper 接口

添加方法

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

Mapper.xml中

<select id="getUserByLimit" resulttype="com.shuo.pojo.User" parameterType="map">
   select * from mybatis.user limit #{startIndex},#{pageSize}
</select>

测试类

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

RowBounds分页

Mapper接口UserDao.java中添加方法

//RowBounds分页
List<User> getUserByRowBounds();

Mapper.xml文件添加

<select id="getUserByRowBounds" resulttype="com.shuo.pojo.User">
   select * from mybatis.user
</select>

测试类

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

    session.close();
}