StudentMapper
public interface StudentMapper { //查询所有学生信息,以及对应的老师信息! public List<Student> getStudent(); // public List<Student> getStudent2(); }
TeacherMapper
public interface TeacherMapper { @Select("select * from teacher where id = #{tid}") Teacher getTeacher(@Param("tid") int id); }
StudentMapper.xml
<!--核心配置文件--> <mapper namespace="com.liang.dao.StudentMapper"> <!--按照结果嵌套处理--> <select id="getStudent2" resultMap="StudentTeacher2"> select s.id sid,s.name sname,t.name tname from student s,teacher t where s.tid = t.id; </select> <resultMap id="StudentTeacher2" type="Student"> <result property="id" column="sid"/> <result property="name" column="sname"/> <result property="id" column="sid"/> <association property="teacher" column="tname" javaType="Teacher"> <result property="name" column="tname"/> </association> </resultMap>