学生实体类:
import lombok.Data;
@Data
public class Student {
private int id;
private String name;
private Teacher teacher;
}
老师实体类:
import lombok.Data;
@Data
public class Teacher {
private int id;
private String name;
}
1、子查询
<select id="getStudent" resultMap="StudentTeacher">
select * from mybatis.student
</select>
<resultMap id="StudentTeacher" type="Student">
<result property="id" column="id"/>
<result property="name" column="name"/>
<association property="teacher" column="tid" javaType="Teacher" select="getTeacher"/>
</resultMap>
<select id="getTeacher" resultType="com.wjj.pojo.Teacher">
select * from mybatis.teacher where id = #{id}
</select>
2、联表查询
<resultMap id="StudentTeacher2" type="Student">
<result property="id" column="sid"/>
<result property="name" column="sname"/>
<association property="teacher" javaType="Teacher">
<result property="id" column="tid"/>
<result property="name" column="tname"/>
</association>
</resultMap>