Connection Pooling
Opening a new database connection for every request is slow and resource-intensive. Connection pooling solves this by reusing a pool of open connections. HikariCP is a popular, high-performance connection pool for Java applications.
Set up HikariCP for CityBook Libraries to improve their application's performance. HikariConfig, HikariDataSource, and database credentials are already imported for you.
本练习是课程的一部分
Querying a PostgreSQL Database in Java
练习说明
- Configure
HikariConfigwith the database URL, username, and password. - Create a
HikariDataSourcefrom the configuration. - Get a connection from the pool.
交互式实操练习
通过完成这段示例代码来试试这个练习。
public class Main {
public static void main(String[] args) {
// Configure HikariCP with credentials
HikariConfig config = new HikariConfig();
config.____(Credentials.URL);
config.____(Credentials.USER);
config.____(Credentials.PASSWORD);
// Create the connection pool
HikariDataSource ds = new ____(config);
// Get a connection from the pool
try (Connection conn = ____.____()) {
System.out.println("Connected with HikariCP!");
} catch (SQLException e) {
System.out.println("Error: " + e.getMessage());
System.out.println("SQLState: " + e.getSQLState());
}
}
}