<dependency>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP</artifactId>
<version>4.0.3</version>
</dependency>
HikariConfig config = new HikariConfig();
config.setJdbcUrl("jdbc:mysql://localhost:3306/mydatabase");
config.setUsername("myusername");
config.setPassword("mypassword");
HikariDataSource dataSource = new HikariDataSource(config);
try (Connection connection = dataSource.getConnection();
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery("SELECT * FROM mytable")) {
while (resultSet.next()) {
}
} catch (SQLException e) {
e.printStackTrace();
}
dataSource.close();
