Verification method of adding Multi-data Source mysql to SpringBot
Package com.holytax.accenture_fp_in.datasource
Import javax.sql.DataSource
Import org.springframework.beans.factory.annotation.Qualifier
Import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder
Import org.springframework.boot.context.properties.ConfigurationProperties
Import org.springframework.context.annotation.Bean
Import org.springframework.context.annotation.Configuration
Import org.springframework.context.annotation.Primary
/ * *
Configure multiple data sources
* / @ Configurationbr/ > @ Configuration
@ Bean (name = "primaryDataSource") @ Qualifier ("primaryDataSource") br/ > @ Qualifier ("primaryDataSource")
@ ConfigurationProperties (prefix = "spring.datasource")
Public DataSource primaryDataSource () {
Return DataSourceBuilder.create () .build ()
}
@ Bean (name = "secondaryDataSource") @ Qualifier ("secondaryDataSource") br/ > @ Qualifier ("secondaryDataSource")
Public DataSource secondaryDataSource () {
Return DataSourceBuilder.create () .build ()
}
}
Copy the code