• Post Reply Bookmark Topic Watch Topic
  • New Topic

Filter ResultSet in JTable  RSS feed

Deroga Rivera
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!