如何使用Java连接到Google Cloud SQL数据库

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

// 数据库连接参数
String instanceConnectionName = "your-instance-connection-name";
String databaseName = "your-database-name";
String username = "your-username";
String password = "your-password";

// 创建连接字符串
String jdbcUrl = String.format(
    "jdbc:mysql://google/%s?cloudSqlInstance=%s&socketFactory=com.google.cloud.sql.mysql.SocketFactory&user=%s&password=%s",
    databaseName, instanceConnectionName, username, password);

// 建立连接
try (Connection connection = DriverManager.getConnection(jdbcUrl)) {
    // 执行数据库操作
    Statement statement = connection.createStatement();
    ResultSet resultSet = statement.executeQuery("SELECT * FROM your_table");
    // 处理结果集
    while (resultSet.next()) {
        // 处理每一行数据
    }
} catch (Exception e) {
    // 处理连接或查询异常
    e.printStackTrace();
}