mybatis文件映射之利用collection定义关联集合（五）

public class Employee {
    private Integer id;
     String lastName;
     String gender;
     String email;
    Department dept;
}

 Department {
     String deptName;
    private List<Employee> employee;
}

interface DepartmentMapper {
    public Department getDeptByIdWithAllEmployees(Integer id);
}

<?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.gong.mybatis.dao.DepartmentMapper">
    
    resultMap type="com.gong.mybatis.bean.Department" id="MyDept">
        id column="did" property="id"/>
        result ="dept_name"="deptName"collection property="employee" ofType="com.gong.mybatis.bean.Employee">
            ="eid"/>
            ="last_name"="lastName"="gender"="gender"="email"="email"</collection>
    resultMapselect id="getDeptByIdWithAllEmployees" resultMap>
        SELECT d.id did,d.dept_name,e.id eid,e.last_name,e.gender,e.email 
        from tbl_department d 
        LEFT JOIN tbl_employee e 
        on d.id = e.d_id 
        WHERE d.id = #{id}
    select>
mapper>

package com.gong.mybatis.test;

import java.io.IOException;
 java.io.InputStream;
 java.util.List;
 java.util.Map;

 org.apache.ibatis.io.Resources;
 org.apache.ibatis.session.SqlSession;
 org.apache.ibatis.session.SqlSessionFactory;
 org.apache.ibatis.session.SqlSessionFactoryBuilder;
 org.junit.Test;

 com.gong.mybatis.bean.Department;
 com.gong.mybatis.bean.Employee;
 com.gong.mybatis.dao.DepartmentMapper;
 com.gong.mybatis.dao.EmployeeMapperPlus;

 TestMybatis2 {
    
    public SqlSessionFactory getSqlSessionFactory() throws IOException {
        String resource = "mybatis-config.xml";
        InputStream is = Resources.getResourceAsStream(resource);
        return new SqlSessionFactoryBuilder().build(is);
    }
    
    @Test
    void test2()  IOException {
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
        SqlSession openSession = sqlSessionFactory.openSession();
        try {
            DepartmentMapper mapper = openSession.getMapper(DepartmentMapper.);
            Department department = mapper.getDepthByIdWithAllEmployees(1);
            System.out.println(department);
            System.out.println(department.getEmployee());
            openSession.commit();
        } finally {
            openSession.close();
        }
        
    }

}