com.oracle
ojdbc6
11.2.0.4
mysql
mysql-connector-java
com.alibaba
druid-spring-boot-starter
1.1.6
然后根据application.yml创建两个数据源配置类MysqlDatasourceConfig和OracleDatasourceConfig:
MysqlDatasourceConfig:
package com.springboot.datasource;
import javax.sql.DataSource;
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.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.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
@Configuration
@MapperScan(basePackages = MysqlDatasourceConfig.PACKAGE, sqlSessionFactoryRef = “mysqlSqlSessionFactory”)
public class MysqlDatasourceConfig {
// mysqldao扫描路径
static final String PACKAGE = “com.springboot.mysqldao”;
// mybatis mapper扫描路径
static final String MAPPER_LOCATION = “classpath:mapper/mysql/*.xml”;
@Primary
@Bean(name = “mysqldatasource”)
@ConfigurationProperties(“spring.datasource.druid.mysql”)
public DataSource mysqlDataSource() {
return DruidDataSourceBuilder.create().build();
}
@Bean(name