Hibernate多对多

最新推荐文章于 2020-05-14 17:38:11 发布

chici7332

最新推荐文章于 2020-05-14 17:38:11 发布

阅读量34

点赞数

原文链接：https://my.oschina.net/u/3848699/blog/2243637

版权

1.单向多对多

例如，一个学生可以有多门课程，，一个课程有多名学生选择

Student.java

package com.java.model;

import java.util.HashSet;
import java.util.Set;

public class Student {
	private int id;
	private String name;
	private Set<Course> courses=new HashSet<Course>();
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Set<Course> getCourses() {
		return courses;
	}
	public void setCourses(Set<Course> courses) {
		this.courses = courses;
	}
	
}

Student.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.java.model">
  <class name="Student" table="t_student">
  
		<id name="id" column="studentId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="studentName"></property>
		
		<!-- 借助第三张中间表student_course实现多对多 -->
		<!-- cascade="save-update"级联更新 -->
		
		<set name="courses" table="student_course" cascade="save-update">
		<!--key，中间表student_course的一个外键属性student_id，关联学生表的主键 -->
			<key column="student_id"></key>
			<!--student_course的外键course_id关联Course表的主键id  -->
			<many-to-many class="com.java.model.Course" column="course_id"></many-to-many>
		</set>
		
	</class>
</hibernate-mapping>

Course.java

package com.java.model;

public class Course {
	private int id;
	private String name;
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	
}

Course.hbm.xml

单向，可以通过学生获取课程，不能通过课程获取学生信息

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.java.model">
<!-- 单向多对一，这里不用配置 -->
  	<class name="Course" table="t_course">
		<id name="id" column="courseId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="courseName"></property>
		
	</class>
</hibernate-mapping>

hibernate.cfg.xml

          <mapping resource="com/java/model/Student.hbm.xml"/>
	  <mapping resource="com/java/model/Course.hbm.xml"/>

StudentTset.java

package com.java.service;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.java.util.HibernateUtil;

public class StudentTset {

	private SessionFactory sessionFactory=HibernateUtil.getSessionFactory();
	private Session session;
	
	@Before
	public void setUp() throws Exception {
		session=sessionFactory.openSession(); // 生成一个session
	    session.beginTransaction(); // 开启事务
	}

	@After
	public void tearDown() throws Exception {
		 session.getTransaction().commit(); // 提交事务
		 session.close(); // 关闭session
	}
	@Test
	public void testSave1(){
	}
	
}

数据库生成的单向多对多的表结构

StudentTset.java添加数据

	@Test
	public void testSave1(){
		Course course1=new Course();
		course1.setName("语文");
		
		Course course2=new Course();
		course2.setName("数学");
		
                //创建学生1保存两门程
		Student student1=new Student();
		student1.setName("张三");
		student1.getCourses().add(course1);
		student1.getCourses().add(course2);
		 //创建学生2保存两门程
		Student student2=new Student();
		student2.setName("李四");
		student2.getCourses().add(course1);
		student2.getCourses().add(course2);
		//多对多单向，数据持久化
		session.save(student1);
		session.save(student2);
	}

取id=1的学生选修的课程，

因为是单向，只能

StudentTset.java取数据

	
	@Test
	public void testLoad1(){
		Student student=(Student)session.get(Student.class, 1);
		Set<Course> courses=(Set<Course>)student.getCourses();
		Iterator it=courses.iterator();
		while(it.hasNext()){
			Course c=(Course)it.next();
			System.out.println(c.getName());
		}
	}

二、多对多双向

Student2.java

package com.java.model;

import java.util.HashSet;
import java.util.Set;

public class Student2 {
	private int id;
	private String name;
	private Set<Course2> courses=new HashSet<Course2>();
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Set<Course2> getCourses() {
		return courses;
	}
	public void setCourses(Set<Course2> courses) {
		this.courses = courses;
	}

	
}

Student2.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.java.model">
  <class name="Student2" table="t_student2">
  
		<id name="id" column="studentId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="studentName"></property>
		
		<!-- 借助第三张中间表student_course实现多对多 -->
		<!-- cascade="save-update"级联更新 -->
		
		<set name="courses" table="student_course2" cascade="save-update">
		<!--key，中间表student_course的一个外键属性student_id，关联学生表的主键 -->
			<key column="student_id"></key>
			<!--student_course的外键course_id关联Course表的主键id  -->
			<many-to-many class="com.java.model.Course2" column="course_id"></many-to-many>
		</set>
		
	</class>
</hibernate-mapping>

Course2.java

package com.java.model;

import java.util.HashSet;
import java.util.Set;

public class Course2 {
	private int id;
	private String name;
	private Set<Student2> students=new HashSet<Student2>();
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Set<Student2> getStudents() {
		return students;
	}
	public void setStudents(Set<Student2> students) {
		this.students = students;
	}
	
}

Course2.hbm.xml

双向，可以通过学生获取课程，也能通过课程获取学生信息

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.java.model">
<!-- 单向多对一，这里不用配置 -->
  	<class name="Course2" table="t_course2">
		<id name="id" column="courseId">
			<generator class="native"></generator>
		</id>
		
		<property name="name" column="courseName"></property>
		<!-- 由学生端维护两张表之间的关系 -->
		<set name="students" table="student_course2" inverse="true" >
			<key column="course_id"></key>
			<many-to-many class="com.java.model.Student2" column="student_id"></many-to-many>
		</set>
		
	</class>
</hibernate-mapping>

hibernate.cfg.xml

          <mapping resource="com/java/model/Student2.hbm.xml"/>
	  <mapping resource="com/java/model/Course2.hbm.xml"/>

StudentTset.java

package com.java.service;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import com.java.util.HibernateUtil;

public class StudentTset {

	private SessionFactory sessionFactory=HibernateUtil.getSessionFactory();
	private Session session;
	
	@Before
	public void setUp() throws Exception {
		session=sessionFactory.openSession(); // 生成一个session
	    session.beginTransaction(); // 开启事务
	}

	@After
	public void tearDown() throws Exception {
		 session.getTransaction().commit(); // 提交事务
		 session.close(); // 关闭session
	}
	@Test
	public void testSave2(){
	}
	
}

数据库生成的双向多对多的表结构

存数据

StudentTset.java

@Test
	public void testSave2(){
		Course2 course1=new Course2();
		course1.setName("语文");
		
		Course2 course2=new Course2();
		course2.setName("数学");
		
		Student2 student1=new Student2();
		student1.setName("张三");
		student1.getCourses().add(course1);
		student1.getCourses().add(course2);
		
		Student2 student2=new Student2();
		student2.setName("李四");
		student2.getCourses().add(course1);
		student2.getCourses().add(course2);
		
		session.save(student1);
		session.save(student2);
	}

取数据，通过课程获取学生

        @Test
	public void testLoad2(){
		Course2 course=(Course2)session.get(Course2.class, 1);
		Set<Student2> students=(Set<Student2>)course.getStudents();
		Iterator it=students.iterator();
		while(it.hasNext()){
			Student2 s=(Student2)it.next();
			System.out.println(s.getName());
		}
		
	}

转载于:https://my.oschina.net/u/3848699/blog/2243637

chici7332

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Hibernate多对多

1.单向多对多例如，一个学生可以有多门课程，，一个课程有多名学生选择 Student.java package com.java.model;import java.util.HashSet;import java.util.Set;public class Stu...
复制链接

扫一扫