在学mybatis写mapper映射文件时,在写到一对一关联时,由于两个javabean的属性相同,导致在select时外部属性覆盖了内部属性:
<resultMap type="Classes" id="classesMap">
<id property="id" column="id" javaType="int"/>
<result property="name" column="name" javaType="String"/>
<association property="teacher" javaType="Teacher" >
<id property="id" column="id" javaType="int"/>
<result property="name" column="name" javaType="String"/>
<result property="age" column="age" javaType="int"/>
</association>
</resultMap>
<sql id="selectAllClassesSql">
SELECT c.id,c.name,teacher_id,t.id,t.name ,t.age
FROM classes c,teacher t
</sql>
这样子由于Classes中有name/id属性,teacher也有name/id属性,通过select语句查询时,Classes的name/id属性会覆盖teacher的name/id属性。
解决方法,在sql语句中给相同的属性起别名:t.id as t_id,同时设置 resultMap 中 teacher的id column为t_id:
<resultMap type="Classes" id="classesMap">
<id property="id" column="id" javaType="int"/>
<result property="name" column="name" javaType="String"/>
<association property="teacher" javaType="Teacher" >
<id property="id" column="t_id" javaType="int"/>
<result property="name" column="t_name" javaType="String"/>
<result property="age" column="t_age" javaType="int"/>
</association>
</resultMap>
<sql id="selectAllClassesSql">
SELECT c.id,c.name,teacher_id,t.id as t_id,t.name as t_name,t.age as t_age
FROM classes c,teacher t
</sql>