Hibernate多对多关联映射主要是通过一张中间表进行设置,把两个表的标识记录项添加到中间表中进行关联,如下图所示:
系统权限类:
public class SystemPrivilege { private String id; private String name; private Set<PrivilegeGroup> groups = new HashSet<PrivilegeGroup>(); public Set<PrivilegeGroup> getGroups() { return groups; } public void setGroups(Set<PrivilegeGroup> groups) { this.groups = groups; } public String getId() { return id; } public void setId(String id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } }
系统权限组类:
public class PrivilegeGroup { private String groupid; private String name; public String getGroupid() { return groupid; } public void setGroupid(String groupid) { this.groupid = groupid; } public String getName() { return name; } public void setName(String name) { this.name = name; } }
完成单向多对多的关联映射只要在系统权限类的映射文件中进行如下配置即可:
<set name="groups" table="t_privilege_groups"> <key column="privilege_id"/> <many-to-many class="com.itzhai.bean.privilege.PrivilegeGroup" column="group_id" /> </set>
其中的t_privilege_groups为中间表,privilege和group_id为中间表包含的字段。
如果要设置成双向关联,则还需要在系统权限组类中添加一个指向系统权限的集合:
private Set<SystemPrivilege> privileges = new HashSet<SystemPrivilege>(); public Set<SystemPrivilege> getPrivileges() { return privileges; } public void setPrivileges(Set<SystemPrivilege> privileges) { this.privileges = privileges; }
然后在系统权限组类的映射文件中添加如下配置:
<set name="privileges" table="t_privilege_groups"> <key column="group_id" not-null="true"/> <many-to-many class="com.itzhai.bean.privilege.SystemPrivilege" column="privilege_id"/> </set>