Mybatis分页插件pagehelper的使用

最新推荐文章于 2025-06-20 16:10:16 发布

人月IT

最新推荐文章于 2025-06-20 16:10:16 发布

阅读量1.1k

点赞数

CC 4.0 BY-SA版权

分类专栏： mybatis

本文链接：https://blog.youkuaiyun.com/dgutliangxuan/article/details/79657126

mybatis 专栏收录该内容

3 篇文章

订阅专栏

本文介绍如何在MyBatis中配置PageHelper插件实现分页功能，并展示了具体的配置代码及分页参数类的设计。同时，文章还提供了如何在实际业务场景中使用PageHelper进行分页查询的例子。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

@Configuration
public class MybatisConfig {
    @Bean
    public PageHelper pageHelper() {
        PageHelper pageHelper = new PageHelper();
        Properties properties = new Properties();
        properties.setProperty("offsetAsPageNum", "true");
        properties.setProperty("rowBoundsWithCount", "true");
        properties.setProperty("reasonable", "true");
        properties.setProperty("supportMethodsArguments", "true");
        properties.setProperty("returnPageInfo", "check");
        properties.setProperty("params", "count=countSql");

        pageHelper.setProperties(properties);
        return pageHelper;
    }
}


@Getter
@Setter
public class PagingParam implements Serializable{

    @Min(value = 1, message = "参数[pageNum]有误")
    private int pageNum = 1;

    @Min(value = 1, message = "参数[pageSize]有误")
    private int pageSize = 12;

}

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

   int pageNum = pagingParam.getPageNum();
   int pageSize = pagingParam.getPageSize();
   PageHelper.startPage(pageNum, pageSize);

 PageInfo<UserDTO> pageInfo = new PageInfo<>(List<T> list);  //你的数据源
  pageInfo.setTotal(new PageInfo<>(userInformations).getTotal());
  **return new Result(200, "成功获取所有成员", Result.constructData(pageInfo));**

    public static <T> Map<String, Object> constructData(PageInfo<T> pageInfo){
        Map<String, Object> data = new TreeMap<>();
        data.put("total",pageInfo.getTotal());
        data.put("pageNum",pageInfo.getPageNum());
        if (pageInfo.getList() == null || pageInfo.getList().size() == 0){
            data.put("list", new ArrayList<>());
        }else {
            data.put("list", pageInfo.getList());
        }
        return data;
    }

  public Result selectAllPaging(PagingParam pagingParam, HttpServletRequest res){

        int pageNum = pagingParam.getPageNum();
        int pageSize = pagingParam.getPageSize();

        String organization = "";

        PageHelper.startPage(pageNum, pageSize);
        List<UserInformation> userInformations;
        try{
            userInformations = userInformationMapper.selectByOrganization(organization);
        }catch (Exception e){
            e.printStackTrace();
            return new Result(400, "未知错误");
        }
        PageInfo<UserDTO> pageInfo = new PageInfo<>(copyFromUserInformationToSUserDTO(userInformations, res));
        pageInfo.setTotal(new PageInfo<>(userInformations).getTotal());

        return new Result(200, "成功获取所有成员", Result.constructData(pageInfo));
    }