SpringBoot 配置多数据源

原创

EicroSoft 2022-12-23 01:30:00 博主文章分类：JAVA ©著作权

文章标签 SpringBoot spring bc Source 文章分类 OpenStack 云计算

©著作权归作者所有：来自51CTO博客作者EicroSoft的原创作品，请联系作者获取转载授权，否则将追究法律责任

SpringBoot 配置多数据源，注意 Mapper XML 的目录创建 Invalid bound statement (not found) idea 中创建目录时，不能直接 mappet.hospital

yml配置

spring: 
  datasource:
    # MySQL  java的new Date()时间插入数据库时差差8个小时问题  GMT%2b8
    # driver-class-name: com.mysql.jdbc.Driver #com.mysql.jdbc.Driver和mysql-connector-java 5一起用。
    iron:
      driver-class-name: com.mysql.cj.jdbc.Driver #com.mysql.cj.jdbc.Driver和mysql-connector-java 6 一起用。
      url: jdbc:mysql://192.168.0.10:3306/iron_test?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL
      username: root
      password: 123
      validation-query: select 'x' #用来检测连接是否有效的sql 必须是一个查询语句（ mysql中为 select 'x'  oracle中为 select 1 from dual）
      mapper-locations: classpath*:mapper/*.xml    #将MyBatis Mapper xml 放到 jar 包外面，发布时改成 file:mapper/*.xml

    his:
      #Oracle
      driver-class-name: oracle.jdbc.driver.OracleDriver
      url: jdbc:oracle:thin:@192.168.0.11:1521/iron_s #jdbc:oracle:thin:@//<host>:<port>/<SERVICE_NAME>  dbc:oracle:thin:@<host>:<port>:<SID>
      username: iron
      password: 123
      validation-query: select 1 from dual #用来检测连接是否有效的sql 必须是一个查询语句（ mysql中为 select 'x'  oracle中为 select 1 from dual）
      mapper-locations: classpath*:mapper/hospital/*.xml    #将MyBatis Mapper xml 放到 jar 包外面，发布时改成 file:mapper/hospital/*.xml

 
#    SQL SERVER 数据源基本配置
#    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
#    url: jdbc:sqlserver://192.168.0.12:1433;DatabaseName=irondb
#    username: sa
#    password: 123

IronDruidConfig

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

/**
 * Iron 自己的数据库
 */
@Configuration
@MapperScan(basePackages = IronDruidConfig.PACKAGE, sqlSessionFactoryRef = "ironSqlSessionFactory")
public class IronDruidConfig {

    /**
     * 配置多数据源 关键就在这里 这里配置了不同的数据源扫描不同mapper
     */
    static final String PACKAGE = "com.iron.his.mapper";

    /**
     * 连接数据库信息 这个其实更好的是用配置中心完成
     */
    @Value("${spring.datasource.iron.url}")
    private String url;

    @Value("${spring.datasource.iron.username}")
    private String username;

    @Value("${spring.datasource.iron.password}")
    private String password;

    @Value("${spring.datasource.iron.driver-class-name}")
    private String driverClassName;

    /**
     * 不同的数据源扫描不同mapper, 放到配置文件里修改。因为发布时，需要改成file:mapper/*.xml 方便后期 SQL调整
     */
    @Value("${spring.datasource.iron.mapper-locations}")
    private String mapperLocations;

    @Bean
    public ServletRegistrationBean druidServlet() {
        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
        // IP白名单
        servletRegistrationBean.addInitParameter("allow", "");//默认就是允许所有访问
        // IP黑名单(共同存在时，deny优先于allow)
        //servletRegistrationBean.addInitParameter("deny", "192.168.1.100");
        //控制台管理用户
        servletRegistrationBean.addInitParameter("loginUsername", "admin");
        servletRegistrationBean.addInitParameter("loginPassword", "123456");
        //是否能够重置数据 禁用HTML页面上的“Reset All”功能
        servletRegistrationBean.addInitParameter("resetEnable", "false");
        return servletRegistrationBean;
    }


    @Bean
    public FilterRegistrationBean filterRegistrationBean() {
        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
        filterRegistrationBean.addUrlPatterns("/*");
        filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
        return filterRegistrationBean;
    }

//    注解@Primary表示是主数据源
    @Bean("ironDataSource")
    @Primary
    public DataSource ironDataSource(){
        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setUrl(url);
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        dataSource.setDriverClassName(driverClassName);
        return dataSource;
    }

    @Bean(name = "ironTransactionManager")
    @Primary
    public DataSourceTransactionManager masterTransactionManager() {
        return new DataSourceTransactionManager(ironDataSource());
    }

    @Bean(name = "ironSqlSessionFactory")
    @Primary
    public SqlSessionFactory masterSqlSessionFactory(@Qualifier("ironDataSource") DataSource masterDataSource) throws Exception {
        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(masterDataSource);
        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapperLocations));
        return sessionFactory.getObject();
    }
}

HisDruidConfig

import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;

/**
 * his 的数据库 多数据源时使用
 */
@Configuration
@MapperScan(basePackages = HisDruidConfig.PACKAGE, sqlSessionFactoryRef = "hisSqlSessionFactory")
public class HisDruidConfig {

    /**
     * 配置多数据源 关键就在这里 这里配置了不同的数据源扫描不同mapper
     */
    static final String PACKAGE = "com.iron.his.hospital.mapper";

    /**
     * 连接数据库信息 这个其实更好的是用配置中心完成
     */

    @Value("${spring.datasource.his.driver-class-name}")
    private String driverClassName;

    @Value("${spring.datasource.his.url}")
    private String url;

    @Value("${spring.datasource.his.username}")
    private String username;

    @Value("${spring.datasource.his.password}")
    private String password;

    /**
     * 不同的数据源扫描不同mapper, 放到配置文件里修改。因为发布时，需要改成file:mapper/*.xml 方便后期 SQL调整
     */
    @Value("${spring.datasource.his.mapper-locations}")
    private String mapperLocations;


//    注解@Primary表示是主数据源
    @Bean("hisDataSource")
    public DataSource hisDataSource(){
        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setUrl(url);
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        dataSource.setDriverClassName(driverClassName);
        return dataSource;
    }

    @Bean(name = "hisTransactionManager")
    public DataSourceTransactionManager masterTransactionManager() {
        return new DataSourceTransactionManager(hisDataSource());
    }

    @Bean(name = "hisSqlSessionFactory")
    public SqlSessionFactory masterSqlSessionFactory(@Qualifier("hisDataSource") DataSource masterDataSource) throws Exception {
        final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
        sessionFactory.setDataSource(masterDataSource);
        sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapperLocations));
        return sessionFactory.getObject();
    }
}