liveBook · Manning

JDBC

Also called Java database connectivity

JDBC (Java Database Connectivity) is the standard Java API for connecting to databases, executing SQL statements, and processing results.

How 3 Manning books explain it

Java Persistence with Spring Data and Hibernate epub

JDBC is the standard Java API for connecting to relational databases and executing SQL statements.

How it is used
Uses JDBC as the low-level SQL access layer beneath Java persistence approaches.
How deep it goes
Describes parameter binding, execution, result retrieval, and type abstraction without walking through a complete JDBC implementation.
Examples
Illustrates type translation with H2Dialect mapping ANSI NUMERIC to vendor-specific DECIMAL.
What you can do after
Evaluate JDBC’s low-level responsibilities and portability limits against ORM and Spring Data JDBC alternatives.

Read how Java Persistence with Spring Data and Hibernate epub explains JDBC →

Data-Oriented Programming: Reduce software complexity

JDBC is the standard Java API for connecting to databases, executing database operations, and processing returned results.

How it is used
Connects Java applications to databases and supplies rows for data-oriented processing.
How deep it goes
Shows a concrete ResultSet conversion utility but stops short of JDBC driver or API internals.
Examples
Uses a book-search query and converts its returned rows into maps containing titles, ISBNs, and publication years.
What you can do after
Apply JDBC to convert database result sets into flexible collections for later JSON serialization.

Read how Data-Oriented Programming: Reduce software complexity explains JDBC →

Test Driven: Practical TDD and Acceptance TDD for Java Developers

JDBC is Java's standard API for connecting to databases, executing SQL statements, and processing results.

How it is used
Connects Java data-access objects to relational databases through connections, prepared statements, queries, and results.
How deep it goes
Works through a DAO query’s JDBC plumbing and test doubles, highlighting exception handling and resource cleanup.
Examples
Uses a PersonDao last-name query for “Smith,” with mocked JDBC interfaces and returned person rows.
What you can do after
Apply JDBC to implement a DAO query that binds a last name, maps people from results, and closes resources.

Read how Test Driven: Practical TDD and Acceptance TDD for Java Developers explains JDBC →

Also covered in

What to know first

Related concepts

Questions about JDBC

What is JDBC?

JDBC (Java Database Connectivity) is the standard Java API for connecting to databases, executing SQL statements, and processing results.

Which Manning books explain JDBC?

Java Persistence with Spring Data and Hibernate epub, Data-Oriented Programming: Reduce software complexity and Test Driven: Practical TDD and Acceptance TDD for Java Developers.

What should I know before learning JDBC?

Manning books that teach JDBC usually introduce checked exception, JPA, NoSQL database and SQL first.

What is the difference between JDBC and Hibernate?

JDBC (Java Database Connectivity) is the standard Java API for connecting to databases, executing SQL statements, and processing results. Hibernate is a Java object-relational mapping and persistence framework that maps Java objects to relational database data and manages their persistence.

What is JDBC also called?

JDBC is also called Java database connectivity.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.