2008-01-08
查询当前组织其下所有子组织 SQL语句
String sql = new StringBuffer("select {n.*} from ")
.append("PUB_STRU n ")
.append("CONNECT BY PRIOR n.STRU_ID=n.PARENT_ID START WITH n.PARENT_ID =?")
.toString();
List sids = new ArrayList();
Iterator it = dao.findBySQLQuery(sql, struId, "n", PubStru.class).iterator();
while(it.hasNext()) {
sids.add(((PubStru) it.next()).getStruId());
}
return sids;
评论排行榜