Implementing dynamic paged queries - POJOs in Action: Developing Enterprise Applications with Lightweight Frameworks - page 445

bb Restrictions.like("name", searchCriteria
bb .getRestaurantName()));
} else {
bb criteria.setFetchMode("restaurant", FetchMode.JOIN);
}
if (searchCriteria.isDeliveryCitySpecified()) {
bb criteria.add(Restrictions.eq("deliveryAddress.city",
bb searchCriteria.getDeliveryCity()));
}
…

}

D Specifies ordering

private void
addSortBy(Criteria criteria,
OrderSearchCriteria searchCriteria) {
switch (searchCriteria.getSortBy()) {
case OrderSearchCriteria.SORT_BY_ORDER_ID:
bb criteria
bb .addOrder(searchCriteria.isSortAscending() ?
bb org.hibernate.criterion.Order
bb .asc("externalOrderId")
bb : org.hibernate.criterion.Order
bb .desc("externalOrderId"));
break;
…
default:
bb throw new NotYetImplementedException();
}
}

E Specifies range

private void addRange(Criteria criteria) {
criteria.setFirstResult(startingIndex);
criteria.setMaxResults(pageSize + 1);
}
private PagedQueryResult
makePagedQueryResult(List result) {
boolean more = result.size() > pageSize;
if (more) {
bb result.remove(pageSize);
}
return new PagedQueryResult(result, more);
}

F Creates PagedQueryResult

}

Let's look at the details: