eXtropia: the open web technology company
Technology | Support | Tutorials | Development | About Us | Users | Contact Us
 ::   Tutorials
 ::   Presentations
Perl & CGI tutorials
 ::   Intro to Perl/CGI and HTML Forms
 ::   Intro to Windows Perl
 ::   Intro to Perl 5
 ::   Intro to Perl
 ::   Intro to Perl Taint mode
 ::   Sherlock Holmes and the Case of the Broken CGI Script
 ::   Writing COM Components in Perl

Java tutorials
 ::   Intro to Java
 ::   Cross Browser Java

Misc technical tutorials
 ::   Intro to The Web Application Development Environment
 ::   Introduction to XML
 ::   Intro to Web Design
 ::   Intro to Web Security
 ::   Databases for Web Developers
 ::   UNIX for Web Developers
 ::   Intro to Adobe Photoshop
 ::   Web Programming 101
 ::   Introduction to Microsoft DNA

Misc non-technical tutorials
 ::   Misc Technopreneurship Docs
 ::   What is a Webmaster?
 ::   What is the open source business model?
 ::   Technical writing
 ::   Small and mid-sized businesses on the Web

Offsite tutorials
 ::   ISAPI Perl Primer
 ::   Serving up web server basics
 ::   Introduction to Java (Parts 1 and 2) in Slovak


Introduction to Databases for Web Developers
JDBC - Java Database Connectivity  
To tell you the truth, if I were to recommend a backend architecture for a web-based database interface, I would probably recommend the CGI architecture we just discussed.

In my opinion and experience, CGI is still the most stable, cross-platform, easy to maintain method for managing such a mission critical application. Alternative technologies like CORBA, Java, Active-X, and Cold Fusion are too difficult, too proprietary, or too buggy.

Nevertheless, no discussion of Web Databases would be complete without a discussion of JDBC.

What is JDBC
JDBC is Java's version of the DBI module in Perl 5. It provides a standard interface between you and the database server.

As with DBI, JDBC provides a standard API which you can use regardless of what Database is being used in the backend. Also, just as DBI is supported by a host of DBD (Database Dependent) modules to connect DBI to the multitude of proprietary systems, JDBC is supported by a large set of JDBC drivers.

[JDBC Architecture]

Fortunately, as in the case of DBI, the JDBC interface and most of the JDBC drivers you will need are installed by default so you already have them if you have installed the JDK. Drivers that are not installed by default can be downloaded by going to www.javasoft.com/products/jdbc/index.html.

This tutorial assumes that you are already familiar with Java programming. If you are not, you may want to read Intro to Web Programming.

Limitations of JDBC
Of course, if you have been keeping up with the news, you will know that Java is still somewhat buggy and slow. However, the language promises to be with us as a basic tool for many years to come.

And though it still is a bit painful to use Java in an internet setting in which one cannot control the browsers, operating systems, or hardware specs of the users, it can still be worthwhile for you to learn and play with it.

At very least, JDBC is extremely useful for server-side application development in which you can control the environment to a much greater degree.

So to conclude this tutorial on web databases, we will take a walk through JDBC technology and present an actual Java GUI that uses JDBC to connect to the datasource we installed for the CGI section.

Previous | Next | Table of Contents