java配置两个mysql数据库

CREATE DATABASE database1;

CREATE DATABASE database2;

# 数据库1配置
spring.datasource.db1.url=jdbc:mysql://localhost:3306/database1?useSSL=false
spring.datasource.db1.username=your_username
spring.datasource.db1.password=your_password
spring.datasource.db1.driver-class-name=com.mysql.jdbc.Driver

# 数据库2配置
spring.datasource.db2.url=jdbc:mysql://localhost:3306/database2?useSSL=false
spring.datasource.db2.username=your_username
spring.datasource.db2.password=your_password
spring.datasource.db2.driver-class-name=com.mysql.jdbc.Driver

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class DatabaseExample {
    public static void main(String[] args) {
        try {
            // 连接数据库1
            Connection connection1 = DriverManager.getConnection("jdbc:mysql://localhost:3306/database1", "your_username", "your_password");
            Statement statement1 = connection1.createStatement();
            
            // 执行查询操作
            ResultSet resultSet1 = statement1.executeQuery("SELECT * FROM table1");
            while (resultSet1.next()) {
                // 处理结果集
            }
            
            // 关闭连接
            resultSet1.close();
            statement1.close();
            connection1.close();
            
            // 连接数据库2
            Connection connection2 = DriverManager.getConnection("jdbc:mysql://localhost:3306/database2", "your_username", "your_password");
            Statement statement2 = connection2.createStatement();
            
            // 执行查询操作
            ResultSet resultSet2 = statement2.executeQuery("SELECT * FROM table2");
            while (resultSet2.next()) {
                // 处理结果集
            }
            
            // 关闭连接
            resultSet2.close();
            statement2.close();
            connection2.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}