This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes FilteredRowSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "FilteredRowSet" Watch "FilteredRowSet" New topic


nelson christos
Ranch Hand

Joined: Aug 08, 2006
Posts: 57
in our prj we need that records be displayed on the page.
It might be any number of records and there is no next or previous buttons
But is place where i am stuck is in giving the search option
the records being displayed have columns like these
doc_num, doc_date, variety, product ,qty, wt, units
so i need to give the search option based on these columns

i have two approaches at hand
1> to get the ResultSet and then populate the javabeans for that particular records and then whenever a search is made query the db and find the records

2>to get a FilteredRowSet and then whenever a query is placed instead of making a db query filter the rowset itself

the problem is i cant understand whether making searches on the rowset is faster than making db query

i am not able to figure which is the best possible solution
can anybody help me out

i think therefore i am
I agree. Here's the link:
subject: FilteredRowSet
jQuery in Action, 3rd edition