SpringBoot整合mybatis-plus

1、导入依赖

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.2.0</version>
</dependency>

2、配置

2.1配置数据源

2.1.1、导入数据库驱动

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.28</version>
</dependency>

2.1.2 在apllication.yml配置数据源相关信息

spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/xxx?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

2.1.3 配置mybatis-plus及分页插件

1.使用@MapperScan

@Configuration
@MapperScan("com.atguigu.gulimall.product.dao")
public class MybatisConfig {
    //引入分页插件
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor interceptor = new PaginationInterceptor();
        //设置请求的页面大于最大页后操作，true调回到首页，false继续请求  默认false
        interceptor.setOverflow(true);
        //设置最大单页限制数量，默认500条，-1不受限制
        interceptor.setLimit(1000);
        return interceptor;
    }
}

2.告诉mybatis-plus  sql映射文件的位置

mybatis-plus.mapper-locations=classpath:/mapper/**/*.xml

2.1.4 逻辑删除配置

1.配置全局的逻辑删除规则

mybatis-plus.global-config.db-config.id-type=auto
mybatis-plus.global-config.db-config.logic-delete-value=1
mybatis-plus.global-config.db-config.logic-not-delete-value=0

2.实体类加上逻辑删除注解@TableLogic