Full Index for Basic Tutorial on using JDBC under Windows

Foilset Search Full Index for Basic foilset

Tutorial on using JDBC under Windows

Given by Nancy McCracken, Mehmet Sen at UC Web Applications Certificate on June 1997. Foils prepared 5 August 97

This talk consists of a set of screen dumps that illustrate the process of setting up an example using JDBC with Microsoft Access on a PC. The JDBC driver is the JDBC-ODBC bridge.

create a simple database in Access
register the database with the ODBC bridge, primarily this is to create an ODBC "name" for the database
write a Java example that uses JDBC to access the database.

Table of Contents for Tutorial on using JDBC under Windows

There are two types of foils -- html and image which are each available in basic and JavaScript enabled "focused" style
(basic:)(focus style:) Denote Foils where Image Critical
(basic:)(focus style:) Denote Foils where HTML is sufficient

JDBC Access Tutorial
2

Tutorial on preparing JDBC with Access
3

Open MS Access Application to make a database.
4

Create a new blank database.
5

Name the database file.
6

Open the tables section to define a new table (like create table).
7

Select "Design View"
8

Give names (labels) and data types to fields (columns).
9

Close the table definition and save.
10

Name the table that you have just defined. This name will now appear in the list of all tables in this file. Double Click to open table.
11

Type in data and exit Access.
12

Select MS Access Driver.
14

Select the name of your database file.
15

Create an ODBC name for your database file and Click o.k.
16

Example Java Program (Java Application)
17

Go to the Command Prompt window. Compile java and run the application.

Full WebWisdom URL and this Foilset Search
This contains all WebWisdom links preceded by those referenced in this foilset

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Jan 8 1998