import java.sql.*;
public class CloudSpannerExample {
public static void main(String[] args) throws SQLException {
String projectId = "your-project-id";
String instanceId = "your-instance-id";
String databaseName = "your-database-name";
String url = "jdbc:cloudspanner://spanner.googleapis.com:443/projects/" + projectId +
"/instances/" + instanceId + "/databases/" + databaseName;
Connection connection = DriverManager.getConnection(url);
String sql = "SELECT * FROM users";
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()) {
String username = resultSet.getString("username");
int age = resultSet.getInt("age");
System.out.println("Username: " + username + ", Age: " + age);
}
resultSet.close();
statement.close();
connection.close();
}
}
