Course Description

Using JDBC

Java curriculum; Topic list; Course list; Home page
call or email us to request a detailed course outline

Benefits

Participants will enhance existing Java skills by learning to develop, test, and deploy Java database programs using JDBC. Hands-on exercises reinforce new concepts.

Audience

Experienced Java developers who need to use JDBC to access an SQL database from Java.

Prerequisites

Students must have Java experience and have completed one of the "Java Essentials" courses (or equivalent). SQL  experience is also required.

Recommended Materials

In addition to the student handouts, the students should have access to the following on-line materials:

Java SDK Documentation

• Introduction to JDBC
• Overview of ODBC
• JDBC and SQL
• java.sql package
• Creating statement objects
• Connect to the database, Closing the connection
• Execute queries and return result sets
• Update database data
• Stored procedures
• MetaData
• SQL exception handling
• Database design issues
• Servlets and JDBC

Exercises

There are five machine exercises.