hibernate中配置非主键关联(单向一对多)

喜欢ヅ旅行 2021-09-10 11:14 291阅读 0赞

from: [http://hi.baidu.com/21chunan/blog/item/ac380c4c156f6ffbd62afc47.html][http_hi.baidu.com_21chunan_blog_item_ac380c4c156f6ffbd62afc47.html]

表结构：

create table primaryTable(  
primaryTableId int primary key,  
refKey varchar(16)--被关联键，注意不是id  
)ENGINE=innodb

create table childTable(  
childTableId int primary key,  
linkRefKey varchar(16)--关联到primaryTable表中的refKey  
)ENGINE=innodb

hibernate映射文件：(注意红字部分)

primaryTable.hbm.xml

<?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][http_hibernate.sourceforge.net_hibernate-mapping-3.0.dtd]">  
<hibernate-mapping>  
<class  
    name="PrimaryTable"  
    table="primaryTable">  
    <id name="id" type="java.lang.Integer">  
     <column name="primaryTableId"/>  
     <generator class="assigned"></generator>  
    </id>

<property name="refKey" type="java.lang.String">  
     <column name="refKey" length="16" />  
    </property>  
    <set name="childTables" inverse="true">  
      
     <key column="linkRefKey" property-ref="refKey" />  
     <one-to-many class="childTable" />  
    </set>  
</class>  
</hibernate-mapping>

childTable.hbm.xml

<?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][http_hibernate.sourceforge.net_hibernate-mapping-3.0.dtd]">  
  
<hibernate-mapping>  
<class name="childTable" table="childTable">  
   <id name="id" type="java.lang.Integer">  
    <column name="childTableId" />  
    <generator class="assigned"></generator>  
   </id>  
   <property name="linkRefKey" type="java.lang.String">  
    <column name="linkRefKey" length="16" />  
   </property>  
   </class>  
</hibernate-mapping>

[http://topic.csdn.net/t/20060325/14/4639486.html][http_topic.csdn.net_t_20060325_14_4639486.html]

[http_hi.baidu.com_21chunan_blog_item_ac380c4c156f6ffbd62afc47.html]: http://hi.baidu.com/21chunan/blog/item/ac380c4c156f6ffbd62afc47.html
[http_hibernate.sourceforge.net_hibernate-mapping-3.0.dtd]: http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd
[http_topic.csdn.net_t_20060325_14_4639486.html]: http://topic.csdn.net/t/20060325/14/4639486.html