<dependency>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP</artifactId>
<version>3.4.5</version>
</dependency>
properties
datasource.jdbcUrl=jdbc:mysql://localhost:3306/mydb
datasource.username=myusername
datasource.password=mypassword
hikari.poolName=MyHikariCPConnectionPool
hikari.maximumPoolSize=100
hikari.connectionTimeout=30000
hikari.idleTimeout=600000
hikari.maxLifetime=1800000
hikari.connectionTestQuery=SELECT 1
import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;
public class HikariCPExample {
public static void main(String[] args) {
HikariConfig config = new HikariConfig();
config.setPoolName("MyHikariCPConnectionPool");
config.setMaximumPoolSize(100);
config.setConnectionTimeout(30000);
config.setIdleTimeout(600000);
config.setMaxLifetime(1800000);
config.setConnectionTestQuery("SELECT 1");
config.setJdbcUrl("jdbc:mysql://localhost:3306/mydb");
config.setUsername("myusername");
config.setPassword("mypassword");
HikariDataSource dataSource = new HikariDataSource(config);
// ...
dataSource.close();
}
}
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DatabaseOperations {
private HikariDataSource dataSource;
public DatabaseOperations(HikariDataSource dataSource) {
this.dataSource = dataSource;
}
public void executeQuery(String sql) {
try (Connection connection = dataSource.getConnection();
PreparedStatement statement = connection.prepareStatement(sql);
ResultSet resultSet = statement.executeQuery()) {
while (resultSet.next()) {
// ...
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
