基于springboot配置多数据源

1 数据库maven依赖
例如

  <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

2 yml 配置数据源

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    xxx-data-mysql:
            driverClassName: com.mysql.jdbc.Driver
            dbUrl: jdbc:mysql://ip:3306/databaseName?                                 useUnicode=true&characterEncoding=UTF-   8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
            username: xxx
            password: xxx
            initialSize: 20
            maxActive: 100
            minIdle: 20
            maxWait: 60000
            poolPreparedStatements: true
            maxPoolPreparedStatementPerConnectionSize: 30
            timeBetweenEvictionRunsMillis: 60000
            minEvictableIdleTimeMillis: 30000
            maxEvictableIdleTimeMillis: 60000
            validationQuery: SELECT 1 FROM DUAL
            testOnBorrow: false
            testOnReturn: false
            testWhileIdle: true
            connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
            filters: stat,wall

3 创建与yml中数据源映射的数据源类

@Component
@ConfigurationProperties(prefix = "spring.datasource.xxx-data-mysql")  // 与步骤2 中的 
xxx-data-mysql   一一对应
public class DruidLinewellParamMysql {
    private String dbUrl;
    private String username;
    private String password;
    private String driverClassName;
    private int initialSize;
    private int maxActive;
    private int minIdle;
    private int maxWait;
    private boolean poolPreparedStatements;
    private int maxPoolPreparedStatementPerConnectionSize;
    private int timeBetweenEvictionRunsMillis;
    private int minEvictableIdleTimeMillis;
    private int maxEvictableIdleTimeMillis;
    private String validationQuery;
    private boolean testWhileIdle;
    private boolean testOnBorrow;
    private boolean testOnReturn;
    private String filters;
    private String connectionProperties;
    }

4 创建配置类

@Configuration
@MapperScan(basePackages =  {"com.xxl.job.executor.mapper.linewellmysql"},sqlSessionTemplateRef = "sqlSessionTemplatexxxMysql")
public class DruidLinewellConfigMysql {
    private static final Logger LOGGER = LoggerFactory.getLogger(DruidLinewellConfigMysql.class) ;

    @Resource
    private DruidxxxParamMysql druidParam; // 通过此数据源类读取yml文件中数据源信息

    @Bean("dataSourcexxxMysql")
    public DataSource dataSourcexxxMysql () {
        DruidDataSource datasource = new DruidDataSource();
        datasource.setUrl(druidParam.getDbUrl());
        datasource.setUsername(druidParam.getUsername());
        datasource.setPassword(druidParam.getPassword());
        datasource.setDriverClassName(druidParam.getDriverClassName());
        datasource.setInitialSize(druidParam.getInitialSize());
        datasource.setMinIdle(druidParam.getMinIdle());
        datasource.setMaxActive(druidParam.getMaxActive());
        datasource.setMaxWait(druidParam.getMaxWait());
        datasource.setTimeBetweenEvictionRunsMillis(druidParam.getTimeBetweenEvictionRunsMillis());
        datasource.setMinEvictableIdleTimeMillis(druidParam.getMinEvictableIdleTimeMillis());
        datasource.setMaxEvictableIdleTimeMillis(druidParam.getMaxEvictableIdleTimeMillis());
        datasource.setValidationQuery(druidParam.getValidationQuery());
        datasource.setTestWhileIdle(druidParam.isTestWhileIdle());
        datasource.setTestOnBorrow(druidParam.isTestOnBorrow());
        datasource.setTestOnReturn(druidParam.isTestOnReturn());
        datasource.setPoolPreparedStatements(druidParam.isPoolPreparedStatements());
        datasource.setMaxPoolPreparedStatementPerConnectionSize(druidParam.getMaxPoolPreparedStatementPerConnectionSize());
        try {
            datasource.setFilters(druidParam.getFilters());
        } catch (Exception e) {
            LOGGER.error("druid configuration initialization filter", e);
        }
        datasource.setConnectionProperties(druidParam.getConnectionProperties());
        return datasource;
    }

    @Bean
    public SqlSessionFactory sqlSessionFactoryxxxMysql() throws Exception{
        MybatisSqlSessionFactoryBean factory = new MybatisSqlSessionFactoryBean();
        ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        factory.setDataSource(dataSourcexxxMysql());
        factory.setMapperLocations(resolver.getResources("classpath*:/dataxxxMysqlMapper/*.xml"));
        return factory.getObject();
    }

    @Bean(name="transactionManagerxxxMysql")
    public DataSourceTransactionManager transactionManagerLinewellMysql(){
        return  new DataSourceTransactionManager(dataSourcexxxMysql());
    }

    @Bean(name = "sqlSessionTemplatexxxMysql")
    public SqlSessionTemplate sqlSessionTemplatexxxMysql() throws Exception {
        return new SqlSessionTemplate(sqlSessionFactoryxxxMysql());
    }
}

步骤4 的basePackages放相对应mapper(dao)文件
步骤3，4主要将yml配置的多数据源与对应的mapper(dao)绑定

5 将mapper(dao)文件与创建的xml（sql语句）关联