SpringBoot如何整合Mybatis分页插件

全网唯一正确的操作

所有人都在扯淡,pom里写的pageHelper连starter都没有,还加@bean注解笑死人了,我来说说正确的操作

第一步

    <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.3.0</version>
        </dependency>

第二步

在application.yml中顶格写:

pagehelper:
  helperDialect: mysql
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql

赠送一个我写的page工具类

@Data@AllArgsConstructor@NoArgsConstructor
public class page<T> {
    private int pageNumber;
    private int pageSize;
    private int total;
    private List<T> rows;
    private int pageCount;
        private int pre;
        private int next;
        private int start; //limit ?,?
        private boolean first;
        private boolean last;

    public int getPageCount() {
        return (getTotal()+getPageSize()-1)/getPageSize();
    }

    public int getPre() {
        if(getPageNumber()==1)
        return 1;
        return getPageNumber()-1;
    }

    public int getNext() {
        if(getPageNumber()==getPageCount())
        return getPageCount();
        return getPageNumber()+1;
    }

    public int getStart() {
        return (getPageNumber()-1)*pageSize;
    }


    public boolean isFirst() {
        return getPageNumber()==1;
    }

}

总结

boot的原理希望大家看一看,他的starter市干啥用的很他妈重要