Create an action that takes in the start id and the quantity to scroll over, and your
query (total of 3 params). Read up on your DB specific SQL language for specifying a
start id and max rows to return (not applicable for this mailing list). Enstate
whatever kind of caching you want, but leave querying to request based only. That's
how most "big" sites do it.
-Jacob
-----Original Message-----
From: Jagadeesan,Sivakumar [mailto:[EMAIL PROTECTED]
Sent: Wed 3/26/2003 5:20 PM
To: 'Struts Users Mailing List'
Cc:
Subject: RE: Design Doubt
I will chk the displayTag.
I think putting data in a ArrayList of beans will be problem , if there are
many data present in the database. For example, if there are 1000 rows then
we will be creating 1000 beans. I don't think this is good idea.
-----Original Message-----
From: Raible, Matt [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 5:16 PM
To: 'Struts Users Mailing List'
Subject: RE: Design Doubt
Easiest way without too many details (lots of opinions on getting data from
database):
1. Put data into an ArrayList of Beans (forms, POJOs, whatever).
2. Use display tag library for display/sorting/paging -
http://displaytag.sf.net (it's open source, so if you want to improve it
feel free!)
Matt
> -----Original Message-----
> From: Jagadeesan,Sivakumar
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 26, 2003 4:09 PM
> To: 'Struts Users Mailing List'
> Subject: Design Doubt
>
>
> * I want to develop a Product Catalog.
> * The product list is present in the database
> * I want to display 10 products in one JSP page. I don't want
> to load all
> the
> products from the Database and keep it in the memory. I also
> don't want to
> return
> the ResultSet to the Servlet/JSP Layer.
>
> What is the best way to do this ?
>
> This is common functionality almost all the web sites have,
> but for some
> reason I am not able to figure it out.
>
> --Siva Jagadeesan
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]