springboot配置双数据源
启动类增加
@SpringBootApplication(exclude= {DataSourceAutoConfiguration.class})
pom.xml增加
<dependency> <groupId>com.baomidougroupId> <artifactId>dynamic-datasource-spring-boot-starterartifactId> <version>3.0.0version> dependency>
application.yml
spring: datasource: dynamic: primary: db1 # 配置默认数据库 datasource: db1: # 数据源1配置 url: jdbc:mysql://ip1:port2/dbname1?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true&serverTimezone=Asia/Shanghai username: jtiptv password: LtXtJc_iptv2018 driver-class-name: com.mysql.jdbc.Driver db2: # 数据源2配置 url: jdbc:mysql://ip2:port2/dbname2?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true&serverTimezone=Asia/Shanghai username: root password: root driver-class-name: com.mysql.jdbc.Driver durid: initial-size: 1 max-active: 20 min-idle: 1 max-wait: 60000
对应service或mapper增加注解
@DS("db1")