HIBERNATE 基于中间表（中间表包含其他属性）多对多关联查询

最新推荐文章于 2021-07-22 22:55:52 发布

原创最新推荐文章于 2021-07-22 22:55:52 发布 · 401 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#hibernate manytomany

JAVA 专栏收录该内容

10 篇文章

订阅专栏

本文介绍了一种通过创建关联表实现多对多关系映射的方法，并详细展示了如何使用Hibernate框架进行用户表、职能表及关联表之间的映射配置。

配置文件：

用户表：

<?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">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="SysUser" table="sys_user" schema="dbo">
        <id name="userId" type="java.lang.String">
            <column name="USER_ID" length="10" />
            <generator class="assigned" />
        </id>
       ...

<!-- 与关联表建立一对多的关系 -->
        <set name="ufis" table="user_functions_info" lazy="false" inverse="true">
		    <key column="USER_ID" />
		    <one-to-many class="UserFunctionsInfo" />
	</set>
    </class>
</hibernate-mapping>

职能表：

<?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">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="FunctionsInfo" table="functions_info" schema="dbo">
        <id name="fiId" type="java.lang.String">
            <column name="FI_ID" length="10" />
            <generator class="assigned" />
        </id>
        ...
    </class>
</hibernate-mapping>

关联表（含其他属性）：

<?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="UserFunctionsInfo" table="user_functions_info" schema="dbo">
        <composite-id name="id" class="UserFunctionsInfo">
            <key-property name="userId" type="java.lang.String">
                <column name="USER_ID" length="10" />
            </key-property>
            <key-property name="fiId" type="java.lang.String">
                <column name="FI_ID" length="10" />
            </key-property>
        </composite-id>
        <property name="upgradePlan" type="java.lang.String">
            <column name="UPGRADE_PLAN" length="10" />
        </property>
        <property name="reachDatetime" type="java.util.Date">
            <column name="REACH_DATETIME" length="23" />
        </property>
        <property name="traineeSituation" type="java.lang.String">
            <column name="TRAINEE_SITUATION" length="8" />
        </property>
    </class>
</hibernate-mapping>

做法就是将多对多的关联，转换为连个与中间表一对多的关联。