I want to use
criteria.setFirstResult(xxx);
criteria.setMaxResults(yyy);

to display list divided into pages. But how can I determine total number of pages?

I though it would be useful to have count() method in Criteria class - then paging becomes simple:

Criteria q = session.createCriteria(Department.class);
q.add( Expression.eq("xxx", xxx) );
// ...
int total = q.count();

int totalPages = total / pageNo;
if (pageNo > totalPages)
pageNo = totalPages;

int first = itemsPerPage * pageNo;

q.setFirstResult(first);
q.setMaxResults(itemsPerPage);

List list = q.list();

Try to get total count

Using
List list = q.list();
int count = list.size(); // To get Total Count
System.out.println("Total :"+count);

Loading the entire list of objects to get count is extremely inefficient. What if you have a million rows? Your performance would be horrible.
In fact, I am using patched Hibernate version 2.1.5 which supplies
count method on Criteria.

If there another way to do it, I would love to know.

If you have scrollable resultsets. You can use the following.


rowNumber + 1 should be what you are looking for.