mybatis一对多查询＜collection＞

今天在写<collection>一对多查询作业的时候真是被一些博客坑坏了，好多博客只写xml文件不写测试方法，找了好久也找不到报错的解决办法，甚至问gpt也是说<collection>能映射list，然鹅就一直报错类型不匹配。。。想想也是啊，映射出来是 d_id, d_name, id, name, old, email, department这样一条一条的数据，怎么能用Department来接呢？

这是我的部门类

package com.test.bean;

import java.util.List;

public class Department {
    private int deId;
    private String deName;
    private List<Employee> employees;

    public Department() {
    }

    @Override
    public String toString() {
        return "Department{" +
                "deId=" + deId +
                ", deName='" + deName + '\'' +
                ", employees=" + employees +
                '}';
    }
}

这是我的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.test.dao.DepartmentDao">
    <resultMap id="departmentResultMap" type="com.test.bean.Department">
        <id property="d_id" column="deId" />
        <result property="d_name" column="deName" />
        <collection property="employees" ofType="com.test.bean.Employee" >
            <id property="id" column="id"/>
            <result property="name" column="name"/>
            <result property="old" column="old"/>
            <result property="email" column="email"/>
            <result property="department" column="department"/>
        </collection>
    </resultMap>
    <select id="searchEmployee" resultMap="departmentResultMap" parameterType="int">
        SELECT * FROM department d LEFT JOIN employee e ON d.d_id=e.department WHERE d.d_id=#{pid}
    </select>
</mapper>

这是我的测试方法

package com.test.dao;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface DepartmentDao {
    List searchEmployee(@Param("pid") int pid);
}

package com.test;
import com.test.bean.Department;
import com.test.bean.Employee;
import com.test.dao.DepartmentDao;
import com.test.factory.MybatisFactory;
import org.apache.ibatis.session.SqlSession;
import org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.util.List;

public class TestDepartment {
    DepartmentDao dao2 = null;

    SqlSession session = null;
    @Before
    public void before(){
        // 通过工厂类创建会话对象
        session = MybatisFactory.openSession();
        // 通过会话创建接口的代理实现类
        dao2 = session.getMapper(DepartmentDao.class);
    }
    @After
    public void after(){
        // 手动提交数据库事务
        session.commit();
        // 关闭会话
        session.close();
    }
    //    查询指定用户的所有订单信息
    @Test
    public void testSearchEmployee(){
        List department = dao2.searchEmployee(1);
        department.toString();

    }
}

最后终于