This week's book giveaway is in the Other Open Source APIs forum. We're giving away four copies of Storm Applied and have Sean Allen, Peter Pathirana & Matthew Jankowski on-line! See this thread for details.
In a properly written JDBC driver, Connection.close() will close any open Statement or ResultSet objects that were opened on that Connection, before closing the connection itself. ResultSet.close() will merely close the ResultSet, leaving open any Statement or Connection above it.