三张表,一对多关系
Purchaser表 Purconn表 Purlist表
purseq 主键 pucseq 主键 purlseq 主键
purflag purseq 外键 purlcode
purway purLseq 外键 purlname
purLimt purlmon一条Purchaser中记录对应多条Purlist表中记录 Purconn是关系表
我现在知道 Purchaser的主键 要去查它对应的Purlist中的记录 该怎么查??????
Hibernate 映射的Purconn 信息是
private String pucseq;
private Purchaser purchaser;
private Purclist purclist;
// Constructors /** default constructor */
public AbstractPurconn() {
}
/** full constructor */
public AbstractPurconn(Purchaser purchaser, Purclist purclist) {
this.purchaser = purchaser;
this.purclist = purclist;
} 映射文件
<hibernate-mapping>
<class name="com.yitong.po.capital.Purconn" table="PURCONN" schema="ERPT1104">
<id name="pucseq" type="java.lang.String">
<column name="PUCSEQ" length="32" />
<generator class="uuid.hex" />
</id>
<many-to-one name="purchaser" class="com.yitong.po.capital.Purchaser" fetch="select">
<column name="PURSEQ" length="32" not-null="true" />
</many-to-one>
<many-to-one name="purclist" class="com.yitong.po.capital.Purclist" fetch="select">
<column name="PURLSEQ" length="32" not-null="true" />
</many-to-one>
</class>
</hibernate-mapping>映射过来的是对象而不是字段 我该怎么查呢?????????????
Purchaser表 Purconn表 Purlist表
purseq 主键 pucseq 主键 purlseq 主键
purflag purseq 外键 purlcode
purway purLseq 外键 purlname
purLimt purlmon一条Purchaser中记录对应多条Purlist表中记录 Purconn是关系表
我现在知道 Purchaser的主键 要去查它对应的Purlist中的记录 该怎么查??????
Hibernate 映射的Purconn 信息是
private String pucseq;
private Purchaser purchaser;
private Purclist purclist;
// Constructors /** default constructor */
public AbstractPurconn() {
}
/** full constructor */
public AbstractPurconn(Purchaser purchaser, Purclist purclist) {
this.purchaser = purchaser;
this.purclist = purclist;
} 映射文件
<hibernate-mapping>
<class name="com.yitong.po.capital.Purconn" table="PURCONN" schema="ERPT1104">
<id name="pucseq" type="java.lang.String">
<column name="PUCSEQ" length="32" />
<generator class="uuid.hex" />
</id>
<many-to-one name="purchaser" class="com.yitong.po.capital.Purchaser" fetch="select">
<column name="PURSEQ" length="32" not-null="true" />
</many-to-one>
<many-to-one name="purclist" class="com.yitong.po.capital.Purclist" fetch="select">
<column name="PURLSEQ" length="32" not-null="true" />
</many-to-one>
</class>
</hibernate-mapping>映射过来的是对象而不是字段 我该怎么查呢?????????????
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货