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.