hibernateコレクションソート1(メモリソート)



メモリ内ソート類似
 
 
sortプロパティを使用すると、結果セットを取り戻した後にメモリでソートし、ソートされた結果セットのデータベース構造を返すことができます.
create table teamSort (id varchar(32),teamname varchar(32));
create table studentSort (name varchar(32),team_id varchar(32));
insert into teamSort values("1","team1");
insert into studentSort values("a","1");
insert into studentSort values("b","1");
insert into studentSort values("c","1");

 
pojo:student部分はset集合を採用し、実体クラスはない
package Collection.Sort;

import java.util.Set;

public class Team {
   private String id;
   private String teamname;
   private Set students;
public String getId() {
    return id;
}
public void setId(String id) {
    this.id = id;
}
public String getTeamname() {
    return teamname;
}
public void setTeamname(String teamname) {
    this.teamname = teamname;
}
public Set getStudents() {
    return students;
}
public void setStudents(Set students) {
    this.students = students;
}

}
 
Team.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
    Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
<class name="Collection.Sort.Team" table="teamSort" >
    <id name="id" unsaved-value="null">
      <generator class="uuid.hex"></generator>
    </id>
    <property name="teamname" type="string" column="teamname"></property>
    <!--  element       -->
    <set name="students" table="studentSort" cascade="all" sort="natural">
      <key column="team_id"></key>
      <element type="string" column="name"></element>
    </set>
</class>

</hibernate-mapping>
 
Hibernate.cfg.xml
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

<session-factory>
    <property name="connection.username">root</property>
    <property name="connection.url">
        jdbc:mysql://localhost:3306/schoolproject?characterEncoding=gb2312&amp;useUnicode=true
    </property>
    <property name="dialect">
        org.hibernate.dialect.MySQLDialect
    </property>
    <property name="myeclipse.connection.profile">mysql</property>
    <property name="connection.password">1234</property>
    <property name="connection.driver_class">
        com.mysql.jdbc.Driver
    </property>
    <property name="hibernate.dialect">
        org.hibernate.dialect.MySQLDialect
    </property>
    <property name="hibernate.show_sql">true</property>
    <property name="current_session_context_class">thread</property>
    <property name="jdbc.batch_size">15</property>
    <mapping resource="Collection/Sort/Team.hbm.xml" />

</session-factory>

</hibernate-configuration>
 
テストコード:
package Collection.Sort;


import java.io.File;
import java.util.Iterator;
import java.util.Set;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class Test {


    public static void main(String[] args) {

        String filePath=System.getProperty("user.dir")+File.separator+"src/Collection/Sort"+File.separator+"hibernate.cfg.xml";
        File file=new File(filePath);
        System.out.println(filePath);
        SessionFactory sessionFactory=new Configuration().configure(file).buildSessionFactory();
        Session session=sessionFactory.openSession();
        Transaction t=session.beginTransaction();
       
        Team team=(Team)session.createQuery("from Team t where t.teamname='team1'").uniqueResult();
        Set result=team.getStudents();
        Iterator iter=result.iterator();
        while(iter.hasNext()){
            System.out.println(iter.next());
        }
       
        t.commit();
       
    }

}
 
実行結果:Hibernate:select team 0_.id as id0_, team0_.teamname as teamname0_ from teamSort team0_ where team0_.teamname='team1' Hibernate: select students0_.team_id as team1_0_, students0_.name as name0_ from studentSort students0_ where students0_.team_id=? a b csort=「natural」はデフォルトで昇順に並べ替えられます.降順に変更する場合は、次のようにクラス実装Comparatorインタフェースを書く必要があります.
package Collection.Sort;

import java.util.Comparator;

public class Compare implements Comparator {

    public int compare(Object o1, Object o2) {
        String s1=(String)o1;
        String s2=(String)o2;
        if(s1.equals(s2)){
            return 0;
        }
        else if(s1.compareTo(s2)>0){
            return -1;
        }
        else{
            return 1;
        }
   
    }

}
 
チームを変更しますhbm.xmlはsort属性sort="Collection.Sort.Compare"を構成してテストコードを再実行し、結果は以下の通りである:Hibernate:select team 0_.id as id0_, team0_.teamname as teamname0_ from teamSort team0_ where team0_.teamname='team1' Hibernate: select students0_.team_id as team1_0_, students0_.name as name0_ from studentSort students0_ where students0_.team_id=? c b a