首先yml配置文件添加数据库连接配置:
datasource:
dynamic:
datasource:
master:
url: jdbc:mysql://数据库地址?characterEncoding=UTF-8&useUnicode=true&useSSL=false&tinyInt1isBit=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai
username: 账号
password: 密码
driver-class-name: com.mysql.cj.jdbc.Driver
hikari:
minimum-idle: 5
idle-timeout: 18000
maximum-pool-size: 10
max-lifetime: 1800000
connection-test-query: SELECT 1
connection-timeout: 30000
auto-commit: true
type: com.zaxxer.hikari.HikariDataSource
sqlserver:
url: jdbc:sqlserver://数据库地址;SelectMethod=cursor;DatabaseName=ecology
username: 账号
password: 密码
driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
启动类StartupApplication.java
添加排除类(重要)
@SpringBootApplication(exclude = {
DruidDataSourceAutoConfigure.class
}