Exercise

Working with Statements

CityBook Libraries wants to query their books table. To execute SQL queries in JDBC, you need to create a Statement object from your connection, then use it to run queries and get results.

The database credentials are preloaded in the Credentials class, and all necessary imports (Connection, DriverManager, SQLException, Statement, ResultSet) are available.

Instructions

100 XP

Create a Statement from the connection.
Execute the query using the Statement to get a ResultSet.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise