Home Hibernate Examples Criteria Restrictions Hibernate Criteria Sort Order

Ask Questions?

View Latest Questions


 
 

Hibernate Criteria Sort Order
Posted on: April 14, 2011 at 12:00 AM
Advertisement
In this tutorial you will learn about hibernate criteria sort order

Hibernate Criteria Sort Order

The hibernate criteria sort order API is used to display the records in some sorted order either ascending or descending
Criteria criteria = session.createCriteria(Student.class);
	criteria.add(Restrictions.gt("rollNo", 1));
	criteria.addOrder(Order.asc("name"));
	List list = criteria.list();

An example of sorted order is fiven below please consider the example

CriteriaSortOrder.java

package net.roseindia.main;

import java.util.Iterator;
import java.util.List;

import net.roseindia.bean.Student;
import net.roseindia.util.HibernateUtil;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;

public class CriteriaSortOrder {
	public static void main(String[] args) {
		Session session = HibernateUtil.getSessionFactory().openSession();
		Criteria criteria = session.createCriteria(Student.class);
		criteria.add(Restrictions.gt("rollNo", 1));
		criteria.addOrder(Order.asc("name"));
		List list = criteria.list();
		Iterator iterator = list.iterator();
		while (iterator.hasNext()) {
			Student student = (Student) iterator.next();
			System.out.println(student.getName());
		}

	}
}

When you run this application it will display message as shown below:

Hibernate: select this_.roll_no as roll1_0_, this_.name as name0_0_, this_.course as course0_0_, this_.address as address0_0_, this_.addmision_date as addmision5_0_0_ from student this_ where this_.roll_no>? order by this_.name asc
Aman
Bharat
Chulbul Panday
Raman
Raman
Ramesh
Vikash

Download Complete Source Code

Related Tags for Hibernate Criteria Sort Order:


DMCA.com