1.加入依赖
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>dynamic-datasource-spring-boot-starter</artifactId>
<version>2.5.4</version>
</dependency>
2.配置文件
datasource:
dynamic:
datasource:
master:
# url:
username:
password:
# password:
driver-class-name: com.mysql.jdbc.Driver
# 多数据源配置
multi-datasource1:
url: jdbc:sqlserver://127.0.0.1:8080;SelectMethod=cursor;DatabaseName=srm
username:
password:
driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
3.对于某个数据库的访问要加上@DS注解
例如
@DS("multi-datasource1")