jdbcTemplate配置多数据源_为不同包下的jdbctemplate注入不同datasource-优快云博客

本文链接：https://blog.youkuaiyun.com/adaadadsa/article/details/100555005

这篇博客介绍了如何在SpringBoot项目中配置jdbcTemplate以支持多数据源。通过在properties配置文件中添加相关属性，并创建DataSourceConfig类进行详细设置，为以后的项目开发提供了便利。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

网上找的资料，地址具体忘了，此处作为保存，方便以后使用

springboot项目，在properties配置文件中添加属性

#aaa
spring.datasource.aaa.jdbcUrl=jdbc:oracle:thin:@172.xx.xx.xx:1521/XXXX
spring.datasource.aaa.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.aaa.username=aaaaa
spring.datasource.aaa.password=xxxxx


#bbb
spring.datasource.bbb.jdbcUrl=jdbc:oracle:thin:@172.xx.xx.xx:1521/XXXX
spring.datasource.bbb.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.bbb.username=bbbbb
spring.datasource.bbb.password=xxxxx

#ccc
spring.datasource.ccc.jdbcUrl=jdbc:oracle:thin:@172.xx.xx.xx:1521/XXXX
spring.datasource.ccc.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.ccc.username=ccccc
spring.datasource.ccc.password=xxxxx

创建DataSourceConfig类，添加注解，备注属性等

package com.zjxt.jszxdemo2.config;

import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
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 javax.sql.DataSource;

/**
 * @Author: heiheihaxi
 * @Date: 2019/7/4 14:48
 */

@Configuration
public class DataSourceConfig {

    @Bean(name = "aaaDataSource")
    @Qualifier("aaaDataSource")
    @Primary
    @ConfigurationProperties(prefix="spring.datasource.aaa")
    public DataSource aaaDataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "bbbDataSource")
    @Qualifier("bbbDataSource")
    @ConfigurationProperties(prefix="spring.datasource.bbb")
    public DataSource bbbDataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "aaaJdbcTemplate")
    public JdbcTemplate aaaJdbcTemplate(
            @Qualifier("aaaDataSource") DataSource dataSource) {
        return new JdbcTemplate(dataSource);
    }

    @Bean(name = "bbbJdbcTemplate")
    public JdbcTemplate bbbJdbcTemplate(
            @Qualifier("bbbDataSource") DataSource dataSource) {
        return new JdbcTemplate(dataSource);
    }

    @Bean(name = "cccDataSource")
    @Qualifier("cccDataSource")
    @ConfigurationProperties(prefix="spring.datasource.ccc")
    public DataSource cccDataSource() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "cccJdbcTemplate")
    public JdbcTemplate cccJdbcTemplate(
            @Qualifier("cccDataSource") DataSource dataSource) {
        return new JdbcTemplate(dataSource);
    }

}