Hibernate Set集合排序

hbm.xml文件中的<set order-by="这里填写的是数据库字段名，而不是属性名，多个用逗号分隔">
</set>

转载另一种方式：原文作者的地址是http://yangdaojun.iteye.com/blog/292926，作者名字不知


本文探讨对Hibernate的set集合进行排序。假如有两张表：课程信息表(ECH_LEARN_COURSE)和课程分类信息表(ECH_LEARN_COUCATEGORY)，它们之间是一对多的关系。对应的java类分别为EchLearnCourse和EchLearnCoucategory。EchLearnCoucategory有一个Set属性 echLearnCourse,需要对echLearnCourse按课程的排序位置(ORDER_NUM)进行排序。首先使用数据库排序：
<set name="echLearnCourses" order-by="ORDER_NUM asc" inverse="true" lazy="true">
       <cache usage="read-write"/>
       <key>
           <column name="CATEGORYID" length="32" not-null="true"/>
       </key> 
       <one-to-many class="cn.echineseblcu.learning.persistence.EchLearnCourse"  />
</set>

但输出的集合无序，无奈，用内存排序吧
<set name="echLearnCourses" inverse="true" lazy="true" sort="cn.echineseblcu.learning.persistence.CourseComparator">
       <cache usage="read-write" />
       <key>
           <column name="CATEGORYID" length="32" not-null="true"/>
       </key> 
       <one-to-many class="cn.echineseblcu.learning.persistence.EchLearnCourse"  />
</set>
输出的集合依然无序。没辙了，那就用TreeSet试试：
即在映射类中定义相应的TreeSet属性echLearnCoursesTreeSet，让EchLearnCoucategory类实现Comparable接口。在EchLearnCoucategory中定义内部类CourseComparator，将EchLearnCourse 按orderNum排序。
     public TreeSet<EchLearnCourse> getEchLearnCoursesTreeSet() {
echLearnCoursesTreeSet.addAll(echLearnCourses);
return echLearnCoursesTreeSet;
    }
     public class CourseComparator implements Comparator{
    public int compare(Object o1,Object o2){
      EchLearnCourse c1=(EchLearnCourse)o1;
      EchLearnCourse c2=(EchLearnCourse)o2;
        if(c1.getOrderNum().compareTo(c2.getOrderNum())>0)
        return 1;
        if(c1.getOrderNum().compareTo(c2.getOrderNum())<0)
        return -1;
        return 0;
    }
}
输出某分类下的课程时使用echLearnCoursesTreeSet，而不用echLearnCourses。

具体映射文件及java类如下：
课程信息表映射文件及对应的java类：
<!--EchLearnCourse.hbm.xml-->
<hibernate-mapping>
    <class name="cn.echineseblcu.learning.persistence.EchLearnCourse" table="ECH_LEARN_COURSE" schema="ECHINESE2">
        <cache usage="read-write"/>
        <id name="id" type="java.lang.String">
            <column name="ID" length="32" />
            <generator class="uuid.hex" />
        </id>
        <many-to-one name="echLearnCoucategory" class="cn.echineseblcu.learning.persistence.EchLearnCoucategory" fetch="select">
            <column name="CATEGORYID" length="32" />
        </many-to-one>
        。。。。。。         
    </class>
</hibernate-mapping>

<!--EchLearnCourse.java-->
public class EchLearnCourse extends CommonBean implements java.io.Serializable,Comparable {
    // Fields   

     public int compareTo(Object o) {
// TODO Auto-generated method stub
return 0;
}

     private EchLearnCoucategory echLearnCoucategory;
     。。。。。。    
     // Constructors

    /** default constructor */
    public EchLearnCourse() {
    }
   
    public EchLearnCourse(String id) {
    this.id = id;
    }

    。。。。。。
    public EchLearnCoucategory getEchLearnCoucategory() {
        return this.echLearnCoucategory;
    }
   
    public void setEchLearnCoucategory(EchLearnCoucategory echLearnCoucategory) {
        this.echLearnCoucategory = echLearnCoucategory;
    }

    。。。。。。
    public boolean equals(Object o)
    {
        return EqualsBuilder.reflectionEquals(this, o);
    }
   
    public int hashCode()
    {
        return HashCodeBuilder.reflectionHashCode(this);
    }

}
课程分类信息表映射文件及对应的java类：
<!--EchLearnCoucategory.hbm.xml-->
<hibernate-mapping>
    <class name="cn.echineseblcu.learning.persistence.EchLearnCoucategory" table="ECH_LEARN_COUCATEGORY" schema="ECHINESE2">
        <cache usage="read-write"/>
        <id name="id" type="java.lang.String">
            <column name="ID" length="32" />
            <generator class="uuid.hex" />
        </id>
        。。。。。。    //省略若干属性  
        <set name="echLearnCourses" where="delflag='02'" inverse="true" lazy="true">
            <cache usage="read-write"/>
            <key>
                <column name="CATEGORYID" length="32" not-null="true"/>
            </key>
         
            <one-to-many class="cn.echineseblcu.learning.persistence.EchLearnCourse"  />
        </set>

    </class>
</hibernate-mapping>

<!--EchLearnCoucategory.java-->

public class EchLearnCoucategory extends CommonBean implements java.io.Serializable,Comparable {

// Fields

public int compareTo(Object o) {
// TODO Auto-generated method stub
return 0;
}

private Set echLearnCourses = new HashSet(0);

private TreeSet<EchLearnCourse> echLearnCoursesTreeSet = new TreeSet<EchLearnCourse>(new CourseComparator());

private Set echLearnCoucategoryI18ns = new HashSet(0);

// Constructors

/** default constructor */
public EchLearnCoucategory() {
}
        
。。。。。。//省略若干属性的getter和setter方法

public Set getEchLearnCourses() {
return this.echLearnCourses;
}

public void setEchLearnCourses(Set echLearnCourses) {
this.echLearnCourses = echLearnCourses;
}

public TreeSet<EchLearnCourse> getEchLearnCoursesTreeSet() {
echLearnCoursesTreeSet.addAll(echLearnCourses);
return echLearnCoursesTreeSet;
}

public void setEchLearnCoursesTreeSet(
   TreeSet<EchLearnCourse> echLearnCoursesTreeSet) {
   this.echLearnCoursesTreeSet = echLearnCoursesTreeSet;
}

public class CourseComparator implements Comparator{
    public int compare(Object o1,Object o2){
      EchLearnCourse c1=(EchLearnCourse)o1;
      EchLearnCourse c2=(EchLearnCourse)o2;
        if(c1.getOrderNum().compareTo(c2.getOrderNum())>0)
        return 1;
        if(c1.getOrderNum().compareTo(c2.getOrderNum())<0)
        return -1;
        return 0;
    }
}
}