用 springboot 与 mybatis 如何配置多数据源？

<!-- Spring Boot Starter Data JPA (如果使用JPA) -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

<!-- MyBatis Starter -->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>${mybatis.version}</version>
</dependency>

<!-- 数据库驱动，例如MySQL -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

<!-- 第二个数据库驱动，根据实际使用的数据库类型添加 -->

@Configuration
public class DataSourceConfig {

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

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

    @Bean
    public SqlSessionFactory sqlSessionFactory(DataSource firstDataSource, DataSource secondDataSource) throws Exception {
        SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
        // 配置第一个数据源的SqlSessionFactory
        factoryBean.setDataSource(firstDataSource);
        // 配置MyBatis的相关属性...
        SqlSessionFactory firstSqlSessionFactory = factoryBean.getObject();

        // 对第二个数据源重复相同步骤
        factoryBean.setDataSource(secondDataSource);
        SqlSessionFactory secondSqlSessionFactory = factoryBean.getObject();

        // 根据需要选择或处理这两个SqlSessionFactory
        // 这里简化处理，实际应用中可能需要更复杂的策略来区分使用哪个SqlSessionFactory
        return firstSqlSessionFactory; // 示例中仅返回一个，实际应用需调整
    }

    // 配置事务管理器等其他bean...
}

// 使用@MapperScan分别指定Mapper接口的位置
@MapperScan(basePackages = "com.example.firstdb.mapper", sqlSessionFactoryRef = "sqlSessionFactory")
@MapperScan(basePackages = "com.example.seconddb.mapper", sqlSessionFactoryRef = "sqlSessionFactory")

@Bean
public MapperScannerConfigurer mapperScannerConfigurer() {
    MapperScannerConfigurer configurer = new MapperScannerConfigurer();
    configurer.setBasePackage("com.example.firstdb.mapper");
    configurer.setSqlSessionFactoryBeanName("sqlSessionFactory");
    return configurer;
}

// 同理，为第二个数据源的Mapper接口配置

@Service
public class SomeService {

    @Autowired
    @Qualifier("firstDataSource")
    private DataSource firstDataSource;

    @Autowired
    @Qualifier("secondDataSource")
    private DataSource secondDataSource;

    // 使用相应的数据源进行数据库操作...
}