Syntax to use OrderBy in Hibernate Criteria Query

The order can be specified using addOrder on a Criteria Object
criteria.addOrder(Order.asc("propertyName"))
criteria.addOrder(Order.desc("propertyName"))

Order results according to an order in Hibernate 

Suppose we have a class
Category.java
package com.ekiras.domain;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.Table;

@Entity
@Table(name="category")
public class Category {

public Category(){}
public Category(Long id){
this.id = id;
}
public Category(Long id, String name){
this.id = id;
this.name = name;
}

@Id
@Column(nullable=false, name="id")
@GeneratedValue(strategy=GenerationType.AUTO)
private Long id;

@Column(nullable=false, name="name")
private String name;

// Getters and Setters

}
So if we need to order the results of this class according to a given order we can do it like following

  • Order by propertyName id in ascending order
    sessionFactory.getCurrentSession()
    .createCriteria(Catgeory.class)
    .addOrder(Order.asc("id"))
    .list();
  • Order by propertyName name in descending order
    sessionFactory.getCurrentSession()
    .createCriteria(Catgeory.class)
    .addOrder(Order.desc("name"))
    .list();
  • Order by propertyName name in random order
    sessionFactory.getCurrentSession()
    .createCriteria(Catgeory.class)
    criteria.add(Restrictions.sqlRestriction("1=1 order by rand()"));
    .list();
    The above code will return the list of Category domain objects in a random order.