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.

        return output;
    }


    public RowSet createShared() throws SQLException {
        // shallow copy
        RowSet result = null;
        try {
            result = (RowSet) super.clone();
        } catch (CloneNotSupportedException e) {
            // TODO add error message
            throw new SQLException();

View Full Code Here

        return output;
    }


    public RowSet createShared() throws SQLException {
        // shallow copy
        RowSet result = null;
        try {
            result = (RowSet) super.clone();
        } catch (CloneNotSupportedException e) {
            throw new SQLException(e.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());


  }

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());


  }

View Full Code Here

        return output;
    }


    public RowSet createShared() throws SQLException {
        // shallow copy
        RowSet result = null;
        try {
            result = (RowSet) super.clone();
        } catch (CloneNotSupportedException e) {
            throw new SQLException(e.getMessage());
        }

View Full Code Here

        return output;
    }


    public RowSet createShared() throws SQLException {
        // shallow copy
        RowSet result = null;
        try {
            result = (RowSet) super.clone();
        } catch (CloneNotSupportedException e) {
            throw new SQLException(e.getMessage());
        }

View Full Code Here

        if (rowset == null || !(rowset instanceof RowSet)) {
            // rowset.33=Not a rowset
            throw new SQLException(Messages.getString("rowset.33")); //$NON-NLS-1$
        }


        RowSet currentRs = (RowSet) rowset;
        if (currentRs.getMetaData() == null) {
            // rowset.32=The given rowset is empty
            throw new SQLException(Messages.getString("rowset.32")); //$NON-NLS-1$
        }


        int matchCol = -1;
        try {
            if (rowset.getMatchColumnIndexes() != null
                    && rowset.getMatchColumnIndexes().length > 0) {
                matchCol = rowset.getMatchColumnIndexes()[0];
                if (matchCol <= 0
                        || matchCol > currentRs.getMetaData().getColumnCount()) {
                    matchCol = -2;
                }
            }
        } catch (SQLException e) {
            try {
                if (rowset.getMatchColumnNames() != null
                        && rowset.getMatchColumnNames().length > 0) {
                    try {
                        matchCol = currentRs.findColumn(rowset
                                .getMatchColumnNames()[0]);
                    } catch (SQLException e1) {
                        matchCol = -3;
                    }
                }

View Full Code Here

        return output;
    }


    public RowSet createShared() throws SQLException {
        // shallow copy
        RowSet result = null;
        try {
            result = (RowSet) super.clone();
        } catch (CloneNotSupportedException e) {
            throw new SQLException(e.getMessage());
        }

View Full Code Here

        if (rowset == null || !(rowset instanceof RowSet)) {
            // rowset.33=Not a rowset
            throw new SQLException(Messages.getString("rowset.33")); //$NON-NLS-1$
        }


        RowSet currentRs = (RowSet) rowset;
        if (currentRs.getMetaData() == null) {
            // rowset.32=The given rowset is empty
            throw new SQLException(Messages.getString("rowset.32")); //$NON-NLS-1$
        }


        int matchCol = -1;
        try {
            if (rowset.getMatchColumnIndexes() != null
                    && rowset.getMatchColumnIndexes().length > 0) {
                matchCol = rowset.getMatchColumnIndexes()[0];
                if (matchCol <= 0
                        || matchCol > currentRs.getMetaData().getColumnCount()) {
                    matchCol = -2;
                }
            }
        } catch (SQLException e) {
            try {
                if (rowset.getMatchColumnNames() != null
                        && rowset.getMatchColumnNames().length > 0) {
                    try {
                        matchCol = currentRs.findColumn(rowset
                                .getMatchColumnNames()[0]);
                    } catch (SQLException e1) {
                        matchCol = -3;
                    }
                }

View Full Code Here

        if (rowset == null || !(rowset instanceof RowSet)) {
            // rowset.33=Not a rowset
            throw new SQLException(Messages.getString("rowset.33")); //$NON-NLS-1$
        }


        RowSet currentRs = (RowSet) rowset;
        if (currentRs.getMetaData() == null) {
            // rowset.32=The given rowset is empty
            throw new SQLException(Messages.getString("rowset.32")); //$NON-NLS-1$
        }


        int matchCol = -1;
        try {
            if (rowset.getMatchColumnIndexes() != null
                    && rowset.getMatchColumnIndexes().length > 0) {
                matchCol = rowset.getMatchColumnIndexes()[0];
                if (matchCol <= 0
                        || matchCol > currentRs.getMetaData().getColumnCount()) {
                    matchCol = -2;
                }
            }
        } catch (SQLException e) {
            try {
                if (rowset.getMatchColumnNames() != null
                        && rowset.getMatchColumnNames().length > 0) {
                    try {
                        matchCol = currentRs.findColumn(rowset
                                .getMatchColumnNames()[0]);
                    } catch (SQLException e1) {
                        matchCol = -3;
                    }
                }

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.