Find this at http://www.npac.syr.edu/users/gcf/cps616jdbcfeb99/

Overview of JDBC: Java Database Connectivity

Given by Nancy McCracken,(Sangetta Aggarwal, Meryem Ispirli, Udayan Parvate, Tom Pulikal, Chao-Wei Ou) at Basic Information Track Computational Science Course CPS616 on Spring Semester 1999. Foils prepared May 19 99

JDBC provides a set of classes for Java with a standard SQL database access interface.
Provides an API for database "drivers" to make actual connections and transactions to database products.
  • includes JDBC-ODBC bridge to standard ODBC drivers, a common interface for relational databases from C
JDBC is "low-level" interface, calling SQL commands directly but is meant to be a base for higher-level interfaces.
This talk has three sections:
  • Using JDBC in Java, with a 2 tier example
  • JDBC drivers
  • 3 tier examples


Table of Contents for Overview of JDBC: Java Database Connectivity


001 JDBC  Java Database Connectivity
002 JDBC Main Features
003 Traditional Web/RDBMS access Compared to using Java
004 JDBC Software Architecture
005 Driver Access Architecture
006 JDBC API is Package java.sql
007 Driver Manager
008 Driver class creates Connection
009 SQL Statements
010 Statement Class
011 ResultSet class
012 Data from ResultSets
013 Result Sets can be Scrollable
014 PreparedStatement class
015 CallableStatement class
016 Generalized example of getting results
017 A typical JDBC API usage sequence
018 Standard Extension Features coming in 2.0
019 Simple JDBC 2 Tier Applet - An Example
020 JDBC 2 Tier Applet
021 JDBC 2 Tier Applet
022 More Details on JDBC Driver Architectures
023 Driver Classification- I
024 Driver Classification  - II
025 JDBC Driver API - I
026 JDBC Driver API - II
027 JDBC Driver API - III
028 List of vendors
029 Remote Database Access Current Options
030 mSQl jdbc driver for mSQl database
031 Weblogic jdbcKona driver for Oracle
032 3 tier Remote JDBC driver Architecture
033 PPT Slide
034 Remote jdbc Driver  Client-side Description
035 Remote jdbc Driver  Server-side Description - I
036 Remote jdbc Driver  Server-side Description - II
037 JDBC 2+ Tier Architecture
038 Advantages of JDBC 2+ Tier Architecture
039 Java WebServer with Servlets
040 Programming Java Servlets
041 JDBC 3 Tier Servlet Example
042 JDBC Servlet Example (contd.)
043 JDBC Servlet Example (contd.)
044 JDBC Servlet Example (contd.)
045 JDBC 3 Tier Example using RMI
046 The RMI Example
047 3-Tier JDBC Example Using CORBA
048 JDBC Example using CORBA
049 Using JDBC-ODBC Bridge
050 Accessing a Desktop Database


© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Mon Jul 5 1999