一个关于外键的问题
各位大侠,我请教一个关于多外键的问题:有两个表:student表:studentID,studentName,studentAge;people表:peopleID,peopleName,peopleAge;其中studentName和studentAge是外键,分别对应peopleName和peopleAge。在EJB下,我用的是oracle数据库,jboss服务器,他们的外键声明的描述符应该是在jbosscmp-jdbc.xml中写,请问如何写?如果单独是一个外键的话是这么写的:
<relationships>
<ejb-relation>
<ejb-relation-name>People--to--Student</ejb-relation-name>
<ejb-relationship-role>
<ejb-relationship-role-name>StudentBelongsPeople</ejb-relationship-role-name>
<key-fields>
<key-field>
<field-name>peopleName</field-name>
<column-name>studentName</column-name>
</key-field>
</key-fields>
</ejb-relationship-role>
<ejb-relationship-role>
<ejb-relationship-role-name>PeopleHasStudent</ejb-relationship-role-name>
<fk-constraint>true</fk-constraint>
<key-fields/>
</ejb-relationship-role>
</ejb-relation>
</relationships>
如果有XDOCLET的高手,也可以告诉我用XDOCLET是怎么写的?如果是单独一个外键的话,用XDOCLET是这么写的:
/**
* @ejb.interface-method view-type = "local"
* @ejb.relation name = "People--to--Student"
* role-name = "StudentBelongsPeople"
* @jboss.relation
* related-pk-field="peopleName"
* fk-column = "studentName" * fk-constraint = "true"
*/
public abstract UserInfoLocal getPeople();
/**
*
* @ejb.interface-method view-type = "local"
*
*/
public abstract void setPeople(PeopleLocal people);