|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
java.lang.Objectau.gov.tas.dpiwe.mr.server.database.MrResultSetAdapter
au.gov.tas.dpiwe.mr.server.database.DistinctRowResultSet
au.gov.tas.dpiwe.mr.server.database.UnionResultSet
public class UnionResultSet
UnionResultSet is a DistinctRowResultSet combining the the values from two other result sets. By default, the values are combined in a way analogous to the set union operator.
IntersectionResultSet,
DifferenceResultSet| Field Summary | |
|---|---|
protected int |
absolute2
The current row number in the second underlying ResultSet. |
protected MrDatabase |
database
The parent database object for this result set. |
protected boolean |
debugging
Indicator is true if debug level logging should occur. |
protected Map |
distinctFieldValuesTable
The keys encountered so far in this result set mapped to the underlying set they appeared in. |
protected boolean |
empty
Indicator is true to indicate the first result set is empty. |
protected boolean |
empty2
Indicator is true to indicate the second result set is empty. |
protected boolean |
in2
Indicator as to which underlying result set contains the current row. |
protected Map |
indistinctRowsCountTable2
The keys encountered so far in the second underlying ResultSet mapped to the number of times they have been encountered. |
protected boolean |
offEndResultSet
Indicator is true to indicate that we are off the end of this result set. |
protected boolean |
offResultSet
Indicator is true to indicate that there is no current row in this result set. |
protected boolean |
on
Indicator is true to indicate the current row corresponds to the current row of the first result set. |
protected boolean |
on2
Indicator is true to indicate the current row corresponds to the current row of the second result set. |
protected Set |
orderedFieldNames
The names of the fields which are used to impose order on the UnionResultSet, in the order in which they are to impose that order. |
protected Collection |
orderedFieldNamesInOrder
The names of the fields which are used to impose order on the UnionResultSet. |
protected List |
orderedFields
The fields which are used to impose order on the UnionResultSet, and by which the component result sets are expected to be ordered. |
protected Stack |
rowStack
A stack which allows us to move backward through the result set. |
protected ResultSet |
underlyingObject2
The second ResultSet underlying this UnionResultSet. |
| Fields inherited from class au.gov.tas.dpiwe.mr.server.database.DistinctRowResultSet |
|---|
absolute, distinctFieldNames, distinctFieldValuesSet, filtered, indistinctRowsCountTable |
| Fields inherited from class au.gov.tas.dpiwe.mr.server.database.MrResultSetAdapter |
|---|
identifier, resultSetClass, underlyingObject |
| Fields inherited from interface java.sql.ResultSet |
|---|
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
| Constructor Summary | |
|---|---|
UnionResultSet(MrDatabase database,
ResultSet underlyingResultSet1,
ResultSet underlyingResultSet2,
Set distinctFieldNames,
List orderedFields,
String identifier,
boolean debugging)
Construct a new UnionResultSet. |
|
UnionResultSet(ResultSet underlyingResultSet1,
ResultSet underlyingResultSet2,
Set distinctFieldNames,
List orderedFields)
Construct a new UnionResultSet. |
|
| Method Summary | |
|---|---|
protected boolean |
addDistinctFieldValues(List distinctValues,
Map indistinctRowsCountTable)
Returns true if the current source row is distinct, and registers the values of the distinct fields so that future rows can be checked for distinctiveness. |
protected void |
advanceCurrentCursor()
Internal method to step forward the result set cursor to move off a row which has been deemed to belong to this result set (i.e. it is the result of a next() or previous() call.) |
void |
beforeFirst()
|
void |
cancelRowUpdates()
|
protected boolean |
chooseNextSourceRow()
Determines the next source row from the two available candidates, removes that row as a future candidate, returns true if the current source row is distinct, and registers the values of the distinct fields so that future rows can be checked for distinctiveness. |
protected boolean |
choosePreviousSourceRow()
Determines the previous source row from the two available candidates, removes that row as a future candidate, returns true if the current source row is distinct, and registers the values of the distinct fields so that future rows can be checked for distinctiveness. |
void |
clearWarnings()
|
void |
close()
Simultaneously closes both underlying ResultSet objects. |
void |
deleteRow()
Deletes the current row of the union result set. |
Array |
getArray(int int1)
|
Array |
getArray(String string1)
|
InputStream |
getAsciiStream(int int1)
|
InputStream |
getAsciiStream(String string1)
|
BigDecimal |
getBigDecimal(int int1)
|
BigDecimal |
getBigDecimal(int int1,
int int2)
|
BigDecimal |
getBigDecimal(String string1)
|
BigDecimal |
getBigDecimal(String string1,
int int2)
|
InputStream |
getBinaryStream(int int1)
|
InputStream |
getBinaryStream(String string1)
|
Blob |
getBlob(int int1)
|
Blob |
getBlob(String string1)
|
boolean |
getBoolean(int int1)
|
boolean |
getBoolean(String string1)
|
byte |
getByte(int int1)
|
byte |
getByte(String string1)
|
byte[] |
getBytes(int int1)
|
byte[] |
getBytes(String string1)
|
Reader |
getCharacterStream(int int1)
|
Reader |
getCharacterStream(String string1)
|
Clob |
getClob(int int1)
|
Clob |
getClob(String string1)
|
Date |
getDate(int int1)
|
Date |
getDate(int int1,
Calendar calendar2)
|
Date |
getDate(String string1)
|
Date |
getDate(String string1,
Calendar calendar2)
|
double |
getDouble(int int1)
|
double |
getDouble(String string1)
|
float |
getFloat(int int1)
|
float |
getFloat(String string1)
|
int |
getInt(int int1)
|
int |
getInt(String string1)
|
long |
getLong(int int1)
|
long |
getLong(String string1)
|
Object |
getObject(int int1)
|
Object |
getObject(int int1,
Map map2)
|
Object |
getObject(String string1)
|
Object |
getObject(String string1,
Map map2)
|
Ref |
getRef(int int1)
|
Ref |
getRef(String string1)
|
short |
getShort(int int1)
|
short |
getShort(String string1)
|
String |
getString(int int1)
|
String |
getString(String string1)
|
Time |
getTime(int int1)
|
Time |
getTime(int int1,
Calendar calendar2)
|
Time |
getTime(String string1)
|
Time |
getTime(String string1,
Calendar calendar2)
|
Timestamp |
getTimestamp(int int1)
|
Timestamp |
getTimestamp(int int1,
Calendar calendar2)
|
Timestamp |
getTimestamp(String string1)
|
Timestamp |
getTimestamp(String string1,
Calendar calendar2)
|
int |
getType()
|
InputStream |
getUnicodeStream(int int1)
|
InputStream |
getUnicodeStream(String string1)
|
URL |
getURL(int int1)
|
URL |
getURL(String string1)
|
SQLWarning |
getWarnings()
|
void |
insertRow()
|
boolean |
isAfterLast()
|
boolean |
isBeforeFirst()
|
void |
moveToCurrentRow()
|
void |
moveToInsertRow()
|
boolean |
next()
|
boolean |
previous()
|
void |
refreshRow()
Refreshes the current row of the union result set. |
protected boolean |
removeDistinctFieldValues(List distinctValues,
Map indistinctRowsCountTable)
Returns true if the current source row is distinct, and if this was the first instance of a particular set of distinct field values in a row, the values are deregistered. |
protected boolean |
retreatCurrentCursor()
Internal method to step back the underlying result set cursor which was most recently advanced. |
boolean |
rowDeleted()
|
boolean |
rowInserted()
|
boolean |
rowUpdated()
|
void |
setFetchDirection(int int1)
|
void |
setFetchSize(int int1)
|
void |
updateArray(int columnIndex,
Array x)
|
void |
updateArray(String columnName,
Array x)
|
void |
updateAsciiStream(int int1,
InputStream inputStream2,
int int3)
|
void |
updateAsciiStream(String string1,
InputStream inputStream2,
int int3)
|
void |
updateBigDecimal(int int1,
BigDecimal bigDecimal2)
|
void |
updateBigDecimal(String string1,
BigDecimal bigDecimal2)
|
void |
updateBinaryStream(int int1,
InputStream inputStream2,
int int3)
|
void |
updateBinaryStream(String string1,
InputStream inputStream2,
int int3)
|
void |
updateBlob(int columnIndex,
Blob x)
|
void |
updateBlob(String columnName,
Blob x)
|
void |
updateBoolean(int int1,
boolean boolean2)
|
void |
updateBoolean(String string1,
boolean boolean2)
|
void |
updateByte(int int1,
byte byte2)
|
void |
updateByte(String string1,
byte byte2)
|
void |
updateBytes(int int1,
byte[] byteArray2)
|
void |
updateBytes(String string1,
byte[] byteArray2)
|
void |
updateCharacterStream(int int1,
Reader reader2,
int int3)
|
void |
updateCharacterStream(String string1,
Reader reader2,
int int3)
|
void |
updateClob(int columnIndex,
Clob x)
|
void |
updateClob(String columnName,
Clob x)
|
void |
updateDate(int int1,
Date date2)
|
void |
updateDate(String string1,
Date date2)
|
void |
updateDouble(int int1,
double double2)
|
void |
updateDouble(String string1,
double double2)
|
void |
updateFloat(int int1,
float float2)
|
void |
updateFloat(String string1,
float float2)
|
void |
updateInt(int int1,
int int2)
|
void |
updateInt(String string1,
int int2)
|
void |
updateLong(int int1,
long long2)
|
void |
updateLong(String string1,
long long2)
|
void |
updateNull(int int1)
|
void |
updateNull(String string1)
|
void |
updateObject(int int1,
Object object2)
|
void |
updateObject(int int1,
Object object2,
int int3)
|
void |
updateObject(String string1,
Object object2)
|
void |
updateObject(String string1,
Object object2,
int int3)
|
void |
updateRef(int columnIndex,
Ref x)
|
void |
updateRef(String columnName,
Ref x)
|
void |
updateRow()
Updates the current row of the union result set. |
void |
updateShort(int int1,
short short2)
|
void |
updateShort(String string1,
short short2)
|
void |
updateString(int int1,
String string2)
|
void |
updateString(String string1,
String string2)
|
void |
updateTime(int int1,
Time time2)
|
void |
updateTime(String string1,
Time time2)
|
void |
updateTimestamp(int int1,
Timestamp timestamp2)
|
void |
updateTimestamp(String string1,
Timestamp timestamp2)
|
boolean |
wasNull()
|
| Methods inherited from class au.gov.tas.dpiwe.mr.server.database.DistinctRowResultSet |
|---|
absolute, addDistinctFieldValues, afterLast, first, getIndistinctCount, getRow, getValues, isFirst, isLast, last, relative, removeDistinctFieldValues |
| Methods inherited from class au.gov.tas.dpiwe.mr.server.database.MrResultSetAdapter |
|---|
findColumn, getConcurrency, getCursorName, getFetchDirection, getFetchSize, getIdentifier, getMetaData, getStatement |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Methods inherited from interface java.sql.Wrapper |
|---|
isWrapperFor, unwrap |
| Field Detail |
|---|
protected ResultSet underlyingObject2
protected Map distinctFieldValuesTable
protected List orderedFields
protected Collection orderedFieldNamesInOrder
protected Set orderedFieldNames
protected int absolute2
protected Map indistinctRowsCountTable2
protected boolean empty
protected boolean empty2
protected boolean in2
protected boolean on
protected boolean on2
protected boolean offResultSet
protected boolean offEndResultSet
protected Stack rowStack
protected MrDatabase database
protected boolean debugging
| Constructor Detail |
|---|
public UnionResultSet(ResultSet underlyingResultSet1,
ResultSet underlyingResultSet2,
Set distinctFieldNames,
List orderedFields)
throws SQLException
Each component result set must be in the order given by orderedFields, and orderedFields' names must be a superset of distinctFieldNames, or this result set will not conform to the set union of its operands.
underlyingResultSet1 - a ResultSet instance.underlyingResultSet2 - a ResultSet instance.distinctFieldNames - identifies the columns which should be used to
determine the distinctiveness of rows.orderedFields - indicates which fields determine the order of the
result set, which are most significant in sorting, and whether each
should be in forward or reverse order.
SQLException
public UnionResultSet(MrDatabase database,
ResultSet underlyingResultSet1,
ResultSet underlyingResultSet2,
Set distinctFieldNames,
List orderedFields,
String identifier,
boolean debugging)
throws SQLException
Each component result set must be in the order given by orderedFields, and orderedFields' names must be a superset of distinctFieldNames, or this result set will not conform to the set union of its operands.
database - the database object to which this result set belongs.underlyingResultSet1 - a ResultSet instance.underlyingResultSet2 - a ResultSet instance.distinctFieldNames - identifies the columns which should be used to
determine the distinctiveness of rows.orderedFields - indicates which fields determine the order of the
result set, which are most significant in sorting, and whether each
should be in forward or reverse order.identifier - a name identifying this result set.debugging - true if debugging messages should be generated, false
otherwise.
SQLException| Method Detail |
|---|
public boolean next()
throws SQLException
next in interface MrResultSetnext in interface ResultSetnext in class DistinctRowResultSetSQLException
protected boolean chooseNextSourceRow()
throws SQLException
SQLException
protected void advanceCurrentCursor()
throws SQLException
This method is not the inverse of retreatCurrentCursor()- it is interleaved between a call to chooseNextSourceRow() which return true and the next call to chooseNextSourceRow().
SQLException
protected boolean addDistinctFieldValues(List distinctValues,
Map indistinctRowsCountTable)
throws SQLException
distinctValues - the values of the distinct key fields.indistinctRowsCountTable - the map where a count of indistinct copies
is kept.
SQLException
public boolean previous()
throws SQLException
previous in interface MrResultSetprevious in interface ResultSetprevious in class DistinctRowResultSetSQLException
protected boolean choosePreviousSourceRow()
throws SQLException
SQLException
protected boolean removeDistinctFieldValues(List distinctValues,
Map indistinctRowsCountTable)
throws SQLException
distinctValues - the values of the distinct key fields.indistinctRowsCountTable - the map where a count of indistinct copies
is kept.
SQLException
protected boolean retreatCurrentCursor()
throws SQLException
This method is not the inverse of advanceCurrentCursor()- possibly many calls will occur during each call to choosePreviousSourceRow().
SQLException
public SQLWarning getWarnings()
throws SQLException
getWarnings in interface MrResultSetgetWarnings in interface ResultSetgetWarnings in class MrResultSetAdapterSQLException
public void clearWarnings()
throws SQLException
clearWarnings in interface MrResultSetclearWarnings in interface ResultSetclearWarnings in class MrResultSetAdapterSQLException
public byte[] getBytes(String string1)
throws SQLException
getBytes in interface MrResultSetgetBytes in interface ResultSetgetBytes in class MrResultSetAdapterSQLException
public byte[] getBytes(int int1)
throws SQLException
getBytes in interface MrResultSetgetBytes in interface ResultSetgetBytes in class MrResultSetAdapterSQLException
public boolean getBoolean(int int1)
throws SQLException
getBoolean in interface MrResultSetgetBoolean in interface ResultSetgetBoolean in class MrResultSetAdapterSQLException
public boolean getBoolean(String string1)
throws SQLException
getBoolean in interface MrResultSetgetBoolean in interface ResultSetgetBoolean in class MrResultSetAdapterSQLException
public int getType()
throws SQLException
getType in interface MrResultSetgetType in interface ResultSetgetType in class MrResultSetAdapterSQLException
public long getLong(String string1)
throws SQLException
getLong in interface MrResultSetgetLong in interface ResultSetgetLong in class MrResultSetAdapterSQLException
public long getLong(int int1)
throws SQLException
getLong in interface MrResultSetgetLong in interface ResultSetgetLong in class MrResultSetAdapterSQLException
public Ref getRef(int int1)
throws SQLException
getRef in interface MrResultSetgetRef in interface ResultSetgetRef in class MrResultSetAdapterSQLException
public Ref getRef(String string1)
throws SQLException
getRef in interface MrResultSetgetRef in interface ResultSetgetRef in class MrResultSetAdapterSQLException
public Object getObject(String string1)
throws SQLException
getObject in interface MrResultSetgetObject in interface ResultSetgetObject in class MrResultSetAdapterSQLException
public Object getObject(int int1)
throws SQLException
getObject in interface MrResultSetgetObject in interface ResultSetgetObject in class MrResultSetAdapterSQLException
public Object getObject(String string1,
Map map2)
throws SQLException
getObject in interface ResultSetgetObject in class MrResultSetAdapterSQLException
public Object getObject(int int1,
Map map2)
throws SQLException
getObject in interface ResultSetgetObject in class MrResultSetAdapterSQLException
public Time getTime(int int1)
throws SQLException
getTime in interface MrResultSetgetTime in interface ResultSetgetTime in class MrResultSetAdapterSQLException
public Time getTime(int int1,
Calendar calendar2)
throws SQLException
getTime in interface MrResultSetgetTime in interface ResultSetgetTime in class MrResultSetAdapterSQLException
public Time getTime(String string1,
Calendar calendar2)
throws SQLException
getTime in interface MrResultSetgetTime in interface ResultSetgetTime in class MrResultSetAdapterSQLException
public Time getTime(String string1)
throws SQLException
getTime in interface MrResultSetgetTime in interface ResultSetgetTime in class MrResultSetAdapterSQLException
public Date getDate(String string1,
Calendar calendar2)
throws SQLException
getDate in interface MrResultSetgetDate in interface ResultSetgetDate in class MrResultSetAdapterSQLException
public Date getDate(int int1)
throws SQLException
getDate in interface MrResultSetgetDate in interface ResultSetgetDate in class MrResultSetAdapterSQLException
public Date getDate(String string1)
throws SQLException
getDate in interface MrResultSetgetDate in interface ResultSetgetDate in class MrResultSetAdapterSQLException
public Date getDate(int int1,
Calendar calendar2)
throws SQLException
getDate in interface MrResultSetgetDate in interface ResultSetgetDate in class MrResultSetAdapterSQLException
public String getString(String string1)
throws SQLException
getString in interface MrResultSetgetString in interface ResultSetgetString in class MrResultSetAdapterSQLException
public String getString(int int1)
throws SQLException
getString in interface MrResultSetgetString in interface ResultSetgetString in class MrResultSetAdapterSQLException
public boolean wasNull()
throws SQLException
wasNull in interface MrResultSetwasNull in interface ResultSetwasNull in class MrResultSetAdapterSQLException
public byte getByte(String string1)
throws SQLException
getByte in interface MrResultSetgetByte in interface ResultSetgetByte in class MrResultSetAdapterSQLException
public byte getByte(int int1)
throws SQLException
getByte in interface MrResultSetgetByte in interface ResultSetgetByte in class MrResultSetAdapterSQLException
public short getShort(int int1)
throws SQLException
getShort in interface MrResultSetgetShort in interface ResultSetgetShort in class MrResultSetAdapterSQLException
public short getShort(String string1)
throws SQLException
getShort in interface MrResultSetgetShort in interface ResultSetgetShort in class MrResultSetAdapterSQLException
public int getInt(String string1)
throws SQLException
getInt in interface MrResultSetgetInt in interface ResultSetgetInt in class MrResultSetAdapterSQLException
public int getInt(int int1)
throws SQLException
getInt in interface MrResultSetgetInt in interface ResultSetgetInt in class MrResultSetAdapterSQLException
public float getFloat(String string1)
throws SQLException
getFloat in interface MrResultSetgetFloat in interface ResultSetgetFloat in class MrResultSetAdapterSQLException
public float getFloat(int int1)
throws SQLException
getFloat in interface MrResultSetgetFloat in interface ResultSetgetFloat in class MrResultSetAdapterSQLException
public double getDouble(String string1)
throws SQLException
getDouble in interface MrResultSetgetDouble in interface ResultSetgetDouble in class MrResultSetAdapterSQLException
public double getDouble(int int1)
throws SQLException
getDouble in interface MrResultSetgetDouble in interface ResultSetgetDouble in class MrResultSetAdapterSQLException
public BigDecimal getBigDecimal(String string1,
int int2)
throws SQLException
getBigDecimal in interface MrResultSetgetBigDecimal in interface ResultSetgetBigDecimal in class MrResultSetAdapterSQLException
public BigDecimal getBigDecimal(int int1,
int int2)
throws SQLException
getBigDecimal in interface MrResultSetgetBigDecimal in interface ResultSetgetBigDecimal in class MrResultSetAdapterSQLException
public BigDecimal getBigDecimal(String string1)
throws SQLException
getBigDecimal in interface MrResultSetgetBigDecimal in interface ResultSetgetBigDecimal in class MrResultSetAdapterSQLException
public BigDecimal getBigDecimal(int int1)
throws SQLException
getBigDecimal in interface MrResultSetgetBigDecimal in interface ResultSetgetBigDecimal in class MrResultSetAdapterSQLException
public Timestamp getTimestamp(String string1)
throws SQLException
getTimestamp in interface MrResultSetgetTimestamp in interface ResultSetgetTimestamp in class MrResultSetAdapterSQLException
public Timestamp getTimestamp(int int1)
throws SQLException
getTimestamp in interface MrResultSetgetTimestamp in interface ResultSetgetTimestamp in class MrResultSetAdapterSQLException
public Timestamp getTimestamp(String string1,
Calendar calendar2)
throws SQLException
getTimestamp in interface MrResultSetgetTimestamp in interface ResultSetgetTimestamp in class MrResultSetAdapterSQLException
public Timestamp getTimestamp(int int1,
Calendar calendar2)
throws SQLException
getTimestamp in interface MrResultSetgetTimestamp in interface ResultSetgetTimestamp in class MrResultSetAdapterSQLException
public InputStream getAsciiStream(int int1)
throws SQLException
getAsciiStream in interface MrResultSetgetAsciiStream in interface ResultSetgetAsciiStream in class MrResultSetAdapterSQLException
public InputStream getAsciiStream(String string1)
throws SQLException
getAsciiStream in interface MrResultSetgetAsciiStream in interface ResultSetgetAsciiStream in class MrResultSetAdapterSQLException
public InputStream getUnicodeStream(String string1)
throws SQLException
getUnicodeStream in interface MrResultSetgetUnicodeStream in interface ResultSetgetUnicodeStream in class MrResultSetAdapterSQLException
public InputStream getUnicodeStream(int int1)
throws SQLException
getUnicodeStream in interface MrResultSetgetUnicodeStream in interface ResultSetgetUnicodeStream in class MrResultSetAdapterSQLException
public InputStream getBinaryStream(String string1)
throws SQLException
getBinaryStream in interface MrResultSetgetBinaryStream in interface ResultSetgetBinaryStream in class MrResultSetAdapterSQLException
public InputStream getBinaryStream(int int1)
throws SQLException
getBinaryStream in interface MrResultSetgetBinaryStream in interface ResultSetgetBinaryStream in class MrResultSetAdapterSQLException
public void close()
throws SQLException
close in interface MrResultSetclose in interface ResultSetclose in class MrResultSetAdapterSQLException - close failed (already closed?)
public void beforeFirst()
throws SQLException
beforeFirst in interface MrResultSetbeforeFirst in interface ResultSetbeforeFirst in class DistinctRowResultSetSQLException
public boolean isBeforeFirst()
throws SQLException
isBeforeFirst in interface MrResultSetisBeforeFirst in interface ResultSetisBeforeFirst in class MrResultSetAdapterSQLException
public boolean isAfterLast()
throws SQLException
isAfterLast in interface MrResultSetisAfterLast in interface ResultSetisAfterLast in class MrResultSetAdapterSQLException
public void updateRow()
throws SQLException
This implementation is probably not well behaved- the current row remains in the result set even if it duplicates another which appeared earlier in the constructed union. If the changed row is a duplicate, the absolute row addresses in the result set may have changed so that the first element is no longer numbered 1, or there may be many elements numbered 1. Selecting first() will restore the correct addressing and the distinctive quality of all returned rows, however order will be violated if the updated row is now out of sequence.
updateRow in interface MrResultSetupdateRow in interface ResultSetupdateRow in class DistinctRowResultSetSQLException
public void deleteRow()
throws SQLException
This implementation is probably not well behaved- the new current row may be a duplicate of an earlier row, and this and subsequent rows may violate the order constraint. Selecting first() will restore order and the distinctive quality of all returned rows.
deleteRow in interface MrResultSetdeleteRow in interface ResultSetdeleteRow in class DistinctRowResultSetSQLException
public void refreshRow()
throws SQLException
This implementation is probably not well behaved- the current row remains in the result set even if it duplicates another which appeared earlier in the constructed union. If the changed row is a duplicate, the absolute row addresses in the result set may have changed so that the first element is no longer numbered 1, or there may be many elements numbered 1. Selecting first() will restore the correct addressing and the distinctive quality of all returned rows, however order will be violated if the refreshed row is now out of sequence.
refreshRow in interface MrResultSetrefreshRow in interface ResultSetrefreshRow in class DistinctRowResultSetSQLException
public boolean rowUpdated()
throws SQLException
rowUpdated in interface MrResultSetrowUpdated in interface ResultSetrowUpdated in class MrResultSetAdapterSQLException
public boolean rowInserted()
throws SQLException
rowInserted in interface MrResultSetrowInserted in interface ResultSetrowInserted in class MrResultSetAdapterSQLException
public boolean rowDeleted()
throws SQLException
rowDeleted in interface MrResultSetrowDeleted in interface ResultSetrowDeleted in class MrResultSetAdapterSQLException
public void setFetchDirection(int int1)
throws SQLException
setFetchDirection in interface MrResultSetsetFetchDirection in interface ResultSetsetFetchDirection in class MrResultSetAdapterSQLException
public void setFetchSize(int int1)
throws SQLException
setFetchSize in interface MrResultSetsetFetchSize in interface ResultSetsetFetchSize in class MrResultSetAdapterSQLException
public Reader getCharacterStream(int int1)
throws SQLException
getCharacterStream in interface MrResultSetgetCharacterStream in interface ResultSetgetCharacterStream in class MrResultSetAdapterSQLException
public Reader getCharacterStream(String string1)
throws SQLException
getCharacterStream in interface MrResultSetgetCharacterStream in interface ResultSetgetCharacterStream in class MrResultSetAdapterSQLException
public void updateNull(int int1)
throws SQLException
updateNull in interface MrResultSetupdateNull in interface ResultSetupdateNull in class MrResultSetAdapterSQLException
public void updateNull(String string1)
throws SQLException
updateNull in interface MrResultSetupdateNull in interface ResultSetupdateNull in class MrResultSetAdapterSQLException
public void updateBoolean(String string1,
boolean boolean2)
throws SQLException
updateBoolean in interface MrResultSetupdateBoolean in interface ResultSetupdateBoolean in class MrResultSetAdapterSQLException
public void updateBoolean(int int1,
boolean boolean2)
throws SQLException
updateBoolean in interface MrResultSetupdateBoolean in interface ResultSetupdateBoolean in class MrResultSetAdapterSQLException
public void updateByte(int int1,
byte byte2)
throws SQLException
updateByte in interface MrResultSetupdateByte in interface ResultSetupdateByte in class MrResultSetAdapterSQLException
public void updateByte(String string1,
byte byte2)
throws SQLException
updateByte in interface MrResultSetupdateByte in interface ResultSetupdateByte in class MrResultSetAdapterSQLException
public void updateShort(int int1,
short short2)
throws SQLException
updateShort in interface MrResultSetupdateShort in interface ResultSetupdateShort in class MrResultSetAdapterSQLException
public void updateShort(String string1,
short short2)
throws SQLException
updateShort in interface MrResultSetupdateShort in interface ResultSetupdateShort in class MrResultSetAdapterSQLException
public void updateInt(String string1,
int int2)
throws SQLException
updateInt in interface MrResultSetupdateInt in interface ResultSetupdateInt in class MrResultSetAdapterSQLException
public void updateInt(int int1,
int int2)
throws SQLException
updateInt in interface MrResultSetupdateInt in interface ResultSetupdateInt in class MrResultSetAdapterSQLException
public void updateLong(String string1,
long long2)
throws SQLException
updateLong in interface MrResultSetupdateLong in interface ResultSetupdateLong in class MrResultSetAdapterSQLException
public void updateLong(int int1,
long long2)
throws SQLException
updateLong in interface MrResultSetupdateLong in interface ResultSetupdateLong in class MrResultSetAdapterSQLException
public void updateFloat(int int1,
float float2)
throws SQLException
updateFloat in interface MrResultSetupdateFloat in interface ResultSetupdateFloat in class MrResultSetAdapterSQLException
public void updateFloat(String string1,
float float2)
throws SQLException
updateFloat in interface MrResultSetupdateFloat in interface ResultSetupdateFloat in class MrResultSetAdapterSQLException
public void updateDouble(int int1,
double double2)
throws SQLException
updateDouble in interface MrResultSetupdateDouble in interface ResultSetupdateDouble in class MrResultSetAdapterSQLException
public void updateDouble(String string1,
double double2)
throws SQLException
updateDouble in interface MrResultSetupdateDouble in interface ResultSetupdateDouble in class MrResultSetAdapterSQLException
public void updateBigDecimal(int int1,
BigDecimal bigDecimal2)
throws SQLException
updateBigDecimal in interface MrResultSetupdateBigDecimal in interface ResultSetupdateBigDecimal in class MrResultSetAdapterSQLException
public void updateBigDecimal(String string1,
BigDecimal bigDecimal2)
throws SQLException
updateBigDecimal in interface MrResultSetupdateBigDecimal in interface ResultSetupdateBigDecimal in class MrResultSetAdapterSQLException
public void updateString(String string1,
String string2)
throws SQLException
updateString in interface MrResultSetupdateString in interface ResultSetupdateString in class MrResultSetAdapterSQLException
public void updateString(int int1,
String string2)
throws SQLException
updateString in interface MrResultSetupdateString in interface ResultSetupdateString in class MrResultSetAdapterSQLException
public void updateBytes(String string1,
byte[] byteArray2)
throws SQLException
updateBytes in interface MrResultSetupdateBytes in interface ResultSetupdateBytes in class MrResultSetAdapterSQLException
public void updateBytes(int int1,
byte[] byteArray2)
throws SQLException
updateBytes in interface MrResultSetupdateBytes in interface ResultSetupdateBytes in class MrResultSetAdapterSQLException
public void updateDate(String string1,
Date date2)
throws SQLException
updateDate in interface MrResultSetupdateDate in interface ResultSetupdateDate in class MrResultSetAdapterSQLException
public void updateDate(int int1,
Date date2)
throws SQLException
updateDate in interface MrResultSetupdateDate in interface ResultSetupdateDate in class MrResultSetAdapterSQLException
public void updateTime(String string1,
Time time2)
throws SQLException
updateTime in interface MrResultSetupdateTime in interface ResultSetupdateTime in class MrResultSetAdapterSQLException
public void updateTime(int int1,
Time time2)
throws SQLException
updateTime in interface MrResultSetupdateTime in interface ResultSetupdateTime in class MrResultSetAdapterSQLException
public void updateTimestamp(String string1,
Timestamp timestamp2)
throws SQLException
updateTimestamp in interface MrResultSetupdateTimestamp in interface ResultSetupdateTimestamp in class MrResultSetAdapterSQLException
public void updateTimestamp(int int1,
Timestamp timestamp2)
throws SQLException
updateTimestamp in interface MrResultSetupdateTimestamp in interface ResultSetupdateTimestamp in class MrResultSetAdapterSQLException
public void updateAsciiStream(String string1,
InputStream inputStream2,
int int3)
throws SQLException
updateAsciiStream in interface MrResultSetupdateAsciiStream in interface ResultSetupdateAsciiStream in class MrResultSetAdapterSQLException
public void updateAsciiStream(int int1,
InputStream inputStream2,
int int3)
throws SQLException
updateAsciiStream in interface MrResultSetupdateAsciiStream in interface ResultSetupdateAsciiStream in class MrResultSetAdapterSQLException
public void updateBinaryStream(String string1,
InputStream inputStream2,
int int3)
throws SQLException
updateBinaryStream in interface MrResultSetupdateBinaryStream in interface ResultSetupdateBinaryStream in class MrResultSetAdapterSQLException
public void updateBinaryStream(int int1,
InputStream inputStream2,
int int3)
throws SQLException
updateBinaryStream in interface MrResultSetupdateBinaryStream in interface ResultSetupdateBinaryStream in class MrResultSetAdapterSQLException
public void updateCharacterStream(String string1,
Reader reader2,
int int3)
throws SQLException
updateCharacterStream in interface MrResultSetupdateCharacterStream in interface ResultSetupdateCharacterStream in class MrResultSetAdapterSQLException
public void updateCharacterStream(int int1,
Reader reader2,
int int3)
throws SQLException
updateCharacterStream in interface MrResultSetupdateCharacterStream in interface ResultSetupdateCharacterStream in class MrResultSetAdapterSQLException
public void updateObject(int int1,
Object object2)
throws SQLException
updateObject in interface MrResultSetupdateObject in interface ResultSetupdateObject in class MrResultSetAdapterSQLException
public void updateObject(String string1,
Object object2,
int int3)
throws SQLException
updateObject in interface MrResultSetupdateObject in interface ResultSetupdateObject in class MrResultSetAdapterSQLException
public void updateObject(String string1,
Object object2)
throws SQLException
updateObject in interface MrResultSetupdateObject in interface ResultSetupdateObject in class MrResultSetAdapterSQLException
public void updateObject(int int1,
Object object2,
int int3)
throws SQLException
updateObject in interface MrResultSetupdateObject in interface ResultSetupdateObject in class MrResultSetAdapterSQLException
public void insertRow()
throws SQLException
insertRow in interface MrResultSetinsertRow in interface ResultSetinsertRow in class MrResultSetAdapterSQLException
public void cancelRowUpdates()
throws SQLException
cancelRowUpdates in interface MrResultSetcancelRowUpdates in interface ResultSetcancelRowUpdates in class MrResultSetAdapterSQLException
public void moveToInsertRow()
throws SQLException
moveToInsertRow in interface MrResultSetmoveToInsertRow in interface ResultSetmoveToInsertRow in class MrResultSetAdapterSQLException
public void moveToCurrentRow()
throws SQLException
moveToCurrentRow in interface MrResultSetmoveToCurrentRow in interface ResultSetmoveToCurrentRow in class MrResultSetAdapterSQLException
public Blob getBlob(String string1)
throws SQLException
getBlob in interface MrResultSetgetBlob in interface ResultSetgetBlob in class MrResultSetAdapterSQLException
public Blob getBlob(int int1)
throws SQLException
getBlob in interface MrResultSetgetBlob in interface ResultSetgetBlob in class MrResultSetAdapterSQLException
public Clob getClob(String string1)
throws SQLException
getClob in interface MrResultSetgetClob in interface ResultSetgetClob in class MrResultSetAdapterSQLException
public Clob getClob(int int1)
throws SQLException
getClob in interface MrResultSetgetClob in interface ResultSetgetClob in class MrResultSetAdapterSQLException
public Array getArray(int int1)
throws SQLException
getArray in interface MrResultSetgetArray in interface ResultSetgetArray in class MrResultSetAdapterSQLException
public Array getArray(String string1)
throws SQLException
getArray in interface MrResultSetgetArray in interface ResultSetgetArray in class MrResultSetAdapterSQLException
public URL getURL(int int1)
throws SQLException
getURL in interface MrResultSetgetURL in interface ResultSetgetURL in class MrResultSetAdapterSQLException
public URL getURL(String string1)
throws SQLException
getURL in interface MrResultSetgetURL in interface ResultSetgetURL in class MrResultSetAdapterSQLException
public void updateRef(int columnIndex,
Ref x)
throws SQLException
updateRef in interface MrResultSetupdateRef in interface ResultSetupdateRef in class MrResultSetAdapterSQLException
public void updateRef(String columnName,
Ref x)
throws SQLException
updateRef in interface MrResultSetupdateRef in interface ResultSetupdateRef in class MrResultSetAdapterSQLException
public void updateBlob(int columnIndex,
Blob x)
throws SQLException
updateBlob in interface MrResultSetupdateBlob in interface ResultSetupdateBlob in class MrResultSetAdapterSQLException
public void updateBlob(String columnName,
Blob x)
throws SQLException
updateBlob in interface MrResultSetupdateBlob in interface ResultSetupdateBlob in class MrResultSetAdapterSQLException
public void updateClob(int columnIndex,
Clob x)
throws SQLException
updateClob in interface MrResultSetupdateClob in interface ResultSetupdateClob in class MrResultSetAdapterSQLException
public void updateClob(String columnName,
Clob x)
throws SQLException
updateClob in interface MrResultSetupdateClob in interface ResultSetupdateClob in class MrResultSetAdapterSQLException
public void updateArray(int columnIndex,
Array x)
throws SQLException
updateArray in interface MrResultSetupdateArray in interface ResultSetupdateArray in class MrResultSetAdapterSQLException
public void updateArray(String columnName,
Array x)
throws SQLException
updateArray in interface MrResultSetupdateArray in interface ResultSetupdateArray in class MrResultSetAdapterSQLException
|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||