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

          crs.next();
          String sql = " select FNCCAMELCASE(estado) estado from TB_CIDADES where geocode = '" + crs.getString("TABELA") + "' ";
          ResultSet rrEstado = stEstado.executeQuery(sql.toUpperCase());


          CachedRowSetImpl crsEstado = new CachedRowSetImpl();
          crsEstado.populate(rrEstado);


          if (crsEstado.size() != 0) {
            crsEstado.next();
            state = crsEstado.getString("ESTADO");
          }

View Full Code Here

      
      Statement st = con.createStatement();
      ResultSet rr = st.executeQuery("SHOW TABLES LIKE '" + tb[0].toUpperCase() + "'");
      
      CachedRowSetImpl crs = new CachedRowSetImpl();
      crs.populate(rr);
      
      nrReg = crs.size();
      
      rr.close();
      st.close();

View Full Code Here

      st = con.createStatement();
      
      rr = st.executeQuery("SHOW COLUMNS FROM DADOS_CLIENTES." + tb[0].toUpperCase() + " WHERE " + where);
      
      crs = new CachedRowSetImpl();
      crs.populate(rr);
      
      nrReg = crs.size();
      
      rr.close();
      st.close();

View Full Code Here

    Statement st = con.createStatement();


    ResultSet rr = st.executeQuery(sql.toUpperCase());
    CachedRowSetImpl crs = new CachedRowSetImpl();


    crs.populate(rr);


    if (crs.size() == poiRoute.length)
      return true;
    else
      return false;

View Full Code Here

        Connection conn = getConnection();
        Statement st = null;
        try {
            st = conn.createStatement();
            CachedRowSetImpl crs = new CachedRowSetImpl();
            crs.populate(st.executeQuery(sql));
            return crs;
        } finally {
            st.close();
            conn.close();
        }

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.