要注意:在sql语句 where t.emp_id = #{id} 中,如果emp_id是主键,那肯定只有一条数据。所以主键不能是emp_id,所以在< id column = "work_time_id" property = "workTimeId" />中这个是正确的,而我把id写成了emp_id,所以只有一条数据。
<mapper namespace="cn.qqcn.emp.mapper.AttendMapper">
<select id="getWorkDayById" resultMap="WorkTimeMap">
select c.emp_id , work_day, month, c.emp_name
from emp_work_time t
join emp_contactes c
on c.emp_id = t.emp_id
where t.emp_id = #{id}
</select>
<resultMap id="WorkTimeMap" type="EmpWorkTime">
<id column="work_time_id" property="workTimeId" />
<result column="emp_id" property="empId"></result>
<result column="work_day" property="workDay"/>
<result column="month" property="month" />
<association property="empContacts" javaType="EmpContacts">
<id column="emp_id" property="empId"></id>
<result column="emp_name" property="empName"></result>
</association>
</resultMap>
</mapper>