<mappernamespace="com.lcb.mapping.userMapper">
<!--association 一对一关联查询 -->
<selectid="getClass"parameterType="int"resultMap="ClassesResultMap">
select * from class c,teacher t where c.teacher_id=t.t_id and c.c_id=#{id}
</select>
<resultMaptype="com.lcb.user.Classes"id="ClassesResultMap">
<!-- 实体类的字段名和数据表的字段名映射 -->
<idproperty="id"column="c_id"/>
<resultproperty="name"column="c_name"/>
<associationproperty="teacher"javaType="com.lcb.user.Teacher">
<idproperty="id"column="t_id"/>
<resultproperty="name"column="t_name"/>
</association>
</resultMap>
<!--collection 一对多关联查询 -->
<selectid="getClass2"parameterType="int"resultMap="ClassesResultMap2">
select * from class c,teacher t,student s where c.teacher_id=t.t_id and c.c_id=s.class_id and c.c_id=#{id}
</select>
<resultMaptype="com.lcb.user.Classes"id="ClassesResultMap2">
<idproperty="id"column="c_id"/>
<resultproperty="name"column="c_name"/>
<associationproperty="teacher"javaType="com.lcb.user.Teacher">
<idproperty="id"column="t_id"/>
<resultproperty="name"column="t_name"/>
</association>
<collectionproperty="student"ofType="com.lcb.user.Student">
<idproperty="id"column="s_id"/>
<resultproperty="name"column="s_name"/>
</collection>
</resultMap>
</mapper>
05-04
782
09-08
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交