I am developing a struts application. One of the requirement is I need to display 10 records per page out of like 100 records that I receive from Database. Does anybody know how to do this. And also I need to give an option to export all the database records in an xl file. Any website that coverts these topics?
Merrill Higginson - I hope you read this. Please help me on these 2 items.
Thank you in advance Radha [ October 03, 2008: Message edited by: Bear Bibeault ]
Check the August issue of the Javaranch Journal. That has a detailed article on implementing pagination. The part about exporting to excel should be fairly simple. But you will have to fire the query on the database again, and open a new page with the mime type as ms/excel.
Also please check your private messages
He who asks a question is a fool for five minutes; he who does not ask a question remains a fool forever - Chinese proverb
Looks like Shikhar gave an excellent response to your question. I'm flattered that you asked for me by name, but this just goes to show that asking a question in an open forum and letting anyone who knows the answer provide it is a better system than just asking one person.
As it happens, I haven't had much time to devote to JavaRanch lately, but luckily there are lots of knowledgeable, helpful people out there who can answer questions.
Thank you everyone for quick response and suggestions.
I did not mean that Merrill is the only one who can help me. But, I always get exact reply back from him all the time. I thought He will look into the post for sure if I specify the name. I should not have done that.
Sorry for the inconvenience that I caused by specifying the name.
Greatly appreciate all your responses.
author & internet detective