启动多个mysql数据库连接

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class MySQLConnectionManager {
    private static final String URL = "jdbc:mysql://localhost:3306/mydatabase";
    private static final String USER = "username";
    private static final String PASSWORD = "password";
    private static final int MAX_CONNECTIONS = 10;

    private List<Connection> connectionPool = new ArrayList<>();

    public MySQLConnectionManager() {
        initializePool();
    }

    private void initializePool() {
        for (int i = 0; i < MAX_CONNECTIONS; i++) {
            try {
                Connection connection = DriverManager.getConnection(URL, USER, PASSWORD);
                connectionPool.add(connection);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public synchronized Connection getConnection() {
        if (connectionPool.isEmpty()) {
            throw new RuntimeException("No available connections in the pool.");
        }
        return connectionPool.remove(connectionPool.size() - 1);
    }

    public synchronized void releaseConnection(Connection connection) {
        connectionPool.add(connection);
    }

    public static void main(String[] args) {
        MySQLConnectionManager manager = new MySQLConnectionManager();
        Connection connection = manager.getConnection();
        try {
            // 使用连接进行数据库操作
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            manager.releaseConnection(connection);
        }
    }
}