jQuery in Action, 2nd edition*
The moose likes JDBC and the fly likes Searches Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Searches" Watch "Searches" New topic
Author

Searches

Rachel Kozlowski
Ranch Hand

Joined: Jan 14, 2009
Posts: 40
Howdy or Hello Fellow Java Wranglers,

I built an application using a CachedRowSet. (For other newbies it is used as a disconnected Result Set.) My users like it because they can bring data into it and do data manipulations on different rows within the set and then when everything is to their liking all the data can be sent back to the database with all of the changes for everything. Also, my users can add new data rows to this set.

My problem is that my users want to be able to search fields within the set for specific values but each field can have duplicate values, so, I do not have anything like a primary key except for the row number that I create. So basically my users have to search through the entire set one record at a time to find the record within the set that they would like to change.

Do you have any suggestions on what I can do with this critter, remembering that the fields that they want to search on have duplicate values?

Thanks Your Fellow Wrangler,

Rachel
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 37865
    
  22
Welcome to JavaRanch.

Afraid that question is rather more complicated than we usually discuss here on Beginners'; I think questions about RowSets would sit better on the JDBC forum. Moving.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Searches
 
Similar Threads
Lock and Search
Populating fields with data on click of radio button
How do I slim down a class full of get...() and set...()
B&S 2.2.2 updateRecord()
get data from html tables and send it to controller/servlet