mysql在mybaties中的多对一和一对多查询

一 . 一对多查询

<mapper namespace="com.xxx.mapper.EmployeeMapper">
   <resultMap id="d_mapper" type="Department">
       <id property="id" column="d_id"/>
       <result property="name" column="d_name"/>
       <collection property="emps" ofType="Employee">
           <id property="id" column="e_id"/>
           <result property="name" column="e_name"/>
       </collection>
</resultMap>

<select id="queryById" parameterType="int" resultMap="d_mapper">
	  select e.id e_id,e.name e_name,d.id d_id,d.name d_name
	     from employee e,department d
	       where e.dept_id=d.id and d.id=#{id}
</select>

二 . 多对一查询

<resultMap id="e_mapper" type="Employee">
   <id property="id" column="e_id"/>
    <result property="name" column="e_name"/>
    <association property="dept" javaType="Department">
        <id property="id" column="d_id"/>
        <result property="name" column="d_name"/>
    </association>
</resultMap>

<select id="queryById2" parameterType="int" resultMap="e_mapper">
     SELECT e.id e_id,e.name e_name,d.id d_id,d.name d_name
       from employee e,department d
         where e.dept_id =d.id and e.id=#{id}
</select>

三 . 多对多查询

<resultMap id="e_mapper" type="Employee">
  <id property="id" column="e_id"/>
     <result property="name" column="e_name"/>
     <association property="dept" javaType="Department">
         <id property="id" column="d_id"/>
         <result property="name" column="d_name"/>
     </association>
 </resultMap>

<select id="query" resultMap="e_mapper">
	  SELECT e.id e_id,e.name e_name,d.id d_id,d.name d_name
	      from employee e,department d
	        where e.dept_id =d.id
</select>
    ```