18、快速开发-配置&测试微服务基本CRUD功能、加依赖，加注解，写配置

1.整合MyBatis-Plus

导入依赖

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

配置

参考官方文档：

https://mp.baomidou.com/guide/quick-start.html#%E9%85%8D%E7%BD%AE

配置数据源
导入数据库驱动

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.17</version>
        </dependency>

驱动对应mysql版本

在application.yml配置数据源

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

配置MyBatis-Plus
1）、使用@MapperScan

@MapperScan("com.xunqi.gulimall.product.dao")

2）、告诉MyBatis-Plus，sql映射文件位置

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

  #设置实体类的自增主键
  global-config:
    db-config:
      id-type: auto