问题:mybatis collection高级映射(不使用子查询,避免N+1),mapper配置如下:
<resultMap id="OmsSkuPoMap" type="com.trymore.pifa.domain.po.OmsSkuPo" >
<id column="sku_id" property="skuId" jdbcType="VARCHAR" />
<result column="pid" property="pid" jdbcType="INTEGER" />
<result column="price" property="price" jdbcType="NUMERIC" />
<result column="amount" property="amount" jdbcType="INTEGER" />
<result column="sku_status" property="skuStatus" jdbcType="INTEGER" />
<result column="crt_time" property