思考：为什么要分页？减少数据处理量1、使用Limit分页语法：select*fromuserlimitstartIndex,pageSize;select*fromuserlimit3;#[0,n]使用Mybatis实现分页，核心SQL接口/***分页查询*@return*/ListgetUserByLimt(Mapmap);Mapper.xmlselect*frommybatis.userlimit#{startIndex},#{pageSize}//测试publicvoidgetUserByLimt(){SqlSessionsqlsession=MybatisUtil.getSqlsession();UserMapper映射器=sqlsession.getMapper(UserMapper.class);HashMapmap=newHashMap();map.put("startIndex",0);map.put("pageSize",3);列表<用户>userByLimt=mapper.getUserByLimt(map);对于（用户用户：userByLimt）{System.out.println（用户）;}}2.RowBounds分页不再使用SQL实现分页接口/****@return*/ListgetUserByRowBounds();Mapper.xmlselect*frommybatis.user//测试publicvoidgetUserByRowBounds(){SqlSessionsqlsession=MybatisUtil.getSqlsession();//RowBounds实现RowBoundsrowBounds=newRowBounds(1,2);//通过java级别分页Listlist=sqlsession.selectList("com.aostarit.dao.UserMapper.getUserByRowBounds",null,rowBounds);for(Useruser:list){System.out.println(user);}//关闭sqlSessionsqlsession.close();}
