Hibernate多对多关联关系

项目和员工关系一个项目需要多个员工参与，一位员工可能参与多个项目

单向多对多关联

1.创建Project(项目)和Employee(员工)持久化类
2.建立Project(项目)和Employee(员工)的单向多对多关联
3.验证对象的持久化方法

package com.pojo;

import java.io.Serializable;
import java.util.HashSet;
import java.util.Set;

public class Project implements Serializable {
    private Integer proid;
    private String proName;
    private Set<Employee> employees = new HashSet<>();

    public Project() {
    }

    public Project(Integer proid, String proName, Set<Employee> employees) {
        this.proid = proid;
        this.proName = proName;
        this.employees = employees;
    }

    public Integer getProid() {
        return proid;
    }

    public void setProid(Integer proid) {
        this.proid = proid;
    }

    public String getProName() {
        return proName;
    }

    public void setProName(String proName) {
        this.proName = proName;
    }

    public Set<Employee> getEmployees() {
        return employees;
    }

    public void setEmployees(Set<Employee> employees) {
        this.employees = employees;
    }

    @Override
    public String toString() {
        return "Project{" +
                "proid=" + proid +
                ", proName='" + proName + '\'' +
                ", employees=" + employees +
                '}';
    }
}

package com.pojo;

import java.io.Serializable;

public class Employee implements Serializable {
    private Integer empid;
    private String empName;

    public Employee() {
    }

    public Employee(Integer empid, String empName) {
        this.empid = empid;
        this.empName = empName;
    }

    public Integer getEmpid() {
        return empid;
    }

    public void setEmpid(Integer empid) {
        this.empid = empid;
    }

    public String getEmpName() {
        return empName;
    }

    public void setEmpName(String empName) {
        this.empName = empName;
    }

    @Override
    public String toString() {
        return "Employee{" +
                "empid=" + empid +
                ", empName='" + empName + '\'' +
                '}';
    }
}

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="com.pojo.Project" table="pro" catalog="project">
        <id name="proid" type="java.lang.Integer" column="proid">
            <generator class="assigned"></generator>
        </id>
        <property name="proName" type="java.lang.String" column="proName"></property>
        <set name="employees" table="proemp" cascade="save-update">
            <key column="RPROID"></key>
            <many-to-many class="com.pojo.Employee" column="REMPID"></many-to-many>
        </set>
    </class>
</hibernate-mapping>

<set>元素

table属性指定关系表的名称为proemp
cascade属性“save-update”表明保存或更新Project对象时，会级联保存或更新与它有关的Employee对象

<key>元素

column属性指定proemp表的外键RPROID，用来参照pro表

<many-to-many>元素

class属性指定employess集合中存放的是Employee对象
cloumn属性指定proemp表的外键REMPID,用来参照employee表

总结
对于多对多关联，cascade属性设为"save-update"，如果设置为"all",如果删除一个Project对象会级联删除与他关联的所有Employee对象，显然这是不合理的。

public void save(Project project)
    {
        this.getCurrentSession().save(project);
    }

 public void save()
    {
        //创建两个项目
        Project project1=new Project();
        project1.setProid(1);
        project1.setProName("项目1");
        Project project2=new Project();
        project2.setProid(2);
        project2.setProName("项目2");
        //创建三个员工
        Employee employee1=new Employee(1,"张三");
        Employee employee2=new Employee(2,"李四");
        Employee employee3=new Employee(3,"王五");
        //进行单向多对多关联
        project1.getEmployees().add(employee1);
        project1.getEmployees().add(employee2);
        project2.getEmployees().add(employee1);
        project2.getEmployees().add(employee2);
        project2.getEmployees().add(employee3);
        proBiz.save(project1);
        proBiz.save(project2);

    }

Hibernate:
select
employee_.empid,
employee_.empName as empName4_
from
project.employee employee_
where
employee_.empid=?
Hibernate:
select
employee_.empid,
employee_.empName as empName4_
from
project.employee employee_
where
employee_.empid=?
Hibernate:
insert
into
project.pro
(proName, proid)
values
(?, ?)
Hibernate:
insert
into
project.employee
(empName, empid)
values
(?, ?)
Hibernate:
insert
into
project.employee
(empName, empid)
values
(?, ?)
Hibernate:
insert
into
proemp
(RPROID, REMPID)
values
(?, ?)
Hibernate:
insert
into
proemp
(RPROID, REMPID)
values
(?, ?)
Hibernate:
select
employee_.empid,
employee_.empName as empName4_
from
project.employee employee_
where
employee_.empid=?
Hibernate:
select
employee_.empid,
employee_.empName as empName4_
from
project.employee employee_
where
employee_.empid=?
Hibernate:
select
employee_.empid,
employee_.empName as empName4_
from
project.employee employee_
where
employee_.empid=?
Hibernate:
insert
into
project.pro
(proName, proid)
values
(?, ?)
Hibernate:
insert
into
project.employee
(empName, empid)
values
(?, ?)
Hibernate:
insert
into
proemp
(RPROID, REMPID)
values
(?, ?)
Hibernate:
insert
into
proemp
(RPROID, REMPID)
values
(?, ?)
Hibernate:
insert
into
proemp
(RPROID, REMPID)
values
(?, ?)

总结
首先根据主键生成策略的assigned根据编号查询是否存在该员工的，之后向pro表中插入一条记录，也向employee插入一条记录，同时向中间表proemp表插入一条记录，由于与project2对象关联的employee1和employee2对象已经保存到employee表中所以不再向employee表插入记录。

双向多对多关联

1.Employee(员工)持久化类
2.建立Employee(员工)和Project(项目)的单向多对多关联
3.验证对象的持久化方法

package com.pojo;

import java.io.Serializable;
import java.util.HashSet;
import java.util.Set;

public class Employee implements Serializable {
    private Integer empid;
    private String empName;
    private Set<Project> projects=new HashSet<>();

    public Employee() {
    }

    public Employee(Integer empid, String empName) {
        this.empid = empid;
        this.empName = empName;
    }

    public Employee(Integer empid, String empName, Set<Project> projects) {
        this.empid = empid;
        this.empName = empName;
        this.projects = projects;
    }

    public Integer getEmpid() {
        return empid;
    }

    public void setEmpid(Integer empid) {
        this.empid = empid;
    }

    public String getEmpName() {
        return empName;
    }

    public void setEmpName(String empName) {
        this.empName = empName;
    }

    public Set<Project> getProjects() {
        return projects;
    }

    public void setProjects(Set<Project> projects) {
        this.projects = projects;
    }

    @Override
    public String toString() {
        return "Employee{" +
                "empid=" + empid +
                ", empName='" + empName + '\'' +
                ", projects=" + projects +
                '}';
    }
}

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="com.pojo.Employee" table="employee" catalog="project">
        <id name="empid" type="java.lang.Integer" column="empid">
            <generator class="assigned"></generator>
        </id>
        <property name="empName" type="java.lang.String" column="empName"></property>
        <set name="projects" table="proemp" inverse="true">
            <key column="REMPID"></key>
            <many-to-many class="com.pojo.Project" column="RPROID"></many-to-many>
        </set>
    </class>
</hibernate-mapping>

总结
对于双向多对多关联的两端，需要把其中的一端的<set>元素的inverse属性设置为"true"。

public void save()
    {
        //创建两个项目
        Project project1=new Project();
        project1.setProid(1);
        project1.setProName("项目1");
        Project project2=new Project();
        project2.setProid(2);
        project2.setProName("项目2");
        //创建三个员工
        Employee employee1=new Employee(1,"张三");
        Employee employee2=new Employee(2,"李四");
        Employee employee3=new Employee(3,"王五");
        //进行双向多对多关联
        
        project1.getEmployees().add(employee1);
        project1.getEmployees().add(employee2);
        
        project2.getEmployees().add(employee1);
        project2.getEmployees().add(employee2);
        project2.getEmployees().add(employee3);

        employee1.getProjects().add(project1);
        employee1.getProjects().add(project2);

        employee2.getProjects().add(project1);
        employee2.getProjects().add(project2);

        employee3.getProjects().add(project2);

        proBiz.save(project1);
        proBiz.save(project2);

    }

Hibernate:
select
employee_.empid,
employee_.empName as empName4_
from
project.employee employee_
where
employee_.empid=?
Hibernate:
select
employee_.empid,
employee_.empName as empName4_
from
project.employee employee_
where
employee_.empid=?
Hibernate:
insert
into
project.pro
(proName, proid)
values
(?, ?)
Hibernate:
insert
into
project.employee
(empName, empid)
values
(?, ?)
Hibernate:
insert
into
project.employee
(empName, empid)
values
(?, ?)
Hibernate:
insert
into
proemp
(RPROID, REMPID)
values
(?, ?)
Hibernate:
insert
into
proemp
(RPROID, REMPID)
values
(?, ?)
Hibernate:
select
employee_.empid,
employee_.empName as empName4_
from
project.employee employee_
where
employee_.empid=?
Hibernate:
select
employee_.empid,
employee_.empName as empName4_
from
project.employee employee_
where
employee_.empid=?
Hibernate:
select
employee_.empid,
employee_.empName as empName4_
from
project.employee employee_
where
employee_.empid=?
Hibernate:
insert
into
project.pro
(proName, proid)
values
(?, ?)
Hibernate:
insert
into
project.employee
(empName, empid)
values
(?, ?)
Hibernate:
insert
into
proemp
(RPROID, REMPID)
values
(?, ?)
Hibernate:
insert
into
proemp
(RPROID, REMPID)
values
(?, ?)
Hibernate:
insert
into
proemp
(RPROID, REMPID)
values
(?, ?)

最后编辑于：2019.11.23 01:10:22

人面猴
序言：七十年代末，一起剥皮案震惊了整个滨河市，随后出现的几起案子，更是在滨河造成了极大的恐慌，老刑警刘岩，带你破解...
沈念sama阅读 217,657评论 6赞 505
死咒
序言：滨河连续发生了三起死亡事件，死亡现场离奇诡异，居然都是意外死亡，警方通过查阅死者的电脑和手机，发现死者居然都...
沈念sama阅读 92,889评论 3赞 394
救了他两次的神仙让他今天三更去死
文/潘晓璐我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
开封第一讲书人阅读 164,057评论 0赞 354
道士缉凶录：失踪的卖姜人
文/不坏的土叔我叫张陵，是天一观的道长。经常有香客问我，道长，这世上最难降的妖魔是什么？我笑而不...
开封第一讲书人阅读 58,509评论 1赞 293
港岛之恋（遗憾婚礼）
正文为了忘掉前任，我火速办了婚礼，结果婚礼上，老公的妹妹穿的比我还像新娘。我一直安慰自己，他们只是感情好，可当我...
茶点故事阅读 67,562评论 6赞 392
恶毒庶女顶嫁案：这布局不是一般人想出来的
文/花漫我一把揭开白布。她就那样静静地躺着，像睡着了一般。火红的嫁衣衬着肌肤如雪。梳的纹丝不乱的头发上，一...
开封第一讲书人阅读 51,443评论 1赞 302
城市分裂传说
那天，我揣着相机与录音，去河边找鬼。笑死，一个胖子当着我的面吹牛，可吹牛的内容都是我干的。我是一名探鬼主播，决...
沈念sama阅读 40,251评论 3赞 418
双鸳鸯连环套：你想象不到人心有多黑
文/苍兰香墨我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
开封第一讲书人阅读 39,129评论 0赞 276
万荣杀人案实录
序言：老挝万荣一对情侣失踪，失踪者是张志新（化名）和其女友刘颖，没想到半个月后，有当地人在树林里发现了一具尸体，经...
沈念sama阅读 45,561评论 1赞 314
护林员之死
正文独居荒郊野岭守林人离奇死亡，尸身上长有42处带血的脓包…… 初始之章·张勋以下内容为张勋视角年9月15日...
茶点故事阅读 37,779评论 3赞 335
白月光启示录
正文我和宋清朗相恋三年，在试婚纱的时候发现自己被绿了。大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
茶点故事阅读 39,902评论 1赞 348
活死人
序言：一个原本活蹦乱跳的男人离奇死亡，死状恐怖，灵堂内的尸体忽然破棺而出，到底是诈尸还是另有隐情，我是刑警宁泽，带...
沈念sama阅读 35,621评论 5赞 345
日本核电站爆炸内幕
正文年R本政府宣布，位于F岛的核电站，受9级特大地震影响，放射性物质发生泄漏。R本人自食恶果不足惜，却给世界环境...
茶点故事阅读 41,220评论 3赞 328
男人毒药：我在死后第九天来索命
文/蒙蒙一、第九天我趴在偏房一处隐蔽的房顶上张望。院中可真热闹，春花似锦、人声如沸。这庄子的主人今日做“春日...
开封第一讲书人阅读 31,838评论 0赞 22
一桩弑父案，背后竟有这般阴谋
文/苍兰香墨我抬头看了看天上的太阳。三九已至，却和暖如春，着一层夹袄步出监牢的瞬间，已是汗流浃背。一阵脚步声响...
开封第一讲书人阅读 32,971评论 1赞 269
情欲美人皮
我被黑心中介骗来泰国打工，没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留，地道东北人。一个月前我还...
沈念sama阅读 48,025评论 2赞 370
代替公主和亲
正文我出身青楼，却偏偏与公主长得像，于是被迫代替她去往敌国和亲。传闻我的和亲对象是个残疾皇子，可洞房花烛夜当晚...
茶点故事阅读 44,843评论 2赞 354

Hibernate多对多关联关系

推荐阅读更多精彩内容