Java Doc for JoinRowSetImpl.java in  » 6.0-JDK-Modules-com.sun » rowset » com » sun » rowset » Java Source Code / Java DocumentationJava Source Code and Java Documentation

The implementation provides an ANSI-style JOIN providing an inner join between two tables. Any unmatched rows in either table of the join are discarded.

Typically, a JoinRowSet implementation is leveraged by RowSet instances that are in a disconnected environment and thus do not have the luxury of an open connection to the data source to establish logical relationships between themselves. In other words, it is largely CachedRowSet objects and implementations derived from the CachedRowSet interface that will use the JoinRowSetImpl implementation.
author:
   Amit Handa, Jonathan Bruce

If the number is positive, the cursor moves to an absolute row with respect to the beginning of the rowset.

A listener might, for example, be a table or graph that needs to be updated in order to accurately reflect the current state of the RowSet object.

Note: if the RowSetListener object is null, this method silently discards the null value and does not add a null reference to the set of listeners.

This method marks the current row as deleted, but it does not delete the row from the underlying data source.

A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.

Note: All the data in the returned stream must be read prior to getting the value of any other column.

Note: All the data in the returned stream must be read prior to getting the value of any other column.

In SQL, a result table is retrieved through a cursor that is named.

The type of the Object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.

This method may also be used to read datatabase-specific abstract data types.

This implementation of the method getObject extends its behavior so that it gets the attributes of an SQL structured type as as an array of Object values.

The type of the Object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.

This method may also be used to read datatabase-specific abstract data types.

This implementation of the method getObject extends its behavior so that it gets the attributes of an SQL structured type as as an array of Object values.

The type of the Object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.

This method may also be used to read datatabase-specific abstract data types.

This implementation of the method getObject extends its behavior so that it gets the attributes of an SQL structured type as as an array of Object values.

Note: calling the method previous() is not the same as calling the method relative(-1).

If the number is positive, the cursor moves the specified number of rows toward the end of the rowset, starting at the current row. For example, the following command, in which crs is a JoinRowSetImpl object with 100 rows, moves the cursor forward four rows from the current row.

If any updates or modifications have been applied to this JoinRowSet object, the CachedRowSet object returned by this method will not be able to persist the changes back to the originating rows and tables in the data source because the data may be from different tables.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given ASCII stream value.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset; however, another method must be called to complete the update process.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method cannot be called when the cursor is on the insert row, and it should be called before the cursor moves to another row.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database.

If the number is positive, the cursor moves to an absolute row with respect to the beginning of the rowset. The first row is row 1, the second is row 2, and so on. For example, the following command, in which crs is a JoinRowSetImpl object, moves the cursor to the fourth row, starting from the beginning of the rowset.

 crs.absolute(4);
  

If the number is negative, the cursor moves to an absolute row position with respect to the end of the rowset. For example, calling absolute(-1) positions the cursor on the last row, absolute(-2) moves it on the next-to-last row, and so on. If the JoinRowSetImpl object crs has five rows, the following command moves the cursor to the fourth-to-last row, which in the case of a rowset with five rows, is also the second row, counting from the beginning.

 crs.absolute(-4);
  

Note: Calling absolute(1) is the same as calling the method first(). Calling absolute(-1) is the same as calling last().
Parameters:
  row - a positive number to indicate the row, starting row numbering fromthe first row, which is 1; a negative number to indicatethe row, starting row numbering from the last row, which is-1; must not be 0 true if the cursor is on the rowset; falseotherwise
throws:
  SQLException - if the given cursor position is 0 or thetype of this rowset is ResultSet.TYPE_FORWARD_ONLY

This method should be used when the given RowSet object already has a match column set.
Parameters:
  rowset - the RowSet object that implements theJoinable interface and is to be addedto this JoinRowSet object
throws:
  SQLException - if an empty RowSet is added to the to theJoinRowSet; if a match column is not set; or if anadditional RowSet violates the active JOIN
See Also:   CachedRowSet.setMatchColumn

This method should be used when the given RowSet object does not already have a match column set.
Parameters:
  rowset - a RowSet object to be added tothe JOIN relation; must implement the Joinableinterface
Parameters:
  columnIdx - an int giving the index of the column to be set asthe match column
throws:
  SQLException - if (1) an empty RowSet object is added to this JoinRowSet object, (2) a match column has not been set,or (3) the RowSet object being added violates the active JOIN
See Also:   CachedRowSet.unsetMatchColumn

This method should be used when the given RowSet object does not already have a match column set.
Parameters:
  rowset - a RowSet object to be added tothe JOIN relation
Parameters:
  columnName - a String object giving the name of the column to be set as the match column; must implement the Joinableinterface
throws:
  SQLException - if (1) an empty RowSet object is added to this JoinRowSet object, (2) a match column has not been set,or (3) the RowSet object being added violates the active JOIN

The first int in columnIdx is used to set the match column for the first RowSet object in rowset, the second int in columnIdx is used to set the match column for the second RowSet object in rowset, and so on.

This method should be used when the given RowSet objects do not already have match columns set.
Parameters:
  rowset - an array of RowSet objects to be added tothe JOIN relation; each RowSet object mustimplement the Joinable interface
Parameters:
  columnIdx - an array of int values designating the columnsto be set as thematch columns for the RowSet objects in rowset
throws:
  SQLException - if the number of RowSet objects inrowset is not equal to the number of int valuesin columnIdx

The first String object in columnName is used to set the match column for the first RowSet object in rowset, the second String object in columnName is used to set the match column for the second RowSet object in rowset, and so on.

This method should be used when the given RowSet objects do not already have match columns set.
Parameters:
  rowset - an array of RowSet objects to be added tothe JOIN relation; each RowSet object mustimplement the Joinable interface
Parameters:
  columnName - an array of String objects designating the columnsto be set as thematch columns for the RowSet objects in rowset
throws:
  SQLException - if the number of RowSet objects inrowset is not equal to the number of String objectsin columnName, an empty JdbcRowSet is added to theJoinRowSet, if a match column is not set,or one or the RowSet objects in rowset violates the active JOIN

A listener might, for example, be a table or graph that needs to be updated in order to accurately reflect the current state of the RowSet object.

Note: if the RowSetListener object is null, this method silently discards the null value and does not add a null reference to the set of listeners.

Note: if the listener is already set, and the new RowSetListerner instance is added to the set of listeners already registered to receive event notifications from this RowSet.
Parameters:
  listener - an object that has implemented thejavax.sql.RowSetListener interface and wants to be notifiedof any events that occur on this JoinRowSet object; May benull.
See Also:   JoinRowSetImpl.removeRowSetListener

After updateRow is called it is the cancelRowUpdates has no affect on the newly inserted values. The method cancelRowInsert can be used to remove any rows inserted into the RowSet.
throws:
  SQLException - if the cursor is on the insert row, before thefirst row, or after the last row

After a call to this method, the getWarnings method returns null until a new warning is reported for this JoinRowSetImpl object.
throws:
  UnsupportedOperationException - if this method is called

This helps in getting the underlying XML schema which can be used as the basis for populating a WebRowSet. a new CachedRowSet object that is a copyof this JoinRowSetImpl object's schema andretains all the constraints on the original rowset but containsno data
throws:
  SQLException - if an error occurs in generating the copyof the CachedRowSet object
See Also:   JoinRowSetImpl.createShared
See Also:   JoinRowSetImpl.createCopy
See Also:   JoinRowSetImpl.createCopyNoConstraints
See Also:   javax.sql.RowSetEvent
See Also:   javax.sql.RowSetListener

This method marks the current row as deleted, but it does not delete the row from the underlying data source. The method acceptChanges must be called to delete the row in the data source.
throws:
  SQLException - if (1) this method is called when the cursoris on the insert row, before the first row, or after thelast row or (2) this rowset isResultSet.CONCUR_READ_ONLY

Another form of this method uses an existing JDBC Connection object instead of creating a new one; therefore, it ignores the properties used for establishing a new connection.

The query specified by the command property is executed to create a ResultSet object from which to retrieve data. The current contents of the rowset are discarded, and the rowset's metadata is also (re)set. If there are outstanding updates, they are also ignored.

The method execute closes any database connections that it creates.
throws:
  SQLException - if an error occurs or thenecessary properties have not been set

A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII format.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX method implicitly closes the stream.
Parameters:
  columnName - a String object giving the SQL name ofa column in this JoinRowSetImpl object a Java input stream that delivers the database column valueas a stream of one-byte ASCII characters. If the value is SQLNULL, the result is null.
throws:
  UnsupportedOperationException - if this method is called

This method is deprecated; use the version of getBigDecimal that does not take a scale parameter and returns a value with full precision.
Parameters:
  columnIndex - the first column is 1, the secondis 2, and so on; must be 1 or largerand equal to or less than the number of columns in the rowset
Parameters:
  scale - the number of digits to the right of the decimal point in thevalue returned the column value with the specified number of digits to the rightof the decimal point; if the value is SQL NULL, theresult is null
throws:
  SQLException - if the given column index is out of bounds,the cursor is not on a valid row, or this method fails

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not.
Parameters:
  columnIndex - the first column is 1, the secondis 2, and so on; must be 1 or largerand equal to or less than the number of columns in the rowset a Java input stream that delivers the database column valueas a stream of uninterpreted bytes. If the value is SQL NULLthen the result is null.
throws:
  SQLException - if an error occurs

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream.
Parameters:
  columnName - a String object giving the SQL name ofa column in this JoinRowSetImpl object a Java input stream that delivers the database column valueas a stream of uninterpreted bytes. If the value is SQLNULL, the result is null.
throws:
  SQLException - if the given column name does not match one ofthis rowset's column names or the cursor is not on one ofthis rowset's rows or its insert row

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX method implicitly closes the stream.
Parameters:
  columnIndex - the first column is 1, the secondis 2, and so on; must be 1 or largerand equal to or less than the number of columns in the rowset a Java character stream that delivers the database column valueas a java.io.Reader object. If the value isSQL NULL, the result is null.
throws:
  SQLException - if the given column index is out of bounds,the cursor is not on a valid row, or there is a type mismatch

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX method implicitly closes the stream.
Parameters:
  columnName - a String object giving the SQL name ofa column in this JoinRowSetImpl object a Java input stream that delivers the database column valueas a stream of two-byte Unicode characters. If the value isSQL NULL, the result is null.
throws:
  SQLException - if the given column index is out of bounds,the cursor is not on a valid row, or there is a type mismatch

In SQL, a result table is retrieved through a cursor that is named. The current row of a result can be updated or deleted using a positioned update/delete statement that references the cursor name. To insure that the cursor has the proper isolation level to support an update operation, the cursor's SELECT statement should be of the form 'select for update'. If the 'for update' clause is omitted, positioned updates may fail.

JDBC supports this SQL feature by providing the name of the SQL cursor used by a ResultSet object. The current row of a result set is also the current row of this SQL cursor.

Note: If positioned updates are not supported, an SQLException is thrown. the SQL cursor name for this JoinRowSetImpl object'scursor
throws:
  SQLException - if an error occurs

The type of the Object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.

This method may also be used to read datatabase-specific abstract data types.

This implementation of the method getObject extends its behavior so that it gets the attributes of an SQL structured type as as an array of Object values. This method also custom maps SQL user-defined types to classes in the Java programming language. When the specified column contains a structured or distinct value, the behavior of this method is as if it were a call to the method getObject(columnIndex, this.getStatement().getConnection().getTypeMap()).
Parameters:
  columnIndex - the first column is 1, the secondis 2, and so on; must be 1 or largerand equal to or less than the number of columns in the rowset a java.lang.Object holding the column value;if the value is SQL NULL, the result is null
throws:
  SQLException - if the given column index is out of bounds,the cursor is not on a valid row, or there is a problem gettingthe Class object for a custom mapping
since:
   1.2

The type of the Object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.

This method may also be used to read datatabase-specific abstract data types.

This implementation of the method getObject extends its behavior so that it gets the attributes of an SQL structured type as as an array of Object values. This method also custom maps SQL user-defined types to classes in the Java programming language. When the specified column contains a structured or distinct value, the behavior of this method is as if it were a call to the method getObject(columnIndex, this.getStatement().getConnection().getTypeMap()).
Parameters:
  columnIndex - the first column is 1, the secondis 2, and so on; must be 1 or largerand equal to or less than the number of columns in the rowset
Parameters:
  map - a java.util.Map object showing the mappingfrom SQL type names to classes in the Java programminglanguage a java.lang.Object holding the column value;if the value is SQL NULL, the result is null
throws:
  SQLException - if (1) the given column name does not match one of this rowset's column names, (2) the cursor is noton a valid row, or (3) there is a problem gettingthe Class object for a custom mapping

The type of the Object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.

This method may also be used to read datatabase-specific abstract data types.

This implementation of the method getObject extends its behavior so that it gets the attributes of an SQL structured type as as an array of Object values. This method also custom maps SQL user-defined types to classes in the Java programming language. When the specified column contains a structured or distinct value, the behavior of this method is as if it were a call to the method getObject(columnIndex, this.getStatement().getConnection().getTypeMap()).
Parameters:
  columnName - a String object that must match theSQL name of a column in this rowset, ignoring case a java.lang.Object holding the column value;if the value is SQL NULL, the result is null
throws:
  SQLException - if (1) the given column name does not matchone of this rowset's column names, (2) the cursor is noton a valid row, or (3) there is a problem gettingthe Class object for a custom mapping

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. . Also, a stream may return 0 for available() whether there is data available or not.
Parameters:
  columnIndex - the first column is 1, the secondis 2, and so on; must be 1 or largerand equal to or less than the number of columns in this rowset a Java input stream that delivers the database column valueas a stream of two byte Unicode characters. If the value is SQL NULLthen the result is null.
throws:
  SQLException - if an error occurs

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getXXX method implicitly closes the stream.
Parameters:
  columnName - a String object giving the SQL name ofa column in this JoinRowSetImpl object a Java input stream that delivers the database column valueas a stream of two-byte Unicode characters. If the value isSQL NULL, the result is null.
throws:
  SQLException - if the given column name does not match one ofthis rowset's column names or the cursor is not on one ofthis rowset's rows or its insert row

The cursor must be on the insert row when this method is called.
throws:
  SQLException - if (1) the cursor is not on the insert row,(2) one or more of the non-nullable columns in the insertrow has not been given a value, or (3) this rowset isResultSet.CONCUR_READ_ONLY

Note: Calling the method isLast may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in this rowset. true if the cursor is on the last row;false otherwise or if this rowset contains no rows
throws:
  SQLException - if an error occurs

Calling this method has no effect unless it is called while the cursor is on the insert row.
throws:
  SQLException - if an error occurs

The insert row is a special row associated with an updatable rowset. It is essentially a buffer where a new row may be constructed by calling the appropriate updateXXX methods to assign a value to each column in the row. A complete row must be constructed; that is, every column that is not nullable must be assigned a value. In order for the new row to become part of this rowset, the method insertRow must be called before the cursor is moved back to the rowset.

Only certain methods may be invoked while the cursor is on the insert row; many methods throw an exception if they are called while the cursor is there. In addition to the updateXXX and insertRow methods, only the getXXX methods may be called when the cursor is on the insert row. A getXXX method should be called on a column only after an updateXXX method has been called on that column; otherwise, the value returned is undetermined.
throws:
  SQLException - if this JoinRowSetImpl object isResultSet.CONCUR_READ_ONLY

If an input stream from the previous row is open, it is implicitly closed. The ResultSet object's warning chain is cleared when a new row is read. true if the new current row is valid;false if there are no more rows
throws:
  SQLException - if an error occurs orthe cursor is not positioned in the rowset, beforethe first row, or after the last row

Note: calling the method previous() is not the same as calling the method relative(-1). This is true because it is possible to call previous() from the insert row, from after the last row, or from the current row, whereas relative may only be called from the current row.

The method previous may used in a while loop to iterate through a rowset starting after the last row and moving toward the beginning. The loop ends when previous returns false, meaning that there are no more rows. For example, the following code fragment retrieves all the data in the JoinRowSetImpl object crs, which has three columns. Note that the cursor must initially be positioned after the last row so that the first call to the method previous places the cursor on the last line.

 
 crs.afterLast();
 while (previous()) {
 String name = crs.getString(1);
 int age = crs.getInt(2);
 short ssn = crs.getShort(3);
 System.out.println(name + "   " + age + "   " + ssn);
 }
  

If the number is positive, the cursor moves the specified number of rows toward the end of the rowset, starting at the current row. For example, the following command, in which crs is a JoinRowSetImpl object with 100 rows, moves the cursor forward four rows from the current row. If the current row is 50, the cursor would move to row 54.

 crs.relative(4);
  

If the number is negative, the cursor moves back toward the beginning the specified number of rows, starting at the current row. For example, calling the method absolute(-1) positions the cursor on the last row, absolute(-2) moves it on the next-to-last row, and so on. If the JoinRowSetImpl object crs has five rows, the following command moves the cursor to the fourth-to-last row, which in the case of a rowset with five rows, is also the second row from the beginning.

 crs.absolute(-4);
  

Note: Calling absolute(1) is the same as calling the method first(). Calling absolute(-1) is the same as calling last(). Calling relative(0) is valid, but it does not change the cursor position.
Parameters:
  rows - an int indicating the number of rows to movethe cursor, starting at the current row; a positive numbermoves the cursor forward; a negative number moves the cursorbackward; must not move the cursor past the validrows true if the cursor is on a row in thisJoinRowSetImpl object; falseotherwise
throws:
  SQLException - if there are no rows in this rowset, the cursor ispositioned either before the first row or after the last row, orthe rowset is type ResultSet.TYPE_FORWARD_ONLY

Implementations should throw an SQLException if they do not support the given JOIN type.
Parameters:
  type - one of the standard JoinRowSet constantsindicating the type of JOIN. Must be one of the following:JoinRowSet.CROSS_JOINJoinRowSet.INNER_JOINJoinRowSet.LEFT_OUTER_JOINJoinRowSet.RIGHT_OUTER_JOIN, orJoinRowSet.FULL_JOIN
throws:
  SQLException - if an unsupported JOIN type is set

If any updates or modifications have been applied to this JoinRowSet object, the CachedRowSet object returned by this method will not be able to persist the changes back to the originating rows and tables in the data source because the data may be from different tables. The CachedRowSet instance returned should not contain modification data, such as whether a row has been updated or what the original values are. Also, the CachedRowSet object should clear its properties pertaining to its originating SQL statement. An application should reset the SQL statement using the RowSet.setCommand method.

To persist changes back to the data source, the JoinRowSet object calls the method acceptChanges. Implementations can leverage the internal data and update tracking in their implementations to interact with the SyncProvider to persist any changes. a CachedRowSet object containing the contents of thisJoinRowSet object
throws:
  SQLException - if an error occurs assembling the CachedRowSetobject
See Also:   javax.sql.RowSet
See Also:   javax.sql.rowset.CachedRowSet
See Also:   javax.sql.rowset.spi.SyncProvider

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Either of these methods must be called before the cursor moves to another row.
Parameters:
  columnIndex - the first column is 1, the secondis 2, and so on; must be 1 or largerand equal to or less than the number of columns in this rowset
Parameters:
  a - the java.sql.Array object that will be set as the new column value
throws:
  SQLException - if (1) the given column index is out of bounds,(2) the cursor is not on one of this rowset's rows or itsinsert row, or (3) this rowset isResultSet.CONCUR_READ_ONLY

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Either of these methods must be called before the cursor moves to another row.
Parameters:
  columnName - a String object giving the name of the columnto be updated; must match one of the column names in thisJoinRowSetImpl object
Parameters:
  a - the java.sql.Array object that will be set as the new column value
throws:
  SQLException - if (1) the given column name is not valid,(2) the cursor is not on one of this rowset's rows or itsinsert row, or (3) this rowset isResultSet.CONCUR_READ_ONLY

Sets the designated column in either the current row or the insert row of this JoinRowSetImpl object with the given ASCII stream value.

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
Parameters:
  columnName - a String object that must match theSQL name of a column in this rowset, ignoring case
Parameters:
  x - the new column value
Parameters:
  length - the number of one-byte ASCII characters in the stream
throws:
  UnsupportedOperationException - if this method is invoked

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
Parameters:
  columnIndex - the first column is 1, the secondis 2, and so on; must be 1 or largerand equal to or less than the number of columns in this rowset
Parameters:
  x - the new column value
throws:
  SQLException - if (1) the given column index is out of bounds,(2) the cursor is not on one of this rowset's rows or itsinsert row, or (3) this rowset isResultSet.CONCUR_READ_ONLY

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
Parameters:
  columnName - a String object that must match theSQL name of a column in this rowset, ignoring case
Parameters:
  x - the new column value
throws:
  SQLException - if (1) the given column name does not match thename of a column in this rowset, (2) the cursor is not onone of this rowset's rows or its insert row, or (3) thisrowset is ResultSet.CONCUR_READ_ONLY

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
Parameters:
  columnIndex - the first column is 1, the secondis 2, and so on; must be 1 or largerand equal to or less than the number of columns in this rowset
Parameters:
  x - the new column value; must be a java.io.InputStreamcontaining BINARY, VARBINARY, orLONGVARBINARY data
Parameters:
  length - the length of the stream in bytes
throws:
  SQLException - if (1) the given column index is out of bounds,(2) the cursor is not on one of this rowset's rows or itsinsert row, (3) the data in the stream is not binary, or(4) this rowset is ResultSet.CONCUR_READ_ONLY

This method updates a column value in either the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
Parameters:
  columnName - a String object that must match theSQL name of a column in this rowset, ignoring case
Parameters:
  x - the new column value; must be a java.io.InputStreamcontaining BINARY, VARBINARY, orLONGVARBINARY data
Parameters:
  length - the length of the stream in bytes
throws:
  SQLException - if (1) the given column name does not match thename of a column in this rowset, (2) the cursor is not onone of this rowset's rows or its insert row, (3) the datain the stream is not binary, or (4) this rowset isResultSet.CONCUR_READ_ONLY

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Either of these methods must be called before the cursor moves to another row.
Parameters:
  columnIndex - the first column is 1, the secondis 2, and so on; must be 1 or largerand equal to or less than the number of columns in this rowset
Parameters:
  b - the java.sql.Blob object that will be set as the new column value
throws:
  SQLException - if (1) the given column index is out of bounds,(2) the cursor is not on one of this rowset's rows or itsinsert row, or (3) this rowset isResultSet.CONCUR_READ_ONLY

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Either of these methods must be called before the cursor moves to another row.
Parameters:
  columnName - a String object giving the name of the columnto be updated; must match one of the column names in thisJoinRowSetImpl object
Parameters:
  b - the java.sql.Blob object that will be set as the new column value
throws:
  SQLException - if (1) the given column name is not valid,(2) the cursor is not on one of this rowset's rows or itsinsert row, or (3) this rowset isResultSet.CONCUR_READ_ONLY

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
Parameters:
  columnIndex - the first column is 1, the secondis 2, and so on; must be 1 or largerand equal to or less than the number of columns in this rowset
Parameters:
  x - the new column value
throws:
  SQLException - if (1) the given column index is out of bounds,(2) the cursor is not on one of this rowset's rows or itsinsert row, or (3) this rowset isResultSet.CONCUR_READ_ONLY

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
Parameters:
  columnName - a String object that must match theSQL name of a column in this rowset, ignoring case
Parameters:
  x - the new column value
throws:
  SQLException - if (1) the given column name does not match thename of a column in this rowset, (2) the cursor is not onone of this rowset's rows or its insert row, or (3) thisrowset is ResultSet.CONCUR_READ_ONLY

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
Parameters:
  columnIndex - the first column is 1, the secondis 2, and so on; must be 1 or largerand equal to or less than the number of columns in this rowset
Parameters:
  x - the new column value
throws:
  SQLException - if (1) the given column index is out of bounds,(2) the cursor is not on one of this rowset's rows or itsinsert row, or (3) this rowset isResultSet.CONCUR_READ_ONLY

This method updates a column value in the current row or the insert row of this rowset, but it does not update the database. If the cursor is on a row in the rowset, the method JoinRowSetImpl.updateRow must be called to update the database. If the cursor is on the insert row, the method JoinRowSetImpl.insertRow must be called, which will insert the new row into both this rowset and the database. Both of these methods must be called before the cursor moves to another row.
Parameters:
  columnName - a String object that must match theSQL name of a column in this rowset, ignoring case
Parameters:
  x - the new column value
throws:
  SQLException - if (1) the given column name does not match thename of a column in this rowset, (2) the cursor is not onone of this rowset's rows or its insert row, or (3) thisrowset is ResultSet.CONCUR_READ_ONLY