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();


上一篇:
下一篇:
切换中文