多对多(many-to-many):在操作和性能方面都不太理想,所以多对多的映射使用较少,实际使用中最好转换成一对多的对象模型;hibernate会为我们创建中间关联表,转换成两个一对多。
1. E-R图
2. 实体类:
Teacher实体类如下:
- package com.reiyen.hibernate.domain;
- import java.util.Set;
- public class Teacher {
- private int id;
- private String name;
- private Set<Student> students;
- //setter和getter方法
- }
Student实体类如下:
- package com.reiyen.hibernate.domain;
- import java.util.Set;
- public class Student {
- private int id;
- private String name;
- private Set<Teacher> teachers;
- //setter和getter方法
- }
3.映射文件如下:
Teacher.hbm.xml如下:
- <?xml version="1.0"?>
- <!DOCTYPE hibernate-mapping PUBLIC
- "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
- "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
- <hibernate-mapping package="com.reiyen.hibernate.domain">
- <class name="Teacher">
- <id name="id">
- <generator class="native" />
- </id>
- <property name="name" />
- <!-- 通过table项告诉hibernate中间表的名称 -->
- <set name="students" table="teacher_student">
- <!-- 通过key属性告诉hibernate在中间表里面查询teacher_id值相应的teacher记录 -->
- <key column="teacher_id" />
- <!-- 通过column项告诉hibernate对student表中查找student_id值相就的studnet记录 -->
- <many-to-many class="Student" column="student_id" />
- </set>
- </class>
- </hibernate-mapping>
Student.hbm.xml如下:
-
- <?xml version="1.0"?>
- <!DOCTYPE hibernate-mapping PUBLIC
- "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
- "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
- <hibernate-mapping package="com.reiyen.hibernate.domain">
- <class name="Student" >
- <id name="id" >
- <generator class="native" />
- </id>
- <property name="name" />
- <set name="teachers" table="teacher_student">
- <key column="student_id" />
- <many-to-many class="Teacher" column="teacher_id"/>
- </set>
- </class>
- </hibernate-mapping>
- 一定要注意映射文件中<many-to-many class="Teacher" column="teacher_id"/>中class的值,它必须与你另一个关联映射文件中的class属性的name值一致,其实就是与你的 实体类的类名一致,如:<many-to-many class="Teacher" column="teacher_id"/>中class的值就不能写成"teacher"。如果写成这样的话,就会抛出如下异常:An association from the table teacher_student refers to an unmapped class: com.reiyen .hibernate.domain.teacher