Database Application Programming with JDBC

Objectives
On successful completion of this course, attendees will be able to:

• describe how data can be stored into relational databases using JDBC (Java Data Base Connectivity)
• explain how data can be retrieved from relational databases using JDBC (Java Data Base Connectivity).

Who Should Attend
Application developers, technical analysts and database administrators who are involved in the development of Java applications that access relational databases.
Prerequisites
Attendees should have experience (at least 3 months) with Java programming programming, and be familiar with basic SQL.
Duration
1 day
Course Code
AJDBC
Contents
Overview of JDBC
JDBC vs ODBC; different types of JDBC drivers; two-tier vs. three-tier vs. n-tier.


Using JDBC: the basics
Connecting to the database; preparing and executing SQL select statements; processing the result: handling multiple rows · exception handling; non-select statements.


More JDBC
Calling stored procedures; scrollable result sets; advanced topics: transactions,· locking,· JNDI: changes with JDBC 2.0.