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