如果你的项目需要两个数据库的话，你可以这么配置你的项目

mysqlConfig配置

/**
 * @author wby
 * @date 2022/4/22
 */
@Configuration
@MapperScan(basePackages = "com.example.yiwu.mysqlMapper", sqlSessionTemplateRef  = "mysqlSqlSessionTemplate")
public class MysqlDataSourceConfig {

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

    @Bean(name = "mysqlSqlSessionFactory")
    @Primary
    public SqlSessionFactory mysqlSqlSessionFactory(@Qualifier("mysqlDataSource") DataSource dataSource) throws Exception {
        final MybatisSqlSessionFactoryBean bean = new MybatisSqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:com/example/yiwu/mysqlMapper/xml/*.xml"));
        return bean.getObject();
    }

    @Bean(name = "mysqlTransactionManager")
    @Primary
    public DataSourceTransactionManager mysqlTransactionManager(@Qualifier("mysqlDataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "mysqlSqlSessionTemplate")
    @Primary
    public SqlSessionTemplate mysqlSqlSessionTemplate(@Qualifier("mysqlSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

oracleConfig配置

/**
 * @author wby
 * @date 2022/4/22
 */
@Configuration
@MapperScan(basePackages = "com.example.yiwu.oracleMapper", sqlSessionTemplateRef  = "oracleSqlSessionTemplate")
public class OracleDataSourceConfig {

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

    @Bean(name = "oracleSqlSessionFactory")
    public SqlSessionFactory oracleSqlSessionFactory(@Qualifier("oracleDataSource") DataSource dataSource) throws Exception {
        final MybatisSqlSessionFactoryBean bean = new MybatisSqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:com/example/yiwu/oracleMapper/xml/*.xml"));
        return bean.getObject();
    }

    @Bean(name = "oracleTransactionManager")
    public DataSourceTransactionManager oracleTransactionManager(@Qualifier("oracleDataSource") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }

    @Bean(name = "oracleSqlSessionTemplate")
    public SqlSessionTemplate oracleSqlSessionTemplate(@Qualifier("oracleSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

yml文件配置

spring:
  datasource:
    mysql:
      #数据库用户名
      username: root
      #数据库用户密码
      password: root
      #serverTimezone=UTC 解决市区的报错 一般mysql是8.0以上的是必须配置这个
      #userUnicode=true&characterEncoding=utf-8 指定字符编码、解码格式
      jdbc-url: jdbc:mysql://localhost:3306/test?serverTimezone=UTC&userUnicode=true&characterEncoding=utf-8
      #设置驱动类
      driver-class-name: com.mysql.cj.jdbc.Driver
      #设置数据源
      type: com.alibaba.druid.pool.DruidDataSource

      #连接池的配置信息
      ## 初始化大小，最小，最大
      initialPoolSize: 5
      minPoolSize: 5
      maxPoolSize: 20
      maxIdleTime: 120
      acquireIncrement: 2
      idleConnectionTestPeriod: 60
    oracle:
      driver-class-name: oracle.jdbc.OracleDriver
      jdbc-url: jdbc:oracle:thin:@localhost:1521:test
      username: root
      password: root
      type: com.alibaba.druid.pool.DruidDataSource

      #连接池的配置信息
      ## 初始化大小，最小，最大
      initialPoolSize: 5
      minPoolSize: 5
      maxPoolSize: 20
      maxIdleTime: 120
      acquireIncrement: 2
      idleConnectionTestPeriod: 60