create ? table ?teamOrder?(id? varchar ( 32 ),teamname? varchar ( 32 ));
create ? table ?studentOrder?(id? varchar ( 32 ),name? varchar ( 32 ),description? varchar ( 32 ),team_id? varchar ( 32 ));
insert ? into ?teamOrder? values (" 1 ","team1");
insert ? into ?studentOrder? values (" 1 ","a","a"," 1 ");
insert ? into ?studentOrder? values (" 2 ","b","b"," 1 ");
insert ? into ?studentOrder? values (" 3 ","c","c"," 1 ");

package ?Collection.Order;

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;
}

}



package ?Collection.Order;

public ? class ?Student? ... {
?? private ?String?id;
?? private ?String?name;
?? private ?String?description;
?? private ?Team?team;
public ?String?getId()? ... {
???? return ?id;
}
public ? void ?setId(String?id)? ... {
???? this .id? = ?id;
}
public ?String?getName()? ... {
???? return ?name;
}
public ? void ?setName(String?name)? ... {
???? this .name? = ?name;
}
public ?String?getDescription()? ... {
???? return ?description;
}
public ? void ?setDescription(String?description)? ... {
???? this .description? = ?description;
}

public ?Team?getTeam()? ... {
???? return ?team;
}
public ? void ?setTeam(Team?team)? ... {
???? this .team? = ?team;
}
}

<? 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/Order/Student.hbm.xml" ? />
???? < mapping? resource ="Collection/Order/Team.hbm.xml" ? />




</ session-factory >

</ hibernate-configuration >

<? 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.Order.Student" ?table ="studentOrder" ? >
???? < id? name ="id" ?unsaved-value ="null" >
?????? < generator? class ="uuid.hex" ></ generator >
???? </ id >
??
???? < property? name ="name" ?type ="string" ?column ="name" ></ property >
???
???? < property? name ="description" ?type ="string" ?column ="description" ></ property > ?
???? < many-to-one? name ="team" ?
?????????????????column ="team_id"
?????????????????class ="Collection.Order.Team" ?
?????????????????cascade ="none" ?
?????????????????fetch ="join" >
???? </ many-to-one >
</ class >

</ hibernate-mapping >

<? 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.Order.Team" ?table ="teamOrder" ? >
???? < id? name ="id" ?unsaved-value ="null" >
?????? < generator? class ="uuid.hex" ></ generator >
???? </ id >
???? < property? name ="teamname" ?type ="string" ?column ="teamname" ></ property >
???? <!-- ?以名稱降序返回student集合? -->
???? < set? name ="students" ?table ="studentOrder" ?cascade ="all" ?order-by ="name?desc" >
?????? < key? column ="team_id" ></ key >
?????? < one-to-many? class ="Collection.Order.Student" />
???? </ set >
</ class >

</ hibernate-mapping >

package ?Collection.Order;


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;