Win a copy of Head First Android this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Devaka Cooray
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Jj Roberts
  • Al Hobbs
  • Piet Souris

How to use rs.previous() method

 
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Respected Sir,
I am developing a awt with database application.
in that application i am using a screen which will fetch the records from database
i implemented rs.next() method to go for next page
but i am not able to implement rs.previous() method to come back from last page.
please help me in any of the way
i am using sql server 2000 database jdk 1.3 version
waithng for your replies
Thankyou Very Much
Yours
Raj
 
Ranch Hand
Posts: 1512
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It depends on the JDBC driver you are using. I that method is part of JDBC 2.0

Bosun
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
what is the exception message? Did you create a scrollable resultset? Does your database driver implement the jdbc feature?
Jamie
 
Rajesh Kumar77
Greenhorn
Posts: 12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Respected Sir,
Thankyou for reply
I implemented the result set as scrollable result like as follows
st = myConusm1.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
actually it has to show 6 records per page
but, Some times it is showing only 5 records in the first page when we came back to first page
and some times it is showing 6 records in first page when we came back to the first page from the end of record
I used jdbc odbc driver and jturbo driver
i am using jdk 1.3 in windows 2000 server with sql server 2000
pl give me solution
yours
Raj

[This message has been edited by Rajesh Kumar77 (edited September 06, 2001).]
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic