ibatis 一对多查询

<typeAlias alias="businessScopeItem" type="com.sdfrdj.vo.BusinessScopeItem"/>

    <typeAlias alias="businessScopeSubItem" type="com.sdfrdj.vo.BusinessScopeSubItem"/>
    

    <resultMap class="businessScopeItem" id="allItemResultMap">

       <result property="item_id"        column="ITEM_ID"/>

       <result property="item"           column="ITEM"/>

       <result property="unit_id"     column="UNIT_ID"/>

       <result property="seq"         column="SEQ"/>

       <result property="createdate"       column="CREATEDATE"/>

       <result property="isdel"   column="ISDEL"/>

       <result property="businessScopeSubItemList" column="item_id"  select="getBusinessScopeSubItemByItemId"/>

    </resultMap>

    <resultMap class="businessScopeSubItem" id="subItemResultMap">

       <result property="subitem_id"   column="SUBITEM_ID"/>

       <result property="item_id"        column="ITEM_ID"/>

       <result property="subitem"     column="SUBITEM"/>

       <result property="content"         column="CONTENT"/>

       <result property="rules"            column="RULES"/>

       <result property="limitdate"    column="LIMITDATE"/>

       <result property="createdate"       column="CREATEDATE"/>

       <result property="isdel"   column="ISDEL"/>

    </resultMap>

<!-- 查询所有业务范围事项子事项-->

    <select id="selectAllBusinessScopeList"  resultMap="allItemResultMap" parameterClass="businessScopeItem">

        SELECT

                ITEM_ID,

                ITEM,

                UNIT_ID,

                SEQ,

                TO_CHAR(CREATEDATE,'yyyy-MM-dd') CREATEDATE,

                ISDEL

        FROM T_BUSINESS_SCOPE_ITEM

        WHERE 1=1

         <isNotEmpty prepend="and" property="unit_id">

                UNIT_ID=#unit_id#

        </isNotEmpty>

        <isNotEmpty prepend="and" property="item">

                 ITEM like '%$item$%'

        </isNotEmpty>

         <isNotEmpty prepend="and" property="isdel">

                ISDEL=#isdel#

        </isNotEmpty>

        ORDER BY ITEM_ID

    </select>

    <!-- 根据事项查询所有子事项-->

    <select id="getBusinessScopeSubItemByItemId"  parameterClass="java.lang.String" resultMap="subItemResultMap">

        SELECT

                SUBITEM_ID,

                ITEM_ID,

                SUBITEM,

                CONTENT,

                RULES,

                LIMITDATE,

                TO_CHAR(CREATEDATE,'yyyy-MM-dd') CREATEDATE,

                ISDEL

        FROM T_BUSINESS_SCOPE_SUBITEM

        WHERE ITEM_ID=#item_id# AND ISDEL='0'

        ORDER BY SUBITEM_ID

    </select>