|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectjavax.sql.rowset.BaseRowSet
com.sun.rowset.JdbcRowSetImpl
public class JdbcRowSetImpl
The standard implementation of the JdbcRowSet
interface. See the interface
defintion for full behavior and implementation requirements.
Field Summary |
---|
Fields inherited from class javax.sql.rowset.BaseRowSet |
---|
ASCII_STREAM_PARAM, asciiStream, BINARY_STREAM_PARAM, binaryStream, charStream, UNICODE_STREAM_PARAM, unicodeStream |
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 | |
---|---|
JdbcRowSetImpl()
Constructs a default JdbcRowSet object. |
|
JdbcRowSetImpl(java.sql.Connection con)
Constructs a default JdbcRowSet object given a
valid Connection object. |
|
JdbcRowSetImpl(java.sql.ResultSet res)
Constructs a JdbcRowSet object using the given valid
ResultSet object. |
|
JdbcRowSetImpl(java.lang.String url,
java.lang.String user,
java.lang.String password)
Constructs a default JdbcRowSet object using the
URL, username, and password arguments supplied. |
Method Summary | |
---|---|
boolean |
absolute(int row)
Moves the cursor to the given row number in this rowset's internal ResultSet object. |
void |
afterLast()
Moves the cursor to the end of this rowset's ResultSet object, just after the
last row. |
void |
beforeFirst()
Moves the cursor to the front of this rowset's ResultSet object, just before the
first row. |
void |
cancelRowUpdates()
Cancels the updates made to the current row in this ResultSet object and notifies listeners that a row
has changed. |
protected void |
checkState()
|
void |
clearWarnings()
Clears all warnings reported on this rowset's ResultSet object. |
void |
close()
Releases this rowset's ResultSet object's database and
JDBC resources immediately instead of waiting for
this to happen when it is automatically closed. |
void |
commit()
Commits all updates in this JdbcRowSet object by
wrapping the internal Connection object and calling
its commit method. |
protected java.sql.Connection |
connect()
|
void |
deleteRow()
Deletes the current row from this rowset's ResultSet object
and from the underlying database and also notifies listeners that a row
has changed. |
void |
execute()
Creates the internal ResultSet object for which this
JdbcRowSet object is a wrapper, effectively
making the result set a JavaBeans component. |
int |
findColumn(java.lang.String columnName)
Maps the given JdbcRowSetImpl column name to its
JdbcRowSetImpl column index and reflects this on
the internal ResultSet object. |
boolean |
first()
Moves the cursor to the first row in this rowset's ResultSet object. |
java.sql.Array |
getArray(int i)
Returns the value of the designated column in the current row of this rowset's ResultSet object as an Array object. |
java.sql.Array |
getArray(java.lang.String colName)
Returns the value of the designated column in the current row of this rowset's ResultSet object as an Array object. |
java.io.InputStream |
getAsciiStream(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a stream of ASCII characters. |
java.io.InputStream |
getAsciiStream(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a stream of
ASCII characters. |
boolean |
getAutoCommit()
Returns the auto-commit status with this JdbcRowSet . |
java.math.BigDecimal |
getBigDecimal(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a
java.math.BigDecimal with full precision. |
java.math.BigDecimal |
getBigDecimal(int columnIndex,
int scale)
Deprecated. |
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a
java.math.BigDecimal with full precision. |
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName,
int scale)
Deprecated. |
java.io.InputStream |
getBinaryStream(int columnIndex)
Gets the value of a column in the current row as a stream of the value of the designated column in the current row of this rowset's ResultSet object as a binary stream of
uninterpreted bytes. |
java.io.InputStream |
getBinaryStream(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a stream of uninterpreted
byte s. |
java.sql.Blob |
getBlob(int i)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a Blob object. |
java.sql.Blob |
getBlob(java.lang.String colName)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a Blob object. |
boolean |
getBoolean(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a boolean . |
boolean |
getBoolean(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a boolean . |
byte |
getByte(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a byte . |
byte |
getByte(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a byte . |
byte[] |
getBytes(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a byte array in the Java programming language. |
byte[] |
getBytes(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a byte array in the Java programming language. |
java.io.Reader |
getCharacterStream(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a
java.io.Reader object. |
java.io.Reader |
getCharacterStream(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as a
java.io.Reader object. |
java.sql.Clob |
getClob(int i)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a Clob object. |
java.sql.Clob |
getClob(java.lang.String colName)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a Clob object. |
int |
getConcurrency()
Returns the concurrency mode of this rowset's ResultSet object. |
protected java.sql.Connection |
getConnection()
Gets this JdbcRowSet object's Connection property |
java.lang.String |
getCursorName()
Gets the name of the SQL cursor used by this rowset's ResultSet
object. |
java.sql.DatabaseMetaData |
getDatabaseMetaData()
Retrieves the DatabaseMetaData associated with
the connection handle associated this this
JdbcRowSet object. |
java.sql.Date |
getDate(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a java.sql.Date object in the Java programming language. |
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar cal)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Date
object. |
java.sql.Date |
getDate(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a java.sql.Date object in the Java programming language. |
java.sql.Date |
getDate(java.lang.String columnName,
java.util.Calendar cal)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Date
object. |
double |
getDouble(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a double . |
double |
getDouble(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a double . |
int |
getFetchDirection()
Returns the fetch direction for this ResultSet object. |
float |
getFloat(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a float . |
float |
getFloat(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a float . |
int |
getInt(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
an int . |
int |
getInt(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
an int . |
long |
getLong(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a long . |
long |
getLong(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a long . |
int[] |
getMatchColumnIndexes()
Retrieves the column id as int array that was set using
setMatchColumn(int []) for this rowset. |
java.lang.String[] |
getMatchColumnNames()
Retrieves the column name as String array
that was set using setMatchColumn(String [])
for this rowset. |
java.sql.ResultSetMetaData |
getMetaData()
Retrieves the number, types and properties of this rowset's ResultSet object's columns. |
java.lang.Object |
getObject(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
an Object . |
java.lang.Object |
getObject(int i,
java.util.Map map)
Returns the value of the designated column in the current row of this rowset's ResultSet object as an Object . |
java.lang.Object |
getObject(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
an Object . |
java.lang.Object |
getObject(java.lang.String colName,
java.util.Map map)
Returns the value of the designated column in the current row of this rowset's ResultSet object as an Object . |
java.sql.ParameterMetaData |
getParameterMetaData()
Retrieves the ParameterMetaData associated with
the connection handle associated this this
JdbcRowSet object. |
protected java.sql.PreparedStatement |
getPreparedStatement()
Gets this JdbcRowSet object's PreparedStatement property |
java.sql.Ref |
getRef(int i)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a Ref object. |
java.sql.Ref |
getRef(java.lang.String colName)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a Ref object. |
protected java.sql.ResultSet |
getResultSet()
Gets this JdbcRowSet object's ResultSet property |
int |
getRow()
Retrieves the current row number. |
RowSetWarning |
getRowSetWarnings()
Return the RowSetWarning object for the current row of a JdbcRowSetImpl |
short |
getShort(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a short . |
short |
getShort(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a short . |
java.sql.Statement |
getStatement()
Returns the Statement object that produced this
ResultSet object. |
java.lang.String |
getString(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a String . |
java.lang.String |
getString(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a String . |
java.sql.Time |
getTime(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a java.sql.Time object in the Java programming language. |
java.sql.Time |
getTime(int columnIndex,
java.util.Calendar cal)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Time
object. |
java.sql.Time |
getTime(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a java.sql.Time object in the Java programming language. |
java.sql.Time |
getTime(java.lang.String columnName,
java.util.Calendar cal)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a java.sql.Time
object. |
java.sql.Timestamp |
getTimestamp(int columnIndex)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a java.sql.Timestamp object in the Java programming language. |
java.sql.Timestamp |
getTimestamp(int columnIndex,
java.util.Calendar cal)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a
java.sql.Timestamp object. |
java.sql.Timestamp |
getTimestamp(java.lang.String columnName)
Gets the value of the designated column in the current row of this rowset's ResultSet object as
a java.sql.Timestamp object. |
java.sql.Timestamp |
getTimestamp(java.lang.String columnName,
java.util.Calendar cal)
Returns the value of the designated column in the current row of this rowset's ResultSet object as a
java.sql.Timestamp object. |
int |
getType()
Returns the fetch size for this ResultSet object. |
java.io.InputStream |
getUnicodeStream(int columnIndex)
Deprecated. use getCharacterStream in place of
getUnicodeStream |
java.io.InputStream |
getUnicodeStream(java.lang.String columnName)
Deprecated. |
java.net.URL |
getURL(int columnIndex)
Provide interface coverage for getURL(int) in ResultSet->RowSet |
java.net.URL |
getURL(java.lang.String columnName)
Provide interface coverage for getURL(String) in ResultSet->RowSet |
java.sql.SQLWarning |
getWarnings()
Returns the first warning reported by calls on this rowset's ResultSet object. |
protected void |
initMetaData(javax.sql.RowSetMetaData md,
java.sql.ResultSetMetaData rsmd)
Initializes the given RowSetMetaData object with the values
in the given ResultSetMetaData object. |
void |
insertRow()
Inserts the contents of the insert row into this ResultSet object and into the database
and also notifies listeners that a row has changed. |
boolean |
isAfterLast()
Indicates whether the cursor is after the last row in this rowset's ResultSet object. |
boolean |
isBeforeFirst()
Indicates whether the cursor is before the first row in this rowset's ResultSet object. |
boolean |
isFirst()
Indicates whether the cursor is on the first row of this rowset's ResultSet object. |
boolean |
isLast()
Indicates whether the cursor is on the last row of this rowset's ResultSet object. |
boolean |
last()
Moves the cursor to the last row in this rowset's ResultSet object. |
void |
moveToCurrentRow()
Moves the cursor to the remembered cursor position, usually the current row. |
void |
moveToInsertRow()
Moves the cursor to the insert row. |
boolean |
next()
Moves the cursor for this rowset's ResultSet
object down one row from its current position. |
protected java.sql.PreparedStatement |
prepare()
|
boolean |
previous()
Moves the cursor to the previous row in this ResultSet object. |
void |
refreshRow()
Refreshes the current row of this rowset's ResultSet
object with its most recent value in the database. |
boolean |
relative(int rows)
Moves the cursor a relative number of rows, either positive or negative. |
void |
rollback()
Rolls back all the updates in this JdbcRowSet object by
wrapping the internal Connection object and calling its
rollback method. |
void |
rollback(java.sql.Savepoint s)
Rollbacks all the updates in the JdbcRowSet back to the
last Savepoint transaction marker. |
boolean |
rowDeleted()
Indicates whether a row has been deleted. |
boolean |
rowInserted()
Indicates whether the current row has had an insertion. |
boolean |
rowUpdated()
Indicates whether the current row has been updated. |
void |
setAutoCommit(boolean autoCommit)
Sets auto-commit on the internal Connection object with this
JdbcRowSet |
void |
setCommand(java.lang.String command)
Sets this JdbcRowSet object's command property to
the given String object and clears the parameters, if any,
that were set for the previous command. |
void |
setConcurrency(int concur)
Sets the concurrency for this RowSet object to
the specified concurrency. |
protected void |
setConnection(java.sql.Connection connection)
Sets this JdbcRowSet object's connection property
to the given Connection object. |
void |
setDataSourceName(java.lang.String dsName)
Sets the dataSourceName property for this JdbcRowSet
object to the given logical name and sets this JdbcRowSet object's
Url property to null . |
void |
setFetchDirection(int direction)
Gives a hint as to the direction in which the rows in this ResultSet object will be processed. |
void |
setFetchSize(int rows)
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object. |
void |
setMatchColumn(int columnIdx)
Sets the designated parameter to the given int
object. |
void |
setMatchColumn(int[] columnIdxes)
Sets the designated parameter to the given int array. |
void |
setMatchColumn(java.lang.String columnName)
Sets the designated parameter to the given String
object. |
void |
setMatchColumn(java.lang.String[] columnNames)
Sets the designated parameter to the given String array. |
void |
setMaxRows(int mRows)
Sets the maximum number of rows that this RowSet object may contain to
the given number. |
protected void |
setParams()
|
void |
setPassword(java.lang.String password)
Sets the password property for this JdbcRowSet object
to the given String object. |
protected void |
setPreparedStatement(java.sql.PreparedStatement preparedStatement)
Sets this JdbcRowSet object's preparedtsatement property
to the given PreparedStatemennt object. |
protected void |
setProperties(java.sql.PreparedStatement ps)
|
protected void |
setResultSet(java.sql.ResultSet resultSet)
Sets this JdbcRowSet object's resultset property
to the given ResultSet object. |
void |
setTransactionIsolation(int transIso)
Sets the transaction isolation property for this JDBC RowSet object to the given
constant. |
void |
setType(int type)
Sets the type for this RowSet object to the specified type. |
void |
setUrl(java.lang.String url)
Sets the Url property for this JdbcRowSet object
to the given String object and sets the dataSource name
property to null . |
void |
setUsername(java.lang.String uname)
Sets the username property for this JdbcRowSet object
to the given user name. |
void |
unsetMatchColumn(int columnIdx)
Unsets the designated parameter to the given int
object. |
void |
unsetMatchColumn(int[] columnIdxes)
Unsets the designated parameter to the given int array. |
void |
unsetMatchColumn(java.lang.String columnName)
Unsets the designated parameter to the given String
object. |
void |
unsetMatchColumn(java.lang.String[] columnIdxes)
Unsets the designated parameter to the given String array. |
void |
updateArray(int columnIndex,
java.sql.Array a)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given
java.sql.Array values. |
void |
updateArray(java.lang.String columnName,
java.sql.Array a)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given
java.sql.Array value. |
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
Updates the designated column with an ascii stream value. |
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
Updates the designated column with an ascii stream value. |
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
Updates the designated column with a java.math.BigDecimal
value. |
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
Updates the designated column with a java.sql.BigDecimal
value. |
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
Updates the designated column with a binary stream value. |
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length)
Updates the designated column with a binary stream value. |
void |
updateBlob(int columnIndex,
java.sql.Blob b)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given
java.sql.Blob value. |
void |
updateBlob(java.lang.String columnName,
java.sql.Blob b)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given
java.sql.Blob value. |
void |
updateBoolean(int columnIndex,
boolean x)
Updates the designated column with a boolean value. |
void |
updateBoolean(java.lang.String columnName,
boolean x)
Updates the designated column with a boolean value. |
void |
updateByte(int columnIndex,
byte x)
Updates the designated column with a byte value. |
void |
updateByte(java.lang.String columnName,
byte x)
Updates the designated column with a byte value. |
void |
updateBytes(int columnIndex,
byte[] x)
Updates the designated column with a byte array value. |
void |
updateBytes(java.lang.String columnName,
byte[] x)
Updates the designated column with a boolean value. |
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
Updates the designated column with a character stream value. |
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader reader,
int length)
Updates the designated column with a character stream value. |
void |
updateClob(int columnIndex,
java.sql.Clob c)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given
double value. |
void |
updateClob(java.lang.String columnName,
java.sql.Clob c)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given
double value. |
void |
updateDate(int columnIndex,
java.sql.Date x)
Updates the designated column with a java.sql.Date value. |
void |
updateDate(java.lang.String columnName,
java.sql.Date x)
Updates the designated column with a java.sql.Date value. |
void |
updateDouble(int columnIndex,
double x)
Updates the designated column with a double value. |
void |
updateDouble(java.lang.String columnName,
double x)
Updates the designated column with a double value. |
void |
updateFloat(int columnIndex,
float x)
Updates the designated column with a float value. |
void |
updateFloat(java.lang.String columnName,
float x)
Updates the designated column with a float value. |
void |
updateInt(int columnIndex,
int x)
Updates the designated column with an int value. |
void |
updateInt(java.lang.String columnName,
int x)
Updates the designated column with an int value. |
void |
updateLong(int columnIndex,
long x)
Updates the designated column with a long value. |
void |
updateLong(java.lang.String columnName,
long x)
Updates the designated column with a long value. |
void |
updateNull(int columnIndex)
Gives a nullable column a null value. |
void |
updateNull(java.lang.String columnName)
Updates the designated column with a null value. |
void |
updateObject(int columnIndex,
java.lang.Object x)
Updates the designated column with an Object value. |
void |
updateObject(int columnIndex,
java.lang.Object x,
int scale)
Updates the designated column with an Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object x)
Updates the designated column with an Object value. |
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
Updates the designated column with an Object value. |
void |
updateRef(int columnIndex,
java.sql.Ref ref)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given
double value. |
void |
updateRef(java.lang.String columnName,
java.sql.Ref ref)
Sets the designated column in either the current row or the insert row of this JdbcRowSetImpl object with the given
double value. |
void |
updateRow()
Updates the underlying database with the new contents of the current row of this rowset's ResultSet object
and notifies listeners that a row has changed. |
void |
updateShort(int columnIndex,
short x)
Updates the designated column with a short value. |
void |
updateShort(java.lang.String columnName,
short x)
Updates the designated column with a short value. |
void |
updateString(int columnIndex,
java.lang.String x)
Updates the designated column with a String value. |
void |
updateString(java.lang.String columnName,
java.lang.String x)
Updates the designated column with a String value. |
void |
updateTime(int columnIndex,
java.sql.Time x)
Updates the designated column with a java.sql.Time value. |
void |
updateTime(java.lang.String columnName,
java.sql.Time x)
Updates the designated column with a java.sql.Time value. |
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x)
Updates the designated column with a java.sql.Timestamp
value. |
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
Updates the designated column with a java.sql.Timestamp
value. |
boolean |
wasNull()
Reports whether the last column read from this rowset's ResultSet object had a value of SQL NULL . |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface javax.sql.rowset.JdbcRowSet |
---|
getShowDeleted, setShowDeleted |
Methods inherited from interface javax.sql.RowSet |
---|
addRowSetListener, clearParameters, getCommand, getDataSourceName, getEscapeProcessing, getMaxFieldSize, getMaxRows, getPassword, getQueryTimeout, getTransactionIsolation, getTypeMap, getUrl, getUsername, isReadOnly, removeRowSetListener, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setEscapeProcessing, setFloat, setInt, setLong, setMaxFieldSize, setNull, setNull, setObject, setObject, setObject, setQueryTimeout, setReadOnly, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setTypeMap |
Methods inherited from interface java.sql.ResultSet |
---|
getFetchSize |
Constructor Detail |
---|
public JdbcRowSetImpl()
JdbcRowSet
object.
The new instance of JdbcRowSet
will serve as a proxy
for the ResultSet
object it creates, and by so doing,
it will make it possible to use the result set as a JavaBeans
component.
The following is true of a default JdbcRowSet
instance:
null
Hashtable
object for storing any
parameters that are set
JdbcRowSet
object must have its
execute
method invoked before other public methods
are called on it; otherwise, such method calls will cause an
exception to be thrown.
java.sql.SQLException
- [1] if any of its public methods are called prior
to calling the execute
method; [2] if invalid JDBC driver
properties are set or [3] if no connection to a data source exists.public JdbcRowSetImpl(java.sql.Connection con) throws java.sql.SQLException
JdbcRowSet
object given a
valid Connection
object. The new
instance of JdbcRowSet
will serve as a proxy for
the ResultSet
object it creates, and by so doing,
it will make it possible to use the result set as a JavaBeans
component.
The following is true of a default JdbcRowSet
instance:
null
Hashtable
object for storing any
parameters that are set
JdbcRowSet
object must have its
execute
method invoked before other public methods
are called on it; otherwise, such method calls will cause an
exception to be thrown.
java.sql.SQLException
- [1] if any of its public methods are called prior
to calling the execute
method, [2] if invalid JDBC driver
properties are set, or [3] if no connection to a data source exists.public JdbcRowSetImpl(java.lang.String url, java.lang.String user, java.lang.String password) throws java.sql.SQLException
JdbcRowSet
object using the
URL, username, and password arguments supplied. The new
instance of JdbcRowSet
will serve as a proxy for
the ResultSet
object it creates, and by so doing,
it will make it possible to use the result set as a JavaBeans
component.
The following is true of a default JdbcRowSet
instance:
null
Hashtable
object for storing any
parameters that are set
url
- - a JDBC URL for the database to which this JdbcRowSet
object will be connected. The form for a JDBC URL is
jdbc:subprotocol:subname
.user
- - the database user on whose behalf the connection
is being madepassword
- - the user's password
java.sql.SQLException
- if a database access error occurspublic JdbcRowSetImpl(java.sql.ResultSet res) throws java.sql.SQLException
JdbcRowSet
object using the given valid
ResultSet
object. The new
instance of JdbcRowSet
will serve as a proxy for
the ResultSet
object, and by so doing,
it will make it possible to use the result set as a JavaBeans
component.
The following is true of a default JdbcRowSet
instance:
null
Hashtable
object for storing any
parameters that are set
res
- a valid ResultSet
object
java.sql.SQLException
- if a database access occurs due to a non
valid ResultSet handle.Method Detail |
---|
protected void initMetaData(javax.sql.RowSetMetaData md, java.sql.ResultSetMetaData rsmd) throws java.sql.SQLException
RowSetMetaData
object with the values
in the given ResultSetMetaData
object.
md
- the RowSetMetaData
object for this
JdbcRowSetImpl
object, which will be set with
values from rsmdrsmd
- the ResultSetMetaData
object from which new
values for md will be read
java.sql.SQLException
- if an error occursprotected void checkState() throws java.sql.SQLException
java.sql.SQLException
public void execute() throws java.sql.SQLException
ResultSet
object for which this
JdbcRowSet
object is a wrapper, effectively
making the result set a JavaBeans component.
Certain properties must have been set before this method is called
so that it can establish a connection to a database and execute the
query that will create the result set. If a DataSource
object will be used to create the connection, properties for the
data source name, user name, and password must be set. If the
DriverManager
will be used, the properties for the
URL, user name, and password must be set. In either case, the
property for the command must be set. If the command has placeholder
parameters, those must also be set. This method throws
an exception if the required properties are not set.
Other properties have default values that may optionally be set
to new values. The execute
method will use the value
for the command property to create a PreparedStatement
object and set its properties (escape processing, maximum field
size, maximum number of rows, and query timeout limit) to be those
of this rowset.
execute
in interface javax.sql.RowSet
java.sql.SQLException
- if (1) a database access error occurs,
(2) any required JDBC properties are not set, or (3) if an
invalid connection exists.protected void setProperties(java.sql.PreparedStatement ps) throws java.sql.SQLException
java.sql.SQLException
protected java.sql.Connection connect() throws java.sql.SQLException
java.sql.SQLException
protected java.sql.PreparedStatement prepare() throws java.sql.SQLException
java.sql.SQLException
public boolean next() throws java.sql.SQLException
ResultSet
object down one row from its current position.
A ResultSet
cursor is initially positioned
before the first row; the first call to the method
next
makes the first row the current row; the
second call makes the second row the current row, and so on.
If an input stream is open for the current row, a call
to the method next
will
implicitly close it. A ResultSet
object's
warning chain is cleared when a new row is read.
next
in interface java.sql.ResultSet
true
if the new current row is valid;
false
if there are no more rows
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void close() throws java.sql.SQLException
ResultSet
object's database and
JDBC resources immediately instead of waiting for
this to happen when it is automatically closed.
Note: A ResultSet
object
is automatically closed by the
Statement
object that generated it when
that Statement
object is closed,
re-executed, or is used to retrieve the next result from a
sequence of multiple results. A ResultSet
object
is also automatically closed when it is garbage collected.
close
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error occurspublic boolean wasNull() throws java.sql.SQLException
ResultSet
object had a value of SQL NULL
.
Note that you must first call one of the getXXX
methods
on a column to try to read its value and then call
the method wasNull
to see if the value read was
SQL NULL
.
wasNull
in interface java.sql.ResultSet
true
if the last column value read was SQL
NULL
and false
otherwise
java.sql.SQLException
- if a database access error occurs
or this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.lang.String getString(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a String
.
getString
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic boolean getBoolean(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a boolean
.
getBoolean
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is false
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic byte getByte(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a byte
.
getByte
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is 0
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic short getShort(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a short
.
getShort
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is 0
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic int getInt(int columnIndex) throws java.sql.SQLException
ResultSet
object as
an int
.
getInt
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is 0
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic long getLong(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a long
.
getLong
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is 0
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic float getFloat(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a float
.
getFloat
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is 0
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic double getDouble(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a double
.
getDouble
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is 0
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws java.sql.SQLException
ResultSet
object as
a java.sql.BigDecimal
.
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onscale
- the number of digits to the right of the decimal point
NULL
, the
value returned is null
java.sql.SQLException
- if (1) database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic byte[] getBytes(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a byte
array in the Java programming language.
The bytes represent the raw values returned by the driver.
getBytes
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.sql.Date getDate(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a java.sql.Date
object in the Java programming language.
getDate
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.sql.Time getTime(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a java.sql.Time
object in the Java programming language.
getTime
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a java.sql.Timestamp
object in the Java programming language.
getTimestamp
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.io.InputStream getAsciiStream(int columnIndex) throws java.sql.SQLException
ResultSet
object as
a stream of ASCII characters. The value can then be 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.
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. Also, a
stream may return 0
when the method
InputStream.available
is called whether there is data available or not.
getAsciiStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the
value returned is null
java.sql.SQLException
- if (1) database access error occurs
(2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLException
getCharacterStream
in place of
getUnicodeStream
ResultSet
object as
as a stream of Unicode characters.
The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving largeLONGVARCHAR
values. The JDBC driver will
do any necessary conversion from the database format into Unicode.
The byte format of the Unicode stream must be Java UTF-8,
as specified in the Java virtual machine specification.
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. Also, a
stream may return 0
when the method
InputStream.available
is called whether there is data available or not.
getUnicodeStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLException
ResultSet
object as a binary stream of
uninterpreted bytes. The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARBINARY
values.
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. Also, a
stream may return 0
when the method
InputStream.available
is called whether there is data available or not.
getBinaryStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.lang.String getString(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
a String
.
getString
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
, the
value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic boolean getBoolean(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
a boolean
.
getBoolean
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
, the
value returned is false
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic byte getByte(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
a byte
.
getByte
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
, the
value returned is 0
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic short getShort(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
a short
.
getShort
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
, the
value returned is 0
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic int getInt(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
an int
.
getInt
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
, the
value returned is 0
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic long getLong(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
a long
.
getLong
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
, the
value returned is 0
java.sql.SQLException
- if a database access error occurs
or this rowset does not have a currently valid connection,
prepared statement, and result setpublic float getFloat(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
a float
.
getFloat
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
, the
value returned is 0
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic double getDouble(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
a double
.
getDouble
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
, the
value returned is 0
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws java.sql.SQLException
ResultSet
object as
a java.math.BigDecimal
.
getBigDecimal
in interface java.sql.ResultSet
columnName
- the SQL name of the columnscale
- the number of digits to the right of the decimal point
NULL
, the
value returned is null
java.sql.SQLException
- if (1) adatabase access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic byte[] getBytes(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
a byte
array in the Java programming language.
The bytes represent the raw values returned by the driver.
getBytes
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
, the
value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.sql.Date getDate(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
a java.sql.Date
object in the Java programming language.
getDate
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
, the
value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.sql.Time getTime(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
a java.sql.Time
object in the Java programming language.
getTime
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
,
the value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.sql.Timestamp getTimestamp(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as
a java.sql.Timestamp
object.
getTimestamp
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
, the
value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.io.InputStream getAsciiStream(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as a stream of
ASCII characters. The value can then be 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.
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. Also, a
stream may return 0
when the method available
is called whether there is data available or not.
getAsciiStream
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
,
the value returned is null
.
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.io.InputStream getUnicodeStream(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as a stream of
Unicode characters. The value can then be 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 Unicode.
The byte format of the Unicode stream must be Java UTF-8,
as defined in the Java virtual machine specification.
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. Also, a
stream may return 0
when the method available
is called whether there is data available or not.
getUnicodeStream
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
,
the value returned is null
.
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.io.InputStream getBinaryStream(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as a stream of uninterpreted
byte
s.
The value can then be read in chunks from the
stream. This method is particularly
suitable for retrieving large LONGVARBINARY
values.
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. Also, a
stream may return 0
when the method available
is called whether there is data available or not.
getBinaryStream
in interface java.sql.ResultSet
columnName
- the SQL name of the column
NULL
, the result is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.sql.SQLWarning getWarnings() throws java.sql.SQLException
ResultSet
object.
Subsequent warnings on this rowset's ResultSet
object
will be chained to the SQLWarning
object that
this method returns.
The warning chain is automatically cleared each time a new row is read.
Note: This warning chain only covers warnings caused
by ResultSet
methods. Any warning caused by
Statement
methods
(such as reading OUT parameters) will be chained on the
Statement
object.
getWarnings
in interface java.sql.ResultSet
SQLWarning
object reported or null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic void clearWarnings() throws java.sql.SQLException
ResultSet
object.
After this method is called, the method getWarnings
returns null
until a new warning is
reported for this rowset's ResultSet
object.
clearWarnings
in interface java.sql.ResultSet
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.lang.String getCursorName() throws java.sql.SQLException
ResultSet
object.
In SQL, a result table is retrieved through a cursor that is
named. The current row of a result set 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 update, the cursor's select
statement should be
of the form 'select for update'. If the 'for update' clause is
omitted, the positioned updates may fail.
The JDBC API supports this SQL feature by providing the name of the
SQL cursor used by a ResultSet
object.
The current row of a ResultSet
object
is also the current row of this SQL cursor.
Note: If positioned update is not supported, a
SQLException
is thrown.
getCursorName
in interface java.sql.ResultSet
ResultSet
object's cursor
java.sql.SQLException
- if (1) a database access error occurs
or (2) xthis rowset does not have a currently valid connection,
prepared statement, and result setpublic java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
ResultSet
object's columns.
getMetaData
in interface java.sql.ResultSet
ResultSet
object's columns
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.lang.Object getObject(int columnIndex) throws java.sql.SQLException
Gets the value of the designated column in the current row
of this rowset's ResultSet
object as
an Object
.
This method will return the value of the given column as a Java object. The type of the Java 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.
In the JDBC 3.0 API, the behavior of method
getObject
is extended to materialize
data of SQL user-defined types. When a column contains
a structured or distinct value, the behavior of this method is as
if it were a call to: getObject(columnIndex,
this.getStatement().getConnection().getTypeMap())
.
getObject
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
java.lang.Object
holding the column value
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.lang.Object getObject(java.lang.String columnName) throws java.sql.SQLException
Gets the value of the designated column in the current row
of this rowset's ResultSet
object as
an Object
.
This method will return the value of the given column as a Java object. The type of the Java 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.
In the JDBC 3.0 API, the behavior of the method
getObject
is extended to materialize
data of SQL user-defined types. When a column contains
a structured or distinct value, the behavior of this method is as
if it were a call to: getObject(columnIndex,
this.getStatement().getConnection().getTypeMap())
.
getObject
in interface java.sql.ResultSet
columnName
- the SQL name of the column
java.lang.Object
holding the column value
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic int findColumn(java.lang.String columnName) throws java.sql.SQLException
JdbcRowSetImpl
column name to its
JdbcRowSetImpl
column index and reflects this on
the internal ResultSet
object.
findColumn
in interface java.sql.ResultSet
columnName
- the name of the column
java.sql.SQLException
- if (1) a database access error occurs
(2) this rowset does not have a currently valid connection,
prepared statement, and result setpublic java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException
ResultSet
object as a
java.io.Reader
object.
getCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
java.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned is
null
.
java.sql.SQLException
public java.io.Reader getCharacterStream(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as a
java.io.Reader
object.
getCharacterStream
in interface java.sql.ResultSet
columnName
- the name of the column
java.io.Reader
object that contains the column
value; if the value is SQL NULL
, the value returned is
null
.
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
ResultSet
object as a
java.math.BigDecimal
with full precision.
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
NULL
, the value returned is
null
.
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid
connection, prepared statement, and result setpublic java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws java.sql.SQLException
ResultSet
object as a
java.math.BigDecimal
with full precision.
getBigDecimal
in interface java.sql.ResultSet
columnName
- the column name
NULL
, the value returned is
null
.
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid
connection, prepared statement, and result setpublic boolean isBeforeFirst() throws java.sql.SQLException
ResultSet
object.
isBeforeFirst
in interface java.sql.ResultSet
true
if the cursor is before the first row;
false
if the cursor is at any other position or the
result set contains no rows
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid
connection, prepared statement, and result setpublic boolean isAfterLast() throws java.sql.SQLException
ResultSet
object.
isAfterLast
in interface java.sql.ResultSet
true
if the cursor is after the last row;
false
if the cursor is at any other position or the
result set contains no rows
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid
connection, prepared statement, and result setpublic boolean isFirst() throws java.sql.SQLException
ResultSet
object.
isFirst
in interface java.sql.ResultSet
true
if the cursor is on the first row;
false
otherwise
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid
connection, prepared statement, and result setpublic boolean isLast() throws java.sql.SQLException
ResultSet
object.
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 the result set.
isLast
in interface java.sql.ResultSet
true
if the cursor is on the last row;
false
otherwise
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid
connection, prepared statement, and result setpublic void beforeFirst() throws java.sql.SQLException
ResultSet
object, just before the
first row. This method has no effect if the result set contains no rows.
beforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- if (1) a database access error occurs,
(2) the result set type is TYPE_FORWARD_ONLY
,
or (3) this rowset does not currently have a valid
connection, prepared statement, and result setpublic void afterLast() throws java.sql.SQLException
ResultSet
object, just after the
last row. This method has no effect if the result set contains no rows.
afterLast
in interface java.sql.ResultSet
java.sql.SQLException
- if (1) a database access error occurs,
(2) the result set type is TYPE_FORWARD_ONLY
,
or (3) this rowset does not currently have a valid
connection, prepared statement, and result setpublic boolean first() throws java.sql.SQLException
ResultSet
object.
first
in interface java.sql.ResultSet
true
if the cursor is on a valid row;
false
if there are no rows in the result set
java.sql.SQLException
- if (1) a database access error occurs,
(2) the result set type is TYPE_FORWARD_ONLY
,
or (3) this rowset does not currently have a valid
connection, prepared statement, and result setpublic boolean last() throws java.sql.SQLException
ResultSet
object.
last
in interface java.sql.ResultSet
true
if the cursor is on a valid row;
false
if there are no rows in the result set
java.sql.SQLException
- if (1) a database access error occurs,
(2) the result set type is TYPE_FORWARD_ONLY
,
or (3) this rowset does not currently have a valid
connection, prepared statement, and result setpublic int getRow() throws java.sql.SQLException
getRow
in interface java.sql.ResultSet
0
if there is no current row
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic boolean absolute(int row) throws java.sql.SQLException
ResultSet
object.
If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.
If the given row number is negative, the cursor moves to
an absolute row position with respect to
the end of the result set. For example, calling the method
absolute(-1)
positions the
cursor on the last row, calling the method absolute(-2)
moves the cursor to the next-to-last row, and so on.
An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before the first row or after the last row.
Note: Calling absolute(1)
is the same
as calling first()
. Calling absolute(-1)
is the same as calling last()
.
absolute
in interface java.sql.ResultSet
true
if the cursor is on the result set;
false
otherwise
java.sql.SQLException
- if (1) a database access error occurs,
(2) the row is 0
, (3) the result set
type is TYPE_FORWARD_ONLY
, or (4) this
rowset does not currently have a valid connection,
prepared statement, and result setpublic boolean relative(int rows) throws java.sql.SQLException
relative(0)
is valid, but does
not change the cursor position.
Note: Calling the method relative(1)
is different from calling the method next()
because is makes sense to call next()
when there
is no current row,
for example, when the cursor is positioned before the first row
or after the last row of the result set.
relative
in interface java.sql.ResultSet
true
if the cursor is on a row;
false
otherwise
java.sql.SQLException
- if (1) a database access error occurs,
(2) there is no current row, (3) the result set
type is TYPE_FORWARD_ONLY
, or (4) this
rowset does not currently have a valid connection,
prepared statement, and result setpublic boolean previous() throws java.sql.SQLException
ResultSet
object.
Note: Calling the method previous()
is not the same as
calling the method relative(-1)
because it
makes sense to callprevious() when there is no current row.
previous
in interface java.sql.ResultSet
true
if the cursor is on a valid row;
false
if it is off the result set
java.sql.SQLException
- if (1) a database access error occurs,
(2) the result set type is TYPE_FORWARD_ONLY
,
or (3) this rowset does not currently have a valid
connection, prepared statement, and result setpublic void setFetchDirection(int direction) throws java.sql.SQLException
ResultSet
object will be processed.
The initial value is determined by the
Statement
object
that produced this rowset's ResultSet
object.
The fetch direction may be changed at any time.
setFetchDirection
in interface java.sql.ResultSet
setFetchDirection
in class BaseRowSet
direction
- one of ResultSet.FETCH_FORWARD
,
ResultSet.FETCH_REVERSE
, or
ResultSet.FETCH_UNKNOWN
java.sql.SQLException
- if (1) a database access error occurs,
(2) the result set type is TYPE_FORWARD_ONLY
and the fetch direction is not FETCH_FORWARD
,
or (3) this rowset does not currently have a valid
connection, prepared statement, and result setStatement.setFetchDirection(int)
public int getFetchDirection() throws java.sql.SQLException
ResultSet
object.
getFetchDirection
in interface java.sql.ResultSet
getFetchDirection
in class BaseRowSet
ResultSet
object
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setBaseRowSet.setFetchDirection(int)
public void setFetchSize(int rows) throws java.sql.SQLException
ResultSet
object.
If the fetch size specified is zero, the JDBC driver
ignores the value and is free to make its own best guess as to what
the fetch size should be. The default value is set by the
Statement
object
that created the result set. The fetch size may be changed at any time.
setFetchSize
in interface java.sql.ResultSet
setFetchSize
in class BaseRowSet
rows
- the number of rows to fetch
java.sql.SQLException
- if (1) a database access error occurs, (2) the
condition 0 <= rows <= this.getMaxRows()
is not
satisfied, or (3) this rowset does not currently have a valid
connection, prepared statement, and result setBaseRowSet.getFetchSize()
public int getType() throws java.sql.SQLException
ResultSet
object.
getType
in interface java.sql.ResultSet
getType
in class BaseRowSet
ResultSet
object
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setBaseRowSet.setType(int)
public int getConcurrency() throws java.sql.SQLException
ResultSet
object.
The concurrency used is determined by the
Statement
object that created the result set.
getConcurrency
in interface java.sql.ResultSet
getConcurrency
in class BaseRowSet
CONCUR_READ_ONLY
or CONCUR_UPDATABLE
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setBaseRowSet.setConcurrency(int)
,
BaseRowSet.isReadOnly()
public boolean rowUpdated() throws java.sql.SQLException
rowUpdated
in interface java.sql.ResultSet
true
if the row has been visibly updated
by the owner or another, and updates are detected
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setDatabaseMetaData.updatesAreDetected(int)
public boolean rowInserted() throws java.sql.SQLException
ResultSet
object can detect visible inserts.
rowInserted
in interface java.sql.ResultSet
true
if a row has had an insertion
and insertions are detected; false
otherwise
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setDatabaseMetaData.insertsAreDetected(int)
public boolean rowDeleted() throws java.sql.SQLException
ResultSet
object can detect deletions.
rowDeleted
in interface java.sql.ResultSet
true
if a row was deleted and deletions are detected;
false
otherwise
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setDatabaseMetaData.deletesAreDetected(int)
public void updateNull(int columnIndex) throws java.sql.SQLException
updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateNull
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so on
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException
boolean
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBoolean
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateByte(int columnIndex, byte x) throws java.sql.SQLException
byte
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateByte
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateShort(int columnIndex, short x) throws java.sql.SQLException
short
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateShort
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateInt(int columnIndex, int x) throws java.sql.SQLException
int
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateInt
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateLong(int columnIndex, long x) throws java.sql.SQLException
long
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateLong
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateFloat(int columnIndex, float x) throws java.sql.SQLException
float
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateFloat
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateDouble(int columnIndex, double x) throws java.sql.SQLException
double
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateDouble
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException
java.math.BigDecimal
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBigDecimal
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException
String
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateString
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException
byte
array value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBytes
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException
java.sql.Date
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateDate
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException
java.sql.Time
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateTime
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException
java.sql.Timestamp
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateTimestamp
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if (1) a database access error occurs
(2) or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException
updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLException
Object
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateObject
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column valuescale
- for java.sql.Types.DECIMAl
or java.sql.Types.NUMERIC
types,
this is the number of digits after the decimal point. For all other
types this value will be ignored.
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException
Object
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateObject
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so onx
- the new column value
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateNull(java.lang.String columnName) throws java.sql.SQLException
null
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateNull
in interface java.sql.ResultSet
columnName
- the name of the column
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateBoolean(java.lang.String columnName, boolean x) throws java.sql.SQLException
boolean
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBoolean
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateByte(java.lang.String columnName, byte x) throws java.sql.SQLException
byte
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateByte
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateShort(java.lang.String columnName, short x) throws java.sql.SQLException
short
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateShort
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateInt(java.lang.String columnName, int x) throws java.sql.SQLException
int
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateInt
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateLong(java.lang.String columnName, long x) throws java.sql.SQLException
long
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateLong
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateFloat(java.lang.String columnName, float x) throws java.sql.SQLException
float
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateFloat
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateDouble(java.lang.String columnName, double x) throws java.sql.SQLException
double
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateDouble
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws java.sql.SQLException
java.sql.BigDecimal
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBigDecimal
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateString(java.lang.String columnName, java.lang.String x) throws java.sql.SQLException
String
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateString
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateBytes(java.lang.String columnName, byte[] x) throws java.sql.SQLException
boolean
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
JDBC 2.0
Updates a column with a byte array value.
The updateXXX
methods are used to update column values in the
current row, or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or insertRow
methods are called to update the database.
updateBytes
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateDate(java.lang.String columnName, java.sql.Date x) throws java.sql.SQLException
java.sql.Date
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateDate
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateTime(java.lang.String columnName, java.sql.Time x) throws java.sql.SQLException
java.sql.Time
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateTime
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x) throws java.sql.SQLException
java.sql.Timestamp
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateTimestamp
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateAsciiStream
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if a database access error occurspublic void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateBinaryStream
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if a database access error occurspublic void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length) throws java.sql.SQLException
updateXXX
methods are used to update column values
in the current row or the insert row. The updateXXX
methods do not update the underlying database; instead the
updateRow
or insertRow
methods are called
to update the database.
updateCharacterStream
in interface java.sql.ResultSet
columnName
- the name of the columnreader
- the new column Reader
stream valuelength
- the length of the stream
java.sql.SQLException
- if a database access error occurspublic void updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws java.sql.SQLException
Object
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateObject
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column valuescale
- for java.sql.Types.DECIMAL
or java.sql.Types.NUMERIC
types,
this is the number of digits after the decimal point. For all other
types this value will be ignored.
java.sql.SQLException
- if a database access error occurspublic void updateObject(java.lang.String columnName, java.lang.Object x) throws java.sql.SQLException
Object
value.
The updateXXX
methods are used to update column values in the
current row or the insert row. The updateXXX
methods do not
update the underlying database; instead the updateRow
or
insertRow
methods are called to update the database.
updateObject
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column value
java.sql.SQLException
- if a database access error occurspublic void insertRow() throws java.sql.SQLException
ResultSet
object and into the database
and also notifies listeners that a row has changed.
The cursor must be on the insert row when this method is called.
insertRow
in interface java.sql.ResultSet
java.sql.SQLException
- if (1) a database access error occurs,
(2) this method is called when the cursor is not
on the insert row, (3) not all non-nullable columns in
the insert row have been given a value, or (4) this
rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateRow() throws java.sql.SQLException
ResultSet
object
and notifies listeners that a row has changed.
This method cannot be called when the cursor is on the insert row.
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
- if (1) a database access error occurs,
(2) this method is called when the cursor is
on the insert row, (3) the concurrency of the result
set is ResultSet.CONCUR_READ_ONLY
, or
(4) this rowset does not currently have a valid connection,
prepared statement, and result setpublic void deleteRow() throws java.sql.SQLException
ResultSet
object
and from the underlying database and also notifies listeners that a row
has changed. This method cannot be called when the cursor is on the insert
row.
deleteRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error occurs
or if this method is called when the cursor is on the insert row
java.sql.SQLException
- if (1) a database access error occurs,
(2) this method is called when the cursor is before the
first row, after the last row, or on the insert row,
(3) the concurrency of this rowset's result
set is ResultSet.CONCUR_READ_ONLY
, or
(4) this rowset does not currently have a valid connection,
prepared statement, and result setpublic void refreshRow() throws java.sql.SQLException
ResultSet
object with its most recent value in the database. This method
cannot be called when the cursor is on the insert row.
The refreshRow
method provides a way for an
application to explicitly tell the JDBC driver to refetch
a row(s) from the database. An application may want to call
refreshRow
when caching or prefetching is being
done by the JDBC driver to fetch the latest value of a row
from the database. The JDBC driver may actually refresh multiple
rows at once if the fetch size is greater than one.
All values are refetched subject to the transaction isolation
level and cursor sensitivity. If refreshRow
is called after
calling an updateXXX
method, but before calling
the method updateRow
, then the
updates made to the row are lost. Calling the method
refreshRow
frequently will likely slow performance.
refreshRow
in interface java.sql.ResultSet
java.sql.SQLException
- if (1) a database access error occurs,
(2) this method is called when the cursor is
on the insert row, or (3) this rowset does not
currently have a valid connection, prepared statement,
and result setpublic void cancelRowUpdates() throws java.sql.SQLException
ResultSet
object and notifies listeners that a row
has changed. This method may be called after calling an
updateXXX
method(s) and before calling
the method updateRow
to roll back
the updates made to a row. If no updates have been made or
updateRow
has already been called, this method has no
effect.
cancelRowUpdates
in interface java.sql.ResultSet
java.sql.SQLException
- if (1) a database access error occurs,
(2) this method is called when the cursor is
on the insert row, or (3) this rowset does not
currently have a valid connection, prepared statement,
and result setpublic void moveToInsertRow() throws java.sql.SQLException
updateXXX
methods prior to
inserting the row into the result set.
Only the updateXXX
, getXXX
,
and insertRow
methods may be
called when the cursor is on the insert row. All of the columns in
a result set must be given a value each time this method is
called before calling insertRow
.
An updateXXX
method must be called before a
getXXX
method can be called on a column value.
moveToInsertRow
in interface java.sql.ResultSet
java.sql.SQLException
- if (1) a database access error occurs,
(2) this rowset's ResultSet
object is
not updatable, or (3) this rowset does not
currently have a valid connection, prepared statement,
and result setpublic void moveToCurrentRow() throws java.sql.SQLException
moveToCurrentRow
in interface java.sql.ResultSet
java.sql.SQLException
- if (1) a database access error occurs,
(2) this rowset's ResultSet
object is
not updatable, or (3) this rowset does not
currently have a valid connection, prepared statement,
and result setpublic java.sql.Statement getStatement() throws java.sql.SQLException
Statement
object that produced this
ResultSet
object.
If the result set was generated some other way, such as by a
DatabaseMetaData
method, this method returns
null
.
getStatement
in interface java.sql.ResultSet
Statment
object that produced
this rowset's ResultSet
object or null
if the result set was produced some other way
java.sql.SQLException
- if a database access error occurspublic java.lang.Object getObject(int i, java.util.Map map) throws java.sql.SQLException
ResultSet
object as an Object
.
This method uses the given Map
object
for the custom mapping of the
SQL structured or distinct type that is being retrieved.
getObject
in interface java.sql.ResultSet
i
- the first column is 1, the second is 2, and so onmap
- a java.util.Map
object that contains the mapping
from SQL type names to classes in the Java programming language
Object
in the Java programming language
representing the SQL value
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Ref getRef(int i) throws java.sql.SQLException
ResultSet
object as a Ref
object.
getRef
in interface java.sql.ResultSet
i
- the first column is 1, the second is 2, and so on
Ref
object representing an SQL REF
value
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Blob getBlob(int i) throws java.sql.SQLException
ResultSet
object as a Blob
object.
getBlob
in interface java.sql.ResultSet
i
- the first column is 1, the second is 2, and so on
Blob
object representing the SQL BLOB
value in the specified column
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Clob getClob(int i) throws java.sql.SQLException
ResultSet
object as a Clob
object.
getClob
in interface java.sql.ResultSet
i
- the first column is 1, the second is 2, and so on
Clob
object representing the SQL CLOB
value in the specified column
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Array getArray(int i) throws java.sql.SQLException
ResultSet
object as an Array
object.
getArray
in interface java.sql.ResultSet
i
- the first column is 1, the second is 2, and so on.
Array
object representing the SQL ARRAY
value in the specified column
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.lang.Object getObject(java.lang.String colName, java.util.Map map) throws java.sql.SQLException
ResultSet
object as an Object
.
This method uses the specified Map
object for
custom mapping if appropriate.
getObject
in interface java.sql.ResultSet
colName
- the name of the column from which to retrieve the valuemap
- a java.util.Map
object that contains the mapping
from SQL type names to classes in the Java programming language
Object
representing the SQL
value in the specified column
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Ref getRef(java.lang.String colName) throws java.sql.SQLException
ResultSet
object as a Ref
object.
getRef
in interface java.sql.ResultSet
colName
- the column name
Ref
object representing the SQL REF
value in
the specified column
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Blob getBlob(java.lang.String colName) throws java.sql.SQLException
ResultSet
object as a Blob
object.
getBlob
in interface java.sql.ResultSet
colName
- the name of the column from which to retrieve the value
Blob
object representing the SQL BLOB
value in the specified column
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Clob getClob(java.lang.String colName) throws java.sql.SQLException
ResultSet
object as a Clob
object.
getClob
in interface java.sql.ResultSet
colName
- the name of the column from which to retrieve the value
Clob
object representing the SQL CLOB
value in the specified column
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Array getArray(java.lang.String colName) throws java.sql.SQLException
ResultSet
object as an Array
object.
getArray
in interface java.sql.ResultSet
colName
- the name of the column from which to retrieve the value
Array
object representing the SQL ARRAY
value in the specified column
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Date getDate(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
ResultSet
object as a java.sql.Date
object. This method uses the given calendar to construct an appropriate
millisecond value for the date if the underlying database does not store
timezone information.
getDate
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so oncal
- the java.util.Calendar
object
to use in constructing the date
java.sql.Date
object;
if the value is SQL NULL
,
the value returned is null
java.sql.SQLException
- if (1) a database access error occurs
or (2) this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Date getDate(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
ResultSet
object as a java.sql.Date
object. This method uses the given calendar to construct an appropriate
millisecond value for the date if the underlying database does not store
timezone information.
getDate
in interface java.sql.ResultSet
columnName
- the SQL name of the column from which to retrieve the valuecal
- the java.util.Calendar
object
to use in constructing the date
java.sql.Date
object;
if the value is SQL NULL
,
the value returned is null
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Time getTime(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
ResultSet
object as a java.sql.Time
object. This method uses the given calendar to construct an appropriate
millisecond value for the date if the underlying database does not store
timezone information.
getTime
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so oncal
- the java.util.Calendar
object
to use in constructing the time
java.sql.Time
object;
if the value is SQL NULL
,
the value returned is null
in the Java programming language
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Time getTime(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
ResultSet
object as a java.sql.Time
object. This method uses the given calendar to construct an appropriate
millisecond value for the date if the underlying database does not store
timezone information.
getTime
in interface java.sql.ResultSet
columnName
- the SQL name of the columncal
- the java.util.Calendar
object
to use in constructing the time
java.sql.Time
object;
if the value is SQL NULL
,
the value returned is null
in the Java programming language
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Timestamp getTimestamp(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
ResultSet
object as a
java.sql.Timestamp
object.
This method uses the given calendar to construct an appropriate millisecond
value for the timestamp if the underlying database does not store
timezone information.
getTimestamp
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, and so oncal
- the java.util.Calendar
object
to use in constructing the timestamp
java.sql.Timestamp
object;
if the value is SQL NULL
,
the value returned is null
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
ResultSet
object as a
java.sql.Timestamp
object.
This method uses the given calendar to construct an appropriate millisecond
value for the timestamp if the underlying database does not store
timezone information.
getTimestamp
in interface java.sql.ResultSet
columnName
- the SQL name of the columncal
- the java.util.Calendar
object
to use in constructing the timestamp
java.sql.Timestamp
object;
if the value is SQL NULL
,
the value returned is null
java.sql.SQLException
- if a database access error occurs
or this rowset does not currently have a valid connection,
prepared statement, and result setpublic void updateRef(int columnIndex, java.sql.Ref ref) throws java.sql.SQLException
JdbcRowSetImpl
object with the given
double
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 updateRow()
must be called to update the database.
If the cursor is on the insert row, the method 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.
updateRef
in interface java.sql.ResultSet
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetref
- the new Ref
column value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateRef(java.lang.String columnName, java.sql.Ref ref) throws java.sql.SQLException
JdbcRowSetImpl
object with the given
double
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 updateRow()
must be called to update the database.
If the cursor is on the insert row, the method 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.
updateRef
in interface java.sql.ResultSet
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring caseref
- the new column value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateClob(int columnIndex, java.sql.Clob c) throws java.sql.SQLException
JdbcRowSetImpl
object with the given
double
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 updateRow()
must be called to update the database.
If the cursor is on the insert row, the method 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.
updateClob
in interface java.sql.ResultSet
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetc
- the new column Clob
value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateClob(java.lang.String columnName, java.sql.Clob c) throws java.sql.SQLException
JdbcRowSetImpl
object with the given
double
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 updateRow()
must be called to update the database.
If the cursor is on the insert row, the method 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.
updateClob
in interface java.sql.ResultSet
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casec
- the new column Clob
value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateBlob(int columnIndex, java.sql.Blob b) throws java.sql.SQLException
JdbcRowSetImpl
object with the given
java.sql.Blob
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 updateRow()
must be called to update the database.
If the cursor is on the insert row, the method 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.
updateBlob
in interface java.sql.ResultSet
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowsetb
- the new column Blob
value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateBlob(java.lang.String columnName, java.sql.Blob b) throws java.sql.SQLException
JdbcRowSetImpl
object with the given
java.sql.Blob
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 updateRow()
must be called to update the database.
If the cursor is on the insert row, the method 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.
updateBlob
in interface java.sql.ResultSet
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring caseb
- the new column Blob
value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public void updateArray(int columnIndex, java.sql.Array a) throws java.sql.SQLException
JdbcRowSetImpl
object with the given
java.sql.Array
values.
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 updateRow()
must be called to update the database.
If the cursor is on the insert row, the method 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.
updateArray
in interface java.sql.ResultSet
columnIndex
- the first column is 1
, the second
is 2
, and so on; must be 1
or larger
and equal to or less than the number of columns in this rowseta
- the new column Array
value
java.sql.SQLException
- if (1) the given column index is out of bounds,
(2) the cursor is not on one of this rowset's rows or its
insert row, or (3) this rowset is
ResultSet.CONCUR_READ_ONLY
public void updateArray(java.lang.String columnName, java.sql.Array a) throws java.sql.SQLException
JdbcRowSetImpl
object with the given
java.sql.Array
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 updateRow()
must be called to update the database.
If the cursor is on the insert row, the method 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.
updateArray
in interface java.sql.ResultSet
columnName
- a String
object that must match the
SQL name of a column in this rowset, ignoring casea
- the new column Array
value
java.sql.SQLException
- if (1) the given column name does not match the
name of a column in this rowset, (2) the cursor is not on
one of this rowset's rows or its insert row, or (3) this
rowset is ResultSet.CONCUR_READ_ONLY
public java.net.URL getURL(int columnIndex) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
public java.net.URL getURL(java.lang.String columnName) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
public RowSetWarning getRowSetWarnings() throws java.sql.SQLException
JdbcRowSetImpl
getRowSetWarnings
in interface JdbcRowSet
RowSetWarning
object reported on this JdbcRowSet
object
or null
if there are none
java.sql.SQLException
- if this method is called on a closed
JdbcRowSet
objectRowSetWarning
public void unsetMatchColumn(int[] columnIdxes) throws java.sql.SQLException
setMatchColumn
as the column which will form the basis of the join.
The parameter value unset by this method should be same as was set.
unsetMatchColumn
in interface Joinable
columnIdxes
- the index into this rowset
object's internal representation of parameter values
java.sql.SQLException
- if an error occurs or the
parameter index is out of bounds or if the columnIdx is
not the same as set using setMatchColumn(int [])
Joinable.setMatchColumn(int)
public void unsetMatchColumn(java.lang.String[] columnIdxes) throws java.sql.SQLException
setMatchColumn
as the column which will form the basis of the join.
The parameter value unset by this method should be same as was set.
unsetMatchColumn
in interface Joinable
columnIdxes
- the index into this rowset
object's internal representation of parameter values
java.sql.SQLException
- if an error occurs or the
parameter index is out of bounds or if the columnName is
not the same as set using setMatchColumn(String [])
Joinable.setMatchColumn(int)
public java.lang.String[] getMatchColumnNames() throws java.sql.SQLException
String
array
that was set using setMatchColumn(String [])
for this rowset.
getMatchColumnNames
in interface Joinable
String
array object that contains the column names
for the rowset which has this the match columns
java.sql.SQLException
- if an error occurs or column name is not setJoinable.setMatchColumn(int)
,
Joinable.unsetMatchColumn(int)
public int[] getMatchColumnIndexes() throws java.sql.SQLException
int
array that was set using
setMatchColumn(int [])
for this rowset.
getMatchColumnIndexes
in interface Joinable
int
array object that contains the column ids
for the rowset which has this as the match columns.
java.sql.SQLException
- if an error occurs or column index is not setJoinable.setMatchColumn(int)
,
Joinable.unsetMatchColumn(int)
public void setMatchColumn(int[] columnIdxes) throws java.sql.SQLException
JoinRowSet
as the column which will form the basis of the
join.
The parameter value set by this method is stored internally and
will be supplied as the appropriate parameter in this rowset's
command when the method getMatchColumnIndexes
is called.
setMatchColumn
in interface Joinable
columnIdxes
- the indexes into this rowset
object's internal representation of parameter values; the
first parameter is 0, the second is 1, and so on; must be
0
or greater
java.sql.SQLException
- if an error occurs or the
parameter index is out of boundsJoinable.setMatchColumn(int[])
,
Joinable.unsetMatchColumn(int[])
public void setMatchColumn(java.lang.String[] columnNames) throws java.sql.SQLException
JoinRowSet
as the column which will form the basis of the
join.
The parameter value set by this method is stored internally and
will be supplied as the appropriate parameter in this rowset's
command when the method getMatchColumn
is called.
setMatchColumn
in interface Joinable
columnNames
- the name of the column into this rowset
object's internal representation of parameter values
java.sql.SQLException
- if an error occurs or the
parameter index is out of boundsJoinable.unsetMatchColumn(int)
,
Joinable.setMatchColumn(int[])
public void setMatchColumn(int columnIdx) throws java.sql.SQLException
int
object. This forms the basis of the join for the
JoinRowSet
as the column which will form the basis of the
join.
The parameter value set by this method is stored internally and
will be supplied as the appropriate parameter in this rowset's
command when the method getMatchColumn
is called.
setMatchColumn
in interface Joinable
columnIdx
- the index into this rowset
object's internal representation of parameter values; the
first parameter is 0, the second is 1, and so on; must be
0
or greater
java.sql.SQLException
- if an error occurs or the
parameter index is out of boundsJoinable.setMatchColumn(int[])
,
Joinable.unsetMatchColumn(int)
public void setMatchColumn(java.lang.String columnName) throws java.sql.SQLException
String
object. This forms the basis of the join for the
JoinRowSet
as the column which will form the basis of the
join.
The parameter value set by this method is stored internally and
will be supplied as the appropriate parameter in this rowset's
command when the method getMatchColumn
is called.
setMatchColumn
in interface Joinable
columnName
- the name of the column into this rowset
object's internal representation of parameter values
java.sql.SQLException
- if an error occurs or the
parameter index is out of boundsJoinable.unsetMatchColumn(int)
,
Joinable.setMatchColumn(int[])
public void unsetMatchColumn(int columnIdx) throws java.sql.SQLException
int
object. This was set using setMatchColumn
as the column which will form the basis of the join.
The parameter value unset by this method should be same as was set.
unsetMatchColumn
in interface Joinable
columnIdx
- the index into this rowset
object's internal representation of parameter values
java.sql.SQLException
- if an error occurs or the
parameter index is out of bounds or if the columnIdx is
not the same as set using setMatchColumn(int)
Joinable.setMatchColumn(int)
public void unsetMatchColumn(java.lang.String columnName) throws java.sql.SQLException
String
object. This was set using setMatchColumn
as the column which will form the basis of the join.
The parameter value unset by this method should be same as was set.
unsetMatchColumn
in interface Joinable
columnName
- the index into this rowset
object's internal representation of parameter values
java.sql.SQLException
- if an error occurs or the
parameter index is out of bounds or if the columnName is
not the same as set using setMatchColumn(String)
Joinable.setMatchColumn(int)
public java.sql.DatabaseMetaData getDatabaseMetaData() throws java.sql.SQLException
DatabaseMetaData
associated with
the connection handle associated this this
JdbcRowSet object.
DatabaseMetadata
associated
with the rowset's connection.
java.sql.SQLException
- if a database access error occurspublic java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
ParameterMetaData
associated with
the connection handle associated this this
JdbcRowSet object.
ParameterMetadata
associated
with the rowset's connection.
java.sql.SQLException
- if a database access error occurspublic void commit() throws java.sql.SQLException
JdbcRowSet
object by
wrapping the internal Connection
object and calling
its commit
method.
This method sets this JdbcRowSet
object's private field
rs
to null
after saving its value to another
object, but only if the ResultSet
constant HOLD_CURSORS_OVER_COMMIT
has not been set.
(The field rs
is this JdbcRowSet
object's
ResultSet
object.)
commit
in interface JdbcRowSet
java.sql.SQLException
- if autoCommit is set to true or if a database
access error occursConnection.setAutoCommit(boolean)
public void setAutoCommit(boolean autoCommit) throws java.sql.SQLException
Connection
object with this
JdbcRowSet
setAutoCommit
in interface JdbcRowSet
java.sql.SQLException
- if a database access error occursConnection.setAutoCommit(boolean)
public boolean getAutoCommit() throws java.sql.SQLException
JdbcRowSet
.
getAutoCommit
in interface JdbcRowSet
java.sql.SQLException
- if a database access error occursConnection.getAutoCommit()
public void rollback() throws java.sql.SQLException
JdbcRowSet
object by
wrapping the internal Connection
object and calling its
rollback
method.
This method sets this JdbcRowSet
object's private field
rs
to null
after saving its value to another object.
(The field rs
is this JdbcRowSet
object's
internal ResultSet
object.)
rollback
in interface JdbcRowSet
java.sql.SQLException
- if autoCommit is set to true or a database
access error occursJdbcRowSet.rollback(Savepoint)
public void rollback(java.sql.Savepoint s) throws java.sql.SQLException
JdbcRowSet
back to the
last Savepoint
transaction marker. Wraps the internal
Connection
object and call it's rollback method
rollback
in interface JdbcRowSet
s
- the Savepoint
transaction marker to roll the
transaction to.
java.sql.SQLException
- if autoCommit is set to true; or ia a database
access error occursJdbcRowSet.rollback()
protected void setParams() throws java.sql.SQLException
java.sql.SQLException
protected java.sql.Connection getConnection()
JdbcRowSet
object's Connection property
Connection
object associated with this rowset;protected void setConnection(java.sql.Connection connection)
JdbcRowSet
object's connection property
to the given Connection
object.
connection
- the Connection
object.protected java.sql.PreparedStatement getPreparedStatement()
JdbcRowSet
object's PreparedStatement property
PreparedStatement
object associated with this rowset;protected void setPreparedStatement(java.sql.PreparedStatement preparedStatement)
JdbcRowSet
object's preparedtsatement property
to the given PreparedStatemennt
object.
preparedStatement
- the PreparedStatement
objectprotected java.sql.ResultSet getResultSet() throws java.sql.SQLException
JdbcRowSet
object's ResultSet property
ResultSet
object associated with this rowset;
java.sql.SQLException
protected void setResultSet(java.sql.ResultSet resultSet)
JdbcRowSet
object's resultset property
to the given ResultSet
object.
resultSet
- the ResultSet
objectpublic void setCommand(java.lang.String command) throws java.sql.SQLException
JdbcRowSet
object's command
property to
the given String
object and clears the parameters, if any,
that were set for the previous command. In addition,
if the command
property has previously been set to a
non-null value and it is
different from the String
object supplied,
this method sets this JdbcRowSet
object's private fields
ps
and rs
to null
.
(The field ps
is its PreparedStatement
object, and
the field rs
is its ResultSet
object.)
The command
property may not be needed if the RowSet
object gets its data from a source that does not support commands,
such as a spreadsheet or other tabular file.
Thus, this property is optional and may be null
.
setCommand
in interface javax.sql.RowSet
setCommand
in class BaseRowSet
command
- a String
object containing an SQL query
that will be set as this RowSet
object's command
property; may be null
but may not be an empty string
java.sql.SQLException
- if an empty string is provided as the command valueBaseRowSet.getCommand()
public void setDataSourceName(java.lang.String dsName) throws java.sql.SQLException
dataSourceName
property for this JdbcRowSet
object to the given logical name and sets this JdbcRowSet
object's
Url property to null
. In addition, if the dataSourceName
property has previously been set and is different from the one supplied,
this method sets this JdbcRowSet
object's private fields
ps
, rs
, and conn
to null
.
(The field ps
is its PreparedStatement
object,
the field rs
is its ResultSet
object, and
the field conn
is its Connection
object.)
The name supplied to this method must have been bound to a
DataSource
object in a JNDI naming service so that an
application can do a lookup using that name to retrieve the
DataSource
object bound to it. The DataSource
object can then be used to establish a connection to the data source it
represents.
Users should set either the Url property or the dataSourceName property. If both properties are set, the driver will use the property set most recently.
setDataSourceName
in interface javax.sql.RowSet
setDataSourceName
in class BaseRowSet
dsName
- a String
object with the name that can be supplied
to a naming service based on JNDI technology to retrieve the
DataSource
object that can be used to get a connection;
may be null
java.sql.SQLException
- if there is a problem setting the
dataSourceName
propertyBaseRowSet.getDataSourceName()
public void setUrl(java.lang.String url) throws java.sql.SQLException
JdbcRowSet
object
to the given String
object and sets the dataSource name
property to null
. In addition, if the Url property has
previously been set to a non null
value and its value
is different from the value to be set,
this method sets this JdbcRowSet
object's private fields
ps
, rs
, and conn
to null
.
(The field ps
is its PreparedStatement
object,
the field rs
is its ResultSet
object, and
the field conn
is its Connection
object.)
The Url property is a JDBC URL that is used when
the connection is created using a JDBC technology-enabled driver
("JDBC driver") and the DriverManager
.
The correct JDBC URL for the specific driver to be used can be found
in the driver documentation. Although there are guidelines for for how
a JDBC URL is formed,
a driver vendor can specify any String
object except
one with a length of 0
(an empty string).
Setting the Url property is optional if connections are established using
a DataSource
object instead of the DriverManager
.
The driver will use either the URL property or the
dataSourceName property to create a connection, whichever was
specified most recently. If an application uses a JDBC URL, it
must load a JDBC driver that accepts the JDBC URL before it uses the
RowSet
object to connect to a database. The RowSet
object will use the URL internally to create a database connection in order
to read or write data.
setUrl
in interface javax.sql.RowSet
setUrl
in class BaseRowSet
url
- a String
object that contains the JDBC URL
that will be used to establish the connection to a database for this
RowSet
object; may be null
but must not
be an empty string
java.sql.SQLException
- if an error occurs setting the Url property or the
parameter supplied is a string with a length of 0
(an
empty string)BaseRowSet.getUrl()
public void setUsername(java.lang.String uname)
JdbcRowSet
object
to the given user name. Because it
is not serialized, the username property is set at run time before
calling the method execute
. In addition,
if the username
property is already set with a
non-null value and that value is different from the String
object to be set,
this method sets this JdbcRowSet
object's private fields
ps
, rs
, and conn
to null
.
(The field ps
is its PreparedStatement
object,
rs
is its ResultSet
object, and
conn
is its Connection
object.)
Setting these fields to null
ensures that only current
values will be used.
setUsername
in interface javax.sql.RowSet
setUsername
in class BaseRowSet
uname
- the String
object containing the user name that
is supplied to the data source to create a connection. It may be null.BaseRowSet.getUsername()
public void setPassword(java.lang.String password)
JdbcRowSet
object
to the given String
object. Because it
is not serialized, the password property is set at run time before
calling the method execute
. Its default valus is
null
. In addition,
if the password
property is already set with a
non-null value and that value is different from the one being set,
this method sets this JdbcRowSet
object's private fields
ps
, rs
, and conn
to null
.
(The field ps
is its PreparedStatement
object,
rs
is its ResultSet
object, and
conn
is its Connection
object.)
Setting these fields to null
ensures that only current
values will be used.
setPassword
in interface javax.sql.RowSet
setPassword
in class BaseRowSet
password
- the String
object that represents the password
that must be supplied to the database to create a connectionBaseRowSet.getPassword()
public void setType(int type) throws java.sql.SQLException
RowSet
object to the specified type.
The default type is ResultSet.TYPE_SCROLL_INSENSITIVE
.
setType
in interface javax.sql.RowSet
setType
in class BaseRowSet
type
- one of the following constants:
ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or
ResultSet.TYPE_SCROLL_SENSITIVE
java.sql.SQLException
- if the parameter supplied is not one of the
following constants:
ResultSet.TYPE_FORWARD_ONLY
or
ResultSet.TYPE_SCROLL_INSENSITIVE
ResultSet.TYPE_SCROLL_SENSITIVE
getConcurrency()
,
getType()
public void setConcurrency(int concur) throws java.sql.SQLException
RowSet
object to
the specified concurrency. The default concurrency for any RowSet
object (connected or disconnected) is ResultSet.CONCUR_UPDATABLE
,
but this method may be called at any time to change the concurrency.
setConcurrency
in interface javax.sql.RowSet
setConcurrency
in class BaseRowSet
concur
- one of the following constants:
ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
java.sql.SQLException
- if the parameter supplied is not one of the
following constants:
ResultSet.CONCUR_UPDATABLE
or
ResultSet.CONCUR_READ_ONLY
getConcurrency()
,
BaseRowSet.isReadOnly()
public void setTransactionIsolation(int transIso) throws java.sql.SQLException
RowSet
object to the given
constant. The DBMS will use this transaction isolation level for
transactions if it can.
For RowSet
implementations such as
the CachedRowSet
that operate in a disconnected environment,
the SyncProvider
object being used
offers complementary locking and data integrity options. The
options described below are pertinent only to connected RowSet
objects (JdbcRowSet
objects).
setTransactionIsolation
in interface javax.sql.RowSet
setTransactionIsolation
in class BaseRowSet
transIso
- one of the following constants, listed in ascending order:
Connection.TRANSACTION_NONE
,
Connection.TRANSACTION_READ_UNCOMMITTED
,
Connection.TRANSACTION_READ_COMMITTED
,
Connection.TRANSACTION_REPEATABLE_READ
, or
Connection.TRANSACTION_SERIALIZABLE
java.sql.SQLException
- if the given parameter is not one of the Connection
constantsSyncFactory
,
SyncProvider
,
BaseRowSet.getTransactionIsolation()
public void setMaxRows(int mRows) throws java.sql.SQLException
RowSet
object may contain to
the given number. If this limit is exceeded, the excess rows are
silently dropped.
setMaxRows
in interface javax.sql.RowSet
setMaxRows
in class BaseRowSet
mRows
- an int
indicating the current maximum number
of rows; zero means that there is no limit
java.sql.SQLException
- if an error occurs internally setting the
maximum limit on the number of rows that a JDBC RowSet
object
can contain; or if max is less than 0
; or
if max is less than the fetchSize
of the
RowSet
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |