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>

项目截图