");
for (int i=1; i<=columns; i++) {
out.write("" + result.getString(i) + " | ");
}
out.write("
");
}
// close the connection and the statement
stmt.close();
conn.close();
} // end of the try block
catch (SQLException e) {
System.out.println("Error " + e);
}
// ensure everything is closed
finally {
try {
if (stmt != null)
stmt.close();
} catch (SQLException e) {}
try {
if (conn != null)
conn.close();
} catch (SQLException e) {}
}
%>