mybatis 一对一关联对象查询

1.             <select id="getClassInfo" parameterType="int" resultMap="ClassResultMap">  
2.                 select * from class c,teacher t where c.teacher_id = t.t_id and c.c_id = #{id}  
3.             </select>  
4.             <!-- 解决字段名属性名不一致问题 -->  
5.             <resultMap type="Classes" id="ClassResultMap">  
6.                 <id property="id" column="c_id"/>  
7.                 <result property="name" column="c_name"/>  
8.                 <!-- 一对一关联查询 -->  
9.                 <association property="teacher" column="teacher_id" javaType="Teacher">  
10.                     <id property="id" column="t_id"/>  
11.                     <result property="name" column="t_name"/>  
12.                 </association>  
13.             </resultMap>  

 

 

1.  <select id="getClassInfo2" parameterType="int" resultMap="ClassResultMap2" >  
2.         select * from class where c_id = #{id}  
3.     </select>  
4.       
5.     <!-- 解决字段名属性名不一致问题 -->  
6.     <resultMap type="Classes" id="ClassResultMap2">  
7.         <id property="id" column="c_id"/>  
8.         <result property="name" column="c_name"/>  
9.         <association property="teacher" column="teacher_id"   
10.                     javaType="Teacher" select="getTeacher">  
11.         </association>  
12.     </resultMap>  
13.       
14.     <select id="getTeacher" parameterType="int" resultType="Teacher">  
15.         select t_id id,t_name name from teacher where t_id=#{id}  
16.     </select>  
17.       

转载于:https://www.cnblogs.com/gtbky/p/8351291.html