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 /> </id> ...
<!-- 与关联表建立一对多的关系 --> <set name="ufis" table="user_functions_info" lazy="false" inverse="true"> <key column="USER_ID" /> <one-to-many /></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 /> </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" 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>
?
?
?
做法就是将多对多的关联，转换为连个与中间表一对多的关联。