import java.sql.*;
public class CloudSpannerJDBCExample {
public static void main(String[] args) {
try {
String connectionString = "jdbc:cloudspanner://database.googleapis.com/projects/{PROJECT_ID}/instances/{INSTANCE_ID}/databases/{DATABASE_ID}";
String username = "{USERNAME}";
String password = "{PASSWORD}";
Connection connection = DriverManager.getConnection(connectionString, username, password);
String query = "SELECT * FROM employees WHERE department = ?";
PreparedStatement statement = connection.prepareStatement(query);
statement.setString(1, "Sales");
ResultSet resultSet = statement.executeQuery();
while(resultSet.next()) {
String name = resultSet.getString("name");
String title = resultSet.getString("title");
System.out.println("Name: " + name + ", Title: " + title);
}
resultSet.close();
statement.close();
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
