Mybatis Plus 分页

ゝ一世哀愁。 2024-03-17 09:43 18阅读 0赞

示例代码:

Controller:

/***
         * @Title: 保单详情-被保险人查询
         * @Author: ken
         * @Description:
         * @Date: 2023/5/17  15:07
         * @Param: [request]
         * @return com.riskeys.common.base.model.Result<com.riskeys.pic.config.dto.newcont.cont.ContDetailInfoDTO>
         **/
        @ApiOperation(value = "保单详情-分页询被保险人")
        @RequestMapping(value = "/queryInsuredPageList", method = RequestMethod.POST)
        public  Result<Page<ContInsuredInfoDTO>> queryInsuredPageList(@RequestBody ContInsuredInfoRequest request) {
            log.info("[ContManageController->queryInsuredPageList]-request：{}", JSONObject.toJSONString(request));
            Result<Page<ContInsuredInfoDTO>> response= new Result<>();
            if (Objects.isNull(request) || StringUtil.isEmpty(request.getContNo())) {
                response.setCode(Result.CODE_SYS_ERR);
                response.setMsg("请求参数为空!");
                return response;
            }
            //查询被保险人列表
            return contManageService.queryInsuredPageList(request);
        }

其中result 用的前辈封装的公共返回类:

//
    // Source code recreated from a .class file by IntelliJ IDEA
    // (powered by Fernflower decompiler)
    //
    
    package com.XXX.common.base.model;
    
    import io.swagger.annotations.ApiModel;
    import io.swagger.annotations.ApiModelProperty;
    import java.io.Serializable;
    import java.util.function.Consumer;
    import javax.validation.Valid;
    
    @ApiModel
    public class Result<T> implements Serializable {
        public static final String CODE_SUCCESS = "1";
        public static final String CODE_SYS_ERR = "0";
        public static final String SYS_SUCCESS_STRING = "成功";
        public static final String SYS_ERR_STRING = "系统错误";
        @ApiModelProperty("成功失败标识，0-失败，1-成功")
        private String code = "1";
        @ApiModelProperty("消息")
        private String msg;
        @Valid
        @ApiModelProperty("数据")
        private T data;
    
        public static <T> Result<T> ofSuccess(T data) {
            Result<T> result = new Result();
            result.setCode("1");
            result.setMsg("成功");
            result.setData(data);
            return result;
        }
    
        public static <T> Result<T> ofSystemError(String msg) {
            Result<T> rslt = new Result();
            rslt.setCode("0");
            rslt.setMsg(msg);
            return rslt;
        }
    
        public T open(Consumer<Result<T>> failedConsumer) {
            if ("1".equals(this.code)) {
                return this.getData();
            } else {
                if (failedConsumer != null) {
                    failedConsumer.accept(this);
                }
    
                return null;
            }
        }
    
        public Result<T> then(Consumer<T> consumer) {
            if ("1".equals(this.code)) {
                consumer.accept(this.data);
            }
    
            return this;
        }
    
        public Result() {
        }
    
        public String getCode() {
            return this.code;
        }
    
        public String getMsg() {
            return this.msg;
        }
    
        public T getData() {
            return this.data;
        }
    
        public void setCode(String code) {
            this.code = code;
        }
    
        public void setMsg(String msg) {
            this.msg = msg;
        }
    
        public void setData(T data) {
            this.data = data;
        }
    
        public boolean equals(Object o) {
            if (o == this) {
                return true;
            } else if (!(o instanceof Result)) {
                return false;
            } else {
                Result<?> other = (Result)o;
                if (!other.canEqual(this)) {
                    return false;
                } else {
                    label47: {
                        Object this$code = this.getCode();
                        Object other$code = other.getCode();
                        if (this$code == null) {
                            if (other$code == null) {
                                break label47;
                            }
                        } else if (this$code.equals(other$code)) {
                            break label47;
                        }
    
                        return false;
                    }
    
                    Object this$msg = this.getMsg();
                    Object other$msg = other.getMsg();
                    if (this$msg == null) {
                        if (other$msg != null) {
                            return false;
                        }
                    } else if (!this$msg.equals(other$msg)) {
                        return false;
                    }
    
                    Object this$data = this.getData();
                    Object other$data = other.getData();
                    if (this$data == null) {
                        if (other$data != null) {
                            return false;
                        }
                    } else if (!this$data.equals(other$data)) {
                        return false;
                    }
    
                    return true;
                }
            }
        }
    
        protected boolean canEqual(Object other) {
            return other instanceof Result;
        }
    
        public int hashCode() {
            int PRIME = true;
            int result = 1;
            Object $code = this.getCode();
            int result = result * 59 + ($code == null ? 43 : $code.hashCode());
            Object $msg = this.getMsg();
            result = result * 59 + ($msg == null ? 43 : $msg.hashCode());
            Object $data = this.getData();
            result = result * 59 + ($data == null ? 43 : $data.hashCode());
            return result;
        }
    
        public String toString() {
            return "Result(code=" + this.getCode() + ", msg=" + this.getMsg() + ", data=" + this.getData() + ")";
        }
    }

page类 引用包:

package com.baomidou.mybatisplus.extension.plugins.pagination.Page

Service:

/**
         * @Title: 分页查询被保险人列表
         * @Author: ken
         * @Description:
         * @Date: 2023/5/22  15:19
         * @Param: [request]
         * @return com.riskeys.common.base.model.Result<com.baomidou.mybatisplus.extension.plugins.pagination.Page<com.riskeys.pic.config.dto.newcont.cont.ContInsuredInfoResponse>>
         **/
        Result<Page<ContInsuredInfoDTO>>queryInsuredPageList(ContInsuredInfoRequest request);

ServiceImpl 实现类:

/**
         * @Title: 查询被保险人列表
         * @Author: ken
         * @Description:
         * @Date: 2023/5/17  15:14
         * @Param: [request]
         * @return com.riskeys.common.base.model.Result<com.riskeys.pic.config.page.PagingModel<com.riskeys.pic.config.dto.newcont.cont.ContInsuredInfoResponse>>
         **/
        @Override
        public Result<Page<ContInsuredInfoDTO>> queryInsuredPageList(ContInsuredInfoRequest request) {
    
            int pageNo = request.getPageNo();
            int pageSize = request.getPageSize();
    
            // 计算偏移量
            int offset = (request.getPageNo() - 1) * request.getPageSize();
    
            // 执行分页查询
            List<ContInsuredInfoDTO> insuredList = picInsuredExMapper.queryInsuredPageList(request, offset);
            // 查询总行数
            int totalCount = picInsuredExMapper.queryInsuredPageCount(request);
            // 计算总页数
            //int totalPage = (int) Math.ceil((double) totalCount / pageSize);
    
            // 封装结果集
            Page<ContInsuredInfoDTO> page = new Page<>(request.getPageNo(), request.getPageSize(), totalCount);
            page.setRecords(insuredList);
            return Result.ofSuccess(page);
        }

Mapper.java:

/**
         * @Title: 保单详情-被保险人分页查询
         * @Author: ken
         * @Description:
         * @Date: 2023/5/22  16:12
         * @Param: [page, request]
         * @return java.util.List<com.riskeys.pic.config.dto.newcont.cont.ContInsuredInfoDTO>
         **/
        List<ContInsuredInfoDTO> queryInsuredPageList(@Param(value = "request") ContInsuredInfoRequest request,
                                                      @Param(value = "offset") int offset);
    
        int queryInsuredPageCount(@Param(value = "request") ContInsuredInfoRequest request);

Mapper.xml

<select id="queryInsuredPageList" resultType="com.riskeys.pic.config.dto.newcont.cont.ContInsuredInfoDTO">
            SELECT XXXXXXXX
            <trim prefix="WHERE" prefixOverrides="AND ">
                <if test="null!=request.contNo and ''!=request.contNo">
                    and cont.cont_no=#{request.contNo}
                </if>
            </trim>
            ORDER BY insr.create_date DESC LIMIT #{offset} , #{request.pageSize}
    </select>
    
    <select id="queryInsuredPageCount" resultType="int">
            SELECT
            COUNT(1)
            FROM
            XXX
            <trim prefix="WHERE" prefixOverrides="AND ">
                <if test="null!=request.contNo and ''!=request.contNo">
                    and cont.cont_no=#{request.contNo}
                </if>
            </trim>
    </select>

执行效果:

![4b81d4b07d924eb8953259c323e43bd1.png][]

![0c6179a5109144a780f38c320f36281b.png][]

公众号请关注"果酱桑", 一起学习,一起进步!

[4b81d4b07d924eb8953259c323e43bd1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/17/fa8f78b4707a422da9fa068af30ddcab.png
[0c6179a5109144a780f38c320f36281b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/17/9cbb7a4b8d7d4794a072c94198287bf1.png