Examples of javax.sql.RowSet

javax.sql.RowSet
A RowSet is an interface which provides access to data being sent from/to a database and which extends the functionality of ResultSet into a form that can be used as a JavaBeans component, perhaps being used in a visual programming environment.
Facilities are provided for get/set of propoerties relating to the Database and the SQL Command and for getting/setting data within the Rows represented by the RowSet. The RowSet supports JavaBeans events so that other components in an application can be informed when various changes happen to the RowSet, such as changes in data values.
RowSet is implemented as a layer on top of the remainder of the JDBC API. A RowSet may be connected where it maintains a connection to the database throughout its lifecycle. A RowSet may be disconnected where it establishes a connection to the database, gets data and then closes the connection. Updates to a disconnected RowSet can be made and later send back the changes to the database, but this requires the RowSet to first reconnect to the database before the changes are sent back.
Disconnected RowSets may make use of RowSetReaders to populate the RowSet with data, possibly from a non-relational database source. Disconnected RowSets may also use RowSetWriters to send data back to the underlying data store. There is considerable freedom in the way that RowSetReaders and RowSetWriters are implemented to get and store data.

    protected List getResult( ResultSet resultSet, int startAtRow,
            int howManyRows )
    {


        RowSetWrapperList results = null;
        RowSet rowSet;
        try
        {
            rowSet = getRORowSet( resultSet, startAtRow, howManyRows );
            results = new RowSetWrapperList( rowSet, getRowSetMapper() );
        }

View Full Code Here

    protected List getResult( ResultSet resultSet, int startAtRow,
            int howManyRows )
    {


        RowSetWrapperList results = null;
        RowSet rowSet;
        try
        {
            rowSet = getRORowSet( resultSet, startAtRow, howManyRows );
            results = new RowSetWrapperList( rowSet, getRowSetMapper() );
        }

View Full Code Here

    protected List getResult( ResultSet resultSet, int startAtRow,
            int howManyRows )
    {


        RowSetWrapperList results = null;
        RowSet rowSet;
        try
        {
            rowSet = getRORowSet( resultSet, startAtRow, howManyRows );
            results = new RowSetWrapperList( rowSet, getRowSetMapper() );
        }

View Full Code Here

   * 
   * @see javax.sql.RowSetReader#readData(javax.sql.RowSetInternal)
   */
  @Override
  public void readData(RowSetInternal caller) throws SQLException {
    RowSet c = (RowSet) caller;
    File f = new File(c.getDataSourceName());
    BufferedReader f1;


    try {
      if (f.canRead()) {
        f1 = new BufferedReader(new FileReader(c.getDataSourceName()));
        try {
          setMetaData(f1.readLine(), c);
          setContent(f1, c);
        } finally {
          f1.close();

View Full Code Here

      this.pstmt = this.conn.prepareStatement(sql);
      this.pstmt.setString(1, "1");
      this.rs = this.pstmt.executeQuery();


      // create a CachedRowSet and populate it
      RowSet cachedRowSet = (RowSet) c.newInstance();
      // cachedRowSet.populate(rs);
      populate.invoke(cachedRowSet, new Object[] { this.rs });


      // scroll through CachedRowSet ...
      assertTrue(cachedRowSet.next());
      assertEquals("1", cachedRowSet.getString("ID"));
      assertEquals("test data stuff !", cachedRowSet
          .getString("datafield"));
      assertFalse(cachedRowSet.next());
    } finally {
      this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug5188");
    }
  }

View Full Code Here

      throw new SQLException("Clone failed; " + ioexception2.getMessage());
    }
  }


  public RowSet createShared() throws SQLException {
    RowSet rowset;
    try {
      rowset = (RowSet) clone();
    } catch (CloneNotSupportedException clonenotsupportedexception) {
      throw new SQLException(clonenotsupportedexception.getMessage());
    }

View Full Code Here

      this.pstmt = this.conn.prepareStatement(sql);
      this.pstmt.setString(1, "1");
      this.rs = this.pstmt.executeQuery();


      // create a CachedRowSet and populate it
      RowSet cachedRowSet = (RowSet) c.newInstance();
      // cachedRowSet.populate(rs);
      populate.invoke(cachedRowSet, new Object[] { this.rs });


      // scroll through CachedRowSet ...
      assertTrue(cachedRowSet.next());
      assertEquals("1", cachedRowSet.getString("ID"));
      assertEquals("test data stuff !", cachedRowSet
          .getString("datafield"));
      assertFalse(cachedRowSet.next());
    } finally {
      this.stmt.executeUpdate("DROP TABLE IF EXISTS testBug5188");
    }
  }

View Full Code Here

0 1

TOP

Related Classes of javax.sql.RowSet

com.bleujin.framework.db.rowset.CachedRowSet

net.sourceforge.jivalo.fw.dao.AbstractDAO

org.apache.harmony.sql.internal.rowset.CachedRowSetImpl

org.apache.harmony.sql.internal.rowset.JoinRowSetImpl

org.jamesii.core.data.runtime.RowSetCSVReader

testsuite.regression.CachedRowsetTest

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.