SpringBoot配置多个数据源

动态 0 616
vom09
vom09 LV1 2021年5月18日 22:32 发表
点击群号免费加入社区交流群:367346704
<p>SpringBoot配置多个数据源:</p><pre><code>@Bean<br>@Primary<br>@ConfigurationProperties("app.datasource.first")<br>public DataSourceProperties firstDataSourceProperties() {<br> return new DataSourceProperties();<br>}<br> <br>@Bean<br>@Primary<br>@ConfigurationProperties("app.datasource.first.configuration")<br>public HikariDataSource firstDataSource() {<br> return firstDataSourceProperties().initializeDataSourceBuilder().type(HikariDataSource.class).build();<br>}<br> <br>@Bean<br>@ConfigurationProperties("app.datasource.second")<br>public BasicDataSource secondDataSource() {<br> return DataSourceBuilder.create().type(BasicDataSource.class).build();<br>}</code></pre><pre><code>app.datasource.first.url=jdbc:mysql://localhost/first<br>app.datasource.first.username=dbuser<br>app.datasource.first.password=dbpass<br>app.datasource.first.configuration.maximum-pool-size=30<br> <br>app.datasource.second.url=jdbc:mysql://localhost/second<br>app.datasource.second.username=dbuser<br>app.datasource.second.password=dbpass<br>app.datasource.second.max-total=30</code></pre><pre><code>@Bean<br>@Primary<br>@ConfigurationProperties("app.datasource.first")<br>public DataSourceProperties firstDataSourceProperties() {<br> return new DataSourceProperties();<br>}<br> <br>@Bean<br>@Primary<br>@ConfigurationProperties("app.datasource.first.configuration")<br>public HikariDataSource firstDataSource() {<br> return firstDataSourceProperties().initializeDataSourceBuilder().type(HikariDataSource.class).build();<br>}<br> <br>@Bean<br>@ConfigurationProperties("app.datasource.second")<br>public DataSourceProperties secondDataSourceProperties() {<br> return new DataSourceProperties();<br>}<br> <br>@Bean<br>@ConfigurationProperties("app.datasource.second.configuration")<br>public BasicDataSource secondDataSource() {<br> return secondDataSourceProperties().initializeDataSourceBuilder().type(BasicDataSource.class).build();<br>}</code></pre><p><br></p>
收藏(0)  分享
相关标签: SpringBoot 多个数据源
0个回复
  • 消灭零回复