Hibernate Map映射的index-many-to-many案例

使用Map映射，index部分可以使用组件，也可以使用持久话类，本例使用<index-many-to-many>来实现使用持久话类为map映射定义index

数据库结构：

 

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

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

CREATE   TABLE  `position` (
  `id`  varchar ( 50 )  NOT   NULL ,
  `role`  varchar ( 50 )  NOT   NULL ,
  `scene`  varchar ( 50 )  NOT   NULL ,
  `bestchoice`  varchar ( 50 )  NOT   NULL ) ENGINE = InnoDB  DEFAULT  CHARSET = gb2312;

 
持久话类：

package  mapindexmanytomany;

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

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

public   class  Position  ... {
    private String id;
  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;
}
public String getId() ...{
    return id;
}
public void setId(String id) ...{
    this.id = id;
}
}

映射文件：
其中  <index-many-to-many class="Position" column="id"></index-many-to-many>定义了，数据表Position的主键id值使用Member表的主键数值

 

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

测试代码：

 

public   static   void  main(String[] args)  ... {
        Configuration cfg=new Configuration();
        cfg.configure();
        SessionFactory sf=cfg.buildSessionFactory();
        Session session=sf.openSession();
        Transaction t=session.beginTransaction();

        Team team1=new Team();
        team1.setName("足球队-01");
    
        
        Member m1=new Member();
        m1.setName("张三");
        m1.setAge("11");

        
        Member m2=new Member();
        m2.setName("张四");
        m2.setAge("22");
        
        Position p1=new Position();
        p1.setRole("守门员");
        p1.setScene("上半场");
        p1.setBestChoice(m1);
        
        Position p2=new Position();
        p2.setRole("中后卫");
        p2.setScene("下半场");
        p2.setBestChoice(m2);
        
        team1.getMembers().put(p1, m1);
        team1.getMembers().put(p2, m2);

        

        session.save(p1);
        session.save(p2);
        session.save(team1);

        t.commit();
        System.out.println("success");

    }

运行结果：
Hibernate: insert into member4 (name, age, team, id) values (?, ?, ?, ?)
Hibernate: insert into position (role, scene, bestchoice, id) values (?, ?, ?, ?)
Hibernate: insert into member4 (name, age, team, id) values (?, ?, ?, ?)
Hibernate: insert into position (role, scene, bestchoice, id) values (?, ?, ?, ?)
Hibernate: insert into team4 (name, id) values (?, ?)
Hibernate: update member4 set team=?, id=? where id=?
Hibernate: update member4 set team=?, id=? where id=?