Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Message-ID: <007901c65e58$42db0220$53696480@sis.utoronto.ca>
From: "Zarar Siddiqi" <zarar.siddiqi@utoronto.ca>
To: <user-java@ibatis.apache.org>
References: <2E7899FA2A83AB4480078DA88C8F10FBE44EC5@HYD-MDP-MBX01.wipro.com>
	 <443D1487.7030606@ncmail.net>
 <a10a823c0604120759r278d2fe8kcfe6420ba326bd59@mail.gmail.com>
 <443D2A50.80802@ncmail.net>
Subject: Re: pager in ibatis
Date: Wed, 12 Apr 2006 13:40:59 -0400
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

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
>>>
>>>
>>>
>>>
>>>
>