Examples of com.sun.rowset.CachedRowSetImpl.populate()

com.sun.rowset.CachedRowSetImpl.populate()
Populates this CachedRowSetImpl object with data from the given ResultSet object. This method is an alternative to the method execute for filling the rowset with data. The method populate does not require that the properties needed by the method execute, such as the command property, be set. This is true because the method populate is given the ResultSet object from which to get data and thus does not need to use the properties required for setting up a connection and executing this CachedRowSetImpl object's command.
After populating this rowset with data, the method populate sets the rowset's metadata and then sends a RowSetChangedEvent object to all registered listeners prior to returning. @param data the ResultSet object containing the datato be read into this CachedRowSetImpl object @throws SQLException if an error occurs; or the max row setting isviolated while populating the RowSet @see #execute


            if (maxrows > 0) {
                rows.setMaxRows(maxrows);
            }


            rows.populate(resultSet);
            return rows;
        } catch (SQLException e) {
            throw new ControlException(e.getMessage(), e);
        }
    }

View Full Code Here

            connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
         ResultSet resultSet = statement.executeQuery(query);


         CachedRowSet crs = new CachedRowSetImpl();
         crs.setPageSize(pageList.getPageSize());
         crs.populate(resultSet, (pageList.getCurrentPage() - 1) * pageList.getPageSize() + 1);


         while (crs.next())
         {
            T bean = dao_.createInstance();
            dao_.getDBObjectMapper().mapResultSet(crs, bean);

View Full Code Here

            model =  m_model.buildTableModel(rs);
            //model = new DefaultTableModel();
          
          else {
            CachedRowSet crs = new CachedRowSetImpl();
            crs.populate(rs);
            model = m_model.buildTableModel(crs);
          }


          table.setModel(model);

View Full Code Here

            connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
         ResultSet resultSet = statement.executeQuery(query);


         CachedRowSet crs = new CachedRowSetImpl();
         crs.setPageSize(pageList.getPageSize());
         crs.populate(resultSet, (pageList.getCurrentPage() - 1) * pageList.getPageSize() + 1);


         while (crs.next())
         {
            T bean = dao_.createInstance();
            dao_.getDBObjectMapper().mapResultSet(crs, bean);

View Full Code Here


            // Need to use a CachedRowSet that caches its rows in memory, which
            // makes it possible to operate without always being connected to
            // its data source
            CachedRowSet rowset = new CachedRowSetImpl();
            rowset.populate(rs);
            return rowset;
        } catch (SQLException ex) {
            throw new DatabaseException(ex.getMessage(), ex);
        } finally {
            safeCloseResultSet(rs);

View Full Code Here


            // Need to use a CachedRowSet that caches its rows in memory, which
            // makes it possible to operate without always being connected to
            // its data source
            CachedRowSet rowset = new CachedRowSetImpl();
            rowset.populate(rs);
            return rowset;
        } catch (SQLException ex) {
            throw new DatabaseException(ex.getMessage(), ex);
        } finally {
            safeCloseResultSet(rs);

View Full Code Here

   */
  public static CachedRowSet fetchRowSet(EOAdaptorChannel adaptorChannel, String query) throws Exception {
    final CachedRowSetImpl rowSet = new CachedRowSetImpl();
    ERXJDBCUtilities.executeQuery(adaptorChannel, query, new IResultSetDelegate() {
      public void processResultSet(EOAdaptorChannel innerAdaptorChannel, ResultSet rs) throws Exception {
        rowSet.populate(rs);
      }
    });
    return rowSet;
  }

View Full Code Here

    
    this.rs = this.stmt
      .executeQuery("select firstName as 'first person' from bug49516");
    
    crs = new CachedRowSetImpl();
    crs.populate(this.rs);
    crs.first();


    assertEquals("John", crs.getString(1));


  }

View Full Code Here

    String fromPlainResultSet = this.rs.getString(1);


    this.rs = noBlobsConn.createStatement().executeQuery("SELECT PASSWORD ('SOMETHING')");


    crs = new CachedRowSetImpl();
    crs.populate(this.rs);
    crs.first();


    assertEquals(fromPlainResultSet, crs.getString(1));


  }

View Full Code Here

            connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
         ResultSet resultSet = statement.executeQuery(query);


         CachedRowSet crs = new CachedRowSetImpl();
         crs.setPageSize(pageList.getPageSize());
         crs.populate(resultSet, (pageList.getCurrentPage() - 1) * pageList.getPageSize() + 1);


         while (crs.next())
         {
            T bean = dao_.createInstance();
            dao_.getDBObjectMapper().mapResultSet(crs, bean);

View Full Code Here

0 1 2 3

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.