Using JDBC

Course Number:  545-JK
Recommended Duration:  2 days

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

Course Overview
Java programmers learn to use JDBC to work with relational database data in Java programs.  There are eight machine exercises.  Exercises use text editor, Sun Java J2SE JDK and the locally available database. IDEs such as Eclipse, WSAD, JDeveloper, JBuilder, etc... may be used upon request.

Course appropriate for Java 5.0 (Java 1.5).  Course covers Java 2 (aka. Java 1.4) with some new Java 5.0 features being introduced.  Most topics and examples also apply to Java 1.1, Java 1.2, Java 1.3, and Java 1.4.

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

Prerequisites
Students must have Java experience or have completed "Java Client-Side Programming I", "Java Server-Side Programming I" or equivalent.  Knowledge of SQL is very useful, but, not required.

Topics

• Introduction to JDBC

• JDBC and SQL

• java.sql package

• Connect to the database, Closing the connection

• Connection pools

• Choosing the correct driver

• Connection property files

• Creating statement objects

• Execute queries and process result sets

• Manipulate result set data

• Using PreparedStatement

• Update database data

• Insert/Delete database rows

• Batched updates

• Using Stored procedures

• Using CallableStatement

• SQL exception handling

• Database design issues

• Servlets and JDBC

• Performance issues

• Local database vendor-specific JDBC libraries

• Overview of SQLJ
  (if applicable)

• Connect to the database, Closing the connection

• Servlets/JSPs and JDBC