一种resultMap包含了其他查询

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMap          PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"          "http://ibatis.apache.org/dtd/sql-map-2.dtd"><sqlMap namespace="User"><select id="selectUserByNameAndPassword" resultClass="user" parameterClass="userVO" >select * from t_user where name=#username# and password=#password# </select><resultMap class="user" id="resultUserAuthor"><result property="id" column="userId"/><result property="userType" column="userType"/><result property="roleList" select="User.selectUserRoleList" column="userId"/><result property="menuList" select="User.selectUserMenuList" column="userId"/><result property="productKeyList" select="User.selectUserProductKeyList" column="userId"/><result property="entityList" select="User.selectUserEntityList" column="userId"/></resultMap><select id="selectUserAuthor" resultMap="resultUserAuthor" parameterClass="userVO">select id as userId, userType as userType from t_user where id=#userId# </select><select id="selectUserRoleList" resultClass="role">select a.* from t_role a, t_user_role b where a.id=b.roleId and b.userId=#userId# </select><select id="selectUserMenuList" resultClass="menu">select a.* from t_menu a, t_role_resource b,t_user_role c where a.id=b.resourceId and b.roleId=c.roleId and b.resourceType=1 and c.userId=#userId# </select><select id="selectUserProductKeyList" resultClass="productKey">select a.* from t_product_key a, t_role_resource b,t_user_role c where a.id=b.resourceId and b.roleId=c.roleId and b.resourceType=4 and c.userId=#userId# and a.scope = (select d.value from t_config d where d.name='serverType')</select><select id="selectUserEntityList" resultClass="entity">select a.* from t_entity a where a.pass=1 unionselect a.* from t_entity a, t_role_resource b,t_user_role c where a.id=b.resourceId and b.roleId=c.roleId and a.pass=0 and b.resourceType=2 and c.userId=#userId# </select><select id="getRolesByUserId" resultClass="role" >  select t.* from t_role  t,t_user_role t1 where t.id=t1.roleId and t1.userId=#id#    </select>  <resultMap class="user" id="userResultMap"><result property="id" column="id"/><result property="name" column="name"/><result property="password" column="password"/><result property="status" column="status"/><result property="userType" column="userType"/><result property="orgId" column="orgId"/><result property="createDate" column="createDate"/><result property="creater" column="creater"/>     </resultMap>           <resultMap class="user" id="userWithRolesResultMap"          extends="userResultMap">        <result property="roleList" column="id" select="User.getRolesByUserId"/>      </resultMap>       <select id="selectUserList" resultMap="userWithRolesResultMap" parameterClass="userVO">select * from t_user where 1=1 <isNotEmpty property="orgId" prepend="and">orgId=#orgId#</isNotEmpty><isNotEmpty property="username" prepend="and">name like concat('%', #username#, '%')</isNotEmpty><isNotEmpty property="userId" prepend="and">id=#userId#</isNotEmpty> </select><!-- 新增用户 --><insert id="insertUser" parameterClass="user">insert into t_user (name,password,status,userDesc,userType,orgId,createDate,creater) values (#name#,#password#,#status#,#userDesc#,#userType#,#orgId#,#createDate#,#creater#)<selectKey resultClass="int" >SELECT @@IDENTITY AS ID</selectKey></insert> <insert id="insertUserRole" parameterClass="userRole">insert into t_user_role (roleId,userId) values (#roleId#,#userId#)<selectKey resultClass="int" >SELECT @@IDENTITY AS ID</selectKey></insert><update id="updateUserRole" parameterClass="userRole">update t_user_role set userId=#userId#,roleId=#roleId#where id=#id#  </update><select id="selectUserRole" parameterClass="userRole" resultClass="userRole">select * from t_user_role where userId=#userId#</select><update id="updateUser" parameterClass="user">update t_user <dynamic  prepend="set">          <isNotEmpty prepend=","  property="name"> `name`=#name# </isNotEmpty>        <isNotEmpty prepend=","  property="password"> `password`=#password# </isNotEmpty>        <isNotEmpty prepend=","  property="status"> `status`=#status# </isNotEmpty>         <isNotEmpty prepend=","  property="orgId"> `orgId`=#orgId# </isNotEmpty>        <isNotEmpty prepend=","  property="userType"> `userType`=#userType# </isNotEmpty>          </dynamic>    where id=#id#  </update><delete id="deleteUser" parameterClass="userVO">delete from t_user where id=#userId#  </delete><select id="isExistUserName" parameterClass="user" resultClass="int">select count(0) from t_user where name=#name# <isNotEmpty prepend="and"  property="id"> `id`!=#id# </isNotEmpty></select> </sqlMap>