一、前言
現在在我們的項目中，使用多數據源已經是很常見的，下面，這里總結一下springboot整合jdbcTemplate配置多數據源的代碼示例，以方便以后直接使用.
二、配置文件
|
1
2
3
4
5
6
7
8
9
10
11
12
|
spring: datasource: datasourceone: driverClassName: com.mysql.jdbc.Driver url: jdbc:mysql://localhost:3306/eesy?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false username: root password: root dataSourcetwo: driverClassName: com.mysql.jdbc.Driver url: jdbc:mysql://localhost:3306/eesy?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false username: root password: root |
三、數據源配置類
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
package com.ssl.datasource.config; import org.springframework.beans.factory.annotation.Qualifier;import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;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;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate; import javax.sql.DataSource; @Configurationpublic class DataSourceOne { @Bean("name-template-one") public NamedParameterJdbcTemplate namedParameterJdbcTemplate(@Qualifier("datasource-one") DataSource dataSource){ return new NamedParameterJdbcTemplate(dataSource); } @Bean("template-one") public JdbcTemplate jdbcTemplate(@Qualifier("datasource-one") DataSource dataSource){ return new JdbcTemplate(dataSource); } @Bean("datasource-one") public DataSource dataSource(@Qualifier("jdbc-config-one") DataSourceProperties dataSourceProperties){ return dataSourceProperties.initializeDataSourceBuilder().build(); } @Primary @Bean("jdbc-config-one") @ConfigurationProperties(prefix = "spring.datasource.datasourceone") public DataSourceProperties properties(){ return new DataSourceProperties(); }} |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
package com.ssl.datasource.config; import org.springframework.beans.factory.annotation.Qualifier;import org.springframework.boot.autoconfigure.jdbc.DataSourceProperties;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;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate; import javax.sql.DataSource; @Configurationpublic class DataSourceTwo { @Bean("name-template-two") public NamedParameterJdbcTemplate namedParameterJdbcTemplate(@Qualifier("datasource-two") DataSource dataSource){ return new NamedParameterJdbcTemplate(dataSource); } @Bean("template-two") public JdbcTemplate jdbcTemplate(@Qualifier("datasource-two") DataSource dataSource){ return new JdbcTemplate(dataSource); } @Bean("datasource-two") public DataSource dataSource(@Qualifier("jdbc-config-two") DataSourceProperties dataSourceProperties){ return dataSourceProperties.initializeDataSourceBuilder().build(); } @Bean("jdbc-config-two") @ConfigurationProperties(prefix = "spring.datasource.datasourcetwo") public DataSourceProperties properties(){ return new DataSourceProperties(); }} |
到此這篇關于詳解Springboot之整合JDBCTemplate配置多數據源的文章就介紹到這了,更多相關springboot整合JDBCTemplate內容請搜索服務器之家以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持服務器之家！
原文鏈接：https://blog.csdn.net/sunshunli/article/details/115663502
