posted 17 years ago
I have a JTable in my application that displays the data in a ResultSet. I also gave the user the ability to filter this list by some of the fields (user,jobNumber, etc).
Currently the filter causes another database query with a WHERE clause then updates the JTable using model.setResultSet(rs) and model.fireTableDataChanged() calls with the new ResultSet.
Since the original list contains all of the records I would like to avoid hitting the database a second time just to hide some of the records and a third time just to show what I had originally!
Is there a way to allow filtering of a ResultSet in a JTable without replacing the ResultSet?
Thanks!