4、Springboot整合MyBatis-Plus

1、整合MyBatis-Plus

1、导入依赖

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

2、配置
1）配置数据源，导入数据库驱动依赖
Mysql官网说明了，mysql驱动8.0同样也适配5.7服务

导入mysql驱动依赖

<!-- mysql驱动 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.17</version>
</dependency>

2）配置文件中配置数据源信息

# mysql
spring:
  datasource:
    #type: com.alibaba.druid.pool.DruidDataSource
    #MySQL配置
    driverClassName: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://192.168.18.38:3306/gulimall_pms?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
    username: root
    password: root

3）启动类配置mybatis-plus扫描路径
在启动类中使用注解，告诉mybatisPlus扫描哪个路径下的包
@MapperScan(“com.atguigu.gulimall.product.dao”)

@EnableRedisHttpSession
@EnableFeignClients(basePackages = "com.atguigu.gulimall.product.feign")
@MapperScan("com.atguigu.gulimall.product.dao")
@SpringBootApplication
@EnableDiscoveryClient
public class GulimallProductApplication {

    public static void main(String[] args) {
        SpringApplication.run(GulimallProductApplication.class, args);
    }
}

4）告诉mybatisPlus SQL的映射xml文件位置及相关配置

#mybatis
mybatis-plus:
  mapper-locations: classpath*:/mapper/**/*.xml
  #实体扫描，多个package用逗号或者分号分隔
  typeAliasesPackage: com.atguigu.gulimall.*.entity
  global-config:
    #数据库相关配置
    db-config:
      #主键类型  AUTO:"数据库ID自增", INPUT:"用户输入ID", ID_WORKER:"全局唯一ID (数字类型唯一ID)", UUID:"全局唯一ID UUID";
      id-type: AUTO
      logic-delete-value: 1 # 逻辑已删除值(默认为 1)
      logic-not-delete-value: 0 # 逻辑未删除值(默认为 0)
    banner: false
  #原生配置
  configuration:
    map-underscore-to-camel-case: true
    cache-enabled: false
    call-setters-on-nulls: true
    jdbc-type-for-null: 'null'

【项目中可使】yml文件中配置主键自增后，实体类中的主键id字段就不需要再次说明自增

3、逻辑删除
1）配置全局的逻辑删除规则

2）配置逻辑删除的组件Bean
3）加上逻辑删除注解@TableLogic

/**
	 * 是否显示[0-不显示，1显示]
	 * @TableLogic 代表逻辑删除
	 *  0:删除   1：未删除
	 */
	@TableLogic(value = "1",delval = "0")
	private Integer showStatus;