Audience

Programmers wishing to learn the fundamentals of the Java Database Connectivity (JDBC) API and to develop Java applications that can access relational databases produced by various vendors

Prerequisites

Familiarity with previous SmartCourses in the Java 2 SmartCurriculum; a good understanding of programming principles; an understanding of relational database concepts and familiarity with database access technologies such as Open Database Connectivity (ODBC); knowledge of a procedural programming language such as C, Pascal, or Basic; knowledge of object-oriented programming and C++, or equivalent, would be an advantage

Course Aim

To describe the architecture behind JDBC and to outline its programming model

Learning Objectives

Outline the JDBC architecture and understand JDBC drivers and the different JDBC driver types. Understand the application scenarios in which the various driver types are appropriate. Register a JDBC driver and connect to a database using it. Outline how to issue SQL DML statements (SELECT, UPDATE, INSERT, DELETE) against a connected database. Describe how to use a RecordSet object to process the results of a SELECT statement. Explain how to implement a fully scrollable result set. Understand the usage and benefits of prepared and callable statements. Outline how to call and pass parameters to stored procedures. Understand transactional concepts and how to manage transactions using JDBC. Describe the benefits of SQLJ and explain how to use it.

Topics Covered

JDBC architecture and driver concepts - JDBC concepts and features - JDBC architecture - Selecting a JDBC driver Using the JDBC API - The JDBC API - Issuing database requests - Hands-on: Connecting to a database Result sets and metadata - Working with result sets - Accessing metadata Prepared statements and stored procedures - Issuing prepared statements - Hands-on: Coding prepared statements - Calling stored procedures Managing transactions - Transaction properties - Managing transactions - Hands-on: Coding a transactional update - SQLJ

| About Eno.com | Security&Privacy | Contact Us |
Copyright © 1998-2001 E&A Inc.. All rights reserved.