<select id="selectAllDept" parameterType="com.ladybird.hkd.model.pojo.Faculty" resultMap="department_faculty_map">
SELECT
d.dept_num,
d.dept_name,
d.tip,
f.fac_num
FROM department d
LEFT JOIN faculty f
ON d.faculty = #{fac_num}
</select>
成功
注:resultMap中的标签返回的是对象,如果只想取faculty中被关联的主键怎么办
(2)只取表中的一列数据
public class Department {
private String dept_num;
private String dept_name;
private String faculty;
private String tip;
<select id="selectAllDept" parameterType="com.ladybird.hkd.model.pojo.Faculty" resultType="com.ladybird.hkd.model.pojo.Department">
SELECT
d.dept_num,
d.dept_name,
d.tip,
f.fac_num
FROM department d
LEFT JOIN faculty f
ON d.faculty = #{fac_num}
</select>