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.
JDBCIntroduction to Databases for the Web | Table of Contents
Using JDBC to Connect to a Database
|
