im new to hibernate. just wonder how to display the search result sets in multiple pages and use the hyperlinks to navigate.
thanks

Use Criteria based query to get required number of records for one page. Depending on the navigation( next 10 or previous 10 ) retrieve the records by going back to the same collection query.



If next link is clicked, startNumber will become (startNumber + 10), similarly endNumber. This is very simple case assuming the propertyName values are sequential incrementing. You can adjust it according to your needs.

Use query.setFirstResult(int firstResult) and setMaxResults(int maxResults). This neatly translates into LIMIT firstResult, maxResults for mysql, LIMIT maxResults OFFSET firstResult for postgres or whatever way for paging your database uses.