Skip to content
SparkTime, home

Tagged #JDBC

GuideTechnology

30 min read

Project 2: Move the Expense Tracker to PostgreSQL with JDBC

Take the Expense Tracker CLI and add a PostgreSQL repository behind the same interface: an idempotent schema, a transactional bulk import, a connection pool, one shared contract test for every implementation, a fat jar, and an honest review.

GuideTechnology

25 min read

JDBC: Talking to a Database from Java

Learn JDBC, the standard way Java programs use a relational database: connecting with a driver, running queries with PreparedStatement, mapping rows, preventing SQL injection, transactions, error codes, batching and connection pooling, with every program run against PostgreSQL 18.