The package java.sql contains numerous classes to allow a Java program to access databases via SQL. These Java Database Connectivity classes (JDBC) make it easy to connect to, and access a database. Using these classes, it is possible to switch your underlying database from one vendor to another with very little code changes, if any.

JDBC can also be used to access specific functionality of a database. In this 3-4 hour section, we will review (or learn) SQL, and understand how to create, update, drop, and query database tables. We'll learn how to process result sets, and how to use stored procedures and prepared statements. We will discuss and use both database and resultset metadata. We will become familiar with the architecture of JDBC, and applications and applets the use JDBC. We will be able to select the appropriate drivers, utilize ODBC if required. We will examine JDBCs Exceptions and Warning mechanism. We'll also examine some interesting database issues, including accessing binary data, storing objects in a database, and discussing transactions.

Objectives
At the end of this section, you will be able to:

• Employ the following classes
• DriverManager
• Connection
• Statement
• ResultSet
• PreparedStatement (compiled statements)
• CallableStatment (stored procedures)
• Create and issue basic SQL statements
• Process metadata from a ResultSet or Connection
• Perform a rollback
• Understand how stored procedures are created and accessed from JDBC.
• Become intimately familiar with how the DriverManager finds and uses drivers to access a database.
• Write an applet that accepts a query string
• Create a database, table, and populate it with data
• Know how to install drivers for a database

Specifications

• Duration (total): 3 - 4 hours
• Duration of Exercises: 1.5 - 2 hours
• Duration of Lecture: 1.5 - 2 hour

Pre-requisites

• Inner Classes
• AWT 1.1 Event Handling
• Basic Java knowledge is assumed, including Exception Handling, full use of all the object-oriented concepts, basic GUI building, be able to create an applet.
• Those without object-oriented and Java experience should consider one of our 5-day Ultimate Java Programming Workshops. These workshops can be customized to include JDBC.

A table of contents of this module is available upon request.

Return to the Custom Order Page.

Copyright ©2007 by Petronio Technology Group, Inc. All rights reserved. Petronio, "Targeted Technology Training", "T3" and "Turning new technologies into your competitive advantage" are trademarks of Petronio Technology Group. All other trademarks are the properties of their respective companies.