详解Springboot之整合JDBCTemplate配置多数据源

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

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;

@Configuration

public 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();

     }

}

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;

@Configuration

public 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();

     }

}