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 JoinRowSet

All Superinterfaces:
CachedRowSet sample code for javax.sql.rowset.CachedRowSet definition code for javax.sql.rowset.CachedRowSet , 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 , WebRowSet sample code for javax.sql.rowset.WebRowSet definition code for javax.sql.rowset.WebRowSet 
public interface JoinRowSet
extends WebRowSet sample code for javax.sql.rowset.WebRowSet definition code for javax.sql.rowset.WebRowSet

The JoinRowSet interface provides a mechanism for combining related data from different RowSet objects into one JoinRowSet object, which represents an SQL JOIN. In other words, a JoinRowSet object acts as a container for the data from RowSet objects that form an SQL JOIN relationship.

The Joinable interface provides the methods for setting, retrieving, and unsetting a match column, the basis for establishing an SQL JOIN relationship. The match column may alternatively be set by supplying it to the appropriate version of the JointRowSet method addRowSet.

1.0 Overview

Disconnected RowSet objects (CachedRowSet objects and implementations extending the CachedRowSet interface) do not have a standard way to establish an SQL JOIN between RowSet objects without the expensive operation of reconnecting to the data source. The JoinRowSet interface is specifically designed to address this need.

Any RowSet object can be added to a JoinRowSet object to become part of an SQL JOIN relationship. This means that both connected and disconnected RowSet objects can be part of a JOIN. RowSet objects operating in a connected environment (JdbcRowSet objects) are encouraged to use the database to which they are already connected to establish SQL JOIN relationships between tables directly. However, it is possible for a JdbcRowSet object to be added to a JoinRowSet object if necessary.

Any number of RowSet objects can be added to an instance of JoinRowSet provided that they can be related in an SQL JOIN. By definition, the SQL JOIN statement is used to combine the data contained in two or more relational database tables based upon a common attribute. The Joinable interface provides the methods for establishing a common attribute, which is done by setting a match column. The match column commonly coincides with the primary key, but there is no requirement that the match column be the same as the primary key. By establishing and then enforcing column matches, a JoinRowSet object establishes JOIN relationships between RowSet objects without the assistance of an available relational database.

The type of JOIN to be established is determined by setting one of the JoinRowSet constants using the method setJoinType. The following SQL JOIN types can be set:

Note that if no type is set, the JOIN will automatically be an inner join. The comments for the fields in the JoinRowSet interface explain these JOIN types, which are standard SQL JOIN types.

2.0 Using a JoinRowSet Object for Creating a JOIN

When a JoinRowSet object is created, it is empty. The first RowSet object to be added becomes the basis for the JOIN relationship. Applications must determine which column in each of the RowSet objects to be added to the JoinRowSet object should be the match column. All of the RowSet objects must contain a match column, and the values in each match column must be ones that can be compared to values in the other match columns. The columns do not have to have the same name, though they often do, and they do not have to store the exact same data type as long as the data types can be compared.

A match column can be be set in two ways:

3.0 Sample Usage

The following code fragment adds two CachedRowSet objects to a JoinRowSet object. Note that in this example, no SQL JOIN type is set, so the default JOIN type, which is INNER_JOIN, is established.

In the following code fragment, the table EMPLOYEES, whose match column is set to the first column (EMP_ID), is added to the JoinRowSet object jrs. Then the table ESSP_BONUS_PLAN, whose match column is likewise the EMP_ID column, is added. When this second table is added to jrs, only the rows in ESSP_BONUS_PLAN whose EMP_ID value matches an EMP_ID value in the EMPLOYEES table are added. In this case, everyone in the bonus plan is an employee, so all of the rows in the table ESSP_BONUS_PLAN are added to the JoinRowSet object. In this example, both CachedRowSet objects being added have implemented the Joinable interface and can therefore call the Joinable method setMatchColumn. 

     JoinRowSet jrs = new JoinRowSetImpl();
 
     ResultSet rs1 = stmt.executeQuery("SELECT * FROM EMPLOYEES");
     CachedRowSet empl = new CachedRowSetImpl();
     empl.populate(rs1);
     empl.setMatchColumn(1); 
     jrs.addRowSet(empl);
 
     ResultSet rs2 = stmt.executeQuery("SELECT * FROM ESSP_BONUS_PLAN");
     CachedRowSet bonus = new CachedRowSetImpl();
     bonus.populate(rs2);
     bonus.setMatchColumn(1); // EMP_ID is the first column
     jrs.addRowSet(bonus);

At this point, jrs is an inside JOIN of the two RowSet objects based on their EMP_ID columns. The application can now browse the combined data as if it were browsing one single RowSet object. Because jrs is itself a RowSet object, an application can navigate or modify it using RowSet methods. 

     jrs.first();
     int employeeID = jrs.getInt(1);
     String employeeName = jrs.getString(2);

Note that because the SQL JOIN must be enforced when an application adds a second or subsequent RowSet object, there may be an initial degradation in performance while the JOIN is being performed.

The following code fragment adds an additional CachedRowSet object. In this case, the match column (EMP_ID) is set when the CachedRowSet object is added to the JoinRowSet object. 

     ResultSet rs3 = stmt.executeQuery("SELECT * FROM 401K_CONTRIB");
     CachedRowSet fourO1k = new CachedRowSetImpl();
     four01k.populate(rs3);
     jrs.addRowSet(four01k, 1);

The JoinRowSet object jrs now contains values from all three tables. The data in each row in four01k in which the value for the EMP_ID column matches a value for the EMP_ID column in jrs has been added to jrs.

4.0 JoinRowSet Methods

The JoinRowSet interface supplies several methods for adding RowSet objects and for getting information about the JoinRowSet object.

Field Summary
static int CROSS_JOIN sample code for javax.sql.rowset.JoinRowSet.CROSS_JOIN definition code for javax.sql.rowset.JoinRowSet.CROSS_JOIN
          An ANSI-style JOIN providing a cross product of two tables
static int FULL_JOIN sample code for javax.sql.rowset.JoinRowSet.FULL_JOIN definition code for javax.sql.rowset.JoinRowSet.FULL_JOIN
          An ANSI-style JOIN providing a a full JOIN.
static int INNER_JOIN sample code for javax.sql.rowset.JoinRowSet.INNER_JOIN definition code for javax.sql.rowset.JoinRowSet.INNER_JOIN
          An ANSI-style JOIN providing a inner join between two tables.
static int LEFT_OUTER_JOIN sample code for javax.sql.rowset.JoinRowSet.LEFT_OUTER_JOIN definition code for javax.sql.rowset.JoinRowSet.LEFT_OUTER_JOIN
          An ANSI-style JOIN providing a left outer join between two tables.
static int RIGHT_OUTER_JOIN sample code for javax.sql.rowset.JoinRowSet.RIGHT_OUTER_JOIN definition code for javax.sql.rowset.JoinRowSet.RIGHT_OUTER_JOIN
          An ANSI-style JOIN providing a right outer join between two tables.
 
Fields inherited from interface javax.sql.rowset.WebRowSet sample code for javax.sql.rowset.WebRowSet definition code for javax.sql.rowset.WebRowSet
PUBLIC_XML_SCHEMA sample code for javax.sql.rowset.WebRowSet.PUBLIC_XML_SCHEMA definition code for javax.sql.rowset.WebRowSet.PUBLIC_XML_SCHEMA , SCHEMA_SYSTEM_ID sample code for javax.sql.rowset.WebRowSet.SCHEMA_SYSTEM_ID definition code for javax.sql.rowset.WebRowSet.SCHEMA_SYSTEM_ID
 
Fields inherited from interface javax.sql.rowset.CachedRowSet sample code for javax.sql.rowset.CachedRowSet definition code for javax.sql.rowset.CachedRowSet
COMMIT_ON_ACCEPT_CHANGES sample code for javax.sql.rowset.CachedRowSet.COMMIT_ON_ACCEPT_CHANGES definition code for javax.sql.rowset.CachedRowSet.COMMIT_ON_ACCEPT_CHANGES
 
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 addRowSet sample code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.rowset.Joinable) definition code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.rowset.Joinable) (Joinable sample code for javax.sql.rowset.Joinable definition code for javax.sql.rowset.Joinable  rowset)
          Adds the given RowSet object to this JoinRowSet object.
 void addRowSet sample code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet[], int[]) definition code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet[], int[]) (RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet [] rowset, int[] columnIdx)
          Adds one or more RowSet objects contained in the given array of RowSet objects to this JoinRowSet object and sets the match column for each of the RowSet objects to the match columns in the given array of column indexes.
 void addRowSet sample code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet[], java.lang.String[]) definition code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet[], java.lang.String[]) (RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet [] rowset, String sample code for java.lang.String definition code for java.lang.String [] columnName)
          Adds one or more RowSet objects contained in the given array of RowSet objects to this JoinRowSet object and sets the match column for each of the RowSet objects to the match columns in the given array of column names.
 void addRowSet sample code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet, int) definition code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet, int) (RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet  rowset, int columnIdx)
          Adds the given RowSet object to this JoinRowSet object and sets the designated column as the match column for the RowSet object.
 void addRowSet sample code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet, java.lang.String) definition code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet, java.lang.String) (RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet  rowset, String sample code for java.lang.String definition code for java.lang.String  columnName)
          Adds rowset to this JoinRowSet object and sets the designated column as the match column.
 int getJoinType sample code for javax.sql.rowset.JoinRowSet.getJoinType() definition code for javax.sql.rowset.JoinRowSet.getJoinType() ()
          Returns a int describing the set SQL JOIN type governing this JoinRowSet instance.
 String sample code for java.lang.String definition code for java.lang.String [] getRowSetNames sample code for javax.sql.rowset.JoinRowSet.getRowSetNames() definition code for javax.sql.rowset.JoinRowSet.getRowSetNames() ()
          Returns a String array containing the names of the RowSet objects added to this JoinRowSet object.
 Collection sample code for java.util.Collection definition code for java.util.Collection <?> getRowSets sample code for javax.sql.rowset.JoinRowSet.getRowSets() definition code for javax.sql.rowset.JoinRowSet.getRowSets() ()
          Returns a Collection object containing the RowSet objects that have been added to this JoinRowSet object.
 String sample code for java.lang.String definition code for java.lang.String getWhereClause sample code for javax.sql.rowset.JoinRowSet.getWhereClause() definition code for javax.sql.rowset.JoinRowSet.getWhereClause() ()
          Return a SQL-like description of the WHERE clause being used in a JoinRowSet object.
 void setJoinType sample code for javax.sql.rowset.JoinRowSet.setJoinType(int) definition code for javax.sql.rowset.JoinRowSet.setJoinType(int) (int joinType)
          Allow the application to adjust the type of JOIN imposed on tables contained within the JoinRowSet object instance.
 boolean supportsCrossJoin sample code for javax.sql.rowset.JoinRowSet.supportsCrossJoin() definition code for javax.sql.rowset.JoinRowSet.supportsCrossJoin() ()
          Indicates if CROSS_JOIN is supported by a JoinRowSet implementation
 boolean supportsFullJoin sample code for javax.sql.rowset.JoinRowSet.supportsFullJoin() definition code for javax.sql.rowset.JoinRowSet.supportsFullJoin() ()
          Indicates if FULL_JOIN is supported by a JoinRowSet implementation
 boolean supportsInnerJoin sample code for javax.sql.rowset.JoinRowSet.supportsInnerJoin() definition code for javax.sql.rowset.JoinRowSet.supportsInnerJoin() ()
          Indicates if INNER_JOIN is supported by a JoinRowSet implementation
 boolean supportsLeftOuterJoin sample code for javax.sql.rowset.JoinRowSet.supportsLeftOuterJoin() definition code for javax.sql.rowset.JoinRowSet.supportsLeftOuterJoin() ()
          Indicates if LEFT_OUTER_JOIN is supported by a JoinRowSet implementation
 boolean supportsRightOuterJoin sample code for javax.sql.rowset.JoinRowSet.supportsRightOuterJoin() definition code for javax.sql.rowset.JoinRowSet.supportsRightOuterJoin() ()
          Indicates if RIGHT_OUTER_JOIN is supported by a JoinRowSet implementation
 CachedRowSet sample code for javax.sql.rowset.CachedRowSet definition code for javax.sql.rowset.CachedRowSet toCachedRowSet sample code for javax.sql.rowset.JoinRowSet.toCachedRowSet() definition code for javax.sql.rowset.JoinRowSet.toCachedRowSet() ()
          Creates a new CachedRowSet object containing the data in this JoinRowSet object, which can be saved to a data source using the SyncProvider object for the CachedRowSet object.
 
Methods inherited from interface javax.sql.rowset.WebRowSet sample code for javax.sql.rowset.WebRowSet definition code for javax.sql.rowset.WebRowSet
readXml sample code for javax.sql.rowset.WebRowSet.readXml(java.io.InputStream) definition code for javax.sql.rowset.WebRowSet.readXml(java.io.InputStream) , readXml sample code for javax.sql.rowset.WebRowSet.readXml(java.io.Reader) definition code for javax.sql.rowset.WebRowSet.readXml(java.io.Reader) , writeXml sample code for javax.sql.rowset.WebRowSet.writeXml(java.io.OutputStream) definition code for javax.sql.rowset.WebRowSet.writeXml(java.io.OutputStream) , writeXml sample code for javax.sql.rowset.WebRowSet.writeXml(java.sql.ResultSet, java.io.OutputStream) definition code for javax.sql.rowset.WebRowSet.writeXml(java.sql.ResultSet, java.io.OutputStream) , writeXml sample code for javax.sql.rowset.WebRowSet.writeXml(java.sql.ResultSet, java.io.Writer) definition code for javax.sql.rowset.WebRowSet.writeXml(java.sql.ResultSet, java.io.Writer) , writeXml sample code for javax.sql.rowset.WebRowSet.writeXml(java.io.Writer) definition code for javax.sql.rowset.WebRowSet.writeXml(java.io.Writer)
 
Methods inherited from interface javax.sql.rowset.CachedRowSet sample code for javax.sql.rowset.CachedRowSet definition code for javax.sql.rowset.CachedRowSet
acceptChanges sample code for javax.sql.rowset.CachedRowSet.acceptChanges() definition code for javax.sql.rowset.CachedRowSet.acceptChanges() , acceptChanges sample code for javax.sql.rowset.CachedRowSet.acceptChanges(java.sql.Connection) definition code for javax.sql.rowset.CachedRowSet.acceptChanges(java.sql.Connection) , columnUpdated sample code for javax.sql.rowset.CachedRowSet.columnUpdated(int) definition code for javax.sql.rowset.CachedRowSet.columnUpdated(int) , columnUpdated sample code for javax.sql.rowset.CachedRowSet.columnUpdated(java.lang.String) definition code for javax.sql.rowset.CachedRowSet.columnUpdated(java.lang.String) , commit sample code for javax.sql.rowset.CachedRowSet.commit() definition code for javax.sql.rowset.CachedRowSet.commit() , createCopy sample code for javax.sql.rowset.CachedRowSet.createCopy() definition code for javax.sql.rowset.CachedRowSet.createCopy() , createCopyNoConstraints sample code for javax.sql.rowset.CachedRowSet.createCopyNoConstraints() definition code for javax.sql.rowset.CachedRowSet.createCopyNoConstraints() , createCopySchema sample code for javax.sql.rowset.CachedRowSet.createCopySchema() definition code for javax.sql.rowset.CachedRowSet.createCopySchema() , createShared sample code for javax.sql.rowset.CachedRowSet.createShared() definition code for javax.sql.rowset.CachedRowSet.createShared() , execute sample code for javax.sql.rowset.CachedRowSet.execute(java.sql.Connection) definition code for javax.sql.rowset.CachedRowSet.execute(java.sql.Connection) , getKeyColumns sample code for javax.sql.rowset.CachedRowSet.getKeyColumns() definition code for javax.sql.rowset.CachedRowSet.getKeyColumns() , getOriginal sample code for javax.sql.rowset.CachedRowSet.getOriginal() definition code for javax.sql.rowset.CachedRowSet.getOriginal() , getOriginalRow sample code for javax.sql.rowset.CachedRowSet.getOriginalRow() definition code for javax.sql.rowset.CachedRowSet.getOriginalRow() , getPageSize sample code for javax.sql.rowset.CachedRowSet.getPageSize() definition code for javax.sql.rowset.CachedRowSet.getPageSize() , getRowSetWarnings sample code for javax.sql.rowset.CachedRowSet.getRowSetWarnings() definition code for javax.sql.rowset.CachedRowSet.getRowSetWarnings() , getShowDeleted sample code for javax.sql.rowset.CachedRowSet.getShowDeleted() definition code for javax.sql.rowset.CachedRowSet.getShowDeleted() , getSyncProvider sample code for javax.sql.rowset.CachedRowSet.getSyncProvider() definition code for javax.sql.rowset.CachedRowSet.getSyncProvider() , getTableName sample code for javax.sql.rowset.CachedRowSet.getTableName() definition code for javax.sql.rowset.CachedRowSet.getTableName() , nextPage sample code for javax.sql.rowset.CachedRowSet.nextPage() definition code for javax.sql.rowset.CachedRowSet.nextPage() , populate sample code for javax.sql.rowset.CachedRowSet.populate(java.sql.ResultSet) definition code for javax.sql.rowset.CachedRowSet.populate(java.sql.ResultSet) , populate sample code for javax.sql.rowset.CachedRowSet.populate(java.sql.ResultSet, int) definition code for javax.sql.rowset.CachedRowSet.populate(java.sql.ResultSet, int) , previousPage sample code for javax.sql.rowset.CachedRowSet.previousPage() definition code for javax.sql.rowset.CachedRowSet.previousPage() , release sample code for javax.sql.rowset.CachedRowSet.release() definition code for javax.sql.rowset.CachedRowSet.release() , restoreOriginal sample code for javax.sql.rowset.CachedRowSet.restoreOriginal() definition code for javax.sql.rowset.CachedRowSet.restoreOriginal() , rollback sample code for javax.sql.rowset.CachedRowSet.rollback() definition code for javax.sql.rowset.CachedRowSet.rollback() , rollback sample code for javax.sql.rowset.CachedRowSet.rollback(java.sql.Savepoint) definition code for javax.sql.rowset.CachedRowSet.rollback(java.sql.Savepoint) , rowSetPopulated sample code for javax.sql.rowset.CachedRowSet.rowSetPopulated(javax.sql.RowSetEvent, int) definition code for javax.sql.rowset.CachedRowSet.rowSetPopulated(javax.sql.RowSetEvent, int) , setKeyColumns sample code for javax.sql.rowset.CachedRowSet.setKeyColumns(int[]) definition code for javax.sql.rowset.CachedRowSet.setKeyColumns(int[]) , setMetaData sample code for javax.sql.rowset.CachedRowSet.setMetaData(javax.sql.RowSetMetaData) definition code for javax.sql.rowset.CachedRowSet.setMetaData(javax.sql.RowSetMetaData) , setOriginalRow sample code for javax.sql.rowset.CachedRowSet.setOriginalRow() definition code for javax.sql.rowset.CachedRowSet.setOriginalRow() , setPageSize sample code for javax.sql.rowset.CachedRowSet.setPageSize(int) definition code for javax.sql.rowset.CachedRowSet.setPageSize(int) , setShowDeleted sample code for javax.sql.rowset.CachedRowSet.setShowDeleted(boolean) definition code for javax.sql.rowset.CachedRowSet.setShowDeleted(boolean) , setSyncProvider sample code for javax.sql.rowset.CachedRowSet.setSyncProvider(java.lang.String) definition code for javax.sql.rowset.CachedRowSet.setSyncProvider(java.lang.String) , setTableName sample code for javax.sql.rowset.CachedRowSet.setTableName(java.lang.String) definition code for javax.sql.rowset.CachedRowSet.setTableName(java.lang.String) , size sample code for javax.sql.rowset.CachedRowSet.size() definition code for javax.sql.rowset.CachedRowSet.size() , toCollection sample code for javax.sql.rowset.CachedRowSet.toCollection() definition code for javax.sql.rowset.CachedRowSet.toCollection() , toCollection sample code for javax.sql.rowset.CachedRowSet.toCollection(int) definition code for javax.sql.rowset.CachedRowSet.toCollection(int) , toCollection sample code for javax.sql.rowset.CachedRowSet.toCollection(java.lang.String) definition code for javax.sql.rowset.CachedRowSet.toCollection(java.lang.String) , undoDelete sample code for javax.sql.rowset.CachedRowSet.undoDelete() definition code for javax.sql.rowset.CachedRowSet.undoDelete() , undoInsert sample code for javax.sql.rowset.CachedRowSet.undoInsert() definition code for javax.sql.rowset.CachedRowSet.undoInsert() , undoUpdate sample code for javax.sql.rowset.CachedRowSet.undoUpdate() definition code for javax.sql.rowset.CachedRowSet.undoUpdate()
 
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[])
 

Field Detail

CROSS_JOIN sample code for javax.sql.rowset.JoinRowSet.CROSS_JOIN 

static final int CROSS_JOIN
An ANSI-style JOIN providing a cross product of two tables

See Also:
Constant Field Values

INNER_JOIN sample code for javax.sql.rowset.JoinRowSet.INNER_JOIN 

static final int INNER_JOIN
An ANSI-style JOIN providing a inner join between two tables. Any unmatched rows in either table of the join should be discarded.

See Also:
Constant Field Values

LEFT_OUTER_JOIN sample code for javax.sql.rowset.JoinRowSet.LEFT_OUTER_JOIN 

static final int LEFT_OUTER_JOIN
An ANSI-style JOIN providing a left outer join between two tables. In SQL, this is described where all records should be returned from the left side of the JOIN statement.

See Also:
Constant Field Values

RIGHT_OUTER_JOIN sample code for javax.sql.rowset.JoinRowSet.RIGHT_OUTER_JOIN 

static final int RIGHT_OUTER_JOIN
An ANSI-style JOIN providing a right outer join between two tables. In SQL, this is described where all records from the table on the right side of the JOIN statement even if the table on the left has no matching record.

See Also:
Constant Field Values

FULL_JOIN sample code for javax.sql.rowset.JoinRowSet.FULL_JOIN 

static final int FULL_JOIN
An ANSI-style JOIN providing a a full JOIN. Specifies that all rows from either table be returned regardless of matching records on the other table.

See Also:
Constant Field Values
Method Detail

addRowSet sample code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.rowset.Joinable) definition code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.rowset.Joinable) 

void addRowSet(Joinable sample code for javax.sql.rowset.Joinable definition code for javax.sql.rowset.Joinable  rowset)
               throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Adds the given RowSet object to this JoinRowSet object. If the RowSet object is the first to be added to this JoinRowSet object, it forms the basis of the JOIN relationship to be established.

This method should be used only when the given RowSet object already has a match column that was set with the Joinable method setMatchColumn.

Note: A Joinable object is any RowSet object that has implemented the Joinable interface.

Parameters:
rowset - the RowSet object that is to be added to this JoinRowSet object; it must implement the Joinable interface and have a match column set
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if (1) an empty rowset is added to the to this JoinRowSet object, (2) a match column has not been set for rowset, or (3) rowset violates the active JOIN
See Also:
Joinable.setMatchColumn(int) sample code for javax.sql.rowset.Joinable.setMatchColumn(int) definition code for javax.sql.rowset.Joinable.setMatchColumn(int)

addRowSet sample code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet, int) definition code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet, int) 

void addRowSet(RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet  rowset,
               int columnIdx)
               throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Adds the given RowSet object to this JoinRowSet object and sets the designated column as the match column for the RowSet object. If the RowSet object is the first to be added to this JoinRowSet object, it forms the basis of the JOIN relationship to be established.

This method should be used when RowSet does not already have a match column set.

Parameters:
rowset - the RowSet object that is to be added to this JoinRowSet object; it may implement the Joinable interface
columnIdx - an int that identifies the column to become the match column
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if (1) rowset is an empty rowset or (2) rowset violates the active JOIN
See Also:
Joinable.unsetMatchColumn(int) sample code for javax.sql.rowset.Joinable.unsetMatchColumn(int) definition code for javax.sql.rowset.Joinable.unsetMatchColumn(int)

addRowSet sample code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet, java.lang.String) definition code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet, java.lang.String) 

void addRowSet(RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet  rowset,
               String sample code for java.lang.String definition code for java.lang.String  columnName)
               throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Adds rowset to this JoinRowSet object and sets the designated column as the match column. If rowset is the first to be added to this JoinRowSet object, it forms the basis for the JOIN relationship to be established.

This method should be used when the given RowSet object does not already have a match column.

Parameters:
rowset - the RowSet object that is to be added to this JoinRowSet object; it may implement the Joinable interface
columnName - the String object giving the name of the column to be set as the match column
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if (1) rowset is an empty rowset or (2) the match column for rowset does not satisfy the conditions of the JOIN

addRowSet sample code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet[], int[]) definition code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet[], int[]) 

void addRowSet(RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet [] rowset,
               int[] columnIdx)
               throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Adds one or more RowSet objects contained in the given array of RowSet objects to this JoinRowSet object and sets the match column for each of the RowSet objects to the match columns in the given array of column indexes. The first element in columnIdx is set as the match column for the first RowSet object in rowset, the second element of columnIdx is set as the match column for the second element in rowset, and so on.

The first RowSet object added to this JoinRowSet object forms the basis for the JOIN relationship.

This method should be used when the given RowSet object does not already have a match column.

Parameters:
rowset - an array of one or more RowSet objects to be added to the JOIN; it may implement the Joinable interface
columnIdx - an array of int values indicating the index(es) of the columns to be set as the match columns for the RowSet objects in rowset
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if (1) an empty rowset is added to this JoinRowSet object, (2) a match column is not set for a RowSet object in rowset, or (3) a RowSet object being added violates the active JOIN

addRowSet sample code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet[], java.lang.String[]) definition code for javax.sql.rowset.JoinRowSet.addRowSet(javax.sql.RowSet[], java.lang.String[]) 

void addRowSet(RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet [] rowset,
               String sample code for java.lang.String definition code for java.lang.String [] columnName)
               throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Adds one or more RowSet objects contained in the given array of RowSet objects to this JoinRowSet object and sets the match column for each of the RowSet objects to the match columns in the given array of column names. The first element in columnName is set as the match column for the first RowSet object in rowset, the second element of columnName is set as the match column for the second element in rowset, and so on.

The first RowSet object added to this JoinRowSet object forms the basis for the JOIN relationship.

This method should be used when the given RowSet object(s) does not already have a match column.

Parameters:
rowset - an array of one or more RowSet objects to be added to the JOIN; it may implement the Joinable interface
columnName - an array of String values indicating the names of the columns to be set as the match columns for the RowSet objects in rowset
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if (1) an empty rowset is added to this JoinRowSet object, (2) a match column is not set for a RowSet object in rowset, or (3) a RowSet object being added violates the active JOIN

getRowSets sample code for javax.sql.rowset.JoinRowSet.getRowSets() definition code for javax.sql.rowset.JoinRowSet.getRowSets() 

Collection sample code for java.util.Collection definition code for java.util.Collection <?> getRowSets()
                         throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Returns a Collection object containing the RowSet objects that have been added to this JoinRowSet object. This should return the 'n' number of RowSet contained within the JOIN and maintain any updates that have occured while in this union.

Returns:
a Collection object consisting of the RowSet objects added to this JoinRowSet object
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if an error occurs generating the Collection object to be returned

getRowSetNames sample code for javax.sql.rowset.JoinRowSet.getRowSetNames() definition code for javax.sql.rowset.JoinRowSet.getRowSetNames() 

String sample code for java.lang.String definition code for java.lang.String [] getRowSetNames()
                        throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Returns a String array containing the names of the RowSet objects added to this JoinRowSet object.

Returns:
a String array of the names of the RowSet objects in this JoinRowSet object
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if an error occurs retrieving the names of the RowSet objects
See Also:
CachedRowSet.setTableName(java.lang.String) sample code for javax.sql.rowset.CachedRowSet.setTableName(java.lang.String) definition code for javax.sql.rowset.CachedRowSet.setTableName(java.lang.String)

toCachedRowSet sample code for javax.sql.rowset.JoinRowSet.toCachedRowSet() definition code for javax.sql.rowset.JoinRowSet.toCachedRowSet() 

CachedRowSet sample code for javax.sql.rowset.CachedRowSet definition code for javax.sql.rowset.CachedRowSet  toCachedRowSet()
                            throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Creates a new CachedRowSet object containing the data in this JoinRowSet object, which can be saved to a data source using the SyncProvider object for the CachedRowSet object.

If any updates or modifications have been applied to the JoinRowSet the CachedRowSet returned by the method will not be able to persist it's changes back to the originating rows and tables in the in the datasource. The CachedRowSet instance returned should not contain modification data and it should clear all properties of it's originating SQL statement. An application should reset the SQL statement using the RowSet.setCommand method.

In order to allow changes to be persisted back to the datasource to the originating tables, the acceptChanges method should be used and called on a JoinRowSet object instance. Implementations can leverage the internal data and update tracking in their implementations to interact with the SyncProvider to persist any changes.

Returns:
a CachedRowSet containing the contents of the JoinRowSet
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if an error occurs assembling the CachedRowSet object
See Also:
RowSet sample code for javax.sql.RowSet definition code for javax.sql.RowSet , CachedRowSet sample code for javax.sql.rowset.CachedRowSet definition code for javax.sql.rowset.CachedRowSet , SyncProvider sample code for javax.sql.rowset.spi.SyncProvider definition code for javax.sql.rowset.spi.SyncProvider

supportsCrossJoin sample code for javax.sql.rowset.JoinRowSet.supportsCrossJoin() definition code for javax.sql.rowset.JoinRowSet.supportsCrossJoin() 

boolean supportsCrossJoin()
Indicates if CROSS_JOIN is supported by a JoinRowSet implementation

Returns:
true if the CROSS_JOIN is supported; false otherwise

supportsInnerJoin sample code for javax.sql.rowset.JoinRowSet.supportsInnerJoin() definition code for javax.sql.rowset.JoinRowSet.supportsInnerJoin() 

boolean supportsInnerJoin()
Indicates if INNER_JOIN is supported by a JoinRowSet implementation

Returns:
true is the INNER_JOIN is supported; false otherwise

supportsLeftOuterJoin sample code for javax.sql.rowset.JoinRowSet.supportsLeftOuterJoin() definition code for javax.sql.rowset.JoinRowSet.supportsLeftOuterJoin() 

boolean supportsLeftOuterJoin()
Indicates if LEFT_OUTER_JOIN is supported by a JoinRowSet implementation

Returns:
true is the LEFT_OUTER_JOIN is supported; false otherwise

supportsRightOuterJoin sample code for javax.sql.rowset.JoinRowSet.supportsRightOuterJoin() definition code for javax.sql.rowset.JoinRowSet.supportsRightOuterJoin() 

boolean supportsRightOuterJoin()
Indicates if RIGHT_OUTER_JOIN is supported by a JoinRowSet implementation

Returns:
true is the RIGHT_OUTER_JOIN is supported; false otherwise

supportsFullJoin sample code for javax.sql.rowset.JoinRowSet.supportsFullJoin() definition code for javax.sql.rowset.JoinRowSet.supportsFullJoin() 

boolean supportsFullJoin()
Indicates if FULL_JOIN is supported by a JoinRowSet implementation

Returns:
true is the FULL_JOIN is supported; false otherwise

setJoinType sample code for javax.sql.rowset.JoinRowSet.setJoinType(int) definition code for javax.sql.rowset.JoinRowSet.setJoinType(int) 

void setJoinType(int joinType)
                 throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Allow the application to adjust the type of JOIN imposed on tables contained within the JoinRowSet object instance. Implementations should throw a SQLException if they do not support a given JOIN type.

Parameters:
joinType - the standard JoinRowSet.XXX static field definition of a SQL JOIN to re-configure a JoinRowSet instance on the fly.
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if an unsupported JOIN type is set
See Also:
getJoinType() sample code for javax.sql.rowset.JoinRowSet.getJoinType() definition code for javax.sql.rowset.JoinRowSet.getJoinType()

getWhereClause sample code for javax.sql.rowset.JoinRowSet.getWhereClause() definition code for javax.sql.rowset.JoinRowSet.getWhereClause() 

String sample code for java.lang.String definition code for java.lang.String  getWhereClause()
                      throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Return a SQL-like description of the WHERE clause being used in a JoinRowSet object. An implementation can describe the WHERE clause of the SQL JOIN by supplying a SQL strings description of JOIN or provide a textual description to assist applications using a JoinRowSet

Returns:
whereClause a textual or SQL description of the logical WHERE clause used in the JoinRowSet instance
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if an error occurs in generating a representation of the WHERE clause.

getJoinType sample code for javax.sql.rowset.JoinRowSet.getJoinType() definition code for javax.sql.rowset.JoinRowSet.getJoinType() 

int getJoinType()
                throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Returns a int describing the set SQL JOIN type governing this JoinRowSet instance. The returned type will be one of standard JoinRowSet types: CROSS_JOIN, INNER_JOIN, LEFT_OUTER_JOIN, RIGHT_OUTER_JOIN or FULL_JOIN.

Returns:
joinType one of the standard JoinRowSet static field definitions of a SQL JOIN. JoinRowSet.INNER_JOIN is returned as the default JOIN type is no type has been explicitly set.
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if an error occurs determining the SQL JOIN type supported by the JoinRowSet instance.
See Also:
setJoinType(int) sample code for javax.sql.rowset.JoinRowSet.setJoinType(int) definition code for javax.sql.rowset.JoinRowSet.setJoinType(int)
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