Hibernate多对多映射

最新推荐文章于 2020-08-26 21:16:46 发布

cuisea

最新推荐文章于 2020-08-26 21:16:46 发布

阅读量1.5k

点赞数

分类专栏： Hibernate 文章标签： hibernate integer insert class string generator

本文链接：https://blog.csdn.net/cuihaiyang/article/details/6317900

版权

Hibernate 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

以前做过使用JPA注解实现多对多映射的示例，在这里使用配置文件再做个小示例。仍然以角色（Role）和权限（Privilege）为例演示：

Role.java

package com.petrochina; import java.util.HashSet; import java.util.Set; public class Role { private Integer id; private String name; private Set<Privilege> privileges=new HashSet<Privilege>(); 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<Privilege> getPrivileges() { return privileges; } public void setPrivileges(Set<Privilege> privileges) { this.privileges = privileges; } }

Privilege.java

package com.petrochina; import java.util.HashSet; import java.util.Set; public class Privilege { private Integer id; private String name; private Set<Role> roles=new HashSet<Role>(); 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<Role> getRoles() { return roles; } public void setRoles(Set<Role> roles) { this.roles = roles; } }

Role.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> <class name="com.petrochina.Role" table="t_role" dynamic-update="true" dynamic-insert="true"> <id name="id" type="java.lang.Integer"> <generator class="native" /> </id> <property name="name" type="java.lang.String"/> <set name="privileges" table="t_role_privilege" inverse="false"> <key column="role_id"></key> <many-to-many class="com.petrochina.Privilege" column="privilege_id"></many-to-many> </set> </class> </hibernate-mapping>

Privilege.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> <class name="com.petrochina.Privilege" table="t_privilege" dynamic-update="true" dynamic-insert="true"> <id name="id" type="java.lang.Integer"> <generator class="native" /> </id> <property name="name" type="java.lang.String"/> <set name="roles" table="t_role_privilege" inverse="true"> <key column="privilege_id"></key> <many-to-many class="com.petrochina.Role" column="role_id"></many-to-many> </set> </class> </hibernate-mapping>

hibernate.cfg.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">  <hibernate-configuration> <session-factory> <property name="connection.username">cui</property> <property name="connection.url">jdbc:oracle:thin:@127.0.0.1:1521:cui</property> <property name="dialect">org.hibernate.dialect.Oracle9Dialect</property> <property name="myeclipse.connection.profile">Oracle_cui</property> <property name="connection.password">cui</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="hibernate.show_sql">true</property> <property name="hibernate.hbm2ddl.auto">update</property> <mapping resource="com/petrochina/Role.hbm.xml" /> <mapping resource="com/petrochina/Privilege.hbm.xml" /> </session-factory> </hibernate-configuration>

测试代码：

public void manyToMany() { Role role1=new Role(); role1.setName("Role1"); Role role2=new Role(); role2.setName("Role2"); Privilege privilege1=new Privilege(); privilege1.setName("Privilege1"); Privilege privilege2=new Privilege(); privilege2.setName("Privilege2"); privilege1.getRoles().add(role1); privilege1.getRoles().add(role2); privilege2.getRoles().add(role1); role1.getPrivileges().add(privilege1); role1.getPrivileges().add(privilege2); role2.getPrivileges().add(privilege1); Transaction tx=session.beginTransaction();//创建session在setUp方法完成 try { //多对多关系必须同时对关联双方进行保存 session.save(privilege1); session.save(privilege2); session.save(role1); session.save(role2); tx.commit(); } catch (Exception e) { e.printStackTrace(); } }

Hibernate生成结果：

Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into t_privilege (name, id) values (?, ?)
Hibernate: insert into t_privilege (name, id) values (?, ?)
Hibernate: insert into t_role (name, id) values (?, ?)
Hibernate: insert into t_role (name, id) values (?, ?)
Hibernate: insert into t_role_privilege (role_id, privilege_id) values (?, ?)
Hibernate: insert into t_role_privilege (role_id, privilege_id) values (?, ?)
Hibernate: insert into t_role_privilege (role_id, privilege_id) values (?, ?)

SQL> select * from t_role;

        ID NAME
---------- ----------
       330 Role1
       331 Role2

SQL> select * from t_privilege;

        ID NAME
---------- ----------
       328 Privilege1
       329 Privilege2

SQL> select * from t_role_privilege;

   ROLE_ID PRIVILEGE_ID
---------- ------------
       330          328
       330          329
       331          328

注意：Role.hbm.xml中通过inverse="false"来设置关联关系由role维护，Role和Privilege只能有一个将inverse字段设置成false。