HikariConfig config = new HikariConfig();
config.setJdbcUrl("jdbc:postgresql://localhost:5432/mydatabase");
config.setUsername("myusername");
config.setPassword("mypassword");
HikariDataSource dataSource = new HikariDataSource(config);
try (Connection connection = dataSource.getConnection()) {
// ...
} catch (SQLException e) {
e.printStackTrace();
}
try (Connection connection = DriverManager.getConnection(url, username, password)) {
try (PreparedStatement statement = connection.prepareStatement("INSERT INTO mytable (column1, column2) VALUES (?, ?)")) {
for (int i = 0; i < 1000; i++) {
statement.setString(1, "value" + i);
statement.setInt(2, i);
statement.addBatch();
}
int[] result = statement.executeBatch();
} catch (SQLException e) {
e.printStackTrace();
}
} catch (SQLException e) {
e.printStackTrace();
}
try (Connection connection = DriverManager.getConnection(url, username, password)) {
try (PreparedStatement statement = connection.prepareStatement("SELECT * FROM mytable WHERE column1 = ?")) {
try (ResultSet resultSet = statement.executeQuery()) {
while (resultSet.next()) {
}
}
} catch (SQLException e) {
e.printStackTrace();
}
} catch (SQLException e) {
e.printStackTrace();
}
try (Connection connection = DriverManager.getConnection(url, username, password)) {
try (PreparedStatement statement = connection.prepareStatement("SELECT * FROM mytable")) {
try (ResultSet resultSet = statement.executeQuery()) {
while (resultSet.next()) {
}
}
} catch (SQLException e) {
e.printStackTrace();
}
} catch (SQLException e) {
e.printStackTrace();
}
