SpringBoot多数据源配置

引入依赖

<dependency>
   <groupId>com.baomidou</groupId>
   <artifactId>dynamic-datasource-spring-boot-starter</artifactId>
   <version>3.5.0</version>
</dependency>

application.yml文件填写多个数据源

spring:

     datasource:

          dynamic:

                #默认数据源

                primary: miclale

                #当为false时未查找到数据源使用默认数据源，为true时未查找到数据源报错

                strict: false

                datasource:

                     miclale:

                         url: jdbc:oracle:thin:@127.0.0.1:1521/itsdev

                         username: root

                         password: 1234

                     dbo:

                         driver-class-name: net.sourceforge.jtds.jdbc.Driver

                         url: jdbc:jtds:sqlserver://127.0.0.1:1433

                         username: root

                         password: 1234

在每个ServiceImpl类上用注解@DS( "指定数据源" ) 指定当前业务层需要操作的数据源

其他操作正常进行即可