Criteria criteria = session.createCriteria(Student.class); criteria.add(Restrictions.gt("rollNo", 1)); criteria.addOrder(Order.asc("name")); List list = criteria.list();
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()); } } }
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 |
Advertisements
Ads
Ads