ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zarar Siddiqi" <zarar.sidd...@utoronto.ca>
Subject Re: pager in ibatis
Date Wed, 12 Apr 2006 17:40:59 GMT
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" <john.chien@ncmail.net>
To: <user-java@ibatis.apache.org>
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 <john.chien@ncmail.net> 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
>>>
>>>
>>>
>>>
>>>
> 



Mime
View raw message