File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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
It's not a secret anymore!