mybatis-pkus+dynamic多数据源配置

111 阅读1分钟

可直接复制使用

pom依赖引入properties :

```
    <mysql.version>5.1.47</mysql.version>
    <mybatis-plus>3.4.1</mybatis-plus>
    <dynamic>2.5.4</dynamic>
```

dependencies :

<!-- 多数据源-->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
    <version>${dynamic}</version>
</dependency>

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>${mybatis-plus}</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>${mysql.version}</version>
</dependency>

yml配置

spring:
  datasource:
    dynamic:
      primary: master #默认数据源 方法上添加@DS("db2")切换子数据源
      strict: false #设置严格模式,默认false不启动,启动后在未匹配到指定数据源时,会抛出异常,不启动则使用默认数据源
      datasource:
        master:
          url: jdbc:mysql://localhost:3306/work?characterEncoding=UTF-8&useUnicode=true&serverTimezone=Asia/Shanghai
          username: root
          password: 123456
          driver-class-name: com.mysql.jdbc.Driver
        db2:
          url: jdbc:mysql://localhost:3306/mysql?characterEncoding=UTF-8&useUnicode=true&serverTimezone=Asia/Shanghai
          username: root
          password: 123456
          driver-class-name: com.mysql.jdbc.Driver
```
```