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.
This lesson covers the JDBC 1.0 API, which is included in JDK tm 1.1, and note where procedures have changed in JDBC 2.0, which is included in JDK 1.2. For coverage of JDBC 2.0 and more advanced features, see the next lesson, New Features in the JDBC 2.0 API.
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.
Setting Up a Database
Establishing a Connection
Setting Up Tables
Retrieving Values from Result Sets
Milestone: The Basics of JDBC
Using Prepared Statements
SQL Statements for Creating a Stored Procedure
Creating Complete JDBC Applications
Running the Sample Applications
Creating an Applet from an Application