请教一下关于Mybatis一对一、一对多中出现的不能查询到的问题。

Question

请教一下关于Mybatis一对一、一对多中出现的问题。

    @Select("select * from employees limit #{limit} offset #{offset} ")
    @Results(id = "empMap", value = {
            @Result(id = true, property = "emp_id", column = "emp_id"),
            @Result(property = "emp_name", column = "emp_name"),
            @Result(property = "emp_email", column = "emp_email"),
            @Result(property = "emp_gender", column = "emp_gender"),
            @Result(property = "emp_dept_id", column = "emp_dept_id"),
            @Result(property = "department", column = "dept_id", javaType = Department.class,
                    one = @One(select = "com.sumaojin.dao.DeptDao.findByDeptId")),
    })
    List<Employees> getEmpListByLimitAndOffset(@Param("offset") int offset,@Param("limit") int limit);

    @Select("select * from employees where emp_dept_id = #{emp_dept_id}")
    @ResultMap("empMap")
    List<Employees> findEmpByDeptId(@Param("emp_dept_id") int emp_dept_id);

emp是员工、dept是部门，就是希望在查询员工的时候能查询出所属的部门信息，在查询部门的时候能出来其所有的员工，麻烦各位大佬帮我看一下我这有什么问题吗？怎么查询员工的时候不能查出来它的部门信息呢。以上是员工方面的代码，以下是部门方面的代码。

        @Select("select * from department where dept_id = #{dept_id}")
    @Results(id = "deptMap", value = {
            @Result(id = true, property = "dept_id", column = "dept_id"),
            @Result(property = "dept_name", column = "dept_name"),
            @Result(property = "dept_leader", column = "dept_leader"),
            @Result(property = "dept_employees", column = "emp_dept_id", javaType = Employees.class,
            many = @Many(select = "com.sumaojin.dao.EmpDao.findEmpByDeptId"))
    })
    Department findByDeptId(@Param("dept_id") int dept_id);

Answer 1

https://www.cnblogs.com/chy18883701161/p/12166505.html