Overview  Package   Class  Tree  Deprecated  Index  Help  Codase Click search sample or example code, search definition, search google 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

javax.sql.rowset
Interface JdbcRowSet

All Superinterfaces:
Joinable sample code for javax.sql.rowset.Joinable definition code for javax.sql.rowset.Joinable , ResultSet sample code for java.sql.ResultSet definition code for java.sql.ResultSet , RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet 
public interface JdbcRowSet
extends RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet , Joinable sample code for javax.sql.rowset.Joinable definition code for javax.sql.rowset.Joinable

The standard interface that all standard implementations of JdbcRowSet must implement.

1.0 Overview

A wrapper around a ResultSet object that makes it possible to use the result set as a JavaBeansTM component. Thus, a JdbcRowSet object can be one of the Beans that a tool makes available for composing an application. Because a JdbcRowSet is a connected rowset, that is, it continually maintains its connection to a database using a JDBC technology-enabled driver, it also effectively makes the driver a JavaBeans component.

Because it is always connected to its database, an instance of JdbcRowSet can simply take calls invoked on it and in turn call them on its ResultSet object. As a consequence, a result set can, for example, be a component in a Swing application.

Another advantage of a JdbcRowSet object is that it can be used to make a ResultSet object scrollable and updatable. All RowSet objects are by default scrollable and updatable. If the driver and database being used do not support scrolling and/or updating of result sets, an application can populate a JdbcRowSet object with the data of a ResultSet object and then operate on the JdbcRowSet object as if it were the ResultSet object.

2.0 Creating a JdbcRowSet Object

The reference implementation of the JdbcRowSet interface, JdbcRowSetImpl, provides an implementation of the default constructor. A new instance is initialized with default values, which can be set with new values as needed. A new instance is not really functional until its execute method is called. In general, this method does the following: If the execute method is successful, it will set the appropriate private JdbcRowSet fields with the following: If these fields have not been set, meaning that the execute method has not executed successfully, no methods other than execute and close may be called on the rowset. All other public methods will throw an exception.

Before calling the execute method, however, the command and properties needed for establishing a connection must be set. The following code fragment creates a JdbcRowSetImpl object, sets the command and connection properties, sets the placeholder parameter, and then invokes the method execute. 

     JdbcRowSetImpl jrs = new JdbcRowSetImpl();
     jrs.setCommand("SELECT * FROM TITLES WHERE TYPE = ?");
     jrs.setURL("jdbc:myDriver:myAttribute");
     jrs.setUsername("cervantes");
     jrs.setPassword("sancho");
     jrs.setString(1, "BIOGRAPHY");
     jrs.execute();
The variable jrs now represents an instance of JdbcRowSetImpl that is a thin wrapper around the ResultSet object containing all the rows in the table TITLES where the type of book is biography. At this point, operations called on jrs will affect the rows in the result set, which is effectively a JavaBeans component.

The implementation of the RowSet method execute in the JdbcRowSet reference implementation differs from that in the CachedRowSetTM reference implementation to account for the different requirements of connected and disconnected RowSet objects.

Field Summary
 
Fields inherited from interface java.sql.ResultSet sample code for java.sql.ResultSet definition code for java.sql.ResultSet
CLOSE_CURSORS_AT_COMMIT sample code for java.sql.ResultSet.CLOSE_CURSORS_AT_COMMIT definition code for java.sql.ResultSet.CLOSE_CURSORS_AT_COMMIT , CONCUR_READ_ONLY sample code for java.sql.ResultSet.CONCUR_READ_ONLY definition code for java.sql.ResultSet.CONCUR_READ_ONLY , CONCUR_UPDATABLE sample code for java.sql.ResultSet.CONCUR_UPDATABLE definition code for java.sql.ResultSet.CONCUR_UPDATABLE , FETCH_FORWARD sample code for java.sql.ResultSet.FETCH_FORWARD definition code for java.sql.ResultSet.FETCH_FORWARD , FETCH_REVERSE sample code for java.sql.ResultSet.FETCH_REVERSE definition code for java.sql.ResultSet.FETCH_REVERSE , FETCH_UNKNOWN sample code for java.sql.ResultSet.FETCH_UNKNOWN definition code for java.sql.ResultSet.FETCH_UNKNOWN , HOLD_CURSORS_OVER_COMMIT sample code for java.sql.ResultSet.HOLD_CURSORS_OVER_COMMIT definition code for java.sql.ResultSet.HOLD_CURSORS_OVER_COMMIT , TYPE_FORWARD_ONLY sample code for java.sql.ResultSet.TYPE_FORWARD_ONLY definition code for java.sql.ResultSet.TYPE_FORWARD_ONLY , TYPE_SCROLL_INSENSITIVE sample code for java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE definition code for java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE , TYPE_SCROLL_SENSITIVE sample code for java.sql.ResultSet.TYPE_SCROLL_SENSITIVE definition code for java.sql.ResultSet.TYPE_SCROLL_SENSITIVE
 
Method Summary
 void commit sample code for javax.sql.rowset.JdbcRowSet.commit() definition code for javax.sql.rowset.JdbcRowSet.commit() ()
          Each JdbcRowSet contains a Connection object from the ResultSet or JDBC properties passed to it's constructors.
 boolean getAutoCommit sample code for javax.sql.rowset.JdbcRowSet.getAutoCommit() definition code for javax.sql.rowset.JdbcRowSet.getAutoCommit() ()
          Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it.
 RowSetWarning sample code for javax.sql.rowset.RowSetWarning definition code for javax.sql.rowset.RowSetWarning getRowSetWarnings sample code for javax.sql.rowset.JdbcRowSet.getRowSetWarnings() definition code for javax.sql.rowset.JdbcRowSet.getRowSetWarnings() ()
          Retrieves the first warning reported by calls on this JdbcRowSet object.
 boolean getShowDeleted sample code for javax.sql.rowset.JdbcRowSet.getShowDeleted() definition code for javax.sql.rowset.JdbcRowSet.getShowDeleted() ()
          Retrieves a boolean indicating whether rows marked for deletion appear in the set of current rows.
 void rollback sample code for javax.sql.rowset.JdbcRowSet.rollback() definition code for javax.sql.rowset.JdbcRowSet.rollback() ()
          Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it.
 void rollback sample code for javax.sql.rowset.JdbcRowSet.rollback(java.sql.Savepoint) definition code for javax.sql.rowset.JdbcRowSet.rollback(java.sql.Savepoint) (Savepoint sample code for java.sql.Savepoint definition code for java.sql.Savepoint  s)
          Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it.
 void setAutoCommit sample code for javax.sql.rowset.JdbcRowSet.setAutoCommit(boolean) definition code for javax.sql.rowset.JdbcRowSet.setAutoCommit(boolean) (boolean autoCommit)
          Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it.
 void setShowDeleted sample code for javax.sql.rowset.JdbcRowSet.setShowDeleted(boolean) definition code for javax.sql.rowset.JdbcRowSet.setShowDeleted(boolean) (boolean b)
          Sets the property showDeleted to the given boolean value.
 
Methods inherited from interface javax.sql.RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet
addRowSetListener sample code for javax.sql.RowSet.addRowSetListener(javax.sql.RowSetListener) definition code for javax.sql.RowSet.addRowSetListener(javax.sql.RowSetListener) , clearParameters sample code for javax.sql.RowSet.clearParameters() definition code for javax.sql.RowSet.clearParameters() , execute sample code for javax.sql.RowSet.execute() definition code for javax.sql.RowSet.execute() , getCommand sample code for javax.sql.RowSet.getCommand() definition code for javax.sql.RowSet.getCommand() , getDataSourceName sample code for javax.sql.RowSet.getDataSourceName() definition code for javax.sql.RowSet.getDataSourceName() , getEscapeProcessing sample code for javax.sql.RowSet.getEscapeProcessing() definition code for javax.sql.RowSet.getEscapeProcessing() , getMaxFieldSize sample code for javax.sql.RowSet.getMaxFieldSize() definition code for javax.sql.RowSet.getMaxFieldSize() , getMaxRows sample code for javax.sql.RowSet.getMaxRows() definition code for javax.sql.RowSet.getMaxRows() , getPassword sample code for javax.sql.RowSet.getPassword() definition code for javax.sql.RowSet.getPassword() , getQueryTimeout sample code for javax.sql.RowSet.getQueryTimeout() definition code for javax.sql.RowSet.getQueryTimeout() , getTransactionIsolation sample code for javax.sql.RowSet.getTransactionIsolation() definition code for javax.sql.RowSet.getTransactionIsolation() , getTypeMap sample code for javax.sql.RowSet.getTypeMap() definition code for javax.sql.RowSet.getTypeMap() , getUrl sample code for javax.sql.RowSet.getUrl() definition code for javax.sql.RowSet.getUrl() , getUsername sample code for javax.sql.RowSet.getUsername() definition code for javax.sql.RowSet.getUsername() , isReadOnly sample code for javax.sql.RowSet.isReadOnly() definition code for javax.sql.RowSet.isReadOnly() , removeRowSetListener sample code for javax.sql.RowSet.removeRowSetListener(javax.sql.RowSetListener) definition code for javax.sql.RowSet.removeRowSetListener(javax.sql.RowSetListener) , setArray sample code for javax.sql.RowSet.setArray(int, java.sql.Array) definition code for javax.sql.RowSet.setArray(int, java.sql.Array) , setAsciiStream sample code for javax.sql.RowSet.setAsciiStream(int, java.io.InputStream, int) definition code for javax.sql.RowSet.setAsciiStream(int, java.io.InputStream, int) , setBigDecimal sample code for javax.sql.RowSet.setBigDecimal(int, java.math.BigDecimal) definition code for javax.sql.RowSet.setBigDecimal(int, java.math.BigDecimal) , setBinaryStream sample code for javax.sql.RowSet.setBinaryStream(int, java.io.InputStream, int) definition code for javax.sql.RowSet.setBinaryStream(int, java.io.InputStream, int) , setBlob sample code for javax.sql.RowSet.setBlob(int, java.sql.Blob) definition code for javax.sql.RowSet.setBlob(int, java.sql.Blob) , setBoolean sample code for javax.sql.RowSet.setBoolean(int, boolean) definition code for javax.sql.RowSet.setBoolean(int, boolean) , setByte sample code for javax.sql.RowSet.setByte(int, byte) definition code for javax.sql.RowSet.setByte(int, byte) , setBytes sample code for javax.sql.RowSet.setBytes(int, byte[]) definition code for javax.sql.RowSet.setBytes(int, byte[]) , setCharacterStream sample code for javax.sql.RowSet.setCharacterStream(int, java.io.Reader, int) definition code for javax.sql.RowSet.setCharacterStream(int, java.io.Reader, int) , setClob sample code for javax.sql.RowSet.setClob(int, java.sql.Clob) definition code for javax.sql.RowSet.setClob(int, java.sql.Clob) , setCommand sample code for javax.sql.RowSet.setCommand(java.lang.String) definition code for javax.sql.RowSet.setCommand(java.lang.String) , setConcurrency sample code for javax.sql.RowSet.setConcurrency(int) definition code for javax.sql.RowSet.setConcurrency(int) , setDataSourceName sample code for javax.sql.RowSet.setDataSourceName(java.lang.String) definition code for javax.sql.RowSet.setDataSourceName(java.lang.String) , setDate sample code for javax.sql.RowSet.setDate(int, java.sql.Date) definition code for javax.sql.RowSet.setDate(int, java.sql.Date) , setDate sample code for javax.sql.RowSet.setDate(int, java.sql.Date, java.util.Calendar) definition code for javax.sql.RowSet.setDate(int, java.sql.Date, java.util.Calendar) , setDouble sample code for javax.sql.RowSet.setDouble(int, double) definition code for javax.sql.RowSet.setDouble(int, double) , setEscapeProcessing sample code for javax.sql.RowSet.setEscapeProcessing(boolean) definition code for javax.sql.RowSet.setEscapeProcessing(boolean) , setFloat sample code for javax.sql.RowSet.setFloat(int, float) definition code for javax.sql.RowSet.setFloat(int, float) , setInt sample code for javax.sql.RowSet.setInt(int, int) definition code for javax.sql.RowSet.setInt(int, int) , setLong sample code for javax.sql.RowSet.setLong(int, long) definition code for javax.sql.RowSet.setLong(int, long) , setMaxFieldSize sample code for javax.sql.RowSet.setMaxFieldSize(int) definition code for javax.sql.RowSet.setMaxFieldSize(int) , setMaxRows sample code for javax.sql.RowSet.setMaxRows(int) definition code for javax.sql.RowSet.setMaxRows(int) , setNull sample code for javax.sql.RowSet.setNull(int, int) definition code for javax.sql.RowSet.setNull(int, int) , setNull sample code for javax.sql.RowSet.setNull(int, int, java.lang.String) definition code for javax.sql.RowSet.setNull(int, int, java.lang.String) , setObject sample code for javax.sql.RowSet.setObject(int, java.lang.Object) definition code for javax.sql.RowSet.setObject(int, java.lang.Object) , setObject sample code for javax.sql.RowSet.setObject(int, java.lang.Object, int) definition code for javax.sql.RowSet.setObject(int, java.lang.Object, int) , setObject sample code for javax.sql.RowSet.setObject(int, java.lang.Object, int, int) definition code for javax.sql.RowSet.setObject(int, java.lang.Object, int, int) , setPassword sample code for javax.sql.RowSet.setPassword(java.lang.String) definition code for javax.sql.RowSet.setPassword(java.lang.String) , setQueryTimeout sample code for javax.sql.RowSet.setQueryTimeout(int) definition code for javax.sql.RowSet.setQueryTimeout(int) , setReadOnly sample code for javax.sql.RowSet.setReadOnly(boolean) definition code for javax.sql.RowSet.setReadOnly(boolean) , setRef sample code for javax.sql.RowSet.setRef(int, java.sql.Ref) definition code for javax.sql.RowSet.setRef(int, java.sql.Ref) , setShort sample code for javax.sql.RowSet.setShort(int, short) definition code for javax.sql.RowSet.setShort(int, short) , setString sample code for javax.sql.RowSet.setString(int, java.lang.String) definition code for javax.sql.RowSet.setString(int, java.lang.String) , setTime sample code for javax.sql.RowSet.setTime(int, java.sql.Time) definition code for javax.sql.RowSet.setTime(int, java.sql.Time) , setTime sample code for javax.sql.RowSet.setTime(int, java.sql.Time, java.util.Calendar) definition code for javax.sql.RowSet.setTime(int, java.sql.Time, java.util.Calendar) , setTimestamp sample code for javax.sql.RowSet.setTimestamp(int, java.sql.Timestamp) definition code for javax.sql.RowSet.setTimestamp(int, java.sql.Timestamp) , setTimestamp sample code for javax.sql.RowSet.setTimestamp(int, java.sql.Timestamp, java.util.Calendar) definition code for javax.sql.RowSet.setTimestamp(int, java.sql.Timestamp, java.util.Calendar) , setTransactionIsolation sample code for javax.sql.RowSet.setTransactionIsolation(int) definition code for javax.sql.RowSet.setTransactionIsolation(int) , setType sample code for javax.sql.RowSet.setType(int) definition code for javax.sql.RowSet.setType(int) , setTypeMap sample code for javax.sql.RowSet.setTypeMap(java.util.Map) definition code for javax.sql.RowSet.setTypeMap(java.util.Map) , setUrl sample code for javax.sql.RowSet.setUrl(java.lang.String) definition code for javax.sql.RowSet.setUrl(java.lang.String) , setUsername sample code for javax.sql.RowSet.setUsername(java.lang.String) definition code for javax.sql.RowSet.setUsername(java.lang.String)
 
Methods inherited from interface java.sql.ResultSet sample code for java.sql.ResultSet definition code for java.sql.ResultSet
absolute sample code for java.sql.ResultSet.absolute(int) definition code for java.sql.ResultSet.absolute(int) , afterLast sample code for java.sql.ResultSet.afterLast() definition code for java.sql.ResultSet.afterLast() , beforeFirst sample code for java.sql.ResultSet.beforeFirst() definition code for java.sql.ResultSet.beforeFirst() , cancelRowUpdates sample code for java.sql.ResultSet.cancelRowUpdates() definition code for java.sql.ResultSet.cancelRowUpdates() , clearWarnings sample code for java.sql.ResultSet.clearWarnings() definition code for java.sql.ResultSet.clearWarnings() , close sample code for java.sql.ResultSet.close() definition code for java.sql.ResultSet.close() , deleteRow sample code for java.sql.ResultSet.deleteRow() definition code for java.sql.ResultSet.deleteRow() , findColumn sample code for java.sql.ResultSet.findColumn(java.lang.String) definition code for java.sql.ResultSet.findColumn(java.lang.String) , first sample code for java.sql.ResultSet.first() definition code for java.sql.ResultSet.first() , getArray sample code for java.sql.ResultSet.getArray(int) definition code for java.sql.ResultSet.getArray(int) , getArray sample code for java.sql.ResultSet.getArray(java.lang.String) definition code for java.sql.ResultSet.getArray(java.lang.String) , getAsciiStream sample code for java.sql.ResultSet.getAsciiStream(int) definition code for java.sql.ResultSet.getAsciiStream(int) , getAsciiStream sample code for java.sql.ResultSet.getAsciiStream(java.lang.String) definition code for java.sql.ResultSet.getAsciiStream(java.lang.String) , getBigDecimal sample code for java.sql.ResultSet.getBigDecimal(int) definition code for java.sql.ResultSet.getBigDecimal(int) , getBigDecimal sample code for java.sql.ResultSet.getBigDecimal(int, int) definition code for java.sql.ResultSet.getBigDecimal(int, int) , getBigDecimal sample code for java.sql.ResultSet.getBigDecimal(java.lang.String) definition code for java.sql.ResultSet.getBigDecimal(java.lang.String) , getBigDecimal sample code for java.sql.ResultSet.getBigDecimal(java.lang.String, int) definition code for java.sql.ResultSet.getBigDecimal(java.lang.String, int) , getBinaryStream sample code for java.sql.ResultSet.getBinaryStream(int) definition code for java.sql.ResultSet.getBinaryStream(int) , getBinaryStream sample code for java.sql.ResultSet.getBinaryStream(java.lang.String) definition code for java.sql.ResultSet.getBinaryStream(java.lang.String) , getBlob sample code for java.sql.ResultSet.getBlob(int) definition code for java.sql.ResultSet.getBlob(int) , getBlob sample code for java.sql.ResultSet.getBlob(java.lang.String) definition code for java.sql.ResultSet.getBlob(java.lang.String) , getBoolean sample code for java.sql.ResultSet.getBoolean(int) definition code for java.sql.ResultSet.getBoolean(int) , getBoolean sample code for java.sql.ResultSet.getBoolean(java.lang.String) definition code for java.sql.ResultSet.getBoolean(java.lang.String) , getByte sample code for java.sql.ResultSet.getByte(int) definition code for java.sql.ResultSet.getByte(int) , getByte sample code for java.sql.ResultSet.getByte(java.lang.String) definition code for java.sql.ResultSet.getByte(java.lang.String) , getBytes sample code for java.sql.ResultSet.getBytes(int) definition code for java.sql.ResultSet.getBytes(int) , getBytes sample code for java.sql.ResultSet.getBytes(java.lang.String) definition code for java.sql.ResultSet.getBytes(java.lang.String) , getCharacterStream sample code for java.sql.ResultSet.getCharacterStream(int) definition code for java.sql.ResultSet.getCharacterStream(int) , getCharacterStream sample code for java.sql.ResultSet.getCharacterStream(java.lang.String) definition code for java.sql.ResultSet.getCharacterStream(java.lang.String) , getClob sample code for java.sql.ResultSet.getClob(int) definition code for java.sql.ResultSet.getClob(int) , getClob sample code for java.sql.ResultSet.getClob(java.lang.String) definition code for java.sql.ResultSet.getClob(java.lang.String) , getConcurrency sample code for java.sql.ResultSet.getConcurrency() definition code for java.sql.ResultSet.getConcurrency() , getCursorName sample code for java.sql.ResultSet.getCursorName() definition code for java.sql.ResultSet.getCursorName() , getDate sample code for java.sql.ResultSet.getDate(int) definition code for java.sql.ResultSet.getDate(int) , getDate sample code for java.sql.ResultSet.getDate(int, java.util.Calendar) definition code for java.sql.ResultSet.getDate(int, java.util.Calendar) , getDate sample code for java.sql.ResultSet.getDate(java.lang.String) definition code for java.sql.ResultSet.getDate(java.lang.String) , getDate sample code for java.sql.ResultSet.getDate(java.lang.String, java.util.Calendar) definition code for java.sql.ResultSet.getDate(java.lang.String, java.util.Calendar) , getDouble sample code for java.sql.ResultSet.getDouble(int) definition code for java.sql.ResultSet.getDouble(int) , getDouble sample code for java.sql.ResultSet.getDouble(java.lang.String) definition code for java.sql.ResultSet.getDouble(java.lang.String) , getFetchDirection sample code for java.sql.ResultSet.getFetchDirection() definition code for java.sql.ResultSet.getFetchDirection() , getFetchSize sample code for java.sql.ResultSet.getFetchSize() definition code for java.sql.ResultSet.getFetchSize() , getFloat sample code for java.sql.ResultSet.getFloat(int) definition code for java.sql.ResultSet.getFloat(int) , getFloat sample code for java.sql.ResultSet.getFloat(java.lang.String) definition code for java.sql.ResultSet.getFloat(java.lang.String) , getInt sample code for java.sql.ResultSet.getInt(int) definition code for java.sql.ResultSet.getInt(int) , getInt sample code for java.sql.ResultSet.getInt(java.lang.String) definition code for java.sql.ResultSet.getInt(java.lang.String) , getLong sample code for java.sql.ResultSet.getLong(int) definition code for java.sql.ResultSet.getLong(int) , getLong sample code for java.sql.ResultSet.getLong(java.lang.String) definition code for java.sql.ResultSet.getLong(java.lang.String) , getMetaData sample code for java.sql.ResultSet.getMetaData() definition code for java.sql.ResultSet.getMetaData() , getObject sample code for java.sql.ResultSet.getObject(int) definition code for java.sql.ResultSet.getObject(int) , getObject sample code for java.sql.ResultSet.getObject(int, java.util.Map) definition code for java.sql.ResultSet.getObject(int, java.util.Map) , getObject sample code for java.sql.ResultSet.getObject(java.lang.String) definition code for java.sql.ResultSet.getObject(java.lang.String) , getObject sample code for java.sql.ResultSet.getObject(java.lang.String, java.util.Map) definition code for java.sql.ResultSet.getObject(java.lang.String, java.util.Map) , getRef sample code for java.sql.ResultSet.getRef(int) definition code for java.sql.ResultSet.getRef(int) , getRef sample code for java.sql.ResultSet.getRef(java.lang.String) definition code for java.sql.ResultSet.getRef(java.lang.String) , getRow sample code for java.sql.ResultSet.getRow() definition code for java.sql.ResultSet.getRow() , getShort sample code for java.sql.ResultSet.getShort(int) definition code for java.sql.ResultSet.getShort(int) , getShort sample code for java.sql.ResultSet.getShort(java.lang.String) definition code for java.sql.ResultSet.getShort(java.lang.String) , getStatement sample code for java.sql.ResultSet.getStatement() definition code for java.sql.ResultSet.getStatement() , getString sample code for java.sql.ResultSet.getString(int) definition code for java.sql.ResultSet.getString(int) , getString sample code for java.sql.ResultSet.getString(java.lang.String) definition code for java.sql.ResultSet.getString(java.lang.String) , getTime sample code for java.sql.ResultSet.getTime(int) definition code for java.sql.ResultSet.getTime(int) , getTime sample code for java.sql.ResultSet.getTime(int, java.util.Calendar) definition code for java.sql.ResultSet.getTime(int, java.util.Calendar) , getTime sample code for java.sql.ResultSet.getTime(java.lang.String) definition code for java.sql.ResultSet.getTime(java.lang.String) , getTime sample code for java.sql.ResultSet.getTime(java.lang.String, java.util.Calendar) definition code for java.sql.ResultSet.getTime(java.lang.String, java.util.Calendar) , getTimestamp sample code for java.sql.ResultSet.getTimestamp(int) definition code for java.sql.ResultSet.getTimestamp(int) , getTimestamp sample code for java.sql.ResultSet.getTimestamp(int, java.util.Calendar) definition code for java.sql.ResultSet.getTimestamp(int, java.util.Calendar) , getTimestamp sample code for java.sql.ResultSet.getTimestamp(java.lang.String) definition code for java.sql.ResultSet.getTimestamp(java.lang.String) , getTimestamp sample code for java.sql.ResultSet.getTimestamp(java.lang.String, java.util.Calendar) definition code for java.sql.ResultSet.getTimestamp(java.lang.String, java.util.Calendar) , getType sample code for java.sql.ResultSet.getType() definition code for java.sql.ResultSet.getType() , getUnicodeStream sample code for java.sql.ResultSet.getUnicodeStream(int) definition code for java.sql.ResultSet.getUnicodeStream(int) , getUnicodeStream sample code for java.sql.ResultSet.getUnicodeStream(java.lang.String) definition code for java.sql.ResultSet.getUnicodeStream(java.lang.String) , getURL sample code for java.sql.ResultSet.getURL(int) definition code for java.sql.ResultSet.getURL(int) , getURL sample code for java.sql.ResultSet.getURL(java.lang.String) definition code for java.sql.ResultSet.getURL(java.lang.String) , getWarnings sample code for java.sql.ResultSet.getWarnings() definition code for java.sql.ResultSet.getWarnings() , insertRow sample code for java.sql.ResultSet.insertRow() definition code for java.sql.ResultSet.insertRow() , isAfterLast sample code for java.sql.ResultSet.isAfterLast() definition code for java.sql.ResultSet.isAfterLast() , isBeforeFirst sample code for java.sql.ResultSet.isBeforeFirst() definition code for java.sql.ResultSet.isBeforeFirst() , isFirst sample code for java.sql.ResultSet.isFirst() definition code for java.sql.ResultSet.isFirst() , isLast sample code for java.sql.ResultSet.isLast() definition code for java.sql.ResultSet.isLast() , last sample code for java.sql.ResultSet.last() definition code for java.sql.ResultSet.last() , moveToCurrentRow sample code for java.sql.ResultSet.moveToCurrentRow() definition code for java.sql.ResultSet.moveToCurrentRow() , moveToInsertRow sample code for java.sql.ResultSet.moveToInsertRow() definition code for java.sql.ResultSet.moveToInsertRow() , next sample code for java.sql.ResultSet.next() definition code for java.sql.ResultSet.next() , previous sample code for java.sql.ResultSet.previous() definition code for java.sql.ResultSet.previous() , refreshRow sample code for java.sql.ResultSet.refreshRow() definition code for java.sql.ResultSet.refreshRow() , relative sample code for java.sql.ResultSet.relative(int) definition code for java.sql.ResultSet.relative(int) , rowDeleted sample code for java.sql.ResultSet.rowDeleted() definition code for java.sql.ResultSet.rowDeleted() , rowInserted sample code for java.sql.ResultSet.rowInserted() definition code for java.sql.ResultSet.rowInserted() , rowUpdated sample code for java.sql.ResultSet.rowUpdated() definition code for java.sql.ResultSet.rowUpdated() , setFetchDirection sample code for java.sql.ResultSet.setFetchDirection(int) definition code for java.sql.ResultSet.setFetchDirection(int) , setFetchSize sample code for java.sql.ResultSet.setFetchSize(int) definition code for java.sql.ResultSet.setFetchSize(int) , updateArray sample code for java.sql.ResultSet.updateArray(int, java.sql.Array) definition code for java.sql.ResultSet.updateArray(int, java.sql.Array) , updateArray sample code for java.sql.ResultSet.updateArray(java.lang.String, java.sql.Array) definition code for java.sql.ResultSet.updateArray(java.lang.String, java.sql.Array) , updateAsciiStream sample code for java.sql.ResultSet.updateAsciiStream(int, java.io.InputStream, int) definition code for java.sql.ResultSet.updateAsciiStream(int, java.io.InputStream, int) , updateAsciiStream sample code for java.sql.ResultSet.updateAsciiStream(java.lang.String, java.io.InputStream, int) definition code for java.sql.ResultSet.updateAsciiStream(java.lang.String, java.io.InputStream, int) , updateBigDecimal sample code for java.sql.ResultSet.updateBigDecimal(int, java.math.BigDecimal) definition code for java.sql.ResultSet.updateBigDecimal(int, java.math.BigDecimal) , updateBigDecimal sample code for java.sql.ResultSet.updateBigDecimal(java.lang.String, java.math.BigDecimal) definition code for java.sql.ResultSet.updateBigDecimal(java.lang.String, java.math.BigDecimal) , updateBinaryStream sample code for java.sql.ResultSet.updateBinaryStream(int, java.io.InputStream, int) definition code for java.sql.ResultSet.updateBinaryStream(int, java.io.InputStream, int) , updateBinaryStream sample code for java.sql.ResultSet.updateBinaryStream(java.lang.String, java.io.InputStream, int) definition code for java.sql.ResultSet.updateBinaryStream(java.lang.String, java.io.InputStream, int) , updateBlob sample code for java.sql.ResultSet.updateBlob(int, java.sql.Blob) definition code for java.sql.ResultSet.updateBlob(int, java.sql.Blob) , updateBlob sample code for java.sql.ResultSet.updateBlob(java.lang.String, java.sql.Blob) definition code for java.sql.ResultSet.updateBlob(java.lang.String, java.sql.Blob) , updateBoolean sample code for java.sql.ResultSet.updateBoolean(int, boolean) definition code for java.sql.ResultSet.updateBoolean(int, boolean) , updateBoolean sample code for java.sql.ResultSet.updateBoolean(java.lang.String, boolean) definition code for java.sql.ResultSet.updateBoolean(java.lang.String, boolean) , updateByte sample code for java.sql.ResultSet.updateByte(int, byte) definition code for java.sql.ResultSet.updateByte(int, byte) , updateByte sample code for java.sql.ResultSet.updateByte(java.lang.String, byte) definition code for java.sql.ResultSet.updateByte(java.lang.String, byte) , updateBytes sample code for java.sql.ResultSet.updateBytes(int, byte[]) definition code for java.sql.ResultSet.updateBytes(int, byte[]) , updateBytes sample code for java.sql.ResultSet.updateBytes(java.lang.String, byte[]) definition code for java.sql.ResultSet.updateBytes(java.lang.String, byte[]) , updateCharacterStream sample code for java.sql.ResultSet.updateCharacterStream(int, java.io.Reader, int) definition code for java.sql.ResultSet.updateCharacterStream(int, java.io.Reader, int) , updateCharacterStream sample code for java.sql.ResultSet.updateCharacterStream(java.lang.String, java.io.Reader, int) definition code for java.sql.ResultSet.updateCharacterStream(java.lang.String, java.io.Reader, int) , updateClob sample code for java.sql.ResultSet.updateClob(int, java.sql.Clob) definition code for java.sql.ResultSet.updateClob(int, java.sql.Clob) , updateClob sample code for java.sql.ResultSet.updateClob(java.lang.String, java.sql.Clob) definition code for java.sql.ResultSet.updateClob(java.lang.String, java.sql.Clob) , updateDate sample code for java.sql.ResultSet.updateDate(int, java.sql.Date) definition code for java.sql.ResultSet.updateDate(int, java.sql.Date) , updateDate sample code for java.sql.ResultSet.updateDate(java.lang.String, java.sql.Date) definition code for java.sql.ResultSet.updateDate(java.lang.String, java.sql.Date) , updateDouble sample code for java.sql.ResultSet.updateDouble(int, double) definition code for java.sql.ResultSet.updateDouble(int, double) , updateDouble sample code for java.sql.ResultSet.updateDouble(java.lang.String, double) definition code for java.sql.ResultSet.updateDouble(java.lang.String, double) , updateFloat sample code for java.sql.ResultSet.updateFloat(int, float) definition code for java.sql.ResultSet.updateFloat(int, float) , updateFloat sample code for java.sql.ResultSet.updateFloat(java.lang.String, float) definition code for java.sql.ResultSet.updateFloat(java.lang.String, float) , updateInt sample code for java.sql.ResultSet.updateInt(int, int) definition code for java.sql.ResultSet.updateInt(int, int) , updateInt sample code for java.sql.ResultSet.updateInt(java.lang.String, int) definition code for java.sql.ResultSet.updateInt(java.lang.String, int) , updateLong sample code for java.sql.ResultSet.updateLong(int, long) definition code for java.sql.ResultSet.updateLong(int, long) , updateLong sample code for java.sql.ResultSet.updateLong(java.lang.String, long) definition code for java.sql.ResultSet.updateLong(java.lang.String, long) , updateNull sample code for java.sql.ResultSet.updateNull(int) definition code for java.sql.ResultSet.updateNull(int) , updateNull sample code for java.sql.ResultSet.updateNull(java.lang.String) definition code for java.sql.ResultSet.updateNull(java.lang.String) , updateObject sample code for java.sql.ResultSet.updateObject(int, java.lang.Object) definition code for java.sql.ResultSet.updateObject(int, java.lang.Object) , updateObject sample code for java.sql.ResultSet.updateObject(int, java.lang.Object, int) definition code for java.sql.ResultSet.updateObject(int, java.lang.Object, int) , updateObject sample code for java.sql.ResultSet.updateObject(java.lang.String, java.lang.Object) definition code for java.sql.ResultSet.updateObject(java.lang.String, java.lang.Object) , updateObject sample code for java.sql.ResultSet.updateObject(java.lang.String, java.lang.Object, int) definition code for java.sql.ResultSet.updateObject(java.lang.String, java.lang.Object, int) , updateRef sample code for java.sql.ResultSet.updateRef(int, java.sql.Ref) definition code for java.sql.ResultSet.updateRef(int, java.sql.Ref) , updateRef sample code for java.sql.ResultSet.updateRef(java.lang.String, java.sql.Ref) definition code for java.sql.ResultSet.updateRef(java.lang.String, java.sql.Ref) , updateRow sample code for java.sql.ResultSet.updateRow() definition code for java.sql.ResultSet.updateRow() , updateShort sample code for java.sql.ResultSet.updateShort(int, short) definition code for java.sql.ResultSet.updateShort(int, short) , updateShort sample code for java.sql.ResultSet.updateShort(java.lang.String, short) definition code for java.sql.ResultSet.updateShort(java.lang.String, short) , updateString sample code for java.sql.ResultSet.updateString(int, java.lang.String) definition code for java.sql.ResultSet.updateString(int, java.lang.String) , updateString sample code for java.sql.ResultSet.updateString(java.lang.String, java.lang.String) definition code for java.sql.ResultSet.updateString(java.lang.String, java.lang.String) , updateTime sample code for java.sql.ResultSet.updateTime(int, java.sql.Time) definition code for java.sql.ResultSet.updateTime(int, java.sql.Time) , updateTime sample code for java.sql.ResultSet.updateTime(java.lang.String, java.sql.Time) definition code for java.sql.ResultSet.updateTime(java.lang.String, java.sql.Time) , updateTimestamp sample code for java.sql.ResultSet.updateTimestamp(int, java.sql.Timestamp) definition code for java.sql.ResultSet.updateTimestamp(int, java.sql.Timestamp) , updateTimestamp sample code for java.sql.ResultSet.updateTimestamp(java.lang.String, java.sql.Timestamp) definition code for java.sql.ResultSet.updateTimestamp(java.lang.String, java.sql.Timestamp) , wasNull sample code for java.sql.ResultSet.wasNull() definition code for java.sql.ResultSet.wasNull()
 
Methods inherited from interface javax.sql.rowset.Joinable sample code for javax.sql.rowset.Joinable definition code for javax.sql.rowset.Joinable
getMatchColumnIndexes sample code for javax.sql.rowset.Joinable.getMatchColumnIndexes() definition code for javax.sql.rowset.Joinable.getMatchColumnIndexes() , getMatchColumnNames sample code for javax.sql.rowset.Joinable.getMatchColumnNames() definition code for javax.sql.rowset.Joinable.getMatchColumnNames() , setMatchColumn sample code for javax.sql.rowset.Joinable.setMatchColumn(int) definition code for javax.sql.rowset.Joinable.setMatchColumn(int) , setMatchColumn sample code for javax.sql.rowset.Joinable.setMatchColumn(int[]) definition code for javax.sql.rowset.Joinable.setMatchColumn(int[]) , setMatchColumn sample code for javax.sql.rowset.Joinable.setMatchColumn(java.lang.String) definition code for javax.sql.rowset.Joinable.setMatchColumn(java.lang.String) , setMatchColumn sample code for javax.sql.rowset.Joinable.setMatchColumn(java.lang.String[]) definition code for javax.sql.rowset.Joinable.setMatchColumn(java.lang.String[]) , unsetMatchColumn sample code for javax.sql.rowset.Joinable.unsetMatchColumn(int) definition code for javax.sql.rowset.Joinable.unsetMatchColumn(int) , unsetMatchColumn sample code for javax.sql.rowset.Joinable.unsetMatchColumn(int[]) definition code for javax.sql.rowset.Joinable.unsetMatchColumn(int[]) , unsetMatchColumn sample code for javax.sql.rowset.Joinable.unsetMatchColumn(java.lang.String) definition code for javax.sql.rowset.Joinable.unsetMatchColumn(java.lang.String) , unsetMatchColumn sample code for javax.sql.rowset.Joinable.unsetMatchColumn(java.lang.String[]) definition code for javax.sql.rowset.Joinable.unsetMatchColumn(java.lang.String[])
 

Method Detail

getShowDeleted sample code for javax.sql.rowset.JdbcRowSet.getShowDeleted() definition code for javax.sql.rowset.JdbcRowSet.getShowDeleted() 

boolean getShowDeleted()
                       throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Retrieves a boolean indicating whether rows marked for deletion appear in the set of current rows. If true is returned, deleted rows are visible with the current rows. If false is returned, rows are not visible with the set of current rows. The default value is false.

Standard rowset implementations may choose to restrict this behavior for security considerations or for certain deployment scenarios. The visibility of deleted rows is implementation-defined and does not represent standard behavior.

Note: Allowing deleted rows to remain visible complicates the behavior of some standard JDBC RowSet implementations methods. However, most rowset users can simply ignore this extra detail because only very specialized applications will likely want to take advantage of this feature.

Returns:
true if deleted rows are visible; false otherwise
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a rowset implementation is unable to to determine whether rows marked for deletion remain visible
See Also:
setShowDeleted(boolean) sample code for javax.sql.rowset.JdbcRowSet.setShowDeleted(boolean) definition code for javax.sql.rowset.JdbcRowSet.setShowDeleted(boolean)

setShowDeleted sample code for javax.sql.rowset.JdbcRowSet.setShowDeleted(boolean) definition code for javax.sql.rowset.JdbcRowSet.setShowDeleted(boolean) 

void setShowDeleted(boolean b)
                    throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Sets the property showDeleted to the given boolean value. This property determines whether rows marked for deletion continue to appear in the set of current rows. If the value is set to true, deleted rows are immediately visible with the set of current rows. If the value is set to false, the deleted rows are set as invisible with the current set of rows.

Standard rowset implementations may choose to restrict this behavior for security considerations or for certain deployment scenarios. This is left as implementation-defined and does not represent standard behavior.

Parameters:
b - true if deleted rows should be shown; false otherwise
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a rowset implementation is unable to to reset whether deleted rows should be visible
See Also:
getShowDeleted() sample code for javax.sql.rowset.JdbcRowSet.getShowDeleted() definition code for javax.sql.rowset.JdbcRowSet.getShowDeleted()

getRowSetWarnings sample code for javax.sql.rowset.JdbcRowSet.getRowSetWarnings() definition code for javax.sql.rowset.JdbcRowSet.getRowSetWarnings() 

RowSetWarning sample code for javax.sql.rowset.RowSetWarning definition code for javax.sql.rowset.RowSetWarning  getRowSetWarnings()
                                throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Retrieves the first warning reported by calls on this JdbcRowSet object. If a second warning was reported on this JdbcRowSet object, it will be chained to the first warning and can be retrieved by calling the method RowSetWarning.getNextWarning on the first warning. Subsequent warnings on this JdbcRowSet object will be chained to the RowSetWarning objects returned by the method RowSetWarning.getNextWarning. The warning chain is automatically cleared each time a new row is read. This method may not be called on a RowSet object that has been closed; doing so will cause an SQLException to be thrown.

Because it is always connected to its data source, a JdbcRowSet object can rely on the presence of active Statement, Connection, and ResultSet instances. This means that applications can obtain additional SQLWarning notifications by calling the getNextWarning methods that they provide. Disconnected Rowset objects, such as a CachedRowSet object, do not have access to these getNextWarning methods.

Returns:
the first RowSetWarning object reported on this JdbcRowSet object or null if there are none
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if this method is called on a closed JdbcRowSet object
See Also:
RowSetWarning sample code for javax.sql.rowset.RowSetWarning definition code for javax.sql.rowset.RowSetWarning

commit sample code for javax.sql.rowset.JdbcRowSet.commit() definition code for javax.sql.rowset.JdbcRowSet.commit() 

void commit()
            throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Each JdbcRowSet contains a Connection object from the ResultSet or JDBC properties passed to it's constructors. This method wraps the Connection commit method to allow flexible auto commit or non auto commit transactional control support.

Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by this Connection object. This method should be used only when auto-commit mode has been disabled.

Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs or this Connection object within this JdbcRowSet is in auto-commit mode
See Also:
Connection.setAutoCommit(boolean) sample code for java.sql.Connection.setAutoCommit(boolean) definition code for java.sql.Connection.setAutoCommit(boolean)

getAutoCommit sample code for javax.sql.rowset.JdbcRowSet.getAutoCommit() definition code for javax.sql.rowset.JdbcRowSet.getAutoCommit() 

boolean getAutoCommit()
                      throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it. This method wraps the Connection's getAutoCommit method to allow an application to determine the JdbcRowSet transaction behavior.

Sets this connection's auto-commit mode to the given state. If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions. Otherwise, its SQL statements are grouped into transactions that are terminated by a call to either the method commit or the method rollback. By default, new connections are in auto-commit mode.

Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs
See Also:
Connection.getAutoCommit() sample code for java.sql.Connection.getAutoCommit() definition code for java.sql.Connection.getAutoCommit()

setAutoCommit sample code for javax.sql.rowset.JdbcRowSet.setAutoCommit(boolean) definition code for javax.sql.rowset.JdbcRowSet.setAutoCommit(boolean) 

void setAutoCommit(boolean autoCommit)
                   throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it. This method wraps the Connection's getAutoCommit method to allow an application to set the JdbcRowSet transaction behavior.

Sets the current auto-commit mode for this Connection object.

Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs
See Also:
Connection.setAutoCommit(boolean) sample code for java.sql.Connection.setAutoCommit(boolean) definition code for java.sql.Connection.setAutoCommit(boolean)

rollback sample code for javax.sql.rowset.JdbcRowSet.rollback() definition code for javax.sql.rowset.JdbcRowSet.rollback() 

void rollback()
              throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it. Undoes all changes made in the current transaction and releases any database locks currently held by this Connection object. This method should be used only when auto-commit mode has been disabled.

Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs or this Connection object within this JdbcRowSet is in auto-commit mode.
See Also:
rollback(Savepoint) sample code for javax.sql.rowset.JdbcRowSet.rollback(java.sql.Savepoint) definition code for javax.sql.rowset.JdbcRowSet.rollback(java.sql.Savepoint)

rollback sample code for javax.sql.rowset.JdbcRowSet.rollback(java.sql.Savepoint) definition code for javax.sql.rowset.JdbcRowSet.rollback(java.sql.Savepoint) 

void rollback(Savepoint sample code for java.sql.Savepoint definition code for java.sql.Savepoint  s)
              throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Each JdbcRowSet contains a Connection object from the original ResultSet or JDBC properties passed to it. Undoes all changes made in the current transaction to the last set savepoint and releases any database locks currently held by this Connection object. This method should be used only when auto-commit mode has been disabled.

Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs or this Connection object within this JdbcRowSet is in auto-commit mode.
See Also:
rollback() sample code for javax.sql.rowset.JdbcRowSet.rollback() definition code for javax.sql.rowset.JdbcRowSet.rollback()
Overview  Package   Class  Tree  Deprecated  Index  Help  Codase Click search sample or example code, search definition, search google 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD