mybatis两表联合查询

tbl_emp包含字段：emp_id, emp_name, gender, email, d_id

tbl_dept包含字段：dept_id,dept_name

部分代码：

<resultMap type="com.atguigu.crud.bean.Employee" id="WithDeptBaseResultMap">
    <id column="emp_id" property="empId" jdbcType="INTEGER" />
    <result column="emp_name" property="empName" jdbcType="VARCHAR" />
    <result column="gender" property="gender" jdbcType="CHAR" />
    <result column="email" property="email" jdbcType="VARCHAR" />
    <result column="d_id" property="dId" jdbcType="INTEGER" />
    <!-- 指定联合查询出的部门的封装 -->
    <association property="department" javaType="com.atguigu.crud.bean.Department">
      <id column="dept_id" property="deptId"/>
      <result column="dept_name" property="deptName"/>
    </association>
  </resultMap>

<sql id="WithDept_Base_Column_List">
    emp_id, emp_name, gender, email, d_id,dept_id,dept_name
  </sql>

<select id="selectByExampleWithDept" resultMap="WithDept_Base_Column_List">
    select
    <if test="distinct" >
      distinct
    </if>
    <include refid="WithDept_Base_Column_List" />
    from tbl_emp left join tbl_dept on tbl_emp.'d_id'=tbl_dept.'dept_id'
    <if test="_parameter != null" >
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null" >
      order by ${orderByClause}
    </if>
  </select>