Mybatis-07-分页

为了减少数据的处理量，采用分页

7.1、limit分页

语法：

select * from user limit startindex,pagesize
select * from user limit 2,3

Mybatis实现分页：

1.接口

List<user> GetListByLimit(Map<String,Integer> map);

2.Mapper.xml

<select id="GetListByLimit" resultType="user" parameterType="map">
    select * from user limit #{startindex},#{pagesize}
</select>

3.测试

public void test4(){
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    HashMap<String, Integer> HashMap = new HashMap<>();
    HashMap.put("startindex",0);
    HashMap.put("pagesize",2);
​
    List<user> li=mapper.GetListByLimit(HashMap);
    for(user us:li){
        System.out.println(us);
    }
    sqlSession.close();
​
}

7.2、RowBounds分页

不再使用SQL实现分页

1.接口

List<user> GetRowBounds();

2.Mapper.xml

<select id="GetRowBounds" resultType="user">
    select * from user
</select>

3.测试

public void test4(){
    SqlSession sqlSession = MybatisUtils.getSqlSession();
    RowBounds rowBounds = new RowBounds(1,2);//startindex  pagesize
    List<user> user = sqlSession.selectList("com.mosang.dao.UserMapper.GetRowBounds", null, rowBounds);
    for (user user1 : user) {
        System.out.println(user1);
    }
    sqlSession.close();
​
}

7.3、分页插件

MyBatis 分页插件 PageHelper