由于具体的一些参数不知道,下面配置仅供参考,照葫芦画瓢即可
<!-- 多对1订单对客户-->
<many-to-one name="custorner" class="com.xxx.Custorner" fetch="select">
<column name="cust_ID" length="32" />
</many-to-one>
<!--多对1订单对地址-->
<many-to-one name="location" class="com.xxx.Location" fetch="select">
<column name="locat_ID" length="32" />
</many-to-one>
<!--1对多订单对订单明细-->
<set name="orderDetails" inverse="true">
<key>
<column name="order_Id" length="32" not-null="true" />
</key>
<one-to-many class="com.xxx.OrderDetail" />
</set>
语句:
select o.orderNum,c.custName,sum(ods.dlCount) ,l.dizhi from order o join fetch o.orderDetails ods join fetch o.location l join fetch o.custorner c group by o.orderId
追问根据上面的业务描述。能帮忙画出一个简单的类图吗?