spring boot 集成dynamic-datasource-spring-boot-starter动态数据源

 一、增加依赖项

        <!--多数据源依赖开始-->
      <dependency>
      <groupId>com.baomidou</groupId>
      <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
      <version>3.4.0</version>
      </dependency>
      <dependency>
      <groupId>com.oracle.database.jdbc</groupId>
      <artifactId>ojdbc8</artifactId>
      <scope>runtime</scope>
      </dependency>
  
 

 二、编写动态数据源配置项

      spring:
       datasource:
      dynamic:
      primary: mysql
      strict: true
      datasource:
      mysql:
      type: com.zaxxer.hikari.HikariDataSource
      driverClassName: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://127.0.0.1:3306/ds0serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=UTF-8
      username: root
      password: 123456
      oracle:
      type: com.zaxxer.hikari.HikariDataSource
      driverClassName: oracle.jdbc.driver.OracleDriver
      url: jdbc:oracle:thin:@localhost:1521:orcl
      username: root
      password: 123456
  
 

三、直接在service层或者mapper层接口和方法上增加DS("数据库名")注解即可

四、详细官方文档请查看

https://mybatis.plus/guide/dynamic-datasource.html#%E6%96%87%E6%A1%A3-documentation

文章来源: blog.csdn.net，作者：血煞风雨城2018，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.csdn.net/qq_31905135/article/details/118027057