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 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 More Details on JDBC Driver Architectures 021 Driver Classification- I 022 Driver Classification - II 023 JDBC Driver API - I 024 JDBC Driver API - II 025 JDBC Driver API - III 026 List of vendors 027 Remote Database Access Current Options 028 mSQl jdbc driver for mSQl database 029 Weblogic jdbcKona driver for Oracle 030 3 tier Remote JDBC driver Architecture 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 2+ Tier Architecture 036 Advantages of JDBC 2+ Tier Architecture 037 Java WebServer with Servlets 038 Programming Java Servlets 039 JDBC 3 Tier Servlet Example 040 JDBC Servlet Example (contd.) 041 JDBC Servlet Example (contd.) 042 JDBC Servlet Example (contd.) 043 JDBC 3 Tier Example using RMI 044 The RMI Example 045 3-Tier JDBC Example Using CORBA 046 CORBA IDL Structure 047 Mapping CORBA IDL to Java - I 048 Mapping CORBA IDL To Java - II 049 An IDL Example - hello.idl 050 Compile An IDL file 051 Example Server - Hello 052 Example Server I - HelloServant 053 Methods in Server Class 054 Example Server II - HelloServer 055 Example Application Client 056 Example Client - Hello 057 JDBC Example using CORBA 058 Using JDBC-ODBC Bridge