Java: Under the Hood™

JDBC - Java Database Connectivity

The goal of JDBC is provide a high-level access to databases without having to write all the low-level code often necessary with ODBC. The advantage of using JDBC is that, like Java, it is platform independent. The code for accessing the database does not depend on where the database server is located. An application that accesses a database can be changed quickly to an applet or moved to another platform.

JDBC plays a major role in creating thin clients for two and three-tier architecture. JDBC is a thin API, and since it is Java, it can be deployed on any platform.

Course Length:

1 day

Audience:

This course is intended for intermediate Java programmers who have experience with databases and SQL.

Overview

• Overview of JDBC: An API for communicating with databases.
• JDBC Drivers: Understanding the various types of drivers available for JDBC.
• Connecting to a Database: Loading the appropriate driver and making the connection.
• Statements: Executing SQL statements.
• Prepared Statements: Executing precompiled SQL statements.
• Results: Working with result sets.