我需要做这件事是再DAO这层
public List findChildId (String parentId) {
String queryStr = "select vg.id from treeEm as vg where vg.parent=? = '"+parentId'";
list.add(getHibernateTemplate().find(queryStr));
.....
return list;
}
with showtree(id,parentid)
as
(
select top 1 id,parentid from form where id=1
union all
select t.id,t.parentid from form as t join showtree on t.parentid=showtree.id
)
SELECT id,parentid FROM showtree order by parentid
写一个public Bean getChild(int parentId);给一个父ID,得到子数据条目的一个JavaBean,如果没有子数据条目则返回null。
List<Bean> list = new ArrayList<Bean>();
int id = ##;
Bean b = null;
while((b=getChild(id))!=null){
id=b.getId;
list.add(b);
}
return b;