【业务功能篇05】Springboot+MybatisPuls 分页查询设计

小灰灰 2024-03-16 10:37 88阅读 0赞

> 业务场景： 针对一个问题表单进行筛选，查询过滤后的数据，是一个基本的功能，而随着数据过多，前端表格设计时是需要有一个分页的功能，比如查询了有100条，那么我们设定一页10条，分成10页给业务看，那么这里后端接口就需要返回哪些东西： 问题总数量，当前分页，页大小，以及当前页的问题表单数据 接下来看看一个例子

**controller类：**

@RestController
    @RequestMapping(value = "/ProdProblemWarn", produces = {"application/json;charset=UTF-8"})
    @Validated
    public class ProdProblemWarnController {
    
        @Autowired(required=false) 
        private ProdProblemWarnDelegate delegate;      
    
    @RequestMapping(
        		value = "/getWarnPage", 
        		produces = { "application/json" }, 
        		method = RequestMethod.POST)
        public ResponseVo getWarnPage(@RequestBody ProdProblemWarnQueryParam queryParam) 
                throws ServiceException {
        	    
    		return delegate.getWarnPage(queryParam);
        }
    
    }

**请求参数类：ProdProblemWarnQueryParam**

import java.util.*;
    import java.io.Serializable;
    import com.fasterxml.jackson.annotation.JsonIgnoreProperties;
    import com.fasterxml.jackson.annotation.JsonProperty;
    
    
    
    
     @JsonIgnoreProperties(ignoreUnknown = true)
    
    public class ProdProblemWarnQueryParam implements Serializable {
        private static final long serialVersionUID = 1L;
        
        @JsonProperty("year")
        private Integer year = null;
        
        @JsonProperty("month")
        private Integer month = null;
        
        @JsonProperty("startDate")
        private String startDate = null;
        
        @JsonProperty("endDate")
        private String endDate = null;
        
        @JsonProperty("startPeriod")
        private String startPeriod = null;
        
        @JsonProperty("endPeriod")
        private String endPeriod = null;
        
        @JsonProperty("warnType")
        private List<String> warnType = new ArrayList<String>();
        
        @JsonProperty("page")
        private Integer page = null;
        
        @JsonProperty("pageSize")
        private Integer pageSize = null;
        
        @JsonProperty("supplier")
        private List<String> supplier = new ArrayList<String>();
        
        @JsonProperty("isEffective")
        private List<String> isEffective = new ArrayList<String>();
        
        @JsonProperty("product")
        private List<String> product = new ArrayList<String>();
        
        @JsonProperty("project")
        private List<String> project = new ArrayList<String>();
        
        @JsonProperty("category")
        private List<String> category = new ArrayList<String>();
        
        @JsonProperty("subCategory")
        private List<String> subCategory = new ArrayList<String>();
        
        @JsonProperty("failItems")
        private List<String> failItems = new ArrayList<String>();
        
        @JsonProperty("itemCode")
        private List<String> itemCode = new ArrayList<String>();
        
        @JsonProperty("warnNo")
        private String warnNo = null;
        
        @JsonProperty("warnStatus")
        private List<String> warnStatus = new ArrayList<String>();
        
        @JsonProperty("warnRea")
        private List<String> warnRea = new ArrayList<String>();
        
        @JsonProperty("warnLev")
        private List<String> warnLev = new ArrayList<String>();
        
        @JsonProperty("warnDesc")
        private String warnDesc = null;
        
        @JsonProperty("mesNo")
        private List<String> mesNo = new ArrayList<String>();
        
        @JsonProperty("toFilled")
        private String toFilled = null;
        
        @JsonProperty("codeType")
        private String codeType = null;
        
        @JsonProperty("filledFlag")
        private String filledFlag = null;
        
        @JsonProperty("nodeName")
        private String nodeName = null;
        
        @JsonProperty("po")
        private String po = null;
        
        @JsonProperty("feedBackName")
        private String feedBackName = null;
        
        @JsonProperty("issureProperty")
        private String issureProperty = null;
        
        @JsonProperty("issureDesc")
        private String issureDesc = null;
        
        @JsonProperty("chartList")
        private Map chartList = null;
        
        @JsonProperty("radioType")
        private String radioType = null;
        
        @JsonProperty("topProblem")
        private List<TopProblem> topProblem = new ArrayList<TopProblem>();
        
        @JsonProperty("analysisBy")
        private List<String> analysisBy = new ArrayList<String>();
        
        @JsonProperty("reviewBy")
        private List<String> reviewBy = new ArrayList<String>();
        
        public ProdProblemWarnQueryParam() {
            super();
        } 
        
        /**
         * 年份
        **/
        public Integer getYear() {
            return year;
        }
    
        public void setYear(Integer year) {
            this.year = year;
        }
        
        /**
         * 月份
        **/
        public Integer getMonth() {
            return month;
        }
    
        public void setMonth(Integer month) {
            this.month = month;
        }
        
        /**
         * 开始时间(预警时间)
        **/
        public String getStartDate() {
            return startDate;
        }
    
        public void setStartDate(String startDate) {
            this.startDate = startDate;
        }
        
        /**
         * 结束时间(预警时间)
        **/
        public String getEndDate() {
            return endDate;
        }
    
        public void setEndDate(String endDate) {
            this.endDate = endDate;
        }
        
        /**
         * 开始时间(预警周期)
        **/
        public String getStartPeriod() {
            return startPeriod;
        }
    
        public void setStartPeriod(String startPeriod) {
            this.startPeriod = startPeriod;
        }
        
        /**
         * 结束时间(预警周期)
        **/
        public String getEndPeriod() {
            return endPeriod;
        }
    
        public void setEndPeriod(String endPeriod) {
            this.endPeriod = endPeriod;
        }
        
        /**
         * 预警类型
        **/
        public List<String> getWarnType() {
            return warnType;
        }
    
        public void setWarnType(List<String> warnType) {
            this.warnType = warnType;
        }
        
        /**
         * 页码
        **/
        public Integer getPage() {
            return page;
        }
    
        public void setPage(Integer page) {
            this.page = page;
        }
        
        /**
         * 分页数量
        **/
        public Integer getPageSize() {
            return pageSize;
        }
    
        public void setPageSize(Integer pageSize) {
            this.pageSize = pageSize;
        }
        
        /**
         * 供应商
        **/
        public List<String> getSupplier() {
            return supplier;
        }
    
        public void setSupplier(List<String> supplier) {
            this.supplier = supplier;
        }
        
        /**
         * 是否有效预警
        **/
        public List<String> getIsEffective() {
            return isEffective;
        }
    
        public void setIsEffective(List<String> isEffective) {
            this.isEffective = isEffective;
        }
        
        /**
         * 产品
        **/
        public List<String> getProduct() {
            return product;
        }
    
        public void setProduct(List<String> product) {
            this.product = product;
        }
        
        /**
         * 项目
        **/
        public List<String> getProject() {
            return project;
        }
    
        public void setProject(List<String> project) {
            this.project = project;
        }
        
        /**
         * 品类
        **/
        public List<String> getCategory() {
            return category;
        }
    
        public void setCategory(List<String> category) {
            this.category = category;
        }
        
        /**
         * 子品类
        **/
        public List<String> getSubCategory() {
            return subCategory;
        }
    
        public void setSubCategory(List<String> subCategory) {
            this.subCategory = subCategory;
        }
        
        /**
         * 编码
        **/
        public List<String> getFailItems() {
            return failItems;
        }
    
        public void setFailItems(List<String> failItems) {
            this.failItems = failItems;
        }
        
        /**
         * 产品编码
        **/
        public List<String> getItemCode() {
            return itemCode;
        }
    
        public void setItemCode(List<String> itemCode) {
            this.itemCode = itemCode;
        }
        
        /**
         * 预警单号
        **/
        public String getWarnNo() {
            return warnNo;
        }
    
        public void setWarnNo(String warnNo) {
            this.warnNo = warnNo;
        }
        
        /**
         * 预警状态
        **/
        public List<String> getWarnStatus() {
            return warnStatus;
        }
    
        public void setWarnStatus(List<String> warnStatus) {
            this.warnStatus = warnStatus;
        }
        
        /**
         * 预警原因
        **