Download the JDK
Search the Tutorials
Hide the TOC
Trail: JDBC(TM) Database Access
Lesson: JDBC Basics
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
Home Page > JDBC(TM) Database Access > JDBC Basics
Milestone: The Basics of JDBC

> You have just reached a milestone.

> You have learned the basics of the JDBC™ API. You learned how to create a table, insert values into it, query the table, retrieve results, and update the table. These are the nuts and bolts of using a database, and you can now use them in a program written in the Java™ programming language using the JDBC 3.0 API. We have used only very simple queries in our examples so far, but as long as the driver and DBMS support them, you can send very complicated SQL queries using only the basic JDBC API we have covered so far.

> The rest of this lessons looks at how to use features that are a little more advanced: stored procedures, and transactions. It also illustrates warnings and exceptions. The final part of this lesson is sample code that you can run yourself.

Previous page: Updating Tables
Next page: Using Prepared Statements