New Features in the JDBC 2.0 API

The java.sql package that is included in the JDK 1.2 release (known as the JDBC 2.0 API) includes several new features not included in the java.sql package that is part of the JDK 1.1 release (referred to as the JDBC 1.0 API). The code samples in the previous sections of this tutorial are written using the JDBC 1.0 API.

With the JDBC 2.0 API, you will be able to do the following:

Scroll forward and backward in a result set or move to a specific row

Make updates to database tables using methods in the Java programming language instead of using SQL commands

Send multiple SQL statements to the database as a unit, or batch

Use the new SQL3 datatypes as column values

Getting Set Up to Use the JDBC 2.0 API

Moving the Cursor in Scrollable Result Sets

Making Updates to Updatable Result Sets

Updating a Result Set Programmatically

Inserting and Deleting Rows Programmatically

Code Sample for Inserting a Row

Deleting a Row

Making Batch Updates

Using SQL3 Datatypes

Standard Extension Features

Contents