aspose file tools*
The moose likes JDBC and the fly likes ResultSet Paging --- I am STUCK!!!!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

ResultSet Paging --- I am STUCK!!!!!!

Dharmesh Chheda
Ranch Hand

Joined: May 08, 2001
Posts: 204
Hello
I am stuck!!! I wanted some help regarding ResultSet paging .. i am getting around 100 records in my resultset. But i just want to display 10 records on each page.. can someone help me by giving some code
or some reference site..
i am using JSP and Servlets ..
reply soon ..


regards,<br />Dharmesh Chheda
pavi kavi
Ranch Hand

Joined: Mar 01, 2001
Posts: 56
Hello Dharmesh,
I have done it for many modules.
there are 2 ways to obtain it
1.u can take whole result set & display only those u want
2.u can take only those which u want to display
let me know which one u want.I can help u out in both cases.
Pavithra
Originally posted by Dharmesh Chheda:
Hello
I am stuck!!! I wanted some help regarding ResultSet paging .. i am getting around 100 records in my resultset. But i just want to display 10 records on each page.. can someone help me by giving some code
or some reference site..
i am using JSP and Servlets ..
reply soon ..

Dharmesh Chheda
Ranch Hand

Joined: May 08, 2001
Posts: 204
Hello Pavi
I didnt actually get what you meant .. anyways .. i want the whole resultset to be displayed but only 10 records per page ...
you can take the case of this javaranch site ..
the records are displayed and also the page numbers on the bottom
reply soon
pavi kavi
Ranch Hand

Joined: Mar 01, 2001
Posts: 56
give me your emailid
i will send the program
pavithra
Originally posted by Dharmesh Chheda:
Hello Pavi
I didnt actually get what you meant .. anyways .. i want the whole resultset to be displayed but only 10 records per page ...
you can take the case of this javaranch site ..
the records are displayed and also the page numbers on the bottom
reply soon

Dharmesh Chheda
Ranch Hand

Joined: May 08, 2001
Posts: 204
Hello Pavi
My email address is dchheda@bom.ontrackin.com
mail soon
Manoj Singh
Ranch Hand

Joined: Aug 10, 2000
Posts: 41
Hi Pavi !
Is it possible for you to send the code to me as well. My email id is singh_mk@hotmail.com . I would be highly obliged.
Thanking you in anticipation.
ThanX
Manoj


Sun Certified Java 2 Programmer<BR>" Only those who will risk going too far can possibly find out how far one can go "
sandeep balyan
Ranch Hand

Joined: Jul 25, 2001
Posts: 134
Hi if u can send me on
sandeep2002@rediffmail.com
thanks in advance
regs


Want to do something great will do one day
Thunderbuck
Greenhorn

Joined: Aug 18, 2002
Posts: 1
Originally posted by pavi kavi:
Hello Dharmesh,
I have done it for many modules.
there are 2 ways to obtain it
1.u can take whole result set & display only those u want
2.u can take only those which u want to display
let me know which one u want.I can help u out in both cases.
Pavithra


Hmmm, it looks like this is popular!
Please e-mail me too (bchandler@codewolf.net)
This is JUST what I was looking for today!


Brett (aka Thunderbuck)
rastin purr
Ranch Hand

Joined: Jul 20, 2002
Posts: 73
Hi there,
Can a copy be sent to me too! Thanks
e-mail: rastinpurr@yahoo.com
rastin purr
Andres Gonzalez
Ranch Hand

Joined: Nov 27, 2001
Posts: 1561
me too pleaseee !!!
britt50423@yahoo.com


I'm not going to be a Rock Star. I'm going to be a LEGEND! --Freddie Mercury
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

Rather than sending this to multiple individuals, it would better to post a somple here so all can make use of it.
Just in case pavi kavi isn't monitoring this tread anymore, I might see if I can get a sample and put it somewhere publically accessible (with permission, of course )
I'd also like to point out that there is no 'magic bullet' for paging. If you do a search and read previous discussions, you'll see that the correct solution depends on the problem you are trying to solve. eg catalogues and searches have very different solutions to paging and the correct solution for one may be unworkable for another.
Dave
Malli Raman
Ranch Hand

Joined: Nov 07, 2001
Posts: 312
Hi,
Please send the code to my id: msraman24@yahoo.com.

Regards,
M.S.Raman
Malli Raman
Ranch Hand

Joined: Nov 07, 2001
Posts: 312
Hi,
I am really happy if you send me the code to my yahoo id: msraman24@yahoo.com.
Regards,
M.S.Raman
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

PLEASE STOP POSTING EMAIL ADDRESSES TO THIS THREAD!
I'm trying to come up with a solution which helps everyone and not individuals, and I'm keeping this thread open in the hope that pavi kavi will respond to an email I sent.
If people keep posting their email addresses I'll just close the thread since there is currently no indication that there has been a response of any sort.
Thanks for your enthousiasm though, it goes to show this is a topic many people are keen on and we'll have to promote some discussion later on.
(not really angry )
Dave
tom mcmorrow
Ranch Hand

Joined: Jan 11, 2002
Posts: 39
hi,
this is a topic i have been giving some consideration to far the past number of days myself so far progress has not being good and i look forward to see some useful suggestions being posted here. Thanking you all for you generous help.
tom mcmorrow
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

to try to stop this insanity, maybe people can share links to useful information. I'll start with previous discussions we've had at the ranch:
link 1
link 2
link 3
Jamie
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

I have just stumbled upon the most comprehensive set of solutions that I have seen so far. It discusses the different options, how to create a standard interface for the options, and gives a concrete implementation of the interface. You can read it here at theserverside.com
Hope this helps,
Jamie
Sreenivas Vulli
Greenhorn

Joined: Mar 24, 2003
Posts: 2
Hi Pavi,
I am looking at the problem posted regarding the paging. I am looking for a code to do the paging of my resultset. Can you please send me the code to vullisri@yahoo.com.
Thank you
Sreenivas
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ResultSet Paging --- I am STUCK!!!!!!