ibatis的result标签顶用select
<select id="get-bp_account_properties" resultClass="accountproperties" parameterClass="java.lang.String">
select propName, propValue from Properties where AcntIdx = #acntIdx#
</select>
<select id="getBankAccount" resultMap="bp_account-result-map" parameterClass="map">
select a.acntIdx,
a.bankNo,
a.bankName,
a.acntNo,
a.acntName,
a.superIdx,
a.regNo,
a.regName,
a.openBankName,
a.areaCode,
a.bankBranchCode,
a.quota,
a.floorBalance,
a.memo,
a.disabled,
m.mnyname
from a left outer join m on a.currencyno = m.mny
where a.bankNo like '%$bank$%'
order by a.acntIdx
</select>
<resultMap id="bp_account-result-map" class="accountview">
<result property="index" column="AcntIdx"/>
<result property="bankNo" column="BankNo"/>
<result property="bankName" column="BankName"/>
<result property="accountNo" column="AcntNo"/>
<result property="accountName" column="AcntName"/>
<result property="superIndex" column="SuperIdx"/>
<result property="regionNo" column="RegNo"/>
<result property="regionName" column="RegName"/>
<result property="openBankName" column="OpenBankName"/>
<result property="areaCode" column="AreaCode"/>
<result property="bankBranchCode" column="BankBranchCode"/>
<result property="quota" column="Quota"/>
<result property="floorBalance" column="FloorBalance"/>
<result property="comment" column="Memo"/>
<result property="disabled2" column="Disabled"/>
<result property="labelList" column="AcntIdx" select="getOfAccount-bp_label"/>
<result property="attributes2" column="AcntIdx" select="get-bp_account_properties"/>
<result property="txCodes" column="AcntIdx" select="get-bp_account_action"/>
<result property="mnyName" column="mnyname"/>
</resultMap>