mybatis两表联合查询

来源：互联网发布：excel表格找相同数据编辑：程序博客网时间：2024/05/17 11:05

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>

阅读全文

0 0