JDBC
(Java Database Connectivity)
(Free Web Tutorials)

by Michael Thomas

(Under Construction)

JDBC (Java Database Connectivity) is a Java API for connecting to a DB via a vendor's driver, executing SQL statements and accessing the results set.

( Home Page: Free Web Tutorials on Java & Web Technologies )

Free Download

• Download - a zip file of the website pertaining to this topic (all content, tutorials, examples, etc...).  Great resource!!!  Work offline!!!

Free Web Tutorials

• YYY First Steps - Hello World Tutorial  - create your first YYY etc...

• Topics for future YYY Tutorials:
  etc...

YYY's Resources

• YYY Home Page - YYY's home page for downloads, docs, etc...

Book Resources

• etc ...

Drivers

• Sun's site
  • http://industry.java.sun.com/products/jdbc/drivers - JDBC drivers.

Tutorials

• Sun's site.
  • http://java.sun.com/docs/books/tutorial/jdbc/index.html - Tutorial from Sun.

My Examples

• Download a zip file with examples using a MS Access database.  JDK 1.1 and JDK 1.2 examples included.  You will need to create an ODBC connection to the .MDB called: JDBCDisplayQuery_access2000.  Then the Java Applications should run fine.

Databases

• Databases
  • MySQL - http://www.mysql.com/ - open-source.
  • PostgreSQL - http://www.postgresql.org - open-source database (Object-Relational DBMS).
  • InstantDB - http://www.instantdb.co.uk/ - - InstantDB is an all Java, Relational Database Management System (RDBMS).
    Quote from site, "It is small, efficient, easy to install, and comes with lots of examples to help get the novice developer started. InstantDB is accessed via its own JDBC™ driver. "
  • OpenBase - http://store.openbase.com
• Digital Certificates
  • Versign - http://www.verisign.com
  • Global Sign - http://www.globalsign.net/
  • Thawte Digital Certificate Services - http://www.thawte.com/
• Applets
  • http://www.jars.com/classes/jresout.cgi?resource=7920
• MAC & Databases (Dated 4/18/01 - Just some information that may be incorrect!)
  • DB's for MAC OS X
    • Postgres 
    • MySQL
    • OpenBase 
  • DB's for MAC Classic (OS below X).
    • InstantDB 
  • http://www.pepsan.com/javamac/index.html - Click on the JDBC link.
    • JDBC & Database server.  Download a MAC Classic version and a MAC X version.  Connects to InstantDB.
    • Stuffit Expander - http://www.alladinsystems.com/expander/index.html - Unzip for Mac & Windows type zip files. 30 day trial version.
  • http:/developer.apple.com/java/download.html - JRE & SDK ???.  (Notes from a friend: There is the jre (MRJ 2.2.4) and sdk (go with v2.2) )
  • http://www.pepsan.com/javamac/  - Java & MAC
  • http://www.ing.unitn.it/~luttero/javaonMac/index.html - Java & Mac.
  • Compiling on the Mac
    • Note from a friend:  If the .jar or .zip class files need to be referenced externally (say by a browser applet), you should store them (or aliases that point to them) in the MRJClasses folder in the MRJ Libraries folder in the Extensions folder in the System folder. This forces them into the class path.

Other References

• Notes from a friend
  • Here are a couple of developerWorks resources that may help you handle the JDBC connection and I/O interface:
    http://www-106.ibm.com/developerworks/java/library/j-jdbcwrap/index.html is a simplified JDBC Java wrapper.
    http://www-106.ibm.com/developerworks/library/j-webdata/?n-j-9271 illustrates how to integrate JDBC with JSPs using Tag Libraries. It's MySQL-centric, but should be a pretty good guide.