Contents |
Thejava.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 thejava.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 |