pom 依賴

            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper-spring-boot-starter</artifactId>
                <version>1.2.10</version>
            </dependency>
             <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>3.3.2</version>
            </dependency>
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-support</artifactId>
                <version>2.3</version>
            </dependency>

yml

mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  mapper-locations: classpath:/mapperxml/*.xml

config MybatisPlusConfig.java

package com.xm.paypalxmbrowser.config;

import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.pagination.optimize.JsqlParserCountOptimize;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

//Spring boot方式
@Configuration
@MapperScan("com.xm.paypalxmbrowser.mapper*")
public class MybatisPlusConfig {

    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));
        return paginationInterceptor;
    }


}

mapper

package com.xm.paypalxmbrowser.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xm.paypalxmbrowser.entity.AccountTable;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface AccountTableMapper extends BaseMapper<AccountTable> {

}

service 使用案列

     public <E> HashMap<String, Object> queryAll(int pageNum, int pageSize) {
            HashMap<String, Object> map = new HashMap<>();
            QueryWrapper<AccountTable>  wrapper =new QueryWrapper<>();
            com.baomidou.mybatisplus.extension.plugins.pagination.Page<AccountTable> page = new Page<>(pageNum, pageSize);
            accountTableMapper.selectPage(page,wrapper);
    
            long total = page.getTotal(); //獲取總記錄數(shù)
            long pageCount = total % pageSize == 0 ? total / pageSize : total / pageSize + 1;
            map.put("ssnInfoList", page.getRecords());
            map.put("pageCount", pageCount);
            map.put("total", total);
            return map;
        }

備注

這里的 page  必須是 com.baomidou.mybatisplus.extension.plugins.pagination.Page  很坑
主鍵   @TableId(value="id",type= IdType.AUTO) 
設(shè)置表時間格式 utf8