在spring boot应用程序中使用jooq连接到多个MySQL数据库实例

<dependencies>
    <!-- JOOQ -->
    <dependency>
        <groupId>org.jooq</groupId>
        <artifactId>jooq</artifactId>
        <version>3.15.2</version>
    </dependency>
    <dependency>
        <groupId>org.jooq</groupId>
        <artifactId>jooq-meta</artifactId>
        <version>3.15.2</version>
    </dependency>
    <dependency>
        <groupId>org.jooq</groupId>
        <artifactId>jooq-codegen</artifactId>
        <version>3.15.2</version>
    </dependency>

    <!-- MySQL Connector -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.27</version>
    </dependency>
</dependencies>

# 第一个MySQL数据库实例
spring.datasource.url=jdbc:mysql://localhost:3306/db1
spring.datasource.username=username1
spring.datasource.password=password1

# 第二个MySQL数据库实例
spring.datasource.db2.url=jdbc:mysql://localhost:3306/db2
spring.datasource.db2.username=username2
spring.datasource.db2.password=password2

@Configuration
public class DataSourceConfig {
    @Primary
    @Bean(name = "dataSource")
    @ConfigurationProperties(prefix = "spring.datasource")
    public DataSource dataSource() {
        return DataSourceBuilder.create().build();
    }

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

@Configuration
public class JOOQConfig {
    @Autowired
    private DataSource dataSource;

    @Autowired
    private DataSource db2DataSource;

    @Bean(name = "jooqConfiguration")
    public Configuration jooqConfiguration() {
        Configuration configuration = new DefaultConfiguration();

        // 第一个MySQL数据库实例
        DSLContext dslContext = DSL.using(dataSource, SQLDialect.MYSQL);
        configuration.set(dslContext);

        // 第二个MySQL数据库实例
        DSLContext db2DslContext = DSL.using(db2DataSource, SQLDialect.MYSQL);
        configuration.set("db2", db2DslContext);

        return configuration;
    }
}

@Service
public class MyService {
    @Autowired
    @Qualifier("jooqConfiguration")
    private Configuration jooqConfiguration;

    public void doSomething() {
        DSLContext dslContext = DSL.using(jooqConfiguration);

        // 使用第一个MySQL数据库实例
        Result<Record> result1 = dslContext.select().from(TABLE1).fetch();

        // 使用第二个MySQL数据库实例
        DSLContext db2DslContext = DSL.using(jooqConfiguration, "db2");
        Result<Record> result2 = db2DslContext.select().from(TABLE2).fetch();

        // 其他操作...
    }
}