mybatis中resultMap的几种用法

基本定义

1. resultMap自定义结果集映射规则
2. resultMap与resultType只能二选一

 <resultMap type="emp" id="emps">
    <id column="id" property="id" />
    <result column="last_name" property="lastName" />
    <result column="email" property="email" />
    <result column="gender" property="gender"/>
  </resultMap>


    <select id="getResultMap"  resultMap="emps" databaseId="mysql"> 
   select last_name, email,id,gender from employee where id = #{id} 
    </select> 

1. ID标签对应主键属性
   2.resultMap要对应相应resultMap的id

关联查询，级联属性封装

<resultMap type="emp" id="emps">
    <id column="id" property="id" />
    <result column="last_name" property="lastName" />
    <result column="email" property="email" />
    <result column="gender" property="gender"/>
    <result column="id" property="departMent.id"/>
    <result column="dept_name" property="departMent.departmentName" />
  </resultMap>

    <select id="getEmpAndDep"  resultMap="emps" databaseId="mysql"> 
   select * from employee e,department d where e.d_id=d.id and e.id=#{id}
    </select> 

利用association定义关联对象封装规则

1. association可以指定联合的javaBean对象
2. property=“”指定哪个属性是联合的对象
3. javaType 指定这个属性对象的类型（不能省略）

 <resultMap type="emp" id="empsk">
    <id column="id" property="id" />
    <result column="last_name" property="lastName" />
    <result column="email" property="email" />
    <result column="gender" property="gender"/>
    <association property="departMent" javaType="dep">
        <id column="did" property="id" />
        <result column="dept_name" property="departmentName" />
    </association>
  </resultMap>




    <select id="getEmpAndDep"  resultMap="empsk" databaseId="mysql"> 
   select e.last_name last_name, e.email email, e.id,e.gender gender,e.d_id ,d.id did, d.dept_name dept_name from employee e,department d where e.d_id=d.id and e.id=#{id}
    </select> 

利用association进行分步查询

1. 先按照员工id查询员工信息
2. 根据查询员工信息中的d_id值去部门表查询
3. 部门设置到员工中
4. select表明当前属性是调用select指定的方法查出的结果
5. column 指定将哪一列的值传给这个方法

<resultMap type="emp" id="emps3">
    <id column="id" property="id" />
    <result column="last_name" property="lastName" />
    <result column="email" property="email" />
    <result column="gender" property="gender"/>
    <association property="departMent" 
     select="com.dao.DepartMentMapper.getDepartMent"
     column="d_id">
    </association>
  </resultMap>



    <select id="getEmpAndDep"  resultMap="emps3" databaseId="mysql"> 
   select last_name,email,id,gender,d_id from employee e where id=#{id}
    </select> 

分布查询之延迟加载

 <setting name="lazyLoadingEnabled" value="true"/>
    <setting name="aggressiveLazyLoading" value="false"/>

1. 需要在全局配置文件中加入这两个设置
2. lazyLoadingEnabled 会导致分布查询时候按需加载，只有在用到某个属性或对象的时候才会去查询
3. aggressiveLazyLoading 侵入懒加载是指，当需要某个对象的级联属性时，其它属性也会顺便加载，而false则只加载当前属性。

关联查询 collection定义关联集合封装规则

<resultMap type="dep" id="depls">
    <id column="did" property="id"/>
    <result column="dept_name" property="departmentName"/>
    <collection property="empls" ofType="emp">
        <id column="eid" property="id"/>
        <result column="last_name" property="lastName" />
        <result column="email" property="email" />
        <result column="gender" property="gender"/>
    </collection>

 </resultMap>

    <select id="getDepartMentBylist"  resultMap="depls" databaseId="mysql"> 
        select d.id did,d.dept_name,e.id eid,e.last_name,e.email,e.gender 
        from department d 
        left join employee e 
        on d.id=e.d_id 
        where d.id=#{id}
    </select> 

1. collection标签的oftype是指集合中元素的类型
2. property属性指明属于哪一个属性

collection分步查询

 <resultMap type="dep" id="deplf">
    <id column="id" property="id"/>
    <result column="dept_name" property="departmentName"/>
    <collection property="empls"     fetchType="lazy" select="com.dao.EmployeeMapper.getEmpByDid" column="id"></collection>
 </resultMap>

<select id="getDepartMent" resultMap="deplf">
        select id, dept_name from department where id=#{id}
    </select>

1. 分步查询需要将第一次查询的某个字段值传递给第二步作为参数
2. 传递多列的值，将多列的值封装成map进行传递column="{key=column1,key2=column2}",然后根据key取出对应值
3. fetchType=”lazy”表示使用延迟加载,eager立即加载

discriminator 监视器属性

1. 这个属性会根据某个字段值的情况，动态选择不同的映射
2. 注意在case标签里面注明返回的类型，即resultType

 <resultMap type="emp" id="empd">
    <id column="id" property="id" />
    <result column="last_name" property="lastName" />
    <result column="email" property="email" />
    <result column="gender" property="gender"/>

    <discriminator javaType="int" column="gender">
        <case value="1" resultType="emp">
            <association property="departMent" javaType="dep">
                <id column="did" property="id" />
                <result column="dept_name" property="departmentName" />
            </association>
        </case>
        <case value="0" resultType="emp">
            <id column="id" property="id" />
            <result column="email" property="lastName" />
            <result column="email" property="email" />
            <result column="gender" property="gender"/>
        </case>
    </discriminator>
  </resultMap>