Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How Do I get Previous record as like Next ?

 
Arockiaraj Swaminathan
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All!
I have retrieved data form the Database. I want to give Search Utility to move back and forth to view the record. I have given to move the record to Next, but I could not get done for previous record. How do I get it?
------------------
S Arockiaraj
 
Peter Tran
Bartender
Posts: 783
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You need to look into scrollable result set. I think the default result set is a forward only cursor. I haven't used a Scrollable result set because the performance is pretty bad (from what I've read). You might want to look into putting the data into a collection and going through the collection rather than using a scrollable result set.
 
Sameer Sawla
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you are using [B]JDBC 3.0[B] then RecordSet.previous() method can also be used.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic