What the JDBC 2.0 API Includes.
Conventions Used in This Book.
Fonts to Indicate Function.
Icons to Indicate New Material.
Special Page Designations in the Index.
SQLException Is Implied in Method Explanations.
Some Method Explanations Are Combined.
Contents of the Book.
Part One.
Part Two.
Suggested Order for Reading Chapters.
Where to Find Information by Topic.
Resources on the Web.
What Is the JDBC API.
What Does JDBC Do?
A Base for Other APIs.
The JDBC API Versus ODBC and UDA.
Two-tier and Three-tier Models.
SQL Conformance.
JDBC Products.
Java Software Framework.
JDBC Driver Types.
Obtaining JDBC Drivers.
Java-relational DBMSs.
Other Products.
Java Overview.
Java Is Portable.
Java Is Object-Oriented.
Java Makes It Easy to Write Correct Code.
Java Includes a Library of Classes and Interfaces.
Java Is Extensible.
Java Is Secure.
Java Performs Well.
Java Scales Well.
Java Is Multithreaded.
Relational Database Overview.
Integrity Rules.
SELECT Statements.
WHERE Clauses.
Joins.
Common SQL Commands.
Result Sets and Cursors.
Transactions.
Stored Procedures.
Metadata.

Getting Started.
Setting Up a Database.
Establishing a Connection.
Loading Drivers.
Making the Connection.
Setting Up Tables.
Creating a Table.
Creating JDBC Statements.
Executing Statements.
Entering Data into a Table.
Getting Data from a Table.
Retrieving Values from Result Sets.
Using the Method next.
Using the getXXX Methods.
Using the Method getString.
Updating Tables.
Milestone: The Basics of JDBC.
Using Prepared Statements.
When to Use a PreparedStatement Object.
Creating a PreparedStatement Object.
Supplying Values for PreparedStatement Parameters.
Using a Loop to Set Values.
Return Values for the Method executeUpdate.
Using Joins.
Using Transactions.
Disabling Auto-commit Mode.
Committing a Transaction.
Using Transactions to Preserve Data Integrity.
When to Roll Back a Transaction.
Stored Procedures.
SQL Statements for Creating a Stored Procedure.
Calling a Stored Procedure Using the JDBC API.
Creating Complete JDBC Applications.
Putting Code in a Class Definition.
Importing Classes to Make Them Visible.
Using the main Method.
Using try and catch Blocks.
Retrieving Exceptions.
Retrieving Warnings.
Running the Sample Applications.
Sample Code.
Sample Code 1 and 2.
Sample Code 3 and 4.
Sample Code 5.
Sample Code 6.
Creating an Applet from an Application.
Writing Applet Code.
Running an Applet.
Sample Code 7 and 8.
Stored Procedures Using SQLJ and the JDBC API.
Creating a Stored Procedure.
Installing a Stored Procedure.
Declaring a Stored Procedure in SQL.

Getting Set Up to Use the JDBC 2.0 API.
Setting Up to Run Code with New Features.
Using Code Examples.
Moving the Cursor in Scrollable Result Sets.
Creating a Scrollable Result Set.
Moving the Cursor Forward and Backward.
Moving the Cursor to a Designated Row.
Getting the Cursor Position.
Making Updates to Updatable Result Sets.
Creating an Updatable Result Set.
Updating a Result Set Programmatically.
Inserting and Deleting Rows Programmatically.
Code Sample for Inserting a Row.
Deleting a Row Programmatically.
Seeing Changes in Result Sets.
Getting the Most Recent Data.
Making Batch Updates.
Using Statement Objects for Batch Updates.
Batch Update Exceptions.
Sample Code for Batch Update.
SQL3 Data Types.
DISTINCT Type.
Using SQL3 Data Types.
Blob, Clob, and Array Objects.
Creating an SQL Structured Type.
Creating a DISTINCT Type.
Using References to Structured Types.
Sample Code for Creating an SQL REF.
Using SQL3 Types as Column Values.
Inserting SQL3 Types into a Table.
Using Custom Mapping.
Implementing SQLData.
Using a Connection's Type Map.
Using Your Own Type Map.
Using Data Sources.
Using a DataSource Object to Get a Connection.
Deploying a Basic DataSource Object.
Deploying Other DataSource Implementations.
Getting and Using a Pooled Connection.
Deployment for Distributed Transactions.
Using Connections for Distributed Transactions.

Getting Information about Result Set Columns.
Using the Method getColumnCount.
Sample Code 9.
Using Other ResultSetMetaData Methods.
Getting Column Type Information.
Sample Code 10 and 11.
Sample Code 12.
Getting Other Information.
Using New JDBC 2.0 ResultSetMetaData Features.
Getting Other Information about a Result Set.
Getting Information about a Database or Database System.
Categories of DatabaseMetaData Methods.
Methods that Return a String.
Methods that Return an int.
Methods that Return a boolean.
Methods that Return a ResultSet Object.
Sample Code 13.
Getting Information about DBMS Data Types.
Sample Code 14.
Getting Information about Primary and Foreign Keys.
Sample Code 15.
Sample Code 16.
New JDBC 2.0 Core Methods.
Generic Applications.
Sample Code 17 and 18.
Sample Code 19.

Types and Uses of Rowsets.
Using a Rowset.
Creating a Rowset and Setting Properties.
Rowsets and Event Notification.
Obtaining a Scroll