Hibernate的many-to-many多对多关系

一 举例

学生<--->课程

顾客<--->商品

qq<--->qq群

二 架构图——学生选课

三 实例——学生选课

1 domain类

1.1 Course

package com.hsp.domain;
import java.util.Set;
public class Course {
        private Integer id;
        private String name;
        private Set<StuCourse> stuCourses;
        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<StuCourse> getStuCourses() {
                return stuCourses;
        }
        public void setStuCourses(Set<StuCourse> stuCourses) {
                this.stuCourses = stuCourses;
        }
}

1.2 Student

package com.hsp.domain;
import java.util.Set;
public class Student {
        private Integer id;
        private String name;
        private Set<StuCourse> stuCourses;
        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<StuCourse> getStuCourses() {
                return stuCourses;
        }
        public void setStuCourses(Set<StuCourse> stuCourses) {
                this.stuCourses = stuCourses;
        }
}

1.3 StuCourse

package com.hsp.domain;
public class StuCourse {
        private Integer id;
        private Student student;
        private Course course;
        private Integer grade;
        public Integer getId() {
                return id;
        }
        public void setId(Integer id) {
                this.id = id;
        }
        public Student getStudent() {
                return student;
        }
        public void setStudent(Student student) {
                this.student = student;
        }
        public Course getCourse() {
                return course;
        }
        public void setCourse(Course course) {
                this.course = course;
        }
        public Integer getGrade() {
                return grade;
        }
        public void setGrade(Integer grade) {
                this.grade = grade;
        }
}

2 配置文件

2.1 Course.hbm.xml

<?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";>
<hibernate-mapping package="com.hsp.domain">
<class name="Course">
<id name="id" type="java.lang.Integer">
<generator class="increment">
</generator>
</id>
<property name="name" type="java.lang.String">
<column name="name" length="64"/>
</property>
<!-- 配置one-to-many 表示一门课程可以对应多个选课记录 -->
<set name="stuCourses">
<key column="course_id"/>
<one-to-many class="StuCourse"/>
</set>
</class>
</hibernate-mapping>

2.2 Student.hbm.xml

<?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";>
<hibernate-mapping package="com.hsp.domain">
<class name="Student">
<id name="id" type="java.lang.Integer">
<generator class="increment">
</generator>
</id>
<property name="name" type="java.lang.String">
<column name="name" length="64"/>
</property>
<!-- 这里我们配置了one-to-many 一个学生可以对应多个选课记录 -->
<set name="stuCourses">
<key column="student_id"/>
<one-to-many class="StuCourse"/>
</set>
</class>
</hibernate-mapping>

2.3 StuCourse.hbm.xml

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd";>
<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>
<session-factory>
                <property name="dialect">
                        org.hibernate.dialect.MySQLDialect
                </property>
                <property name="connection.url">
                        jdbc:mysql://localhost:3306/users
                </property>
                <property name="connection.username">root</property>
                <property name="connection.password">waDY820828</property>
                <property name="connection.driver_class">
                        org.gjt.mm.mysql.Driver
                </property>
        <property name="show_sql">true</property>
        <!-- 配置让hibernate自动创建关系模型(表) -->
        <property name="hbm2ddl.auto">update</property>
        <mapping resource="com/hsp/domain/Course.hbm.xml" />
        <mapping resource="com/hsp/domain/StuCourse.hbm.xml" />
        <mapping resource="com/hsp/domain/Student.hbm.xml" />
</session-factory>
</hibernate-configuration>

3 测试代码

package com.hsp.view;
import java.util.Date;
import java.util.HashSet;
import java.util.Set;
import org.hibernate.Hibernate;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.hsp.domain.Course;
import com.hsp.domain.StuCourse;
import com.hsp.domain.Student;
import com.hsp.util.HibernateUtil;
public class TestMain {
    /**
     * @param args
     */
    public static void main(String[] args) {
        Session s=null;
        Transaction tx=null;
        try {
            //我们使用基础模板来讲解.
            s=HibernateUtil.getCurrentSession();
            tx=s.beginTransaction();
            //添加一个学生，一门课程，选课
            Student stu1=new Student();
            stu1.setName("小明");    
            Course course=new Course();
            course.setName("java");
            StuCourse sc=new StuCourse();
            sc.setCourse(course);
            sc.setStudent(stu1);
            //顺序保存.
            s.save(stu1);
            s.save(course);
            s.save(sc);
            tx.commit();
        } catch (Exception e) {
            e.printStackTrace();
            if(tx!=null){
                tx.rollback();
            }
        }finally{
            
            if(s!=null && s.isOpen()){
                s.close();
            }
        }
    }
}

4 测试结果

Hibernate: select max(id) from Student

Hibernate: select max(id) from Course

Hibernate: select max(id) from StuCourse

Hibernate: insert into Student (name, id) values (?, ?)

Hibernate: insert into Course (name, id) values (?, ?)

Hibernate: insert into StuCourse (grade, course_id, student_id, id) values (?, ?, ?, ?)