mybatis中的多表联查

//如果实体类有外键对象可使用两种方式解决
			1、查询的时候直接使用外键对象.外键属性("rinfo.id","rinfo.name")	(推荐)
			2、使用resultMap对象进行映射
1.
		select s.*,t.tid as "tinfo.tid",t.job as "tinfo.job",t.tname as "tinfo.tname" from Students s,Teachers t
		where s.tid = t.tid and t.tid=#{tid}
	
2.
 
			
  
			
  
			
  
			
  
			
   
    
    
    
  
	
 
	
		select s.*,t.tid as tid ,t.job as job ,t.tname as tname from Students s,Teachers t
		where s.tid = t.tid and t.tid=#{tid}