eXtropia: the open web technology company
Technology | Support | Tutorials | Development | About Us | Users | Contact Us
Resources
 ::   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 Application Environment Setup  
Assuming that you have already been working through this tutorial, you will already be set to run a JDBC application. However, before we get into the nitty gritty, let's do a recap.

Installing a Database
The first thing you will need, of course is an actual running database with a table that you can query and modify. In the SQL and CGI sections, we explained how to setup an MSAccess database and create a test table. We will continue to use that table and database here. In particular, we will use the CUSTOMERS table from the Test_db.mdb database that we gave a datasource name of "Access" in our 32-bit ODBC control panel.

Installing the JDK
You will also need to install the JDK. I recommend installing JDK 1.17, but that you code your application to the JDK 1.02 standard. That way your application will be accessible to a wider audience of web browsers, many of who may not have browsers that support JDK 1.1 APIs.

As we said before, most of the JDBC drivers you will need are installed by default so you already have them when you install the JDK. Drivers that are not installed by default can be downloaded by going to www.javasoft.com/products/jdbc/index.html. You will install them in the "lib" directory in the Java files tree. I put mine in "c:\java\sun\jdk1.1.7\lib\sun\jdbc\".

Installing a Local Web Server
Finally, you will need a web server to serve your Java application. In the CGI section, we discussed how you could setup the Sambar Web Server on your local workstation. Using a local web server means that you can do all your development and testing locally and then transfer the final application to the web server on the internet. This section assumes you have already installed Sambar and the rest.

Previous | Next | Table of Contents