Chapter 13. JDBC

Sun says that JDBC is not an acronym for anything, and www.sun.com says it stands for Java Database Connectivity. Go figure. Anyway, JDBC is the de facto standard API for Java programs and applets. In this chapter, we won't try to compete with the giant reference books on the subject[1]—remember, we said in Chapter 1, “Facilis Descensus Averni,” that we assume you're already familiar with (among other things) programming with an SQL API such as JDBC. Our goal is more specific: to suggest improvements in Java applications written for SQL DBMSs.

In simple terms, a JDBC driver makes it possible to do three things:

  • Establish a connection with a data source

  • Send queries and data changes to the data source

  • Process the results

Listing 13-1 ...

Get SQL Performance Tuning now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.