oracle递归查询
向下查询
select d.name from T_IN_DEPARTMENT d start with d.id = #{saledept,jdbcType=VARCHAR} connect by prior d.id=d.parentid
向上查询
select d.name from T_IN_DEPARTMENT d start with d.id = #{saledept,jdbcType=VARCHAR} connect by d.id=d.parentid