Hibernate配置问题`!

数据库中2个表不存在关联关系```
TabScan没主键使用billCode和SscanDate设置的联合主键
但是他们有同样的字段billCode
我想通过一条HQL语句，把所有数据查出来
但是返回的集合是包括他们两个的所有字段？
我现在应该怎么做？TabScan       private String billCode; private String scanDate; private String registerDate; private String scanType; private String scanSite; private String preOrNextStation; private String scanMan; private String dispatchOrSendMan; private String class_; private String dispatchSite; private String re; private String subBillCode; private String scanPrincipal; private String sitePhone; private String employeeNamePhone; private String nextPrincipal; private String nextPhone; private String destinationPrincipal; private String destinationPhone;get/set
TabBill        private String billCode; private String transferCode; private Date sendDate; private String takePieceEmployee; private Long pieceNumber; private String sendAddress; private String destination; private String sendSite; private String registerSite; private String dispatchSite; private Date registerDate; private Date dispatchDate; private Double feeWeight; private Double settlementWeight; private Double transferFee; private Double dispatchFee; private Double freight; private String freightCurrency; private Double topayment; private Double goodsPayment; private String goodsCode; private String paymentType; private String currency; private String topaymentCurrency; private String goodsPaymentCurrency; private String customerName; private String sendMan; private String sendManCompany; private String sendManPhone; private String sendManAddress; private String acceptMan; private String acceptManCompany; private String acceptManPhone; private String acceptManAddress; private String goodsType; private String soonPieceType; private String dispatchMode; private Long blReturnBill; private String centerAuditMan; private Date centerAuditDate; private Long blCenterAudit; private Long blSiteAuditor; private String siteAuditMan; private Date siteAuditDate; private String modifier; private Date modifyDate; private String timeLimit; private String class_; private String employeeType; private Double employeeGain; private String registerMan; private String re; private String sendFinanceCenter; private String dispatchFinanceCenter; private Double centerBetTopay; private Double dispatchCenterRecPoundage; private Double dispatchSiteRecPoundage; private String blSignsMarking; private String state; private Double sendCenterRecPoundage; private Double dispatchSiteReTopay; private Double dispatchCenterReTopay; private Double sendCenterReTopay; private String blRecordAuditor; private Double firstTopayment; private String changeTopayment; private String modifierCode; private String modifySite; private String dispatchUnderlingSite; private String customerCode; private String signMan; private String goodsState; private String sendSiteStateModifier; private Date sendSiteStateDate; private String dispatchSiteStateModifier; private Date dispatchSiteStateDate; private String centerGatheringModifier; private Date centerGatheringDate; private String centerRefundmentModifier; private Date centerRefundmentDate; private Long blQuestionId; private String goodsName; private Double insurance; private String RBillcode; private String paymentSide; private String sendSiteBill; private String patchSiteBill; private String billCodeSub; private String truckWay; private String rangeName; private String quoteArea; private Long blGoodsKind; private Long blGoodsUntreadCenter; private Long blGoodsCenterAffirm; private String sendreckoningCode; private String dispatchreckoningCode; private Double centerDistill; private String dispatchTruckWay; private String dispatchRangeName; private String dispatchQuoteArea; private Long blReturn; private Long blTransfer; private String goodsReckoning; private Long blCheck; private Long blCenterAudit1; private Double guestFreight; private Long blSendGainType; private Double otherFee;get/set
TabScan.xml<class name="com.htky.po.TabScan" table="TAB_SCAN">
<cache usage="read-only"/>
<composite-id>
<key-property name="billCode" type="java.lang.String">
<column name="BILL_CODE" length="20" />
</key-property>
<key-property name="scanDate" type="java.lang.String">
<column name="SCAN_DATE" length="19" />
</key-property>
</composite-id>

<property name="registerDate" type="java.lang.String">
<column name="REGISTER_DATE" length="16" />
</property>
<property name="scanType" type="java.lang.String">
<column name="SCAN_TYPE" length="30" />
</property>
<property name="scanSite" type="java.lang.String">
<column name="SCAN_SITE" length="30" />
</property>
<property name="preOrNextStation" type="java.lang.String">
<column name="PRE_OR_NEXT_STATION" length="30" />
</property>
<property name="scanMan" type="java.lang.String">
<column name="SCAN_MAN" length="30" />
</property>
<property name="dispatchOrSendMan" type="java.lang.String">
<column name="DISPATCH_OR_SEND_MAN" length="30" />
</property>
<property name="class_" type="java.lang.String">
<column name="CLASS" length="30" />
</property>
<property name="dispatchSite" type="java.lang.String">
<column name="DISPATCH_SITE" length="30" />
</property>
<property name="re" type="java.lang.String">
<column name="REMARK" length="100" />
</property>
<property name="subBillCode" type="java.lang.String">
<column name="SUB_BILL_CODE" length="20" />
</property>
<property name="scanPrincipal" type="java.lang.String">
<column name="SCAN_PRINCIPAL" length="30" />
</property>
<property name="sitePhone" type="java.lang.String">
<column name="SITE_PHONE" length="500" />
</property>
<property name="employeeNamePhone" type="java.lang.String">
<column name="EMPLOYEE_NAME_PHONE" length="50" />
</property>
<property name="nextPrincipal" type="java.lang.String">
<column name="NEXT_PRINCIPAL" length="30" />
</property>
<property name="nextPhone" type="java.lang.String">
<column name="NEXT_PHONE" length="500" />
</property>
<property name="destinationPrincipal" type="java.lang.String">
<column name="DESTINATION_PRINCIPAL" length="30" />
</property>
<property name="destinationPhone" type="java.lang.String">
<column name="DESTINATION_PHONE" length="500" />
</property>

</class>TabBill.xml<hibernate-mapping>
    <class name="com.htky.po.TabBill" table="BKHT.TAB_BILL">
        <id name="billCode" type="java.lang.String">
            <column name="BILL_CODE" length="20" />
            <generator class="native" />

        </id>
        <one-to-one name="scan" class="com.htky.po.TabScan"></one-to-one>
        <property name="transferCode" type="java.lang.String">
            <column name="TRANSFER_CODE" length="20" />
        </property>
        <property name="sendDate" type="java.util.Date">
            <column name="SEND_DATE" length="7" not-null="true" />
        </property>
.......................
           </class>
</hibernate-mapping>

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

此回复为自动发出,仅用于显示而已，并无任何其他特殊作用
楼主【xiaomaha】截止到2008-07-09 13:12:08的历史汇总数据(不包括此帖)：
发帖的总数量:57                       发帖的总分数:2274                     每贴平均分数:39
回帖的总数量:143                      得分贴总数量:38                       回帖的得分率:26%
结贴的总数量:45                       结贴的总分数:2024
无满意结贴数:5                        无满意结贴分:350
未结的帖子数:12                       未结的总分数:250
结贴的百分比:78.95 %               结分的百分比:89.01 %
无满意结贴率:11.11 %               无满意结分率:17.29 %
楼主加油
借贴测试效果.
    private String scanDate;    private String registerDate;    private String scanType;    private String scanSite;    private String preOrNextStation;    private String scanMan;<hibernate-mapping>
    <class name="com.htky.po.TabBill" table="BKHT.TAB_BILL">
        <id name="billCode" type="java.lang.String">
            <column name="BILL_CODE" length="20" />
            <generator class="native" />

        </id>
        <one-to-one name="scan" class="com.htky.po.TabScan"></one-to-one>
        <property name="transferCode" type="java.lang.String">
            <column name="TRANSFER_CODE" length="20" />
        </property>
        <property name="sendDate" type="java.util.Date">
            <column name="SEND_DATE" length="7" not-null="true" />
        </property>
.......................
           </class>
</hibernate-mapping>
TabBill的属性是不是想追上bill的财富
如果没有关联关系，我到建议你不如用native sql写得了，反正本来就不是对象了