import java.sql.*;
import com.google.cloud.spanner.jdbc.*;
String url = "jdbc:cloudspanner://spanner.googleapis.com/projects/{project_id}/instances/{instance_id}/databases/{database}";
Connection connection = DriverManager.getConnection(url);
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM table");
while (resultSet.next()) {
}
Statement statement = connection.createStatement();
statement.executeUpdate("INSERT INTO table (column1, column2) VALUES (value1, value2)");
connection.commit();
HikariConfig config = new HikariConfig();
config.setJdbcUrl(url);
config.setMaximumPoolSize(10);
config.setIdleTimeout(30000);
DataSource dataSource = new HikariDataSource(config);
Connection connection = dataSource.getConnection();