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

Overview of JDBC and its use with Microsoft Access

Given by Nancy McCracken(Sangetta Aggarwal, Udayan Parvate, Tom Pulikal) at UC Web Applications Certificate on June 26 97. Foils prepared 23 June 1997

JDBC provides a set of classes for Java with a standard SQL database access interface.
  • Goal is uniform access to a wide range of relational databases
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
  • JDBC drivers, including how to use examples at NPAC
  • MicroSoft Access and its JDBC interface


Table of Contents for Overview of JDBC and its use with Microsoft Access


001 JDBC  Java - Database Connectivity Overview for CPS616 
    Technologies of Information Age Summer 97
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 PreparedStatement class
014 CallableStatement class
015 Generalized example of getting results
016 A typical JDBC API usage sequence
017 Simple JDBC 2 Tier Applet - An Example
018 JDBC 2 Tier Applet
019 JDBC 2 Tier Applet
020 DBDiagram Example
021 More Details on JDBC Architectures
022 Driver Classification- I
023 Driver Classification  - II
024 JDBC Driver API - I
025 JDBC Driver API - II
026 JDBC Driver API - III
027 Remote Database Access  Current Options
028 mSQl jdbc driver for mSQl database
029 Weblogic jdbcKona driver for Oracle
030 Remote jdbc-driver features
031 PPT Slide
032 Remote jdbc Driver  Client-side Description
033 Remote jdbc Driver  Server-side Description - I
034 Remote jdbc Driver  Server-side Description - II
035 JDBC 3 Tier Example
036 JDBC 3 Tier Example (contd.)
037 Java Servlets
038 Java Servlets (contd.)
039 Java Servlets (contd.)
040 JDBC Servlet Example
041 JDBC Servlet Example (contd.)
042 JDBC Servlet Example (contd.)
043 JDBC Servlet Example (contd.)
044 List of vendors
045 Practical Options at NPAC
046 Practical Options at NPAC contd.
047 Example - Using Imaginary's mSQL Driver
048 Example - using Imaginary's mSQL Driver -II
049 Example - Using Weblogic's Oracle Driver
050 Example - Using Weblogic's Oracle Driver -II
051 Example - Using Weblogic's Oracle Driver -III
052 Example - Using JDBC-ODBC Bridge - I
053 Example - Using JDBC-ODBC Bridge - II
054 Example - Using JDBC-ODBC  Bridge -III
055 Example - usingJDBC-ODBC Bridge -IV
056 Example - usingJDBC-ODBC Bridge (contd.)
057 Microsoft Access
058 MS Access - Features (cont'd)
059 Cool Features of Access - I
060 Cool Features of Access - II
061 The Access Event Model
062 VBA class modules
063 Database Design - I
064 Database Design - II
065 Database Design - III
066 Access SQL - I
067 Access SQL - II
068 Access SQL - III
069 Access SQL - IV
070 Access Controls
071 Access Forms and Reports
072 Developing Multiuser Applications
073 Security in Access
074 Client-Server Applications
075 Web-Enabled Applications -I
076 Web-Enabled Applications -II
077 Web-Enabled Applications -III
078 Sample code for ASP files - I
079 Sample code for ASP files - II
080 Access as an Automation Client-I
081 Access as an Automation Client-II
082 Access as an Automation Client-III


© 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 Thu Jan 8 1998