List:MySQL and Java« Previous MessageNext Message »
From:Pascal Robert Date:January 21 2003 7:28pm
Subject:Display ResultSet per batch
View as plain text  
Hi list,

I want to display a ResultSet (coming from MySQL) per batch inside a
JSP/servlet combo.  For example: if the ResultSet returns 56 items, I want
to display 20 rows at a time (so to view the full ResultSet, the user will
have to "scroll" on 3 different pages).

The only thing I can think of, is to put the ResultSet inside beans, build
an array of those beans and keep the array as a session object.  At each
page refresh, I transfer some parameters to keep track of where I am in the
array to display the batch.

Do you have a better solution ?  Any taglibs or code that already do
something similar ?

Thanks.

Thread
Display ResultSet per batchPascal Robert21 Jan