Table of Contents
JDBC including Access Java - Database Connectivity Overview for ARL DoD PET Program Database Tutorial Fall 97
JDBC Main Features
Traditional Web/RDBMS access Compared to using Java
JDBC Software Architecture
Driver Access Architecture
JDBC API is Package java.sql
Driver Manager
Driver class creates Connection
SQL Statements
Statement Class
ResultSet class
Data from ResultSets
PreparedStatement class
CallableStatement class
Generalized example of getting results
A typical JDBC API usage sequence
Simple JDBC 2 Tier Applet - An Example
JDBC 2 Tier Applet
JDBC 2 Tier Applet
DBDiagram Example
More Details on JDBC Architectures
Driver Classification- I
Driver Classification - II
JDBC Driver API - I
JDBC Driver API - II
JDBC Driver API - III
Remote Database Access Current Options
mSQl jdbc driver for mSQl database
Weblogic jdbcKona driver for Oracle
Remote jdbc-driver features
PPT Slide
Remote jdbc Driver Client-side Description
Remote jdbc Driver Server-side Description - I
Remote jdbc Driver Server-side Description - II
JDBC 3 Tier Example
JDBC 3 Tier Example (contd.)
Java Servlets
Java Servlets (contd.)
Java Servlets (contd.)
JDBC Servlet Example
JDBC Servlet Example (contd.)
JDBC Servlet Example (contd.)
JDBC Servlet Example (contd.)
List of vendors
Practical Options at NPAC
Practical Options at NPAC contd.
Example - Using Imaginary’s mSQL Driver
Example - using Imaginary’s mSQL Driver -II
Example - Using Weblogic’s Oracle Driver
Example - Using Weblogic’s Oracle Driver -II
Example - Using Weblogic’s Oracle Driver -III
Example - Using JDBC-ODBC Bridge - I
Example - Using JDBC-ODBC Bridge - II
Example - Using JDBC-ODBC Bridge -III
Example - usingJDBC-ODBC Bridge -IV
Example - usingJDBC-ODBC Bridge (contd.)
Microsoft Access
MS Access - Features (cont’d)
Cool Features of Access - I
Cool Features of Access - II
The Access Event Model
VBA class modules
Database Design - I
Database Design - II
Database Design - III
Access SQL - I
Access SQL - II
Access SQL - III
Access SQL - IV
Access Controls
Access Forms and Reports
Developing Multiuser Applications
Security in Access
Client-Server Applications
Web-Enabled Applications -I
Web-Enabled Applications -II
Web-Enabled Applications -III
Sample code for ASP files - I
Sample code for ASP files - II
Access as an Automation Client-I
Access as an Automation Client-II
Access as an Automation Client-III
|