Hibernate Map映射的composite-index案例

CREATE   TABLE  `team3` (
  `id`  varchar ( 50 )  NOT   NULL ,
  `name`  varchar ( 50 )  default   NULL ,
   PRIMARY   KEY   (`id`)
) ENGINE = InnoDB  DEFAULT  CHARSET = gb2312;

CREATE   TABLE  `member3` (
  `id`  varchar ( 50 )  NOT   NULL ,
  `name`  varchar ( 50 )  default   NULL ,
  `age`  varchar ( 50 )  default   NULL ,
  `role`  varchar ( 50 )  default   NULL ,
  `scene`  varchar ( 50 )  default   NULL ,
  `team`  varchar ( 50 )  default   NULL ,
  `bestChoice`  varchar ( 50 )  default   NULL ,
   PRIMARY   KEY   (`id`)
) ENGINE = InnoDB  DEFAULT  CHARSET = gb2312;

package  mapcompoistindex;

import  java.util.HashMap;
import  java.util.Map;

public   class  Team  ... {
    private  String id;
    private  String name;
    private  Map members = new  HashMap();
public  String getId()  ... {
     return  id;
}
public   void  setId(String id)  ... {
     this .id  =  id;
}


public  Map getMembers()  ... {
     return  members;
}
public   void  setMembers(Map members)  ... {
     this .members  =  members;
}
public  String getName()  ... {
     return  name;
}
public   void  setName(String name)  ... {
     this .name  =  name;
}
}


package  mapcompoistindex;

import  java.util.HashMap;
import  java.util.Map;
import  java.util.Set;

public   class  Member  ... {
    private  String id;
    private  String name;
    private  Position postition;
    private  Team team;
    private  String age;
public  String getAge()  ... {
     return  age;
}
public   void  setAge(String age)  ... {
     this .age  =  age;
}

public  String getName()  ... {
     return  name;
}
public   void  setName(String name)  ... {
     this .name  =  name;
}


public  Position getPostition()  ... {
     return  postition;
}
public   void  setPostition(Position postition)  ... {
     this .postition  =  postition;
}
public  String getId()  ... {
     return  id;
}
public   void  setId(String id)  ... {
     this .id  =  id;
}
public  Team getTeam()  ... {
     return  team;
}
public   void  setTeam(Team team)  ... {
     this .team  =  team;
}




}

package  mapcompoistindex;

public   class  Position  ... {
   private  String role;
   private  String scene;
   private  Member bestChoice;
public  Member getBestChoice()  ... {
     return  bestChoice;
}
public   void  setBestChoice(Member bestChoice)  ... {
     this .bestChoice  =  bestChoice;
}
public  String getRole()  ... {
     return  role;
}
public   void  setRole(String role)  ... {
     this .role  =  role;
}
public  String getScene()  ... {
     return  scene;
}
public   void  setScene(String scene)  ... {
     this .scene  =  scene;
}
}

<? 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  package ="mapcompoistindex" >
     < class  name ="Team"  table ="team3" >
        < id  name ="id"  column ="id" >
          < generator  class ="uuid.hex" ></ generator >
        </ id >
        < property  name ="name"  column ="name" />
        < map  name ="members"  inverse ="false"  cascade ="save-update" >
           < key  column ="team" />
            < composite-index  class ="Position" >
              < key-property  name ="role" ></ key-property >
              < key-property  name ="scene" ></ key-property >
              < key-many-to-one  name ="bestChoice"  class ="Member" ></ key-many-to-one >
            </ composite-index >
            < one-to-many  class ="Member" />
        </ map >
     </ class >
</ hibernate-mapping >


<? xml version="1.0" encoding="utf-8" ?>