Full HTML for

Basic foilset Tutorial on using JDBC under Windows

Given by Nancy McCracken, Mehmet Sen at ARL Database Tutorial on February 98. Foils prepared 7 October 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 ARL DoD PET Program Database Tutorial Fall 97
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 7 October 97

Foil 1 JDBC Access Tutorial ARL DoD PET Program Database Tutorial Fall 97

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
Nancy McCracken
Assisted by Mehmet Sen
http://www.npac.syr.edu/projects/tutorials/JDBC
HTML version of Basic Foils prepared 7 October 97

Foil 2 Tutorial on preparing JDBC with Access

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
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 7 October 97

Foil 3 Open MS Access Application to make a database.

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 97

Foil 4 Create a new blank database.

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 97

Foil 5 Name the database file.

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 97

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

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 97

Foil 7 Select "Design View"

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 97

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

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 97

Foil 9 Close the table definition and save.

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 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 ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 97

Foil 11 Type in data and exit Access.

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 97

Foil 12 Register your database with ODBC.

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 97

Foil 13 Select MS Access Driver.

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 97

Foil 14 Select the name of your database file.

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 97

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

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
HTML version of Basic Foils prepared 7 October 97

Foil 16 Example Java Program (Java Application)

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
The URL has form jdbc:odbc:odbcdbname.
HTML version of Basic Foils prepared 7 October 97

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

From Tutorial on using JDBC under Windows ARL Database Tutorial -- February 98. *
Full HTML Index
© on Mon Oct 13 1997