liveBook · Manning

JdbcTemplate

JdbcTemplate is a Spring Framework class that simplifies JDBC database access by providing higher-level operations and handling recurring resource and result-processing tasks.

How 3 Manning books explain it

Spring Start Here, Second Edition

JdbcTemplate is a Spring API component that simplifies JDBC database access by handling recurring connection, statement, and result-processing code.

How it is used
Uses JdbcTemplate to simplify JDBC access in a Spring persistence layer without requiring another persistence framework.
How deep it goes
Demonstrates insertion and selection in a repository, including parameter values, row mapping, and connection use.
Examples
Uses an online-shop purchase table and REST endpoints to store and retrieve purchases.
What you can do after
Apply it via JdbcTemplate to insert and retrieve relational data from a Spring repository.

Read how Spring Start Here, Second Edition explains JdbcTemplate →

Test Driven: Practical TDD and Acceptance TDD for Java Developers

JdbcTemplate is a Spring Framework class that provides higher-level JDBC operations while managing repetitive data-access and resource-handling tasks.

How it is used
Simplifies DAO data-access code by handling repetitive JDBC plumbing so implementations can focus on persistence logic.
How deep it goes
Explains resource-handling boilerplate, query inputs, and RowMapper responsibilities without detailing JdbcTemplate internals.
Examples
Uses a PersonDao query for employees by last name and a mapper that creates Person objects from result rows.
What you can do after
Apply JdbcTemplate to implement DAO queries while delegating repetitive JDBC resource-handling boilerplate.

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

Spring in Action, Sixth Edition

JdbcTemplate is a Spring API element that simplifies relational database access by providing template methods around JDBC operations.

How it is used
Simplifies relational database access inside Spring repositories by wrapping routine JDBC operations.
How deep it goes
Demonstrates setup, dependency injection, querying, row mapping, optional results, and inserts, but defers external database configuration.
Examples
Uses Ingredient queries, ResultSet row mapping, repository interfaces, SQL inserts, embedded H2, and controller repository injection.
What you can do after
Build a Spring JDBC repository that queries, maps, and inserts relational data with JdbcTemplate.

Read how Spring in Action, Sixth Edition explains JdbcTemplate →

What to know first

Related concepts

Questions about JdbcTemplate

What is JdbcTemplate?

JdbcTemplate is a Spring Framework class that simplifies JDBC database access by providing higher-level operations and handling recurring resource and result-processing tasks.

Which Manning books explain JdbcTemplate?

Spring Start Here, Second Edition, Test Driven: Practical TDD and Acceptance TDD for Java Developers and Spring in Action, Sixth Edition.

What should I know before learning JdbcTemplate?

Manning books that teach JdbcTemplate usually introduce JDBC and SQL first.

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.