为了减少数据的处理量,采用分页
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、分页插件