Find this at http://www.npac.syr.edu/users/gcf/uccjdbcaccess97/

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


001 JDBC Access Tutorial
002 Tutorial on preparing JDBC with Access
003 Open MS Access Application to make a database.
004 Create a new blank database.
005 Name the database file.
006 Open the tables section to define a new table (like create table).
007 Select "Design View"
008 Give names (labels) and data types to fields (columns).
009 Close the table definition and save.
010 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.
011 Type in data and exit Access.
012 Register your database with ODBC.
013 Select MS Access Driver.
014 Select the name of your database file.
015 Create an ODBC name for your database file and Click o.k.
016 Example Java Program (Java Application)
017 Go to the Command Prompt window.  Compile java and run the 
    application.


© 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