Separate HTML for Basic Foil 54 Example - Using JDBC-ODBC Bridge -III

Basic HTML version of Foils prepared 7 October 97

Foil 54 Example - Using JDBC-ODBC Bridge -III

From Overview of JDBC and its use with Microsoft Access ARL Database Tutorial -- February 98. by Nancy McCracken(Sangetta Aggarwal, Udayan Parvate, Tom Pulikal)

// Create a Statement object so we can submit

// SQL statements to the driver

Statement stmt = con.createStatement ();

// Submit a query, creating a ResultSet object

ResultSet rs = stmt.executeQuery (query);

// Display all columns and rows from the result set

dispResultSet (rs); // see later

// Close the result set

rs.close();

// Close the statement and then the connection

stmt.close();

con.close();

}