ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <lmead...@apache.org>
Subject Re: pager in ibatis
Date Wed, 12 Apr 2006 17:43:34 GMT
Agreed.

Larry


On 4/12/06, Zarar Siddiqi <zarar.siddiqi@utoronto.ca> 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" <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