减少数据的处理量
使用limit分页,语法:
select * from user limit startIndex , pageSize; select * from user limit 3;二、使用Mybatis实现分页
沿用上一篇博客项目
2.1、接口 2.2、Mapper.xml 2.3、测试类@Test
public void getUserByLimit(){
SqlSession sqlSession = MybatisUtils.getSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
HashMap map = new HashMap();
map.put("startIndex" , 0);
map.put("pageSize" , 2);
List userList = mapper.getUserByLimit(map);
for (User user : userList){
System.out.println(user);
}
sqlSession.close();
}
测试效果如下:



