JDBC Basics
In this lesson you will learn the basics of the JDBC API. We start by giving you set up
instructions in Getting Started , Setting Up a Database , and Establishing a Connection .
The next sections discuss how to create and update tables, use joins, transactions and
stored procedures. The final sections give instructions on how to complete your JDBC
application and how to convert it to an applet.
Note: Most JDBC drivers available at the time of this printing are for JDBC 1.0.
More drivers will become available for JDBC 2.0 as it gains wider acceptance.
Getting Set Up to Use the JDBC 2.0 API
If you want to run code that employs any of the JDBC 2.0 features, you will need to do
the following:
The JDBC 2.0 API enables you 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 a batch.
Buy It now
In this lesson you will learn the basics of the JDBC API. We start by giving you set up
instructions in Getting Started , Setting Up a Database , and Establishing a Connection .
The next sections discuss how to create and update tables, use joins, transactions and
stored procedures. The final sections give instructions on how to complete your JDBC
application and how to convert it to an applet.
Note: Most JDBC drivers available at the time of this printing are for JDBC 1.0.
More drivers will become available for JDBC 2.0 as it gains wider acceptance.
Getting Set Up to Use the JDBC 2.0 API
If you want to run code that employs any of the JDBC 2.0 features, you will need to do
the following:
- Download JDK 1.2, following the download instructions
- Install a JDBC driver that implements the JDBC 2.0 features used in the code
- Access a DBMS that implements the JDBC 2.0 features used in the code
If your driver does not bundle the JDBC 2.0 Standard Extension API (the javax.sql package,
The JDBC 2.0 API enables you 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 a batch.
Buy It now
0 comments:
Post a Comment