posted 18 years ago
For your information, writing completely in capital letters is 'shouting' and is often considered rude.
ResultSets do not read all of the results from the query, and they need the Connection so that they are able to go back and read more results when required.