mapper.java:
public List<DepartmentDTO> getTreeForm();
mapper.xml:
/*step1*/ /*step4*/...
<select id="getTreeForm" resultType="brilliance.znjt.business.postman.entity.DepartmentDTO"
resultMap="departmentDTOMap">
SELECT DEPTNO,DEPTNAME,DEPTGRADE,PARENTDEPT
FROM VMGR_DEPT
WHERE PARENTDEPT = '' OR PARENTDEPT IS NULL
<!-- WHERE SUBSTR(DEPTNO,5) = '0000' -->
ORDER BY DEPTGRADE,DEPTNO
</select>
/*step2*//*step5*/...
<id column="deptno" property="deptno"/>
<