Download the JDK
Search the Tutorials
Hide the TOC
JDBC Basics
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
Trail: JDBC(TM) Database Access
Lesson: 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. This lesson sets up a basic development environment, including Java™ SE 6 and NetBeans™.
> - Setting Up a Database installs a testing database accessable through the NetBeans IDE, and installs its database driver.
> - Establishing a Connection connects you to your database.
> - Setting up Tables, Retrieving Values from Result Sets and Updating Tables all develop the process of configuring your database, sending queries and retrieving data from your database.

> The next lesson discusses how to use joins, row sets, transactions and stored procedures.

> The final lesson describes how to create and run a complete JDBC application and provides some code examples for study.

Previous page: Previous Lesson
Next page: Getting Started