springboot自定义mybatis拦截器，配合pagehelper不冲突

修改pom文件

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

自定义Page对象

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class Page<T> {
   
    private int pageNo = 1;//页码，默认是第一页
    private int pageSize = 10;//每页显示的记录数，默认是15
    private int totalRecord;//总记录数
    private int totalPage;//总页数
    private List<T> results;//对应的当前页记录
    private Map params = new HashMap();//其他的参数我们把它分装成一个Map对象

    public int getPageNo() {
   
        return pageNo;
    }

    public void setPageNo(int pageNo) {
   
        this.pageNo = pageNo;
    }

    public int getPageSize() {
   
        return pageSize;
    }

    public void setPageSize(int pageSize) {
   
        this.pageSize = pageSize;
    }

    public int getTotalRecord() {
   
        return totalRecord;
    }

    public void setTotalRecord(int totalRecord) {
   
        this.totalRecord = totalRecord;
        //在设置总页数的时候计算出对应的总页数，在下面的三目运算中加法拥有更高的优先级，所以最后可以不加括号。
        int totalPage = totalRecord%pageSize==0 ? totalRecord/pageSize : totalRecord/pageSize + 1;
        this.setTotalPage(totalPage);
    }

    public int getTotalPage() {
   
        return totalPage;
    }

    public void setTotalPage(int totalPage) {
   
        this.totalPage = totalPage;
    }

    public List<T> getResults() {
   
        return results;
    }

    public void setResults(List<T> results) {
   
        this.results = results;
    }

    public Map getParams() {
   
        return params;
    }

    public void setParams(Map params) {
   
        this.params = params;
    }

    @Override
    public String toString() {
   
        StringBuilder builder = new StringBuilder();
        builder.append("Page [pageNo=").append(pageNo).append(", pageSize=")
                .append(pageSize).append(", results=").append(results).append(
                ", totalPage=").append(totalPage).append(
                ", totalRecord=").append(totalRecord).append("]");
        return builder.toString();
    }

}

自定义注解

这里请注意，在mapper中调用自定义的注解才会生效

import java.lang.annotation.*;

@Target (ElementType.METHOD)
@Retention (RetentionPolicy.RUNTIME)
@Documented
public @interface QueryConfigInterceptor {
   

    String value() default "";
}

自定义mybatis插件

import org.apache.ibatis.cache.CacheKey;
import org.apache.ibatis.executor.Executor;
import org.apache.ibatis.mapping.BoundSql