hibernate多对多映射

需求：在员工和权限的设置权衡上，员工和权限都是多对多的关系。

员工和权限两张表
Employee.java

package com.ssh.entities;

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

public class Employee {
    private Integer id;
    private String name;
    private String pwd;
    private Integer money;
    private String role; //角色
    private String remark;
    //权限的集合
    private Set<Privilege> privileges = new HashSet<Privilege>();

    public Employee() {
        super();
    }
    public Employee(String name, String pwd, Integer money, String role, String remark) {
        super();
        this.name = name;
        this.pwd = pwd;
        this.money = money;
        this.role = role;
        this.remark = remark;
    }
    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 String getPwd() {
        return pwd;
    }
    public void setPwd(String pwd) {
        this.pwd = pwd;
    }
    public Integer getMoney() {
        return money;
    }
    public void setMoney(Integer money) {
        this.money = money;
    }
    public String getRole() {
        return role;
    }
    public void setRole(String role) {
        this.role = role;
    }
    public String getRemark() {
        return remark;
    }
    public void setRemark(String remark) {
        this.remark = remark;
    }
    public Set<Privilege> getPrivileges() {
        return privileges;
    }
    public void setPrivileges(Set<Privilege> privileges) {
        this.privileges = privileges;
    }

}

Employee.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">
<!-- Generated 2015-4-22 11:04:17 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
    <class name="com.ssh.entities.Employee" table="EMPLOYEE">
        <id name="id" type="java.lang.Integer">
            <column name="ID" />
            <generator class="native" />
        </id>
        <property name="name" type="java.lang.String">
            <column name="NAME" />
        </property>
        <property name="pwd" type="java.lang.String">
            <column name="PWD" />
        </property>
        <property name="money" type="java.lang.Integer">
            <column name="MONEY" />
        </property>
        <property name="role" type="java.lang.String">
            <column name="ROLE" />
        </property>
        <property name="remark" type="java.lang.String">
            <column name="REMARK" />
        </property>
        <set name="privileges" table="EMPLOYEE_PRIVILEGE" >
            <key column="employeeId"></key>
            <many-to-many class="com.ssh.entities.Privilege" column="privilegeId"></many-to-many>
        </set>
    </class>
</hibernate-mapping>

注意：Employee.hbm.xml中通过inverse=”false”来设置关联关系由employee维护，true代表放弃维护，Employee和Privilege只能有一个将inverse字段设置成false。

Privilege.java

package com.ssh.entities;

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

/**
* 权限类
*/
public class Privilege {
private Integer id;
private String name; // 权限名称

private Set<Employee> emps = new HashSet<Employee>();

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<Employee> getEmps() {
    return emps;
}
public void setEmps(Set<Employee> emps) {
    this.emps = emps;
}

}

Privilege.hbm.xml

测试：

    Privilege privilege1 = new Privilege();
    privilege1.setName("风控设置");
    Privilege privilege2 = new Privilege();
    privilege2.setName("划拨请求");
    Employee employee1 = new Employee("tg", "1", 100, "tg", "投顾");
    privilege1.getEmps().add(employee1);
    privilege2.getEmps().add(employee1);
    employee1.getPrivileges().add(privilege1);
    employee1.getPrivileges().add(privilege2);
    privilegeService.save(privilege1);
    privilegeService.save(privilege2);
    employeeService.saveOrUpdate(employee1);

    Privilege privilege3 = new Privilege();
    privilege3.setName("审核");
    Employee employee2 = new Employee("sh", "1", -1, "sh", "审核");
    privilege1.getEmps().add(employee1);
    employee2.getPrivileges().add(privilege3);
    privilegeService.save(privilege3);
    employeeService.saveOrUpdate(employee2);

    Privilege privilege4 = new Privilege();
    privilege4.setName("批准");
    Employee employee3 = new Employee("cp", "1", 100, "cp", "产品经理");
    privilege4.getEmps().add(employee1);
    employee3.getPrivileges().add(privilege4);
    privilegeService.save(privilege4);
    employeeService.saveOrUpdate(employee3);

“`
现象：
Hibernate:
insert
into
PRIVILEGE
(NAME)
values
(?)
Hibernate:
insert
into
PRIVILEGE
(NAME)
values
(?)
Hibernate:
insert
into
EMPLOYEE
(NAME, PWD, MONEY, ROLE, REMARK)
values
(?, ?, ?, ?, ?)
Hibernate:
insert
into
EMPLOYEE_PRIVILEGE
(employeeId, privilegeId)
values
(?, ?)
Hibernate:
insert
into
EMPLOYEE_PRIVILEGE
(employeeId, privilegeId)
values
(?, ?)
Hibernate:
insert
into
PRIVILEGE
(NAME)
values
(?)
Hibernate:
insert
into
EMPLOYEE
(NAME, PWD, MONEY, ROLE, REMARK)
values
(?, ?, ?, ?, ?)
Hibernate:
insert
into
EMPLOYEE_PRIVILEGE
(employeeId, privilegeId)
values
(?, ?)
Hibernate:
insert
into
PRIVILEGE
(NAME)
values
(?)
Hibernate:
insert
into
EMPLOYEE
(NAME, PWD, MONEY, ROLE, REMARK)
values
(?, ?, ?, ?, ?)
Hibernate:
insert
into
EMPLOYEE_PRIVILEGE
(employeeId, privilegeId)
values
(?, ?)

说明：
hibernate自动创建三个表
employee 员工表
employee_privilege 关联表
privilege 权限表

end