<resultMap id="UserPortfolio" type="com.fil.ap.api.hk.retail.domain.UserPortfolio">
<result property="portfolioCode" column="PORTFOLIO_CODE"/>
<result property="userId" column="USER_ID"/>
<result property="userType" column="USER_TYPE"/>
<result property="createdDate" column="CREATED_DATE"/>
<result property="createdBy" column="CREATED_BY"/>
<collection property="funds"
select="getPortfolioFunds"
column="{code=PORTFOLIO_CODE,uid=USER_ID,type=USER_TYPE}"/> <!--这里的大括号不写也可以-->
<result property="portfolioCode" column="PORTFOLIO_CODE"/>
<result property="userId" column="USER_ID"/>
<result property="userType" column="USER_TYPE"/>
<result property="createdDate" column="CREATED_DATE"/>
<result property="createdBy" column="CREATED_BY"/>
<collection property="funds"
select="getPortfolioFunds"
column="{code=PORTFOLIO_CODE,uid=USER_ID,type=USER_TYPE}"/> <!--这里的大括号不写也可以-->
</resultMap>
<select id="getPortfolioFunds" resultMap="PortfolioFund">
SELECT * FROM CF_PORTFOLIO_FUND
WHERE PORTFOLIO_CODE = #{code}
AND USER_ID = #{uid}
AND USER_TYPE = #{type}
</select>