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>