JDBC Pocket Reference

JDBC--the Java Database Connectivity specification--is a complex set of application programming interfaces (APIs) that developers need to understand if they want their Java applications to work with databases. JDBC is so complex that even the most experienced developers need to refresh their memories from time to time on specific methods and details. But, practically speaking, who wants to stop and thumb through a weighty tutorial volume each time a question arises? The answer is the JDBC Pocket Reference, a data-packed quick reference that is both a time-saver and a lifesaver.

The JDBC Pocket Reference offers quick look-ups for all methods of the standard JDBC classes. These include concise reviews of the procedures for common JDBC tasks such as connecting to a database, executing stored procedures, executing DDL and the like. You'll find documentation of the connect string formats for the most common databases, including Oracle, SQL-Server, and PostgreSQL. You'll even find information on working with large objects, and on using SQL99 user defined datatypes to work with object-relational data. Searching for this sort of material through large tutorials is frustrating and a waste of time, but this pocket-sized book is easy to take anywhere and makes finding the information you need a snap.

O'Reilly's Pocket References have become a favorite among developers everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point and need to get to the answer quickly, the new JDBC Pocket Reference is the book you'll want close at hand.

Table of Contents

Introduction  

Import Statements  

JDBC Drivers  

      Driver Types  

      Database URLs  

Establishing a Connection  

      Using DriverManager  

      Using JNDI  

Examining Database MetaData  

Executing Dynamic SQL  

      Executing DDL  

      Executing INSERT, UPDATE, or DELETE Statements  

      Executing SELECT Statements  

Executing Precompiled SQL  

Executing a Stored Procedure  

Retrieving Query Results  

      Navigating a Result Set  

      Accessing Column Values  

      Inserting, Updating, and Deleting Rows in a ResultSet  

      Dynamically Determining Result Set Characteristics  

SQL/Java Data Type Mapping  

Handling NULL Values  

      Detecting NULL Values with wasNull(  )  

      Detecting NULL Values with BigDecimal  

      Setting a Column to a NULL Value  

Batching Inserts and Updates  

Working with Large Objects  

      Inserting a BLOB  

      Retrieving a BLOB  

User-Defined Data Types  

      Creating a Java Class for a UDT  

      Updating a Type Map  

      Inserting a UDT  

      Selecting a UDT  

Row Sets  

Escape Syntax  

Transaction Management  

The JDBC API