mybatis的Collection关联、分步查询

了解数据库表，请看之前写的一篇文章：点击打开链接

部门类

public class Deptno {
    private Integer id;	
    private String deptName;
    //员工集合
    private List<Employee> empList;
    //get,set,toString方法省略....
}

员工类

public class Employee {
    private Integer id;
    private String last_name;
    private String gender;
    private String email;
    //get,set,toString方法省略....
}

现在的需求是，查询某部门下所有的员工

首先在mapper接口中定义方法

public interface DeptnoMapper {
    public Deptno findDeptAndEmpList(Integer id);
    public Deptno findDeptAndEmpList2