14、mybatis多表关联查询 association定义关联对象封装规则及懒加载

１、使用association单步查询

1)、EmployeeMapper

package com.mi.dao;

import com.mi.pojo.Employee;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface EmployeeMapper {
   

    //查询员工及部门
    public Employee getEmpAndDept(Integer id);
}

2)、EmployeeMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--指定为接口的全类名-->
<mapper namespace="com.mi.dao.EmployeeMapper">


    <!--使用association定义单个对象的封装-->
    <resultMap id="myEmpAndEmp2" type="com.mi.pojo.Employee">
        <id column="id" property="id"/>
        <result column="last_name" property="lastName"/>
        <result column="gender" property="gender"/>
        <!--association可以指定联合的javaBean对象
        property="dept" 指定哪个属性是联合的对象
        javaType：指定这个属性对象的类型[不能省略]
        -->
        <association property="dept" javaType="com.mi.pojo.Dept">
            <result column="d_id" property="id"/>
            <result column="dept_name" property="deptName"/>
        </association>
    </resultMap>
    <!--关联查询员工及部门-->
    <select id="getEmpAndDept" resultMap="myEmpAndEmp2">
        select e.id,e.last_name, e.gender,d.id d_id,d.dept_name dept_name
        from employee e ,dept d
        where e.d_id = d.id and e.id = #{id}

    </select>
</mapper>

3)、Test

@Test
    public void getEmpAndDept() throws IOException {
   
        //1、获取SqlSessionFactory对象
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
        //2、获取Sqlsesion对象
        SqlSession sqlSession = sqlSessionFactory.openSession();

        try {
   
            //3、获取接口的实现类对象
            //会为接口自动创建一个代理对象，代理对象去执行增删改查方法
            EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);

            Employee employee = mapper.getEmpAndDept(3);
            System.out.println(employee);
            System.out.println(employee.getDept());