Ibatis自我关联

在menu.xml中配置

<resultMap class="menu" id="MenuResult">
        <result property="mId" column="MID"/>
        <result property="mName" column="MNAME"/>
        <result property="mSuperior_name" column="MSUPERIOR_NAME"/>
        <result property="mType" column="MTYPE"/>
        <result property="mPath" column="MPATH"/>  
        <result property="mDescription" column="MDESCRIPTION"/> 
        <result property="children" column="mName" select="getChildren"/>
    </resultMap>

    <select id="getChildren" resultClass="menu" parameterClass="String" resultMap="MenuResult">
        select MID,MNAME,MSUPERIOR_NAME,MTYPE,MPATH,MSTATUS,MDESCRIPTION from MENU where mSuperior_name=#mName#
    </select>

项目截图