Plus分页插件单表/连接查询都默认支持，很强大！！！

插件定义：

  1. package com.iwhalecloud.aiFactory.common.autoconfigure;
  3. import com.baomidou.mybatisplus.plugins.PaginationInterceptor;
  4. import com.baomidou.mybatisplus.plugins.PerformanceInterceptor;
  5. import org.springframework.boot.autoconfigure.condition.ConditionalOnClass;
  6. import org.springframework.boot.autoconfigure.condition.ConditionalOnMissingBean;
  7. import org.springframework.boot.autoconfigure.condition.ConditionalOnProperty;
  8. import org.springframework.context.annotation.Bean;
  9. import org.springframework.context.annotation.Configuration;
  11. @Configuration
  12. @ConditionalOnClass(name = "com.baomidou.mybatisplus.spring.boot.starter.MybatisPlusAutoConfiguration")
  13. public class MybatisCommonConfig {
  14.     @Bean
  15.     @ConditionalOnMissingBean
  16.     public PaginationInterceptor paginationInterceptor() {
  17.         return new PaginationInterceptor();
  18.     }
  20.     @Bean
  21.     @ConditionalOnMissingBean
  22.     @ConditionalOnProperty(name = "mybatis-plus.show-sql", havingValue = "true")
  23.     public PerformanceInterceptor performanceInterceptor() {
  24.         return new PerformanceInterceptor();
  25.     }
  26. }

分页Mapper格式

  1. public interface VmInstanceApplicationMapper extends BaseMapper<VmInstanceApplication> {
  2.     /**
  3.      * 申请列表
  4.      * @param page
  5.      * @param params
  6.      * @return
  7.      */
  8.     List<VmInstanceApplicationResponse> applicationList(Page page, VmInstanceApplicationRequest params);
  9. }
  11. #SQL无需手动分页了
  12.     <select id="applicationList" parameterType="com.iwhalecloud.aiFactory.aiDevCenter.application.vo.VmInstanceApplicationRequest" resultType="com.iwhalecloud.aiFactory.aiDevCenter.application.vo.VmInstanceApplicationResponse">
  13.         SELECT
  14.             vm.name vmName,
  15.             t.id, t.vm_instance, t.duration, t.application_desc, t.create_user_id, t.create_time, t.auditor, t.audit_desc, t.audit_time, t.com_acct_id, t.application_status
  16.         FROM
  17.             vm_instance_application t
  18.         LEFT JOIN vm_instance vm ON t.vm_instance = vm.id
  19.         WHERE
  20.             1 = 1
  21.         <if test="createUserId != null">
  22.             AND t.create_user_id = #{createUserId}
  23.         </if>
  24.         <if test="applicationStatus != null and applicationStatus != ''">
  25.             AND t.application_status = #{applicationStatus}
  26.         </if>
  27.         <if test="vmName != null and vmName != ''">
  28.             AND vm.name LIKE concat('%', #{vmName}, '%')
  29.         </if>
  30.         <if test="vmInstance != null">
  31.             AND t.vm_instance = #{vmInstance}
  32.         </if>
  33.         <if test="comAcctId != null">
  34.             AND t.com_acct_id = #{comAcctId}
  35.         </if>
  36.         <if test="applicationStatusList != null and applicationStatusList.size() > 0">
  37.             AND t.application_status in
  38.             <foreach collection="applicationStatusList" item="one" open="(" close=")" separator=",">
  39.                 #{one}
  40.             </foreach>
  41.         </if>
  42.         ORDER BY
  43.             create_time DESC
  44.     </select>

Service接口格式

  1. public interface VmInstanceApplicationService {
  3.     /**
  4.      * 申请列表
  5.      * @param params
  6.      * @return
  7.      */
  8.     PageInfo<VmInstanceApplicationResponse> applicationList(VmInstanceApplicationRequest params);
  9. }

Service实现格式

其中Page是Plus框架类
PageInfo是自定义返回封装与Page无继承关系

  1. public PageInfo<VmInstanceApplicationResponse> applicationList(VmInstanceApplicationRequest params) {
  2.         Page page = new Page<>((params.getPageIndex() == null ? 1 : params.getPageIndex()), (params.getPageSize() == null ? 10 : params.getPageSize()));
  3.         //这是一个单页的列表，但可以被plus插件拦截取到total值
  4.         List<VmInstanceApplicationResponse> applicationList = vmInstanceApplicationMapper.applicationList(page, params);
  5.         if (applicationList == null || applicationList.isEmpty()) {
  6.             return new PageInfo<>(page.getCurrent(), page.getSize(), page.getTotal(), Collections.emptyList());
  7.         }
  8.         // 翻译状态VM_APPLICATION_STATUS
  9.         taiDcService.addDictListNameInfo(applicationList, ResourceConst.SYS_RESOURCE,
  10.                 new DictFieldList().addField(AiDevCenterConsts.VM_APPLICATION_STATUS_KEY, "applicationStatus", "applicationStatusName"));
  11.         // 翻译申请人和审核人
  12.         List<Long> userIds = applicationList.stream().map(VmInstanceApplicationResponse::getCreateUserId).filter(Objects::nonNull).collect(Collectors.toList());
  13.         userIds.addAll(applicationList.stream().map(VmInstanceApplicationResponse::getAuditor).filter(Objects::nonNull).collect(Collectors.toList()));
  14.         userIds = userIds.stream().distinct().collect(Collectors.toList());
  15.         try {
  16.             List<UserInfoDto> userList = userService.getByIdList(userIds); // 查询用户列表
  17.             if (userList != null && !userList.isEmpty()) {
  18.                 Map<Long, String> userNameMap = userList.stream().collect(Collectors.toMap(UserInfoDto::getUserId, UserInfoDto::getUserName));
  19.                 applicationList.forEach(one -> {
  20.                     one.setUserName(userNameMap.get(one.getCreateUserId()));
  21.                     one.setAuditorName(userNameMap.get(one.getAuditor()));
  22.                 });
  23.             }
  24.         }
  25.         catch (Exception e) {
  26.             LoggerUtil.error("fail to translate userName", e);
  27.         }
  29.         return new PageInfo<>(page.getCurrent(), page.getSize(), page.getTotal(), applicationList);
  30.     }

其中

  1. Page page = new Page<>((params.getPageIndex() == null ? 1 : params.getPageIndex()), (params.getPageSize() == null ? 10 : params.getPageSize()));
  2. //这是一个单页的列表，但可以被plus插件拦截取到total值 
  3. List<VmInstanceApplicationResponse> applicationList = vmInstanceApplicationMapper.applicationList(page, params);

Vo请求类格式

定义分页字段：

  • private Integer pageIndex;
  • private Integer pageSize; ```java package com.iwhalecloud.aiFactory.aiDevCenter.application.vo;

import com.iwhalecloud.aiFactory.aiDevCenter.application.dto.VmInstanceApplication;

import lombok.Data; import lombok.experimental.Accessors;

import java.util.List;

@Data @Accessors(chain = true) public class VmInstanceApplicationRequest extends VmInstanceApplication {

  1. private Integer pageIndex;
  3. private Integer pageSize;
  5. private String vmName; // 虚拟机名称（即notebook的名称）
  7. private List<String> applicationStatusList; //  申请状态列表
  9. private String userName;
  11. @Override
  12. public String toString() {
  13.     final StringBuffer sb = new StringBuffer("VmInstanceApplicationRequest{");
  14.     sb.append("pageIndex=").append(pageIndex);
  15.     sb.append(", pageSize=").append(pageSize);
  16.     sb.append(", vmName='").append(vmName).append('\'');
  17.     sb.append(", applicationStatusList=").append(applicationStatusList);
  18.     sb.append(", userName='").append(userName).append('\'');
  19.     sb.append('}');
  20.     return sb.toString();
  21. }

}

  2. <a name="jOrQx"></a>
  3. # 分页类数据结构
  4. <a name="nFaNV"></a>
  5. ## Page
  6. ```java
  7. /**
  8.  * Copyright (c) 2011-2014, hubin (jobob@qq.com).
  9.  * <p>
  10.  * Licensed under the Apache License, Version 2.0 (the "License"); you may not
  11.  * use this file except in compliance with the License. You may obtain a copy of
  12.  * the License at
  13.  * <p>
  14.  * http://www.apache.org/licenses/LICENSE-2.0
  15.  * <p>
  16.  * Unless required by applicable law or agreed to in writing, software
  17.  * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
  18.  * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
  19.  * License for the specific language governing permissions and limitations under
  20.  * the License.
  21.  */
  22. package com.baomidou.mybatisplus.plugins;
  24. import java.beans.Transient;
  25. import java.util.Collections;
  26. import java.util.List;
  27. import java.util.Map;
  29. import com.baomidou.mybatisplus.plugins.pagination.Pagination;
  31. /**
  32.  * <p>
  33.  * 实现分页辅助类
  34.  * </p>
  35.  *
  36.  * @author hubin
  37.  * @Date 2016-03-01
  38.  */
  39. public class Page<T> extends Pagination {
  41.     private static final long serialVersionUID = 1L;
  43.     /**
  44.      * 查询数据列表
  45.      */
  46.     private List<T> records = Collections.emptyList();
  48.     /**
  49.      * 查询参数（ 不会传入到 xml 层，这里是 Controller 层与 service 层传递参数预留 ）
  50.      */
  51.     private Map<String, Object> condition;
  53.     public Page() {
  54.         /* 注意，传入翻页参数 */
  55.     }
  57.     public Page(int current, int size) {
  58.         super(current, size);
  59.     }
  61.     public Page(int current, int size, String orderByField) {
  62.         super(current, size);
  63.         this.setOrderByField(orderByField);
  64.     }
  66.     public Page(int current, int size, String orderByField, boolean isAsc) {
  67.         this(current, size, orderByField);
  68.         this.setAsc(isAsc);
  69.     }
  71.     public List<T> getRecords() {
  72.         return records;
  73.     }
  75.     public Page<T> setRecords(List<T> records) {
  76.         this.records = records;
  77.         return this;
  78.     }
  80.     @Transient
  81.     public Map<String, Object> getCondition() {
  82.         return condition;
  83.     }
  85.     public Page<T> setCondition(Map<String, Object> condition) {
  86.         this.condition = condition;
  87.         return this;
  88.     }
  90.     @Override
  91.     public String toString() {
  92.         StringBuilder pg = new StringBuilder();
  93.         pg.append(" Page:{ [").append(super.toString()).append("], ");
  94.         if (records != null) {
  95.             pg.append("records-size:").append(records.size());
  96.         } else {
  97.             pg.append("records is null");
  98.         }
  99.         return pg.append(" }").toString();
  100.     }
  102. }

PageInfo

  1. package com.iwhalecloud.aiFactory.common.dto;
  3. import lombok.ToString;
  5. import java.io.Serializable;
  6. import java.util.Collections;
  7. import java.util.List;
  9. @ToString
  10. public class PageInfo<T> implements Serializable {
  11.     /**
  12.      * 总数
  13.      */
  14.     private int total = 0;
  16.     /**
  17.      * 每页显示条数，默认 10
  18.      */
  19.     private int size = 10;
  21.     /**
  22.      * 总页数
  23.      */
  24.     private int pages = 0;
  26.     /**
  27.      * 当前页
  28.      */
  29.     private int current = 1;
  32.     private int pageCount; // 总页数
  34.     /**
  35.      * 查询数据列表
  36.      */
  37.     private List<T> list = Collections.emptyList();
  39.     public PageInfo() {
  40.     }
  42.     public PageInfo(int current, int size) {
  43.         this.size = size;
  44.         this.current = current;
  45.     }
  47.     public PageInfo(int current, int size, int total, List<T> list) {
  48.         this.total = total;
  49.         this.size = size;
  50.             this.current = current;
  51.         this.list = list;
  52.         this.pages = (total + size - 1) / size;
  53.     }
  55.     public int getTotal() {
  56.         return total;
  57.     }
  59.     public PageInfo<T> setTotal(int total) {
  60.         this.total = total;
  61.         pages = (total + size - 1) / size;
  62.         return this;
  63.     }
  65.     public int getSize() {
  66.         return size;
  67.     }
  69.     public PageInfo<T> setSize(int size) {
  70.         this.size = size;
  71.         pages = (total + size - 1) / size;
  72.         return this;
  73.     }
  75.     public int getPages() {
  76.         return pages;
  77.     }
  79.     public int getCurrent() {
  80.         return current;
  81.     }
  83.     public PageInfo<T> setCurrent(int current) {
  84.         this.current = current;
  85.         return this;
  86.     }
  88.     public List<T> getList() {
  89.         return list;
  90.     }
  92.     public PageInfo<T> setList(List<T> list) {
  93.         this.list = list;
  94.         return this;
  95.     }
  96.     public int getPageCount() {
  97.         return pageCount;
  98.     }
  100.     public void setPageCount(int pageCount) {
  101.         this.pageCount = pageCount;
  102.     }
  103. }