Building Database Client Applications Using JDBC 2.0 is a 15-hour course that teaches students how to build database client applications using JDBC 2.0. Students will learn how to apply the JDBC API to connect to relational databases; issue SQL statements and queries; and use transactions, prepared statements, stored procedures and metadata to create and manipulate database information. Students will apply the knowledge they learn in class by building a graphical client application.

• Explain the JDBC API architecture
• Load a JDBC driver and establish a connection to a database
• Manipulate tables and perform queries in a database using JDBC
• Store and execute SQL statements, and use prepared statements and stored procedure
• Extract meta data from a database or a database management system
• Create and use scrollable and updatable result sets

Topics :

Introduction to JDBC

• JDBC - The Basics
• Relational Databases
• Structured Query Language
• System Architecture

Using JDBC Drivers

• JDBC Drivers
• Establishing a Connection

Executing SQL Statements

• The Statement Interface
• Transactions Using SQL Statements

Prepared Statements and Stored Procedures

• Prepared Statements
• Stored Procedures

Metadata

• Introduction to Metadata
• DatabaseMetaData
• ResultSetMetaData

SQLException

• Introduction to SQLException
• try and catch Blocks
• SQLException Methods

Scrollable and Updatable Result Sets

• Scrollable Result Sets
• Updatable Result Sets

Batch Updates

• Introduction to Batch Updates
• Parameterized Batch Updates
• BatchUpdateException