递归查询某id下的所有子节点

最新推荐文章于 2024-08-14 15:35:12 发布

a498740995

最新推荐文章于 2024-08-14 15:35:12 发布

阅读量696

点赞数 1

分类专栏：原创文章标签： java

本文链接：https://blog.csdn.net/a498740995/article/details/84358083

版权

原创专栏收录该内容

12 篇文章 0 订阅

订阅专栏

	StringBuffer sql = new StringBuffer();
			
			sql.append("  with copytable  as                                          																												");
			sql.append("   (																																										");
			sql.append("   select c.CATEGORIZATIONPLANGUID  from DT_ERMS_CATEGORIZATIONSCHEMES_CATEGORIZATIONINFO_METADATA  c where c.PID ='"+ nodeguid + "'    and  c.STATE!='2'                                           ");
			sql.append("  union all                              																														            ");
			sql.append("  select c.CATEGORIZATIONPLANGUID from copytable z                                          																					");
			sql.append("  inner join DT_ERMS_CATEGORIZATIONSCHEMES_CATEGORIZATIONINFO_METADATA c                                          																");
			sql.append("  on z.CATEGORIZATIONPLANGUID=c.PID   and c.STATE!='2'                                        															   								");
			sql.append("   )                                          															   							                                     	");
			sql.append("   select copytable.CATEGORIZATIONPLANGUID from copytable                                          															   				");
			
			logger.debug(sql);