[SXT][WY]Hibernate08 多对多关联映射

hibernate多对多关联映射(单向User---->Role)

 

具体映射方式：
 <set name="roles" table="t_user_role">
  <key column="userid"/>
  <many-to-many class="com.bjsxt.hibernate.Role" column="roleid"/>
 </set>

 

User.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">
<hibernate-mapping>
 <class name="com.bjsxt.hibernate.User" table="t_user">
  <id name="id">
   <generator class="native"/>
  </id>
  <property name="name"/>
  <set name="roles" table="t_user_role">
   <key column="userid"/>
   <many-to-many class="com.bjsxt.hibernate.Role" column="roleid"/>
  </set>
 </class>
</hibernate-mapping>

 

Role.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">
<hibernate-mapping>
 <class name="com.bjsxt.hibernate.Role" table="t_role">
  <id name="id">
   <generator class="native"/>
  </id>
  <property name="name"/>
 </class>
</hibernate-mapping>

 

 

public void testSave2() {
  Session session = null;
  try {
   session = HibernateUtils.getSession();
   session.beginTransaction();
   
   Role r1 = new Role();
   r1.setName("数据录入人员");
   session.save(r1);
   
   Role r2 = new Role();
   r2.setName("商务主管");
   session.save(r2);
   
   Role r3 = new Role();
   r3.setName("大区经理");
   session.save(r3);
   
   User u1 = new User();
   u1.setName("10");
   Set u1Roles = new HashSet();
   u1Roles.add(r1);
   u1Roles.add(r2);
   u1.setRoles(u1Roles);
   
   User u2 = new User();
   u2.setName("祖儿");
   Set u2Roles = new HashSet();
   u2Roles.add(r2);
   u2Roles.add(r3);
   u2.setRoles(u2Roles);
   
   User u3 = new User();
   u3.setName("杰伦");
   Set u3Roles = new HashSet();
   u3Roles.add(r1);
   u3Roles.add(r2);
   u3Roles.add(r3);
   u3.setRoles(u3Roles);
   
   session.save(u1);
   session.save(u2);
   session.save(u3);
   
   session.getTransaction().commit();
  }catch(Exception e) {
   e.printStackTrace();
   session.getTransaction().rollback();
  }finally {
   HibernateUtils.closeSession(session);
  }
 }  
 
 public void testLoad1() {
  Session session = null;
  try {
   session = HibernateUtils.getSession();
   session.beginTransaction();
   User user = (User)session.load(User.class, 1);
   System.out.println(user.getName());
   for (Iterator iter=user.getRoles().iterator(); iter.hasNext();) {
    Role role = (Role)iter.next();
    System.out.println(role.getName());
   }
   session.getTransaction().commit();
  }catch(Exception e) {
   e.printStackTrace();
   session.getTransaction().rollback();
  }finally {
   HibernateUtils.closeSession(session);
  }
 }  

 

 

hibernate多对多关联映射(双向User<---->Role)

 

映射方法：
  <set name="roles" table="t_user_role">
   <key column="userid"/>
   <many-to-many class="com.bjsxt.hibernate.Role" column="roleid"/>
  </set>
table属性值必须和单向关联中的table属性值一致
<key>中column属性值要与单向关联中的<many-to-many>标签中的column属性值一致
在<many-to-many>中的column属性值要与单向关联中<key>标签的column属性值一致
 

Role.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">
<hibernate-mapping>
 <class name="com.bjsxt.hibernate.Role" table="t_role">
  <id name="id">
   <generator class="native"/>
  </id>
  <property name="name"/>
  <set name="users" table="t_user_role" order-by="userid">
   <key column="roleid"/>
   <many-to-many class="com.bjsxt.hibernate.User" column="userid"/>
  </set>
 </class>
</hibernate-mapping>