MyBatis学习（八）——分页

傷城~ 2022-12-29 00:25 9阅读 0赞

### 分页 ###

*  使用limit分页
 *  RowBounds分页
 *  分页插件

分页是为了减少数据的处理量

# 使用limit分页 #

语法
    select * from user limit startIndex,pageSize
    [0,n]

接口

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

Mapper.xml

<resultMap id="UserMap" type="User">
            
        
            <result column="pwd" property="password"/>
    
        </resultMap>
    
    
        
        <select id="getUserByLimit" parameterType="map" resultMap="UserMap">
            select * from  mybatis.user limit #{
        startIndex},#{
        pageSize}
        </select>

测试

@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",0);
            map.put("pageSize",2);
    
            List<User> list = mapper.getUserByLimit(map);
            for (User user : list) {
        
                System.out.println(user);
            }
    
            sqlSession.close();
        }

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoYXJfbQ_size_16_color_FFFFFF_t_70]

# RowBounds分页 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoYXJfbQ_size_16_color_FFFFFF_t_70 1]

# 分页插件 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoYXJfbQ_size_16_color_FFFFFF_t_70 2]  
[链接][Link 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoYXJfbQ_size_16_color_FFFFFF_t_70]: /images/20221120/14aac0c82b294a32840bc3c803efe19d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoYXJfbQ_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20201218163051609.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoYXJfbQ==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoYXJfbQ_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20201218163209765.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoYXJfbQ==,size_16,color_FFFFFF,t_70
[Link 1]: https://pagehelper.github.io/