Audience

Java application developers

Prerequisites

The previous courses in the Java curriculum; some knowledge of SQL would be useful

Course Aim

To describe the JDBC architecture, how database connections are controlled using drivers, how databases are queried, and other techniques associated with JDBC

Learning Objectives

Define JDBC and explain how it implements the 'write once, run anywhere' approach to development. Explain the structure and workings of two-tier and three-tier JDBC architectures. Discuss the use of JDBC drivers and DriveManager class. Outline the purpose of a middle tier in the JDBC database access model. Explain how to establish a connection with a database. Describe the methods and objects involved when passing SQL statements to a database. Explain how the ResultSet object is processed. Create an applet to query a database. Describe how parameters are passed in JDBC. Discuss the way transactions operate in JDBC. Explain how Java's multithreading capabilities impact upon JDBC.

Topics Covered

Overview of JDBC - Introduction to JDBC - Two-tier JDBC architecture - Three-tier JDBC architecture JDBC configuration - JDBC Drivers - The DriverManager class - Creating a middle tier Connections - Establishing a connection - Hands-on: Passing connection arguments - Using threads to monitor connections Querying the database - Sending SQL statements - Hands-on: Passing SQL parameters - Handling transactions - Processing ResultSet objects - Hands-on: Creating a query applet

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