http://java.sun.com, version 1.1 incudes the java.sql.* and sun.jdbc.odbc.* drivers.
Install them under the d:/java directory.
- win95; 32-bits odbc drivers. Are delivered with the MS-Office CD. Run setup on CD and goto Add/Remove components. Select Converters, Filters, and Data Access, and select all. Press Continue.
- jdbc-odbc brigde; Intersolv has made an jdbc-odbc brigde for general use with ms-access. The bridge consists of two .dll's jdbcodbc.dll, jdbcodbc_g.dll and Netscape_jdbcodbc.dll. After downloading proceed with step 3.
Consists of two packages.
- Copy the JdbcOdbc.zip file into your Java home directory (i.e. c:\java). This file contains all of the JDBC class files for the driver as well as the operating system dependent libraries and sample source code.
- Unzip the JdbcOdbc.zip file, using the directory names stored in the ZIP file (be sure to use an unzip program that preserves long file names, such as WinZIP).
- Copy the JdbcOdbc.dll library (in sun\jdbc\odbc\win32) to a directory on your library path (i.e. c:\windows\system).
- If you will be using the JDBC-ODBC Bridge with Netscape 3.0, copy the Netscape_JdbcOdbc.dll library (in sun\jdbc\odbc\win32) in the program\java\bin subdirectory under the Netscape 3.0 home directory. Note that if you are using the JDBC-ODBC Bridge with Netscape 3.0, the Java home directory is program\java\classes under your Netscape 3.0 home directory. Applets must be loaded from your CLASSPATH or from the program\java\classes directory in order to use the JDBC-ODBC Bridge.
This process creates the following subdirectory structure beneath your Java home directory:
Directory Contains
--------- ----------------------------------------------
java\sql The JDBC API classes provided by JavaSoft
sun\jdbc\odbc The JDBC-ODBC Bridge classes, libraries, and
sample source code
- In windows 95 goto your control panel and select the 32-bits ODBC Driver.
Now add System DSN (Data Source Name) by pressing System DSN and Add. Select Microsoft Access Driver (*.mbd). Fill out the form; Data Source Name, Description and press select to make link to the actual database on your harddrive.
The Data Source Name we'll use in our Java Source Code to make a connection with the ODBC. Our settings are:
data source name = Noorderwind (Northwind)
description = default database for ms-access
select path = c:/msoffice/access/nwind.mdb
- Making the link to the jdbcodbc.class which will talk with the right *.dll.
- open a data source name by means of the jdbcodbcdriver.
- executing a query on the opened connection.
public NorthWind() {
// Load the JDBC-ODBC bridge driver
try {
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
} catch( ClassNotFoundException ee) {
ee.printStackTrace();
}
}
static void open() throws SQLException {
// ODBC data source name
String dsn = "jdbc:odbc:Nooderwind";
String user = "admin";
String password = "";
// Connect to the database
con = DriverManager.getConnection(dsn, user, password);
// Shut off autocommit
con.setAutoCommit(false);
}
static void select(String whereClause) {
Statement stmt; // SQL statement object
String query; // SQL select string
ResultSet rs; // SQL query results
boolean more; // "more rows found" switch
String v1, v2, v3; // Temporary storage results
results = new Vector( 10 );
query = "SELECT EmployeeId, LastName, FirstName, Title "
+ "FROM Employees "
+ whereClause;
try {
stmt = con.createStatement();
rs = stmt.executeQuery(query);
// Check to see if any rows were read
more = rs.next();
if (!more) {
System.out.println("No rows found.");
return;
}
// Loop through the rows retrieved from the query
while (more) {
v1 = "ID: " + rs.getInt("EmployeeId");
v2 = "Name: " + rs.getString("FirstName") + " " + rs.getString("LastName");
v3 = "Title: " + rs.getString("Title");
System.out.println( v1 );
System.out.println( v2 );
System.out.println( v3 );
System.out.println("");
results.addElement( v1 + "\n" + v2 + "\n" + v3 + "\n");
more = rs.next();
}
rs.close();
stmt.close();
} catch (SQLException e) {
System.out.println("" + results.size() + " results where found.");
}