public class Employee {
private String eid;
private String name;
private Date startTime;
private Manager manager;
public class Manager {
private String mid;
private String name;
private Employee employee;
我现在写了一个方法要通过经理的 ID 查出经理 同时一个经理对象里边会有对应的多个雇员,然后雇员对象里边还有对应的经理信息 可以使用 collection 标签里边嵌套 association 标签嘛 如果可以的话我这个写的哪里有问题?
<select id="getEmployeeByManagerId" resultMap="managerMap">
select * from
employee e, manager m
where m.id = e.mid
and m.id = #{id};
</select>
<resultMap id="managerMap" type="com.gzk.pojo.Manager">
<result property="mid" column="id"/>
<result property="name" column="name"/>
<collection property="employee" ofType="com.gzk.pojo.Employee">
<result property="eid" column="id"/>
<result column="name" property="name"/>
<result property="startTime" column="startTime"/>
<association property="manager" column="mid" >
<result column="id" property="mid"/>
<result property="name" column="name"/>
</association>
</collection>
</resultMap>
</mapper>