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.