<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd"><!--指定为接口的全类名--><mappernamespace="com.mi.dao.EmployeeMapper"><!--联合查询,级联属性封装结果集--><resultMapid="myEmpAndEmp"type="com.mi.pojo.Employee"><idcolumn="id"property="id"/><resultcolumn="last_name"property="lastName"/><resultcolumn="gender"property="gender"/><resultcolumn="d_id"property="dept.id"/><resultcolumn="dept_name"property="dept.deptName"/></resultMap><!--关联查询员工及部门--><selectid="getEmpAndDept"resultMap="myEmpAndEmp">
select e.id,e.last_name, e.gender,d.id d_id,d.dept_name dept_name
from employee e ,dept d
where e.d_id = d.id and e.id = #{id}
</select></mapper>