ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 获得webi报表

获得webi报表

原创 Linux操作系统 作者:ydn156 时间:2010-06-03 23:12:47 0 删除 编辑

      public String[][] getWebiName(String folderName1,String folderName2) {
  if (boes == null ) {
   return null;
  }

  try {
   IInfoStore store = (IInfoStore) boes.getService("InfoStore");
                        int folderID1 ;
                        IInfoObject folder1 =null;
                        IInfoObjects folders1 =
                                store.query("select si_id from ci_infoobjects where si_name = '"+folderName1+"' and si_kind ='folder'");
                        if(folders1.getResultSize()>0){
                              folder1 = (IInfoObject)folders1.get(0);
                        }
                        folderID1 = folder1.getID();  //获得父文件夹id
                        int folderID2 ;
                        IInfoObject folder2 =null;
                        IInfoObjects folders2 =
                                store.query("select * from ci_infoobjects where si_name = '"+folderName2+"' and SI_PARENTID="+folderID1+"");
                        if(folders2.getResultSize()>0){
                              folder2 = (IInfoObject)folders2.get(0);
                        }
                        folderID2 = folder2.getID(); //获得子文件夹id


   IInfoObjects webis =
    store.query(
     "select * from ci_infoobjects where SI_PARENTID="+folderID2+"");
                        String[][] webiName = new String[webis.getResultSize()][2];
   if (webis.getResultSize() > 0) {
   for(int i=0;i                            IInfoObject webi = (IInfoObject) webis.get(i);
                                webiName[i][0]=String.valueOf(webi.getID());
    webiName[i][1]=webi.getTitle();
                        }
                           return webiName;    //获得webi名字
   }
  } catch (SDKException sdke) {
   msg = sdke.getMessage();
  }

  return null;
 }

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15073171/viewspace-664350/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 什么是UI
全部评论

注册时间:2008-12-22

  • 博文量
    15
  • 访问量
    46514