The JavaTM Tutorial

| Start of Tutorial > Start of Trail | Search Feedback Form

Trail: JDBC(TM) Database Access

## Lesson: 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

| Start of Tutorial > Start of Trail | Search Feedback Form