Paging Through Results on the Web

Hi
One way to achieve it is through using a hidden form field(In case of using html to display results) and using a query like the one i had written below.
 
 This query will give you records and count of that record.i.e..like if accNo is the primary key and it's value is 20 and it is the 13th record in the table(It became 13th record because the some of records whose accNo<20 might be deleted.), the query gives this record details and number 13 indicating it is the 13th record.
 The value of the the hidden form feild will be this record count number.First it will be 0.When we submit the request, using the query, we retrive records whose record count>0 and <(0+10).Now we set the hidden variable's value to 10.Again when we submit the form, we retrive recordcount>10 and <(10+10) and set hidden value to 20 and proceed like this .
 The query is like following
 select *,(select count(*) from dr_accs where dr_accs.accno=d.accno) as recNum
 from dr_accs d
 where recNum>0 and recNum<(0+10)
 orderby recNum

This is the case when u access the servlet for first time.Instead of the 0, u put the hidden varible's value.

try this:
accept the result from DB once, and store it in a Vector.
call your servlet with a 'startFrom' parameter. on each re-call of the servlet, just iterate the Vector and display the items from startFrom to startFrom+10.

this will save you multiple access to the DB.

qilap,

I am fairly new to servlet programming.  Would I have to store the vector in a session object to keep state between servlet requests?  

Comment accepted as answer

Thanks for your help...