java 递归查询组织机构树

需求：不要在数据库层写存储过程或者调用数据库自带方法实现，因为数据库有可能是MySQL或者是oracle。

核心递归代码：

/**
	 * @Description: 递归查询机构 
	 * @param @param departList
	 * @param @param departId    设定文件 
	 * @return void    返回类型 
	 * @throws
	 */
	private void getDepartmentList(List<SysDepartment> departList, Integer departId) {
		try {
			List<SysDepartment> list = departmentService.getDListByParentId(departId);
			if (null != list && list.size()>0) {
				for (int i = 0; i < list.size(); i++) {
					SysDepartment department = list.get(i);
					departList.add(department);
					getDepartmentList(departList, department.getDepartId());
				}
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

调用代码：

List<SysDepartment> departList = departmentService.getDListByParentId(Integer.parseIn