Full HTML 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
Outside Index Summary of Material

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 full HTML of Tutorial on using JDBC under Windows

 Denote Foils where Image Critical
Denote Foils where HTML is sufficient
1 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 Register your database with ODBC.
13 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.

Outside Index Summary of Material

HTML version of Basic Foils prepared 5 August 97

Foil 1 JDBC Access Tutorial

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
Nancy McCracken
Assisted by Mehmet Sen
http://www.npac.syr.edu/projects/tutorials/JDBC
HTML version of Basic Foils prepared 5 August 97

Foil 2 Tutorial on preparing JDBC with Access

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
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.
HTML version of Basic Foils prepared 5 August 97

Foil 3 Open MS Access Application to make a database.

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

Foil 4 Create a new blank database.

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

Foil 5 Name the database file.

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

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

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

Foil 7 Select "Design View"

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

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

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

Foil 9 Close the table definition and save.

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

Foil 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.

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

Foil 11 Type in data and exit Access.

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

Foil 12 Register your database with ODBC.

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

Foil 13 Select MS Access Driver.

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

Foil 14 Select the name of your database file.

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

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

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
HTML version of Basic Foils prepared 5 August 97

Foil 16 Example Java Program (Java Application)

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
The URL has form jdbc:odbc:odbcdbname.
HTML version of Basic Foils prepared 5 August 97

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

From Tutorial on using JDBC under Windows UC Web Applications Certificate -- June 1997. *
Full HTML Index
© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

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