Pagination using a criteria

Now we will look at how to limit the number of rows using hibernate.

How to do it...

Here's a scenario to easily understand what we are about to do.

Let's consider that we have four rows in an employee table, and a SELECT * FROM employee SQL query returns all four records. However, if we want only the second and third records, we can use the SELECT * FROM employee LIMIT 1, 2 SQL statement.

Let's take a look at how to achieve such a condition in hibernate:

Code

Enter the following code to paginate using a criteria:

SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
Session session = sessionFactory.openSession();

Criteria criteria = session.createCriteria(Employee.class);
criteria.setFirstResult(1); // represent LIMIT 1,* in MySQL
criteria.setMaxResults(2);// represent LIMIT *,2 in MySQL

List<Employee> employees = criteria.list();
for (Employee employee : employees) {
  System.out.println(employee.toString());
}

session.close();
HibernateUtil.shutdown...