import java.sql.*;
public class CloudSpannerExample {
public static void main(String[] args) {
try {
Class.forName("com.google.cloud.spanner.jdbc.JdbcDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
return;
}
String instanceId = "your-instance-id";
String databaseId = "your-database-id";
String projectId = "your-project-id";
String credentialsPath = "path-to-your-credentials-file.json";
String connectionUrl = String.format("jdbc:cloudspanner://https://spanner.googleapis.com/v1/projects/%s/instances/%s/databases/%s", projectId, instanceId, databaseId);
try (Connection connection = DriverManager.getConnection(connectionUrl)) {
String sql = "SELECT * FROM your_table";
try (Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql)) {
while (resultSet.next()) {
String column1 = resultSet.getString("column1");
int column2 = resultSet.getInt("column2");
}
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
