| Contents

# 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