Chapter 17. Accessing Databases with JDBC

Topics in This Chapter

  • Connecting to databases: the seven basic steps

  • Simplifying JDBC usage: some utilities

  • Using precompiled (parameterized) queries

  • Creating and executing stored procedures

  • Updating data through transactions

  • Using JDO and other object-to-relational mappings

JDBC provides a standard library for accessing relational databases. By using the JDBC API, you can access a wide variety of SQL databases with exactly the same Java syntax. It is important to note that although the JDBC API standardizes the approach for connecting to databases, the syntax for sending queries and committing transactions, and the data structure representing the result, JDBC does not attempt to standardize the SQL syntax. ...

Get Core Servlets and JavaServer Pages™: Volume 1: Core Technologies, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.