Mybatis_分页(pageHelper插件实现)

Myth丶恋晨 2023-06-25 13:27 17阅读 0赞

1.  在pom.xml中添加pageHelper依赖

<dependency>
        <groupId>com.github.pagehelper</groupId>
        <artifactId>pagehelper</artifactId>
        <version>5.1.10</version>
    </dependency>

1.  在mybatis配置文件中添加插件依赖

1.  DAO层Mapper写法和无分页写法相同，在Service层调用插件

public class UserService {
        
    	/**
    	 * 
    	 * @param pageNum
    	 * @param map
    	 * @return
    	 */
    	public PageInfo<User> selectPage(int pageNum, Map<String, Object> map) {
        
    
    		SqlSession sqlSession = SqlSessionUtil.openSession();
    		try {
        
    			UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    			//开启分页功能
    			PageHelper.startPage(pageNum, 5);
    			List<User> users = userMapper.select(map);
    			//PageInfo对象获得非常全面的分页信息
    			PageInfo<User> page = new PageInfo<User>(users);
    			return page;
    		} finally {
        
    			SqlSessionUtil.close(sqlSession);
    		}
    	}
    }

Debug模式下查看到PageInfo中的属性，常用的pageNum当前页，pages总页数，list分页查询的数据等…  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NoaWxsX0x5bg_size_16_color_FFFFFF_t_70]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NoaWxsX0x5bg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191229113421331.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0NoaWxsX0x5bg==,size_16,color_FFFFFF,t_70