hibernateTemplate-Order Results

最新推荐文章于 2025-09-12 18:08:49 发布

weixin_34203426

最新推荐文章于 2025-09-12 18:08:49 发布

阅读量78

点赞数

CC 4.0 BY-SA版权

文章标签： java

原文链接：http://www.cnblogs.com/liwp_Stephen/archive/2008/09/29/1302216.html

本文介绍如何在Hibernate应用中使用hibernateTemplate添加排序功能。通过两种方法实现：使用getHibernateTemplate().find()方法直接进行SQL查询；使用getHibernateTemplate().findByCriteria()结合DetachedCriteria和Order.asc()进行排序。

This article is obtained from http://www.roseindia.net/hibernate/hibernate-how-to/ordering-result.shtml

In this section you will learn how to add ordering ability to in Hibernate Application when using hibernateTemplate. There are many ways you can order your results when using hibernateTemplate.

Suppose you have a class called "Student" with the fields "studentName", "StudentCode" and you want to retrieve all the records from database in sorted by "studentName" in ascending order. There are following options for you.

Use getHibernateTemplate().find() method
Following code shows how you can use getHibernateTemplate().find() method:
public Collection loadAllStudent() throws DataAccessException{
return getHibernateTemplate().find("from Student student order bystudent.studentName");
}
Use getHibernateTemplate().findByCriteria()
Following code shows how you can use getHibernateTemplate().findByCriteria() function in your hibernate application.
public Collection loadAllStudent() throws DataAccessException{
return getHibernateTemplate().findByCriteria(DetachedCriteria.forClass(Student.class).addOrder(Order.asc("studentName")));
}