ApplicationService simpleApp = new ApplicationService();
String appId = simpleApp.searchApplicationByName("办公流程管理系统").getId();
DataSourceProcessBean dspb = new DataSourceProcessBean();
Collection result = dspb.queryDataSourceSQL("rich",sql,appId);
if(result != null){
Iterator iter = result.iterator();
if(iter.hasNext()){
Map map1 = (Map)iter.next();
String parent = (String)map1.get("PARENT");
String tcmc = (String)map1.get("ITEM_TCMC");
String tcjg = (String)map1.get("ITEM_TCJG"); |