§嵌套结果映射–case也能引用它自身, 所以也能包含这些同样的元素。它也可以从外部引用resultMap

?

Id、result属性如下：

?

  
  
  
      
      
      
          
          
          
          
          
          
      
      
      
        select studymybatis_id,studymybatis_name,studymybatis_password,studymybatis_phone  
        from studymybatis where id=#{id}  
      
      
      
        select studymybatis_id,studymybatis_name,studymybatis_password,studymybatis_phone  
        from studymybatis sm  
          
              
                and sm.studymybatis_name = #{name}  
              
              
                and sm.studymybatis_classid=#{classid}  
              
          
      
      
      
          
          
          
          
      
      
        select studymybatis_name,studymybatis_password,  
        from studymybatis st left outer join studyclass sc on st.studymybatis_classid=sc.classid  
        where sc.studymybatis_id=#{id}  
      
      
      
        select * from studymybatis where 1=1  
          
            and studymybatis_name=#{name}  
          
          
            and studymybatis_phone=#{phone}  
          
      
      
      
        select * from studymybatis where 1=1  
          
              
                and studymybatis_name=#{name}  
              
              
                and studymybatis_phone=#{phone}  
              
              
                and studymybatis_classid="1"  
              
          
      
      
      
        select * from studymybatis   
          
              
                and studymybatis_name=#{name}  
              
              
                and studymybatis_phone=#{phone}  
              
          
      
      
      
        update studymybatis   
          
              
                and studymybatis_name=#{name}  
              
              
                and studymybatis_phone=#{phone}  
              
          
        where studymybatis_id=#{id}  
      
      
      
      
        select * from studymybatis where studymybatis_classid in  
          
            #{item}  
          
      
      
      
          
          
          
      
      
        select * from studymybatis where studymybatis_id=#{id}  
      
      
        select * from studyclass where classid=#{cid}  
      
      
      
          
          
          
      
      
        select * from studymybatis sm left outer join studyclass sc on sm.studymybatis_id=sc.classid where studymybatis_id=#{id}  
      
      
  

  
  
  
      
          
          
          
      
      
    id,classage,banji  
      
      
          
          
          
          
          
      
      
        select * from studyclass sc left outer join studymybatis sm on sc.classid=sm.studymybatis_classid  
        where sc.banji=${banji}  
      
  

?