mybatis 嵌套查询 学习记录

 

     在学习mybatis时用到了一个嵌套循环查询，其实还是挺简单的（不过我不会） 

     查询省市区，

     要求查出所有省里面有对应的市，市里面有对应的区

     数据格式要求类似这样的

    

     [ 

            {"citys":  [    {"areas":[ {"acode":"110101","aid":1,"aname":"东城区"} ]  ,

                               "ccode":"110100","cid":520,"cname":"北京市"}

                          ],

             "pcode":"110000","pid":78,"pname":"北京市"}...

    ]

然后就百度了 然后就弄成这样了

  <resultMap id="proviceResultMap" type="com.yinlian.api.app.dto.Api_ProvinceDto">        
         <id property="pid" column="pid" />
        <result property="pname" column="pname" />
        <result property="pcode" column="pcode" />
                
        <collection property="citys"  ofType="com.yinlian.api.app.dto.Api_CityDto"> 
        <id property="cid" column="cid" />
             <result property="cname" column="cname" />
             <result property="ccode" column="ccode" />   
                  
             <collection property="areas" ofType="com.yinlian.api.app.dto.Api_AreaDto" >
          <id property="aid" column="aid" />
       <result property="aname" column="aname" />
       <result property="acode" column="acode" />
             </collection>
        </collection>  
    </resultMap>
    


    <select id="getplaces"  resultMap="proviceResultMap">
       select p.id as pid,p.Name as pname,p.code as pcode,
       c.id as cid,c.name as cname,c.code as ccode, 
       a.id as aid, a.name as aname,a.code as acode
       from province p left join city c on p.code=c.ProvinceCode
       left join area a on c.code=a.citycode       
    </select>

dto格式就不给了