(记录)SpringBoot外部配置文件实现数据库切换
- 程序以jar包形式执行后,可通过外部application.yml配置文件直接切换程序连接的数据库
- 导入依赖
- 内部配置文件
server:
port: 9001
spring:
datasource:
driver-class-name: oracle.jdbc.driver.OracleDriver
dynamic:
#2.指定下方 local DB
primary: name1
strict: false
datasource:
#1.配置数据源
name1:
url: jdbc:oracle:thin:@localhost:端口:test01
username: 1111111111
password: 1111111111
name2:
url: jdbc:oracle:thin:@localhost:端口:test02
username: 222222222222
password: 222222222222
- 外部配置文件
server:
port: 9001
spring:
datasource:
driver-class-name: oracle.jdbc.driver.OracleDriver
dynamic:
#2.指定下方 local DB
primary: name1
strict: false
datasource:
#1.配置数据源
name1:
url: jdbc:oracle:thin:@localhost:端口:test01
username: 1111111111
password: 1111111111
name2:
url: jdbc:oracle:thin:@localhost:端口:test02
username: 222222222222
password: 222222222222