Java Enterprise Connectivity: Java Database Connectivity (JDBC)

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

Target 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

Expected Duration
5 Hours

Objectives:

Java Enterprise Connectivity: Java Database Connectivity (JDBC)

  • To describe Java Database Connectivity (JDBC) concepts, architecture, and driver types
  • To explain how the JDBC API is used to issue database requests
  • To explain how the JDBC(API) is used to process result sets and access metadata
  • To explain how to create prepared statements and call stored procedures
  • To explain how to use SQLJ to manage SQL transactions from Java


    • Course Number: JAV07SE