7、分页.

思考：为什么分页？

• 减少数据的处理量

7.1 使用Limit分页

语法

SELECT * from user limit startIndex,pageSize 
SELECT * from user limit 3  #[0,3]
-- startIndex 当前页码
-- pageSize 页面大小

使用MyBatis实现分页，核心SQL （推荐使用sql层面做分页）

1. 接口

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

2. Mapper.xml

   <resultMap id="user" type="User">
     <!--column数据库中的字段，property实体类中的属性-->
     <result column="id" property="id"></result>
     <result column="name" property="name"></result>
     <result column="pwd" property="password"></result>
   </resultMap>
   
   <!--分页-->
   <select id="getUserByLimit"  parameterType="map" resultMap="user">
     select * from user limit #{startIndex}, #{pageSize}
   </select>
   

3. 测试

   //分页
   @Test
   public void getUserByLimit(){
     SqlSession sqlSession = MybatisUtils.getSqlSession();
     UserMapper mapper = sqlSession.getMapper(UserMapper.class);
     Map<String, Integer> map = new HashMap<String, Integer>();
     map.put("startIndex",1);
     map.put("pageSize",2);
     List<User> list = mapper.getUserByLimit(map);
     for (User user : list) {
       System.out.println(user);
     }
     sqlSession.close();
   }
   
   =================
   User{id=2, name='李四', password='123123'}
   User{id=3, name='小明', password='123'}
   

7.2 RowBounds分页

不再使用SQL实现分页

1. 接口

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

2. Mapper.xml

   <!--分页2-->
   <select id="getUserByRowBounds" resultMap="user" >
     select * from user
   </select>
   

3. 测试

   //分页2
   @Test
   public void getUserByRowBounds(){
     SqlSession sqlSession = MybatisUtils.getSqlSession();
     //RowBounds实现
     RowBounds rowBounds = new RowBounds(1,2);
     //通过Java代码层面实现分页
     List<User> users = sqlSession.selectList("com.yin.dao.UserMapper.getUserByRowBounds", null, rowBounds);
     for (User user : users) {
       System.out.println(user);
     }
     sqlSession.close();
   }
   ======================
     
   User{id=2, name='李四', password='123123'}
   User{id=3, name='小明', password='123'}
   

7.3 分页插件

地址：https://pagehelper.github.io/

了解