ibatis多对一代码示例

1.---Aa.xml--->

<!-- N:1 -->
<typeAlias alias="S" type="domain.Sex"/>

<resultMap id="AAandSexResult" class="A">
<result property="aid" column="aid"/>
<result property="aname" column="aname"/>
<result property="aage" column="aage"/>
<result property="abirth" column="abirth"/>
<result property="sex" column="sex_id" select="selectSexForAA"/>
</resultMap>

<resultMap id="SexForAAResult" class="S">
<result property="sid" column="sid"/>
<result property="sname" column="sname"/>
</resultMap>

<select id="selectSexForAA" parameterClass="int" resultMap="SexForAAResult">
select * from sex where sid = #sid#
</select>

<select id="selectAAandSex" parameterClass="int" resultMap="AAandSexResult">
select * from aa where aid = #aid#
</select>
----------------------------------------------------------------------------------
<resultMap id="AAandSexResult2" class="A">
<result property="aid" column="aid"/>
<result property="aname" column="aname"/>
<result property="aage" column="aage"/>