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.

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.

Getting Started

Setting Up a Database

Establishing a Connection

Setting Up Tables

Retrieving Values from Result Sets

Updating Tables

Milestone: The Basics of JDBC

Using Prepared Statements

Using Joins

Using Transactions

Stored Procedures

SQL Statements for Creating a Stored Procedure

Creating Complete JDBC Applications

Running the Sample Applications

Creating an Applet from an Application

Contents