Java JDBC Programming - 21 Hour Online Class or 3 Day Classroom Workshop

An introduction to JDBC, the standard coding method for Java programs requiring database access, for students familiar with Java and SQL. Covers an overview of JDBC including what it is, where it lives and the basic approach, JDBC versus ODBC, Java.sql, handling SQL in JDBC, and setup; connecting to a database including JDBC Drivers, the DriverManager Class and loading Drivers; JDBC and ODBC URLs, parameters, strings and properties; creating, executing and closing SQL Static Statements; JDBC data types; the basics of Results Sets in JDBC including getting, reading, closing and updating; JDBC exceptions; SQL Prepared Statements; Metadata including what it is, getting and using it and various types; Escape Clauses; SQL Stored Procedures; data management in JDBC; SQL Batches, and Enterprise JDBC.

Online Class Schedule

Request a Class

 		 

Request More Info


   

Buy Course Book
   (5 out of 5)

Topic Summary | Print Version

Class Description:

JDBC has long been the standard way of coding Java programs that need database access. Programs coded using the JDBC API benefit from all the portability and platform independence that has been the hallmark of Java applications. In addition, since JDBC is an open API, it will allow one to write DBMS independent applications without having to learn vendor specific features.

With the advent of the Java 2 Platform and Enterprise Java, JDBC is used in middle-tier Java code (servlets and Enterprise JavaBeans) as well as front-end applications.

This 3-day course will provide a first introduction to JDBC. It includes both instructional and hands-on lab work designed to reinforce the lectured material. Course workshops have been designed for either Oracle, Access or Cloudscape.

Audience: Students interested in developing Java applications or components that must directly access a database. This includes Enterprise JavaBeans that will manage their own persistence.

Prerequisites: Students are expected to be comfortable with the basics of the Java language and to have a fundamental understanding of SQL.

Objectives: This course will teach you to:

  • Use the JDBC API to access databases from a Java application or applet
  • Use and understand the JDBC classes
  • Utilize various interfaces such as Connection, Statement, ResultSet
  • Handle SQL exceptions
  • Perform database updates
  • Handle transactions
  • Understand the difference between Two-Tier and Three-Tier models as it relates to JDBC
  • Recognize different driver implementations by different vendors

Look Inside This Book:

Topic Summary

To Top | Topic Summary