1.创建用户实体UserTreeVo
public class UserTreeVo {
private String id;
private List<UserTreeVo> children;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public List<UserTreeVo> getChildren() {
return children;
}
public void setChildren(List<UserTreeVo> children) {
this.children = children;
}
}
2.查询该用户下的所有子孙用户 xml:
<resultMap type="com.ssish.saas.constant.db.vo.UserTreeVo" id="userIdTree">
<id property="id" column="id"/>
<association property="children" column="{id=id}" select="selectChildren"/>
</resultMap>
<select id="selectChillersByUserId" resultMap="userIdTree" >
SELECT u.id