<select id="selectByPoid" parameterType="long" resultMap="pomainResultMap">
select
p1.*,
p2.num poitemnum,
p3.*
from
pomain p1,poitem p2 ,product p3
where
p2.POID = p1.poid
and
p3.ProductCode = p2.ProductCode
and
p1.POID = #{poid}
</select>
<resultMap type="com.test.model.Pomain" id="pomainResultMap">
<id column="poid" property="poId"/>
<result column="venderCode" property="venderCode"/>
<result column="account" property="account"/>
<result column="createTime" property="createTime"/>
<result column="tipFee" property="tipFee"/>
<result column="productTotal" property="productTotal"/>
<result column="poTotal" property="poTotal"/>
<collection property="poitems" ofType="com.test.model.Poitem">
<id column="poId" property="poId"/>
<id column="productCode" property="productCode"/>
<result column="unitPrice" property="unitPrice"/>
<result column="poitemnum" property="num"/>
<result column="unitName" property="unitName"/>
<association property="product" javaType="com.test.model.Product">
<id column="productCode" property="productCode"/>
<result column="categoryId" property="categoryId"/>
<result column="name" property="name"/>
</association>
</collection>
</resultMap>