formula : 用于计算元素外键值的SQL公式.
在xml中配置:
<many-to-one name="goodsInfo" class="com.huatek.ops.goodsmanagement.entity.hibernate.GoodsInfo" fetch="select">
<formula>(SELECT a.goods_id from goods_info a INNER JOIN sales_Order_Detail b on a.goods_id=b.goods_id INNER JOIN logistics_order_detail c on b.detail_id=c.SALES_ORDER_DETAIL_ID where c.order_detail_id=substr(id,0,length(id)-9))</formula>
</many-to-one>
热门工具 换一换