Example - Using JDBC-ODBC Bridge -III

// 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();

}