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.
|
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:
|
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