Springboot项目配置多数据源

最新推荐文章于 2024-01-02 19:51:03 发布

温柔的男孩像海洋

最新推荐文章于 2024-01-02 19:51:03 发布

阅读量131

点赞数

分类专栏： java知识点文章标签： spring boot mybatis java

本文链接：https://blog.csdn.net/qq_43526338/article/details/127442981

版权

java知识点专栏收录该内容

8 篇文章 0 订阅

订阅专栏

第一步：连接池

spring.datasource.data.jdbc-url=****
spring.datasource.data.username=****
spring.datasource.data.password=****
spring.datasource.data.driver-class-name=****
spring.datasource.data.type=****

spring.datasource.data2.jdbc-url=****
spring.datasource.data2.username=****
spring.datasource.data2.password=****
spring.datasource.data2.driver-class-name=****
spring.datasource.data2.type=****

第二部：编写Configuration

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
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.*;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import javax.sql.DataSource;

@Configuration
@MapperScan(basePackages = {"****.mapper"}, sqlSessionFactoryRef = "dataSqlSessionFactory")
@Profile({"dev", "default"})
public class DataSource3Config {
    @Bean(name = "dataDataSource")//注入到这个容器
    @ConfigurationProperties(prefix = "spring.datasource.data")
    @Primary
    public DataSource dataDataSource() {
        return DataSourceBuilder.create().build();
    }

    //@Qualifier("xxx")的含义是告诉他使用哪个DataSource
    @Bean(name = "data3SqlSessionFactory")
    @Primary
    public SqlSessionFactory data3SqlSessionFactory(@Qualifier("data3DataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        return bean.getObject();
    }

    @Bean(name = "data3TransactionManager")//配置事务
    @Primary
    public DataSourceTransactionManager data3TransactionManager(@Qualifier("data3DataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "data3SqlSessionTemplate")
    @Primary
    public SqlSessionTemplate data3SqlSessionTemplate(@Qualifier("data3SqlSessionFactory") SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }

}