Filtering a java sql resultset

[ChallengedProgrammer]

Does anyone know whether you can filter on a returned java resultset WITHOUT executing another SQL with a filter (i.e. without performing another call on the DB)?

For example if I had a resultset with a list of Sales Reps and Province, could I filter on that returned resultset for the Sales Reps by Province?

Thanks for your help.

 

[sedj]

Loop the ResultSet, adding the fields into an ArrayList, then perform your own "filter", or add an ORDER BY clause to the SQL statement (or in the proc you are calling) ?