1. Learn
    2. /
  2. Courses
    3. /
  3. Querying a PostgreSQL Database in Java
Connected

Exercise

Setting up the connection

CityBook Libraries needs your application to establish a live connection to their PostgreSQL database. You'll use JDBC's DriverManager.getConnection() method to open the connection, passing in the URL, username, and password.

To ensure proper resource management, you'll wrap the connection in a try-with-resources block so it closes automatically. The Credentials class with URL, USER, and PASSWORD fields is already available, along with the necessary imports: Connection, DriverManager, and SQLException.

Instructions

100 XP
  • Enclose the connection in a try block.
  • Create a connection from DriverManager.