864      阿裏雲  技術社區[雲棲]

第九章 關係映射 多對多關聯映射

表設計:

有一張中間表，中間表中有兩張關聯表的外鍵

如：student與teacher

Student:

package cn.framelife.mvc.entity;

import java.util.Set;

public class Student {
	private Integer id;
	private String name;
	private Set<Teacher> teachers;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

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

	public Set<Teacher> getTeachers() {
		return teachers;
	}

	public void setTeachers(Set<Teacher> teachers) {
		this.teachers = teachers;
	}
}

Teacher:

package cn.framelife.mvc.entity;

import java.util.Set;

public class Teacher {
	private Integer id;
	private String name;
	private Set<Student> students;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

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

	public Set<Student> getStudents() {
		return students;
	}

	public void setStudents(Set<Student> students) {
		this.students = students;
	}

}

Student.hbm.xml:

<hibernate-mapping>
    <class name="cn.framelife.hibernate.entity.Student" table="student">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator  />
        </id>
        <property name="name" type="java.lang.String">
            <column name="s_name" length="45" not-null="true" />
        </property>
        <set name="teachers" table="s_t" cascade="all">
        	<key column="student_id"/>
        	<many-to-many column="teacher_id" ></many-to-many>
        </set>
    </class>
</hibernate-mapping>

Teacher.hbm.xml:

<hibernate-mapping>
    <class name="cn.framelife.hibernate.entity.Teacher" table="teacher" catalog="hibernate">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator  />
        </id>
        <property name="name" type="java.lang.String">
            <column name="t_name" length="45" not-null="true" />
        </property>
        <set name="students" table="s_t" >
        	<key column="teacher_id"/>
        	<many-to-many column="student_id" ></many-to-many>
        </set>
    </class>
</hibernate-mapping>

增加：

Student s1 = new Student();
			s1.setName("s10");
			Student s2 = new Student();
			s2.setName("s11");
			
			Set<Teacher> set = new HashSet<Teacher>();
			Teacher t1 = new Teacher();
			t1.setName("t10");
			Teacher t2 = new Teacher();
			t2.setName("t11");
			set.add(t1);
			set.add(t2);
			
			//設置學生與老師的的關係
			s1.setTeachers(set);
			s2.setTeachers(set);
			
			//增加兩個學生，同時會把老師也加到數據庫中
			session.save(s1);
			session.save(s2);

最後更新：2017-04-03 18:52:08

  上一篇： HDU 4316 凸包+半麵相交

  下一篇： 零零總總的麵試題（4）