<?xml version="1.0" encoding="utf-8"?>sort="natural"表示使用对象的comparaTo()方法来进行排序,容器中的对象上必须有实作java.lang.Comparable 接口,例如String就有实作java.lang.Comparable接口,结果会使用字典顺序来排列容器中的对象。
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="onlyfun.caterpillar.User" table="user">
....
<set name="emails" table="email" sort="natural">
<key column="id"/>
<element type="java.lang.String"
column="address"/>
</set>
</class>
</hibernate-mapping>
package onlyfun.caterpillar;在自订的Comparator中,如果两个对象的顺序相同会传回0,而为了方便比较对象,要求传入的对象必须实作Comparable接口(例如 String对象就有实作Comparable接口),范例中只是简单的将原来compareTo()传回的值乘以负一,如此就可以简单的让排列顺序相 反,接着可以在映像文件中指定自订的Comparator类别:
import java.util.Comparator;
public class CustomComparator implements Comparator {
public int compare(Object o1, Object o2) {
if (((String) o1).equals(o2))
return 0;
return ((Comparable) o1).compareTo(o2) * -1;
}
}
<?xml version="1.0" encoding="utf-8"?>Bag与List并不适用于这种方式。
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="onlyfun.caterpillar.User" table="user">
....
<set name="emails" table="email"
sort="onlyfun.caterpillar.CustomComparator">
<key column="id"/>
<element type="java.lang.String"
column="address"/>
</set>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8"?>观察Hibernate所使用的SQL可以看到order by子句:
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="onlyfun.caterpillar.User" table="user">
....
<set name="emails" table="email" order-by="address desc">
<key column="id"/>
<element type="java.lang.String"
column="address"/>
</set>
</class>
</hibernate-mapping>
Hibernate: select emails0_.id as id0_, emails0_.address as address0_ from email emails0_ where emails0_.id=? order by emails0_.address desc