tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ralph Einfeldt" <ralph.einfe...@uptime-isc.de>
Subject RE: [off topic] - passing a ResultSet from a servlet to a JSP
Date Wed, 30 Apr 2003 08:38:22 GMT
That depends very much on the database if you have an easy and 
performant way to achieve that.

There are several solutions that are quite imperformant as the
underlying database may rebuild the complete result set to 
deliver the next 20 entries.

> -----Original Message-----
> From: Erik Price [mailto:eprice@ptc.com]
> Sent: Tuesday, April 29, 2003 11:18 PM
> To: Tomcat Users List
> Subject: Re: [off topic] - passing a ResultSet from a servlet to a JSP
> 
> 
> Why not just fetch the number of records that you intend to 
> display on a given page, and pass the offset of the last fetched record?  
> This way, on the first page you can display records 1-20, and you pass 
> "20" to the second page (via the session, querystring, or hidden form 
> field).  On the next page, you simply display 20 records starting with 
> the offset + 1 (21), so you end up with records 21-40.
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message