Hibernate(九)多表联查之双向一对多

双向一对多或多对一

举例：家庭和家庭成员
- 通过家庭能知道家庭成员有多少
- 通过家庭成员能知道家的位置

代码实现：
1、工具类：HibernateUtil

public class HibernateUtilEX {
    private static Configuration configuration = null;
    private static SessionFactory sessionFactory = null;
    // 本地化线程、
    private static ThreadLocal<Session> localSession = null;

    static {
        try {
            // 加载Hibernate配置文件(默认加载bihernate.cfg.xml)
            configuration = new Configuration().configure();
            // 获取SessionFactory工厂对象
            sessionFactory = configuration.buildSessionFactory();

            localSession = new ThreadLocal<Session>();
        } catch (Exception e) {
            System.out.println("加载hibernate映射文件失败");
            e.printStackTrace();
        }
    }

    /**
     * 得到Session对象
     * 
     * @return Session
     */
    public static Session openSession() throws HibernateException {
        // 底层有一个Map<k,V>,K:线程ID，V:session ,一个线程绑定一个session
        Session session = localSession.get();
        if (session == null) {
            session = sessionFactory.openSession();
            localSession.set(session);
        }
        return session;
    }

    /**
     * 关闭Session
     * 
     * @throws HibernateException
     */
    public static void closeSession() throws HibernateException {
        Session session = localSession.get();
        if (session != null) {
            session.close();
        }
        localSession.set(null);
    }
}

2、创建实体类
家庭实体类：HomeEntity

public class HomeEntity {
    private int id;
    private String address;     //家庭地址
    private Set<MemberEntity> member;   //家庭成员集合引用
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getAddress() {
        return address;
    }
    public void setAddress(String address) {
        this.address = address;
    }
    public Set<MemberEntity> getMember() {
        return member;
    }
    public void setMember(Set<MemberEntity> member) {
        this.member = member;
    }
    @Override
    public String toString() {
        return "HomeEntity [id=" + id + ", address=" + address + ", member=" + member + "]";
    }
}

家庭配置文件：HomeEntity.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.zh.entity">
    <class name="HomeEntity" table="t_home">
        <!-- 映射标识属性(属性) -->
        <id name="id" column="id" type="int">
            <!-- 主键生成策略(自增主键) -->
            <generator class="native" />
        </id>

        <!-- 映射普通属性 -->
        <property name="address" column="address"></property>

        <!-- 关联映射（双向一对多） inverse属性用于指定不控制关联关系(反转)-->
        <set name="member" inverse="true">
            <!-- 指定外建（必须与关联类外键相同） -->
            <key column="home_id"></key>
            <!-- 单个一方使用one-to-many -->
            <one-to-many class="MemberEntity"/>
        </set>
    </class>
</hibernate-mapping>

家庭成员实体类：MemberEntity

public class MemberEntity {

    private int id;
    private String relation;//关系
    private HomeEntity home;    //引用家庭
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getRelation() {
        return relation;
    }
    public void setRelation(String relation) {
        this.relation = relation;
    }
    public HomeEntity getHome() {
        return home;
    }
    public void setHome(HomeEntity home) {
        this.home = home;
    }
    @Override
    public String toString() {
        return "MemberEntity [id=" + id + ", relation=" + relation + "]";
    }
}
注：同样，这里toString两边还是只需要一个类实现所有属性

成员配置文件：MemberEntity.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.zh.entity">
    <class name="MemberEntity" table="t_member">
        <!-- 映射标识属性(属性) -->
        <id name="id" column="id" type="int">
            <!-- 主键生成策略(自增主键) -->
            <generator class="native" />
        </id>

        <!-- 映射普通属性 -->
        <property name="relation" column="relation"></property>

        <!-- 关联映射（双向多的一方对应少的一方） not-null：不为空-->
        <many-to-one name="home" class="HomeEntity" column="home_id" not-null="true"></many-to-one>
    </class>
</hibernate-mapping>

3、在总配置文件hibernate.cfg.xml里添加配置映射文件

<!-- 双向一对多 -->
<mapping resource="com/zh/entity/HomeEntity.hbm.xml" />
<mapping resource="com/zh/entity/MemberEntity.hbm.xml" />

4、创建测试类：HibernateTest

public class HibernateTest {
    public static void main(String[] args) {
        HibernateTest test = new HibernateTest();
        test.DoubleManyToOne();
    }

    // 双向一对多（多对一）
    public void DoubleManyToOne() {
        //开启会话
        Session session = HibernatUtil.getSession();
        //打开事物
        Transaction transaction = session.beginTransaction();
        /**
         * 实例化家庭类
         */
        HomeEntity home = new HomeEntity();
        home.setAddress("成都市"); //设置地址
        session.persist(home);
        /**
         * 实例化家庭成员1
         */
        MemberEntity member = new MemberEntity();
        member.setRelation("爸爸");   //设置关系
        member.setHome(home);       //成员1引用Home
        session.persist(member);    //保存数据到数据库
        /**
         * 实例化家庭成员2
         */
        MemberEntity member2 = new MemberEntity();
        member2.setRelation("儿子");  //设置关系
        member2.setHome(home);  //成员2引用Home
        session.persist(member2);   //保存数据到数据库

        transaction.commit();
        HibernatUtil.closeSession(session);
    }
}

运行结果：

查看数据库：

添加成功！

可以通过get方法，来查询是否关联成功！

HomeEntity homeEntity = (HomeEntity) session.get(HomeEntity.class, 1);
        System.out.println(homeEntity);

控制台显示：

关联成功！