12. 多对多关联映射

多对多关联映射_单向

实例背景:

1. 定义Role类

package com.bjsxt.hibernate;

 

public class Role {

      

       private int id;  

       private String name;

 

       public int getId() {

              return id;

       }

       public void setId(int id) {

              this.id = id;

       }

       public String getName() {

              return name;

       }

       public void setName(String name) {

              this.name = name;

       }

}

2. 定义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>

3.定义User类

package com.bjsxt.hibernate;

 

import java.util.Set;

 

public class User {

      

       private int id;

       private String name;

       private Set roles;

      

       public int getId() {

              return id;

       }

       public void setId(int id) {

              this.id = id;

       }

       public String getName() {

              return name;

       }

       public void setName(String name) {

              this.name = name;

       }

       public Set getRoles() {

              return roles;

       }

       public void setRoles(Set roles) {

              this.roles = roles;

       }    

}

4. 定义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.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>

5. 定义hibernate.cfg.xml、HibernateUtils和ExportDB等（略）

6. 编写测试用例

package com.bjsxt.hibernate;

 

import java.util.HashSet;

import java.util.Iterator;

import java.util.Set;

import org.hibernate.Session;

import junit.framework.TestCase;

 

public class Many2Many extends TestCase {

 

       public void testSave() {

              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 testLoad() {

              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);

              }

       }           

}

多对多关联映射_双向

实例背景：

1. 修改Role类

package com.bjsxt.hibernate;

 

import java.util.Set;

 

public class Role {

      

       private int id;

       private String name;

       private Set users;

 

       public int getId() {

              return id;

       }

       public void setId(int id) {

              this.id = id;

       }

       public String getName() {

              return name;

       }

       public void setName(String name) {

              this.name = name;

       }

       public Set getUsers() {

              return users;

       }

       public void setUsers(Set users) {

              this.users = users;

       }

}

2. 修改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>

 

 

注：

1.table属性值必须和单向关联中的table属性值一致

2.<key>中column属性值要与单向关联中的<many-to-many>标签中的column属性值一致

  在<many-to-many>中的column属性值要与单向关联中<key>标签的column属性值一致

3. order-by属性指定生成的set集合的元素按照表中的哪个字段进行排序