IBatis一对多嵌套查询

1)类

 public class AppData
    {
       // public int ModuleId { get; set; }
        public int DataId { get; set; }
        public int DataSequence { get; set; }
        public string ContentValue { get; set; }
    }
    public class AppModuleJoin
    {
        //public int PageId { get; set; }
        public int ModuleId { get; set; }
        public IList<AppData> DataList { get; set; }
        //public int DataId { get; set; }
        //public int DataSequence { get; set; }
        //public string ContentValue { get; set; }
    }
    public class AppModule
    {
       //public int PageId { get; set; }
        public int ModuleId { get; set; }
     
        //public int DataId { get; set; }
        //public int DataSequence { get; set; }
        //public string ContentValue { get; set; }
    }
    public class AppPageJoin
    {
        public int PageId { get; set; }
        public IList<AppModuleJoin> ModuleList { get; set; }
    }
    public class AppPage
    {
        public int PageId { get; set; }
       
    }

　　sqlxml

<?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="App"  xmlns="http://ibatis.apache.org/mapping"  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <alias>
    <typeAlias alias="AppPageJoin" type="IBatis.AppPageJoin"/>
    <typeAlias alias="AppPage" type="IBatis.AppPage"/>
    <typeAlias alias="AppModule" type="IBatis.AppModule"/>
    <typeAlias alias="AppModuleJoin" type="IBatis.AppModuleJoin"/>
    <typeAlias alias="AppData" type="IBatis.AppData"/>
  </alias>
  <resultMaps>
    <!--<resultMap id="AppModuleReslut" class="AppModule">
      --><!--<result property="PageId" column="PageId"/>--><!--
      <result property="ModuleId" column="ModuleId"/>
      <result property="DataId" column="DataId"/>
      <result property="DataSequence" column="DataSequence"/>
      <result property="ContentValue" column="ContentValue"/>
    </resultMap>-->

    <resultMap id="AppDataReslut" class="AppData">
      <!--<result property="PageId" column="PageId"/>-->
      <!--<result property="ModuleId" column="ModuleId"/>-->
      <result property="DataId" column="DataId"/>
      <result property="DataSequence" column="DataSequence"/>
      <result property="ContentValue" column="ContentValue"/>
    </resultMap>
    
    <resultMap id="AppModuleReslut" class="AppModule">
      <!--<result property="PageId" column="PageId"/>-->
      <result property="ModuleId" column="ModuleId"/>
     
    </resultMap>
    
    <resultMap id="AppPageReslut" class="AppPage">
      <result property="PageId" column="PageId"/>
    </resultMap>

  

    <resultMap id="AppPageModuleJoinReslut" class="AppModuleJoin" extends="AppModuleReslut" groupBy="ModuleId">
      <result property="DataList" resultMapping="App.AppDataReslut"  />
    </resultMap>
    
    <resultMap id="AppPageJoinReslut" class="AppPageJoin" extends="AppPageReslut" groupBy="PageId">
      <result property="ModuleList" resultMapping="App.AppPageModuleJoinReslut"  />
    </resultMap>
  </resultMaps>
  <statements>
    <select id="QueryData" resultMap="AppPageJoinReslut">
      select *
      from  QueryData
    </select>

  </statements>
</sqlMap>

在调用中

 

 public IList<AppPageJoin> QueryData()
        {
            ISqlMapper mapper = _sqlMap;
            IList<AppPageJoin> ListPerson = mapper.QueryForList<AppPageJoin>("QueryData", null);  //这个"SelectAllPerson"就是xml映射文件的Id
            return ListPerson;
        }