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
