此博客介绍了Java中的SysOrgTreeModel类及其字段，包括sysOrgId、tenantId、pid等属性，以及SysOrgMapper接口的listChildOrgTree方法，用于根据tenantId和pid查询组织树数据。Mapper的XML配置展示了如何映射SQL查询，从sys_org表中获取符合条件的组织信息。
DO.java
@Data
public class SysOrgTreeModel {
private String sysOrgId;
private String tenantId;
private String pid;
private String dictOrgType;
private String name;
private Integer level;
private String description;
private String address;
private String email;
private String contactPersonName;
private String contactPersonPhone;
private String dictSysOrgStatus;
private Long createTime;
private Long updateTime;
private List childList;
}
Mapper.java
public interface SysOrgMapper {
List listChildOrgTree(@Param("tenantId") String tenantId, @Param("pid") String pid);
}
Mapper.xml
ofType="com.foo.model.SysOrgTreeModel" select="getNextSysOrgTree"/>
ofType="com.foo.model.SysOrgTreeModel" select="getNextSysOrgTree"/>
sys_org_id, tenant_id, pid, dict_org_type, name, level, description, address, email,
contact_person_name, contact_person_phone, dict_sys_org_status, create_time, update_time
SELECT
FROM sys_org
WHERE tenant_id = #{tenantId}
and pid = #{pid}
SELECT
FROM sys_org
WHERE tenant_id = #{tenantId}
and pid = #{pid}
扫一扫
869
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
