Topic 14. Working with relational databases through JDBC

Goal: learn to use parameterized queries, map results to objects, and verify transactional changes.

Lecture contents

1. The relational model and PostgreSQL — Persistent data and the relational model · Setting up PostgreSQL
2. JDBC and queries — JDBC: API, driver, and connection · Example 1. The first connection · Query parameters and results · Example 2. A book catalog with JOIN
3. Transactions and concurrency — Transactions and concurrency
4. DAO, DataSource, and testing — DAO and batch changes · DataSource, metadata, and errors · Testing the DAO and transactions

Practice and review

• Practice — 3 worked examples with complete code
• Tasks — 30 variants, each with tasks at three difficulty levels
• Summary — conclusions and self-check questions