【无标题】

结果集 一对多的结果映射

    
    
        select s.id sid,s.name sname,t.name tname,t.id tid from student s ,teacher t where s.tid=t.id and t.id=#{tid}
    
    
        
        
        
        
            
            
            
        
    
    
    
        select * from mybatis.teacher where id=#{tid}
    
    
        
        
    
    
        select * from mybatis.student where tid=#{tid}
    

多对一的结果映射配置

    
    
        
        
        
        
    
    
        select * from student
    
    
        select * from teacher where id=#{id}
    
    
    
    
        
        
        
            
        
    
    
        select s.id sid,s.name sname,t.name tname from student s ,teacher t where s.tid=t.id;