ejb中的session中得到相应list

    /**
     * 构造tColManage数据对象集合
     * @param rs
     * @return Collection
     * @throws SQLException
     */
     protected Collection getColManages(KRMDS ds,String strSQL) throws SQLException {
       
        log.log(Level.INFO, strSQL);
       
        Connection conn=null;
        PreparedStatement pstat = null;
        ResultSet rs = null;
        try {
            conn=ds.getConnection();
            pstat = conn.prepareStatement(strSQL);

            log.log(Level.INFO, "Start Query...");
           
            rs = pstat.executeQuery();
            ArrayList array=new ArrayList();
           
            ManageColInUI vo=null;
            ArrayList arrayList=null;
            int i=0;
            while (rs.next()) {
                i++;
                if((i- (Math.rint(i/maxCols))*maxCols)==1) {
                    arrayList=new ArrayList();
                    vo = new ManageColInUI();
                    vo.setColManage(arrayList);
                    array.add(vo);
                }
                arrayList.add(getManageInUI(rs));
            }
           
            //关闭rs,pstat
            rs.close();
            pstat.close();
            conn.close();
           
            return array;
        }catch(SQLException e) {
            try {
//                if (conn != null)
                    conn.close();
            }catch(SQLException ex) {}
           
//            throw e;
        }finally{
            try{
//                if (conn != null)
                    conn.close();
                    conn = null;
                    pstat = null;
                    rs = null;
            }catch(SQLException e){
//                throw e;
            }
        }
        return null;
    }

 

 /**    * Close a <code>ResultSet</code>, avoid closing if null and hide
    
    * any SQLExceptions that occur.   
    */   
    public static void closeQuietly(ResultSet rs) {
   
        try {        
       close(rs);       } catch (SQLException sqle) {
           
       // quiet
        }
  
       }

  
    /**    * Close a <code>Statement</code>, avoid closing if null and hide
    
    * any SQLExceptions that occur.
   
    */
  
     public static void closeQuietly(Statement stmt) {
      
      try {
           
      close(stmt);
     
        } catch (SQLException sqle) {
  
                 // quiet
        }
 
        }
 

 /**
 
    * Close a <code>ResultSet</code>, avoid closing if null and hide
    
    * any SQLExceptions that occur.
    
    */
   
    public static void closeQuietly(ResultSet rs) {
   
        try {
          
       close(rs);
       
       } catch (SQLException sqle) {
           
       // quiet
        }
  
       }

  
    /**
    
    * Close a <code>Statement</code>, avoid closing if null and hide
    
    * any SQLExceptions that occur.
   
    */
  
     public static void closeQuietly(Statement stmt) {
      
      try {
           
      close(stmt);
     
        } catch (SQLException sqle) {
  
                 // quiet      }        }