Agreed. Larry
On 4/12/06, Zarar Siddiqi <[EMAIL PROTECTED]> wrote: > The queryForPaginatedList() retrieves all the records from the database and > simply then returns a subList based on whatever you've set via > gotoPage/nextPage and the page size. So yes, you have to pass in pageSize > every time and then set the appropriate page via gotoPage(), nextPage() or > previousPage() each time. It's somewhat a manual process. > > If this is a large query, I'd actually recommend just writing the SQL which > efficiently gets the correct set of records that you want. (E.g: LIMIT in > MySQL or TOP in SQL Server) > > Zarar Siddiqi > > > ----- Original Message ----- > From: "John Chien" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, April 12, 2006 12:26 PM > Subject: Re: pager in ibatis > > > > L:arry: > > > > Thank you for the information. > > The queryForPaginatedList() will return a list, then I can check for the > > existence of successive records by calling the isNextPageAvailable(). > > and go to that page by calling gotoPage(); > > > > However, I can not keep this list in my server due to concurrecy reason. > > Does that mean that I have to call the same method every time and give > > it the page number for it to return me the records ? > > > > I am doing the web development. > > How can I make use of this returned list in JSP with Struct development ? > > > > Should I keep the list in the session or request scope ? > > > > Thanks, > > > > John Chien > > > > Larry Meadors wrote: > > > >>queryForPaginatedList() > >> > >>Larry > >> > >> > >>On 4/12/06, John Chien <[EMAIL PROTECTED]> wrote: > >> > >> > >>>Dear sir: > >>> > >>>I have a feature that requires me to return query result of a selection > >>>statment in certain amount of successive records every time. > >>>This is just like a page. > >>> > >>>For example: > >>> > >>>SELECT id, name > >>>FROM employee; > >>> > >>>The selection result of this statement is a list. > >>>However, I want to only get 30 records every time. > >>>For the first call, I want to get the first 30 (1 - 30) records, for > >>>thext call, I would like to get the next 30 (31 - 60) records. > >>> > >>>How can I do this in Ibatis ? > >>> > >>>Thanks, > >>> > >>>John Chien > >>> > >>> > >>> > >>> > >>> > > > > >
