ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Chien <john.ch...@ncmail.net>
Subject pager in ibatis
Date Wed, 12 Apr 2006 14:53:59 GMT
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 ?


John Chien

View raw message