快捷導(dǎo)航

Mybatisplus集成springboot完成分頁查詢功能(示例代碼)

更新時間：2023年11月10日 14:10:01 作者：知識淺談

今天小編給大家分享Mybatisplus集成springboot完成分頁查詢功能,本文通過實例代碼給大家介紹的非常詳細,需要的朋友參考下吧

??引入依賴

引入mybatisplus依賴

    <dependency>
      <groupId>com.baomidou</groupId>
      <artifactId>mybatis-plus-boot-starter</artifactId>
      <version>3.5.2</version>
    </dependency>

??分頁插件配置類

溫馨提醒：這個必不可少

public class MybatisPlusConfig{
    /**
     * mybatisplus 分頁配置
     */
    @Bean
    public MybatisPlusInterceptor mpInterceptor(){
        //定義mp攔截器
        MybatisPlusInterceptor mpInterceptor = new MybatisPlusInterceptor();
        //添加具體的攔截器
        mpInterceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.ORACLE));
        mpInterceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
        return mpInterceptor;
    }
}

??在controller中使用

    @ApiOperation("分頁查詢")
    @GetMapping("/pageList")
    public PageResult pageList(@RequestParam(name="postName",required = false) String postName,
                                        @RequestParam(name = "pageNo",required = false) Integer pageNo,
                                        @RequestParam(name = "pageSize",required = false) Integer pageSize){
        PageResult<List<Post>> result = new PageResult<>();
        try {
            if (pageNo == null) pageNo = 1;
            if (pageSize == null) pageSize = 5;
            LambdaQueryWrapper<Post> queryWrapper = new LambdaQueryWrapper<>();
            queryWrapper.like(Post::getPostName,postName);//根據(jù)職位名模糊查詢
            Page<Post> page = new Page<>(pageNo,pageSize); //定義分頁類型
            Page page1 = postService.page(page,queryWrapper); //開始查詢
            result.setResult(page1.getRecords());
            result.setTotal(page1.getTotal());
            result.setCurrent(page1.getCurrent());
            result.setPages(page1.getPages());
            result.setSize(page1.getSize());
            result.success("獲取職位列表成功！");
        } catch (Exception e) {
            result.error500("獲取職位列表失??！");
        }
        return result;
    }