Foilset Search Full Index for Basic foilset

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

There are two types of foils -- html and image which are each available in basic and JavaScript enabled "focused" style
(basic:)(focus style:) Denote Foils where Image Critical
(basic:)(focus style:) Denote Foils where Image has important information
(basic:)(focus style:) Denote Foils where HTML is sufficient
denotes presence of Additional linked information which is greyed out if missing
1 JDBC Java Database Connectivity
Link to Sun web page on JDBC 2 JDBC Main Features
3 Traditional Web/RDBMS access Compared to using Java
4 JDBC Software Architecture
5 Driver Access Architecture
Suns API for JDBC 6 JDBC API is Package java.sql
7 Driver Manager
8 Driver class creates Connection
9 SQL Statements
10 Statement Class
11 ResultSet class
JDBC use of SQL types for Foil 12 12 Data from ResultSets
13 Result Sets can be Scrollable
14 PreparedStatement class
15 CallableStatement class
16 Generalized example of getting results
17 A typical JDBC API usage sequence
18 Standard Extension Features coming in 2.0
2 tier person database example for Foil 19 19 Simple JDBC 2 Tier Applet - An Example
20 JDBC 2 Tier Applet
21 JDBC 2 Tier Applet
22 More Details on JDBC Driver Architectures
23 Driver Classification- I
24 Driver Classification - II
25 JDBC Driver API - I
26 JDBC Driver API - II
27 JDBC Driver API - III
28 List of vendors
29 Remote Database Access Current Options
30 mSQl jdbc driver for mSQl database
31 Weblogic jdbcKona driver for Oracle
32 3 tier Remote JDBC driver Architecture
33 PPT Slide
34 Remote jdbc Driver Client-side Description
35 Remote jdbc Driver Server-side Description - I
36 Remote jdbc Driver Server-side Description - II
37 JDBC 2+ Tier Architecture
38 Advantages of JDBC 2+ Tier Architecture
39 Java WebServer with Servlets
40 Programming Java Servlets
41 JDBC 3 Tier Servlet Example
42 JDBC Servlet Example (contd.)
43 JDBC Servlet Example (contd.)
Suns servlet database example for Foil 44 44 JDBC Servlet Example (contd.)
45 JDBC 3 Tier Example using RMI
3 tier person database example using RMI for Foil 46 46 The RMI Example
47 3-Tier JDBC Example Using CORBA
3 tier person database example using CORBA IDL for Foil 48 48 JDBC Example using CORBA
49 Using JDBC-ODBC Bridge
50 Accessing a Desktop Database
Full WebWisdom URL and this Foilset Search
This contains all WebWisdom links preceded by those referenced in this foilset
© 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