public class ResultSetImpl extends java.lang.Object implements ResultSetInternalMethods
A ResultSet maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The 'next' method moves the cursor to the next row.
The getXXX methods retrieve column values for the current row. You can retrieve values either using the index number of the column, or by using the name of the column. In general using the column index will be more efficient. Columns are numbered from 1.
For maximum portability, ResultSet columns within each row should be read in left-to-right order and each column should be read only once.
For the getXXX methods, the JDBC driver attempts to convert the underlying data to the specified Java type and returns a suitable Java value. See the JDBC specification for allowable mappings from SQL types to Java types with the ResultSet getXXX methods.
Column names used as input to getXXX methods are case insenstive. When performing a getXXX using a column name, if several columns have the same name, then the value of the first matching column will be returned. The column name option is designed to be used when column names are used in the SQL Query. For columns that are NOT explicitly named in the query, it is best to use column numbers. If column names were used there is no way for the programmer to guarentee that they actually refer to the intended columns.
A ResultSet is automatically closed by the Statement that generated it when that Statement is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results.
The number, types and properties of a ResultSet's columns are provided by the ResultSetMetaData object returned by the getMetaData method.
| Modifier and Type | Field and Description |
|---|---|
protected java.lang.String |
catalog
The catalog that was in use when we were created
|
protected java.util.Map<java.lang.String,java.lang.Integer> |
columnLabelToIndex
Map column names (and all of their permutations) to column indices
|
protected java.util.Map<java.lang.String,java.lang.Integer> |
columnNameToIndex |
protected java.util.Map<java.lang.String,java.lang.Integer> |
columnToIndexCache
The above map is a case-insensitive tree-map, it can be slow, this caches lookups into that map, because the other alternative is to create new
object instances for every call to findColumn()....
|
protected boolean[] |
columnUsed
Keep track of columns accessed
|
protected MySQLConnection |
connection
The Connection instance that created us
|
protected long |
connectionId |
protected int |
currentRow
The current row #, -1 == before start of result set
|
protected boolean |
doingUpdates
Are we in the middle of doing updates to the current row?
|
(package private) static char[] |
EMPTY_SPACE |
protected com.mysql.jdbc.profiler.ProfilerEventHandler |
eventSink |
(package private) java.util.Calendar |
fastClientCal |
(package private) java.util.Calendar |
fastDefaultCal |
protected int |
fetchDirection
The direction to fetch rows (always FETCH_FORWARD)
|
protected int |
fetchSize
The number of rows to fetch in one go...
|
protected Field[] |
fields
The fields for this result set
|
protected char |
firstCharOfQuery
First character of the query that created this result set...Used to determine whether or not to parse server info messages in certain
circumstances.
|
protected java.util.Map<java.lang.String,java.lang.Integer> |
fullColumnNameToIndex
Map of fully-specified column names to column indices
|
protected java.util.Calendar |
gmtCalendar |
protected boolean |
hasBuiltIndexMapping |
protected boolean |
isBinaryEncoded
Is the data stored as strings (default) or natively (which is the case with results from PrepStmts)
|
protected boolean |
isClosed
Has this result set been closed?
|
protected static double |
MAX_DIFF_PREC
Epsillon between Float.MAX_VALUE and the double representation of said value.
|
protected static double |
MIN_DIFF_PREC
Epsillon between Float.MIN_VALUE and the double representation of said value.
|
protected ResultSetInternalMethods |
nextResultSet |
protected boolean |
onInsertRow
Are we on the insert row?
|
protected StatementImpl |
owningStatement
The statement that created us
|
protected java.lang.String |
pointOfOrigin
StackTrace generated where ResultSet was created... used when profiling
|
protected boolean |
profileSql
Are we tracking items for profileSql?
|
protected boolean |
reallyResult
Do we actually contain rows, or just information about UPDATE/INSERT/DELETE?
|
(package private) static int |
resultCounter
Counter used to generate IDs for profiling.
|
protected int |
resultId
The id (used when profiling) to identify us
|
protected int |
resultSetConcurrency
Are we read-only or updatable?
|
protected int |
resultSetType
Are we scroll-sensitive/insensitive?
|
protected boolean |
retainOwningStatement |
protected RowData |
rowData
The actual rows
|
protected java.lang.String |
serverInfo
Any info message from the server that was created while generating this result set (if 'info parsing' is enabled for the connection).
|
(package private) PreparedStatement |
statementUsedForFetchingRows |
protected ResultSetRow |
thisRow
Pointer to current row data
|
protected long |
updateCount
How many rows were affected by UPDATE/INSERT/DELETE?
|
protected long |
updateId
Value generated for AUTO_INCREMENT columns
|
protected boolean |
useFastDateParsing |
protected boolean |
useLegacyDatetimeCode |
protected boolean |
useUsageAdvisor |
protected java.sql.SQLWarning |
warningChain
The warning chain
|
protected boolean |
wasNullFlag
Did the previous value retrieval find a NULL?
|
protected java.sql.Statement |
wrapperStatement |
| Constructor and Description |
|---|
ResultSetImpl(long updateCount,
long updateID,
MySQLConnection conn,
StatementImpl creatorStmt)
Create a result set for an executeUpdate statement.
|
ResultSetImpl(java.lang.String catalog,
Field[] fields,
RowData tuples,
MySQLConnection conn,
StatementImpl creatorStmt)
Creates a new ResultSet object.
|
| Modifier and Type | Method and Description |
|---|---|
boolean |
absolute(int row)
JDBC 2.0
Move to an absolute row number in the result set.
|
void |
afterLast()
JDBC 2.0
Moves to the end of the result set, just after the last row.
|
static boolean |
arraysEqual(byte[] left,
byte[] right) |
void |
beforeFirst()
JDBC 2.0
Moves to the front of the result set, just before the first row.
|
void |
buildIndexMapping()
Builds a hash between column names and their indices for fast retrieval.
|
void |
cancelRowUpdates()
JDBC 2.0 The cancelRowUpdates() method may be called after calling an
updateXXX() method(s) and before calling updateRow() to rollback the
updates made to a row.
|
protected MySQLConnection |
checkClosed()
Ensures that the result set is not closed
|
protected void |
checkColumnBounds(int columnIndex)
Checks if columnIndex is within the number of columns in this result set.
|
protected void |
checkRowPos()
Ensures that the cursor is positioned on a valid row and that the result
set is not closed
|
void |
clearNextResult()
We can't do this ourselves, otherwise the contract for
Statement.getMoreResults() won't work correctly.
|
void |
clearWarnings()
After this call, getWarnings returns null until a new warning is reported
for this ResultSet
|
void |
close()
In some cases, it is desirable to immediately release a ResultSet
database and JDBC resources instead of waiting for this to happen when it
is automatically closed.
|
protected static java.math.BigInteger |
convertLongToUlong(long longVal)
Converts the given value as a java long, to an 'unsigned' long, using the java.math.BigInteger class.
|
ResultSetInternalMethods |
copy()
Returns a new instance of this result set, that shares the
underlying row data.
|
void |
deleteRow()
JDBC 2.0 Delete the current row from the result set and the underlying
database.
|
protected java.sql.Date |
fastDateCreate(java.util.Calendar cal,
int year,
int month,
int day) |
protected java.sql.Time |
fastTimeCreate(java.util.Calendar cal,
int hour,
int minute,
int second) |
protected java.sql.Timestamp |
fastTimestampCreate(java.util.Calendar cal,
int year,
int month,
int day,
int hour,
int minute,
int seconds,
int secondsPart) |
int |
findColumn(java.lang.String columnName) |
boolean |
first()
JDBC 2.0
Moves to the first row in the result set.
|
java.sql.Array |
getArray(int i)
JDBC 2.0 Get an array column.
|
java.sql.Array |
getArray(java.lang.String colName)
JDBC 2.0 Get an array column.
|
java.io.InputStream |
getAsciiStream(int columnIndex)
A column value can be retrieved as a stream of ASCII characters and then
read in chunks from the stream.
|
java.io.InputStream |
getAsciiStream(java.lang.String columnName) |
java.math.BigDecimal |
getBigDecimal(int columnIndex)
JDBC 2.0 Get the value of a column in the current row as a
java.math.BigDecimal object.
|
java.math.BigDecimal |
getBigDecimal(int columnIndex,
int scale)
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName)
JDBC 2.0 Get the value of a column in the current row as a
java.math.BigDecimal object.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName,
int scale)
Deprecated.
|
java.io.InputStream |
getBinaryStream(int columnIndex)
A column value can also be retrieved as a binary stream.
|
java.io.InputStream |
getBinaryStream(java.lang.String columnName) |
java.sql.Blob |
getBlob(int columnIndex)
JDBC 2.0 Get a BLOB column.
|
java.sql.Blob |
getBlob(java.lang.String colName)
JDBC 2.0 Get a BLOB column.
|
boolean |
getBoolean(int columnIndex)
Get the value of a column in the current row as a Java boolean
|
boolean |
getBoolean(java.lang.String columnName) |
byte |
getByte(int columnIndex)
Get the value of a column in the current row as a Java byte.
|
byte |
getByte(java.lang.String columnName) |
byte[] |
getBytes(int columnIndex)
Get the value of a column in the current row as a Java byte array.
|
protected byte[] |
getBytes(int columnIndex,
boolean noConversion) |
byte[] |
getBytes(java.lang.String columnName) |
int |
getBytesSize() |
protected java.util.Calendar |
getCalendarInstanceForSessionOrNew()
Optimization to only use one calendar per-session, or calculate it for
each call, depending on user configuration
|
java.io.Reader |
getCharacterStream(int columnIndex)
JDBC 2.0
Get the value of a column in the current row as a java.io.Reader.
|
java.io.Reader |
getCharacterStream(java.lang.String columnName)
JDBC 2.0
Get the value of a column in the current row as a java.io.Reader.
|
java.sql.Clob |
getClob(int i)
JDBC 2.0 Get a CLOB column.
|
java.sql.Clob |
getClob(java.lang.String colName)
JDBC 2.0 Get a CLOB column.
|
int |
getConcurrency()
JDBC 2.0 Return the concurrency of this result set.
|
java.lang.String |
getCursorName()
Get the name of the SQL cursor used by this ResultSet
In SQL, a result table is retrieved though a cursor that is named.
|
java.sql.Date |
getDate(int columnIndex)
Get the value of a column in the current row as a java.sql.Date object
|
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar cal)
JDBC 2.0 Get the value of a column in the current row as a java.sql.Date
object.
|
java.sql.Date |
getDate(java.lang.String columnName) |
java.sql.Date |
getDate(java.lang.String columnName,
java.util.Calendar cal)
Get the value of a column in the current row as a java.sql.Date object.
|
double |
getDouble(int columnIndex)
Get the value of a column in the current row as a Java double.
|
double |
getDouble(java.lang.String columnName) |
protected double |
getDoubleInternal(int colIndex)
Converts a string representation of a number to a double.
|
protected double |
getDoubleInternal(java.lang.String stringVal,
int colIndex)
Converts a string representation of a number to a double.
|
protected ExceptionInterceptor |
getExceptionInterceptor() |
int |
getFetchDirection()
JDBC 2.0 Returns the fetch direction for this result set.
|
int |
getFetchSize()
JDBC 2.0 Return the fetch size for this result set.
|
char |
getFirstCharOfQuery()
Returns the first character of the query that this result set was created
from.
|
float |
getFloat(int columnIndex)
Get the value of a column in the current row as a Java float.
|
float |
getFloat(java.lang.String columnName) |
protected java.util.Calendar |
getGmtCalendar() |
protected static ResultSetImpl |
getInstance(long updateCount,
long updateID,
MySQLConnection conn,
StatementImpl creatorStmt) |
protected static ResultSetImpl |
getInstance(java.lang.String catalog,
Field[] fields,
RowData tuples,
MySQLConnection conn,
StatementImpl creatorStmt,
boolean isUpdatable)
Creates a result set instance that represents a query result -- We need
to provide factory-style methods so we can support both JDBC3 (and older)
and JDBC4 runtimes, otherwise the class verifier complains when it tries
to load JDBC4-only interface classes that are present in JDBC4 method
signatures.
|
int |
getInt(int columnIndex)
Get the value of a column in the current row as a Java int.
|
int |
getInt(java.lang.String columnName) |
long |
getLong(int columnIndex)
Get the value of a column in the current row as a Java long.
|
long |
getLong(java.lang.String columnName) |
java.sql.ResultSetMetaData |
getMetaData()
The numbers, types and properties of a ResultSet's columns are provided
by the getMetaData method
|
protected java.sql.Array |
getNativeArray(int i)
JDBC 2.0 Get an array column.
|
protected java.io.InputStream |
getNativeAsciiStream(int columnIndex)
A column value can be retrieved as a stream of ASCII characters and then
read in chunks from the stream.
|
protected java.math.BigDecimal |
getNativeBigDecimal(int columnIndex)
JDBC 2.0 Get the value of a column in the current row as a
java.math.BigDecimal object.
|
protected java.math.BigDecimal |
getNativeBigDecimal(int columnIndex,
int scale)
Get the value of a column in the current row as a java.math.BigDecimal
object
|
protected java.io.InputStream |
getNativeBinaryStream(int columnIndex)
A column value can also be retrieved as a binary stream.
|
protected java.sql.Blob |
getNativeBlob(int columnIndex)
JDBC 2.0 Get a BLOB column.
|
protected byte |
getNativeByte(int columnIndex)
Get the value of a column in the current row as a Java byte.
|
protected byte |
getNativeByte(int columnIndex,
boolean overflowCheck) |
protected byte[] |
getNativeBytes(int columnIndex,
boolean noConversion)
Get the value of a column in the current row as a Java byte array.
|
protected java.io.Reader |
getNativeCharacterStream(int columnIndex)
JDBC 2.0
Get the value of a column in the current row as a java.io.Reader.
|
protected java.sql.Clob |
getNativeClob(int columnIndex)
JDBC 2.0 Get a CLOB column.
|
protected java.sql.Date |
getNativeDate(int columnIndex)
Get the value of a column in the current row as a java.sql.Date object
|
protected java.sql.Date |
getNativeDate(int columnIndex,
java.util.Calendar cal)
JDBC 2.0 Get the value of a column in the current row as a java.sql.Date
object.
|
(package private) java.sql.Date |
getNativeDateViaParseConversion(int columnIndex) |
protected double |
getNativeDouble(int columnIndex)
Get the value of a column in the current row as a Java double.
|
protected float |
getNativeFloat(int columnIndex)
Get the value of a column in the current row as a Java float.
|
protected int |
getNativeInt(int columnIndex)
Get the value of a column in the current row as a Java int.
|
protected int |
getNativeInt(int columnIndex,
boolean overflowCheck) |
protected long |
getNativeLong(int columnIndex)
Get the value of a column in the current row as a Java long.
|
protected long |
getNativeLong(int columnIndex,
boolean overflowCheck,
boolean expandUnsignedLong) |
protected java.sql.Ref |
getNativeRef(int i)
JDBC 2.0 Get a REF(<structured-type>) column.
|
protected short |
getNativeShort(int columnIndex)
Get the value of a column in the current row as a Java short.
|
protected short |
getNativeShort(int columnIndex,
boolean overflowCheck) |
protected java.lang.String |
getNativeString(int columnIndex)
Get the value of a column in the current row as a Java String
|
(package private) java.sql.Timestamp |
getNativeTimestampViaParseConversion(int columnIndex,
java.util.Calendar targetCalendar,
java.util.TimeZone tz,
boolean rollForward) |
(package private) java.sql.Time |
getNativeTimeViaParseConversion(int columnIndex,
java.util.Calendar targetCalendar,
java.util.TimeZone tz,
boolean rollForward) |
protected java.io.InputStream |
getNativeUnicodeStream(int columnIndex)
A column value can also be retrieved as a stream of Unicode characters.
|
protected java.net.URL |
getNativeURL(int colIndex) |
ResultSetInternalMethods |
getNextResultSet()
Returns the next ResultSet in a multi-resultset "chain", if any,
null if none exists.
|
java.lang.Object |
getObject(int columnIndex)
Get the value of a column in the current row as a Java object
This method will return the value of the given column as a Java object.
|
<T> T |
getObject(int columnIndex,
java.lang.Class<T> type) |
java.lang.Object |
getObject(int i,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
JDBC 2.0 Returns the value of column i as a Java object.
|
java.lang.Object |
getObject(java.lang.String columnName)
Get the value of a column in the current row as a Java object
This method will return the value of the given column as a Java object.
|
<T> T |
getObject(java.lang.String columnLabel,
java.lang.Class<T> type) |
java.lang.Object |
getObject(java.lang.String colName,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
JDBC 2.0 Returns the value of column i as a Java object.
|
java.lang.Object |
getObjectStoredProc(int columnIndex,
int desiredSqlType)
Functions like ResultSet.getObject(), but using the given SQL type
(as registered during CallableStatement.registerOutParameter()).
|
java.lang.Object |
getObjectStoredProc(int i,
java.util.Map<java.lang.Object,java.lang.Object> map,
int desiredSqlType)
Functions like ResultSet.getObject(), but using the given SQL type
(as registered during CallableStatement.registerOutParameter()).
|
java.lang.Object |
getObjectStoredProc(java.lang.String columnName,
int desiredSqlType)
Functions like ResultSet.getObject(), but using the given SQL type
(as registered during CallableStatement.registerOutParameter()).
|
java.lang.Object |
getObjectStoredProc(java.lang.String colName,
java.util.Map<java.lang.Object,java.lang.Object> map,
int desiredSqlType)
Functions like ResultSet.getObject(), but using the given SQL type
(as registered during CallableStatement.registerOutParameter()).
|
java.sql.Ref |
getRef(int i)
JDBC 2.0 Get a REF(<structured-type>) column.
|
java.sql.Ref |
getRef(java.lang.String colName)
JDBC 2.0 Get a REF(<structured-type>) column.
|
int |
getRow()
JDBC 2.0
Determine the current row number.
|
java.lang.String |
getServerInfo()
Returns the server info (if any), or null if none.
|
short |
getShort(int columnIndex)
Get the value of a column in the current row as a Java short.
|
short |
getShort(java.lang.String columnName) |
java.sql.Statement |
getStatement()
JDBC 2.0 Return the Statement that produced the ResultSet.
|
java.lang.String |
getString(int columnIndex)
Get the value of a column in the current row as a Java String
|
java.lang.String |
getString(java.lang.String columnName)
The following routines simply convert the columnName into a columnIndex
and then call the appropriate routine above.
|
protected java.lang.String |
getStringInternal(int columnIndex,
boolean checkDateTypes) |
java.sql.Time |
getTime(int columnIndex)
Get the value of a column in the current row as a java.sql.Time object
|
java.sql.Time |
getTime(int columnIndex,
java.util.Calendar cal)
Get the value of a column in the current row as a java.sql.Time object.
|
java.sql.Time |
getTime(java.lang.String columnName)
Get the value of a column in the current row as a java.sql.Time object.
|
java.sql.Time |
getTime(java.lang.String columnName,
java.util.Calendar cal)
Get the value of a column in the current row as a java.sql.Time object.
|
java.sql.Timestamp |
getTimestamp(int columnIndex)
Get the value of a column in the current row as a java.sql.Timestamp
object
|
java.sql.Timestamp |
getTimestamp(int columnIndex,
java.util.Calendar cal)
Get the value of a column in the current row as a java.sql.Timestamp
object.
|
java.sql.Timestamp |
getTimestamp(java.lang.String columnName) |
java.sql.Timestamp |
getTimestamp(java.lang.String columnName,
java.util.Calendar cal)
Get the value of a column in the current row as a java.sql.Timestamp
object.
|
int |
getType()
JDBC 2.0 Return the type of this result set.
|
java.io.InputStream |
getUnicodeStream(int columnIndex)
Deprecated.
|
java.io.InputStream |
getUnicodeStream(java.lang.String columnName)
Deprecated.
|
long |
getUpdateCount()
Returns the update count for this result set (if one exists), otherwise
-1.
|
long |
getUpdateID()
Returns the AUTO_INCREMENT value for the DDL/DML statement which created
this result set.
|
java.net.URL |
getURL(int colIndex) |
java.net.URL |
getURL(java.lang.String colName) |
java.sql.SQLWarning |
getWarnings()
The first warning reported by calls on this ResultSet is returned.
|
void |
initializeFromCachedMetaData(CachedResultSetMetaData cachedMetaData) |
void |
initializeWithMetadata() |
void |
insertRow()
JDBC 2.0 Insert the contents of the insert row into the result set and
the database.
|
boolean |
isAfterLast()
JDBC 2.0
Determine if the cursor is after the last row in the result set.
|
boolean |
isBeforeFirst()
JDBC 2.0
Determine if the cursor is before the first row in the result set.
|
boolean |
isClosed()
Returns true if this ResultSet is closed.
|
boolean |
isFirst()
JDBC 2.0
Determine if the cursor is on the first row of the result set.
|
boolean |
isLast()
JDBC 2.0
Determine if the cursor is on the last row of the result set.
|
boolean |
last()
JDBC 2.0
Moves to the last row in the result set.
|
void |
moveToCurrentRow()
JDBC 2.0 Move the cursor to the remembered cursor position, usually the
current row.
|
void |
moveToInsertRow()
JDBC 2.0 Move to the insert row.
|
boolean |
next()
A ResultSet is initially positioned before its first row, the first call
to next makes the first row the current row; the second call makes the
second row the current row, etc.
|
void |
populateCachedMetaData(CachedResultSetMetaData cachedMetaData) |
boolean |
prev()
The prev method is not part of JDBC, but because of the architecture of
this driver it is possible to move both forward and backward within the
result set.
|
boolean |
previous()
JDBC 2.0
Moves to the previous row in the result set.
|
void |
realClose(boolean calledExplicitly)
Closes this ResultSet and releases resources.
|
boolean |
reallyResult()
Does the result set contain rows, or is it the result of a DDL or DML
statement?
|
void |
redefineFieldsForDBMD(Field[] f)
Used by DatabaseMetadata implementations to coerce the metadata returned
by metadata queries into that required by the JDBC specification.
|
void |
refreshRow()
JDBC 2.0 Refresh the value of the current row with its current value in
the database.
|
boolean |
relative(int rows)
JDBC 2.0
Moves a relative number of rows, either positive or negative.
|
boolean |
rowDeleted()
JDBC 2.0 Determine if this row has been deleted.
|
boolean |
rowInserted()
JDBC 2.0 Determine if the current row has been inserted.
|
boolean |
rowUpdated()
JDBC 2.0 Determine if the current row has been updated.
|
protected void |
setBinaryEncoded()
Flag that this result set is 'binary' encoded (from a PreparedStatement),
not stored as strings.
|
void |
setFetchDirection(int direction)
JDBC 2.0 Give a hint as to the direction in which the rows in this result
set will be processed.
|
void |
setFetchSize(int rows)
JDBC 2.0 Give 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 result
set.
|
void |
setFirstCharOfQuery(char c)
Sets the first character of the query that this result set was created
from.
|
protected void |
setNextResultSet(ResultSetInternalMethods nextResultSet) |
void |
setOwningStatement(StatementImpl owningStatement)
Sets the statement that "owns" this result set (usually used when the
result set should internally "belong" to one statement, but is created
by another.
|
protected void |
setResultSetConcurrency(int concurrencyFlag)
Sets the concurrency (JDBC2)
|
protected void |
setResultSetType(int typeFlag)
Sets the result set type for (JDBC2)
|
protected void |
setServerInfo(java.lang.String info)
Sets server info (if any)
|
void |
setStatementUsedForFetchingRows(PreparedStatement stmt) |
void |
setWrapperStatement(java.sql.Statement wrapperStatement) |
java.lang.String |
toString() |
void |
updateArray(int arg0,
java.sql.Array arg1) |
void |
updateArray(java.lang.String arg0,
java.sql.Array arg1) |
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
JDBC 2.0 Update a column with an ascii stream value.
|
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
JDBC 2.0 Update a column with an ascii stream value.
|
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
JDBC 2.0 Update a column with a BigDecimal value.
|
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
JDBC 2.0 Update a column with a BigDecimal value.
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
JDBC 2.0 Update a column with a binary stream value.
|
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length)
JDBC 2.0 Update a column with a binary stream value.
|
void |
updateBlob(int arg0,
java.sql.Blob arg1) |
void |
updateBlob(java.lang.String arg0,
java.sql.Blob arg1) |
void |
updateBoolean(int columnIndex,
boolean x)
JDBC 2.0 Update a column with a boolean value.
|
void |
updateBoolean(java.lang.String columnName,
boolean x)
JDBC 2.0 Update a column with a boolean value.
|
void |
updateByte(int columnIndex,
byte x)
JDBC 2.0 Update a column with a byte value.
|
void |
updateByte(java.lang.String columnName,
byte x)
JDBC 2.0 Update a column with a byte value.
|
void |
updateBytes(int columnIndex,
byte[] x)
JDBC 2.0 Update a column with a byte array value.
|
void |
updateBytes(java.lang.String columnName,
byte[] x)
JDBC 2.0 Update a column with a byte array value.
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
JDBC 2.0 Update a column with a character stream value.
|
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader reader,
int length)
JDBC 2.0 Update a column with a character stream value.
|
void |
updateClob(int arg0,
java.sql.Clob arg1) |
void |
updateClob(java.lang.String columnName,
java.sql.Clob clob) |
void |
updateDate(int columnIndex,
java.sql.Date x)
JDBC 2.0 Update a column with a Date value.
|
void |
updateDate(java.lang.String columnName,
java.sql.Date x)
JDBC 2.0 Update a column with a Date value.
|
void |
updateDouble(int columnIndex,
double x)
JDBC 2.0 Update a column with a Double value.
|
void |
updateDouble(java.lang.String columnName,
double x)
JDBC 2.0 Update a column with a double value.
|
void |
updateFloat(int columnIndex,
float x)
JDBC 2.0 Update a column with a float value.
|
void |
updateFloat(java.lang.String columnName,
float x)
JDBC 2.0 Update a column with a float value.
|
void |
updateInt(int columnIndex,
int x)
JDBC 2.0 Update a column with an integer value.
|
void |
updateInt(java.lang.String columnName,
int x)
JDBC 2.0 Update a column with an integer value.
|
void |
updateLong(int columnIndex,
long x)
JDBC 2.0 Update a column with a long value.
|
void |
updateLong(java.lang.String columnName,
long x)
JDBC 2.0 Update a column with a long value.
|
void |
updateNull(int columnIndex)
JDBC 2.0 Give a nullable column a null value.
|
void |
updateNull(java.lang.String columnName)
JDBC 2.0 Update a column with a null value.
|
void |
updateObject(int columnIndex,
java.lang.Object x)
JDBC 2.0 Update a column with an Object value.
|
void |
updateObject(int columnIndex,
java.lang.Object x,
int scale)
JDBC 2.0 Update a column with an Object value.
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x)
JDBC 2.0 Update a column with an Object value.
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
JDBC 2.0 Update a column with an Object value.
|
void |
updateRef(int arg0,
java.sql.Ref arg1) |
void |
updateRef(java.lang.String arg0,
java.sql.Ref arg1) |
void |
updateRow()
JDBC 2.0 Update the underlying database with the new contents of the
current row.
|
void |
updateShort(int columnIndex,
short x)
JDBC 2.0 Update a column with a short value.
|
void |
updateShort(java.lang.String columnName,
short x)
JDBC 2.0 Update a column with a short value.
|
void |
updateString(int columnIndex,
java.lang.String x)
JDBC 2.0 Update a column with a String value.
|
void |
updateString(java.lang.String columnName,
java.lang.String x)
JDBC 2.0 Update a column with a String value.
|
void |
updateTime(int columnIndex,
java.sql.Time x)
JDBC 2.0 Update a column with a Time value.
|
void |
updateTime(java.lang.String columnName,
java.sql.Time x)
JDBC 2.0 Update a column with a Time value.
|
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x)
JDBC 2.0 Update a column with a Timestamp value.
|
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
JDBC 2.0 Update a column with a Timestamp value.
|
boolean |
wasNull()
A column may have the value of SQL NULL; wasNull() reports whether the
last column read had this special value.
|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, waitgetHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRowId, getRowId, getSQLXML, getSQLXML, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateRowId, updateRowId, updateSQLXML, updateSQLXMLprotected static final double MIN_DIFF_PREC
protected static final double MAX_DIFF_PREC
static int resultCounter
protected java.lang.String catalog
protected java.util.Map<java.lang.String,java.lang.Integer> columnLabelToIndex
protected java.util.Map<java.lang.String,java.lang.Integer> columnToIndexCache
protected boolean[] columnUsed
protected volatile MySQLConnection connection
protected long connectionId
protected int currentRow
protected boolean doingUpdates
protected com.mysql.jdbc.profiler.ProfilerEventHandler eventSink
java.util.Calendar fastDefaultCal
java.util.Calendar fastClientCal
protected int fetchDirection
protected int fetchSize
protected Field[] fields
protected char firstCharOfQuery
protected java.util.Map<java.lang.String,java.lang.Integer> fullColumnNameToIndex
protected java.util.Map<java.lang.String,java.lang.Integer> columnNameToIndex
protected boolean hasBuiltIndexMapping
protected boolean isBinaryEncoded
protected boolean isClosed
protected ResultSetInternalMethods nextResultSet
protected boolean onInsertRow
protected StatementImpl owningStatement
protected java.lang.String pointOfOrigin
protected boolean profileSql
protected boolean reallyResult
protected int resultId
protected int resultSetConcurrency
protected int resultSetType
protected RowData rowData
protected java.lang.String serverInfo
PreparedStatement statementUsedForFetchingRows
protected ResultSetRow thisRow
protected long updateCount
protected long updateId
protected boolean useUsageAdvisor
protected java.sql.SQLWarning warningChain
protected boolean wasNullFlag
protected java.sql.Statement wrapperStatement
protected boolean retainOwningStatement
protected java.util.Calendar gmtCalendar
protected boolean useFastDateParsing
static final char[] EMPTY_SPACE
protected boolean useLegacyDatetimeCode
public ResultSetImpl(long updateCount,
long updateID,
MySQLConnection conn,
StatementImpl creatorStmt)
updateCount - the number of rows affected by the updateupdateID - the autoincrement value (if any)conn - creatorStmt - public ResultSetImpl(java.lang.String catalog,
Field[] fields,
RowData tuples,
MySQLConnection conn,
StatementImpl creatorStmt)
throws java.sql.SQLException
catalog - the database in use when we were createdfields - an array of Field objects (basically, the ResultSet MetaData)tuples - actual row dataconn - the Connection that created us.creatorStmt - java.sql.SQLException - if an error occursprotected static java.math.BigInteger convertLongToUlong(long longVal)
protected static ResultSetImpl getInstance(long updateCount, long updateID, MySQLConnection conn, StatementImpl creatorStmt) throws java.sql.SQLException
java.sql.SQLExceptionprotected static ResultSetImpl getInstance(java.lang.String catalog, Field[] fields, RowData tuples, MySQLConnection conn, StatementImpl creatorStmt, boolean isUpdatable) throws java.sql.SQLException
java.sql.SQLExceptionpublic void initializeWithMetadata()
throws java.sql.SQLException
initializeWithMetadata in interface ResultSetInternalMethodsjava.sql.SQLExceptionpublic boolean absolute(int row)
throws java.sql.SQLException
Move to an absolute row number in the result set.
If row is positive, moves to an absolute row with respect to the beginning of the result set. The first row is row 1, the second is row 2, etc.
If row is negative, moves to an absolute row position with respect to the end of result set. For example, calling absolute(-1) positions the cursor on the last row, absolute(-2) indicates the next-to-last row, etc.
An attempt to position the cursor beyond the first/last row in the result set, leaves the cursor before/after the first/last row, respectively.
Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().
absolute in interface java.sql.ResultSetrow - the row number to move tojava.sql.SQLException - if a database-access error occurs, or row is 0, or result
set type is TYPE_FORWARD_ONLY.public void afterLast()
throws java.sql.SQLException
Moves to the end of the result set, just after the last row. Has no effect if the result set contains no rows.
afterLast in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs, or result set type is
TYPE_FORWARD_ONLY.public void beforeFirst()
throws java.sql.SQLException
Moves to the front of the result set, just before the first row. Has no effect if the result set contains no rows.
beforeFirst in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs, or result set type is
TYPE_FORWARD_ONLYpublic void buildIndexMapping()
throws java.sql.SQLException
buildIndexMapping in interface ResultSetInternalMethodsjava.sql.SQLExceptionpublic void cancelRowUpdates()
throws java.sql.SQLException
cancelRowUpdates in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs, or if called when on
the insert row.NotUpdatableprotected final MySQLConnection checkClosed() throws java.sql.SQLException
java.sql.SQLException - if the result set is closedprotected final void checkColumnBounds(int columnIndex)
throws java.sql.SQLException
columnIndex - the index to checkjava.sql.SQLException - if the index is out of boundsprotected void checkRowPos()
throws java.sql.SQLException
java.sql.SQLException - if the result set is not in a valid state for traversalpublic void clearNextResult()
clearNextResult in interface ResultSetInternalMethodspublic void clearWarnings()
throws java.sql.SQLException
clearWarnings in interface java.sql.ResultSetjava.sql.SQLException - if a database access error occurspublic void close()
throws java.sql.SQLException
Note: A ResultSet is automatically closed by the Statement the Statement that generated it when that Statement is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results. A ResultSet is also automatically closed when it is garbage collected.
close in interface java.lang.AutoCloseableclose in interface java.sql.ResultSetjava.sql.SQLException - if a database access error occurspublic ResultSetInternalMethods copy() throws java.sql.SQLException
ResultSetInternalMethodscopy in interface ResultSetInternalMethodsjava.sql.SQLExceptionpublic void redefineFieldsForDBMD(Field[] f)
ResultSetInternalMethodsredefineFieldsForDBMD in interface ResultSetInternalMethodsf - the coerced metadata to be applied to result sets
returned by "SHOW ..." or SELECTs on INFORMATION_SCHEMA performed on behalf
of methods in DatabaseMetadata.public void populateCachedMetaData(CachedResultSetMetaData cachedMetaData) throws java.sql.SQLException
populateCachedMetaData in interface ResultSetInternalMethodsjava.sql.SQLExceptionpublic void initializeFromCachedMetaData(CachedResultSetMetaData cachedMetaData)
initializeFromCachedMetaData in interface ResultSetInternalMethodspublic void deleteRow()
throws java.sql.SQLException
deleteRow in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs, or if called when on
the insert row.NotUpdatableprotected java.sql.Date fastDateCreate(java.util.Calendar cal,
int year,
int month,
int day)
throws java.sql.SQLException
java.sql.SQLExceptionprotected java.sql.Time fastTimeCreate(java.util.Calendar cal,
int hour,
int minute,
int second)
throws java.sql.SQLException
java.sql.SQLExceptionprotected java.sql.Timestamp fastTimestampCreate(java.util.Calendar cal,
int year,
int month,
int day,
int hour,
int minute,
int seconds,
int secondsPart)
throws java.sql.SQLException
java.sql.SQLExceptionpublic int findColumn(java.lang.String columnName)
throws java.sql.SQLException
findColumn in interface java.sql.ResultSetjava.sql.SQLExceptionpublic boolean first()
throws java.sql.SQLException
Moves to the first row in the result set.
first in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs, or result set type is
TYPE_FORWARD_ONLY.public java.sql.Array getArray(int i)
throws java.sql.SQLException
getArray in interface java.sql.ResultSeti - the first column is 1, the second is 2, ...java.sql.SQLException - if a database error occursNotImplementedpublic java.sql.Array getArray(java.lang.String colName)
throws java.sql.SQLException
getArray in interface java.sql.ResultSetcolName - the column namejava.sql.SQLException - if a database error occursNotImplementedpublic java.io.InputStream getAsciiStream(int columnIndex)
throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not.
getAsciiStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database access error occursgetBinaryStreampublic java.io.InputStream getAsciiStream(java.lang.String columnName)
throws java.sql.SQLException
getAsciiStream in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionpublic java.math.BigDecimal getBigDecimal(int columnIndex)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.@Deprecated
public java.math.BigDecimal getBigDecimal(int columnIndex,
int scale)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2...scale - the number of digits to the right of the decimaljava.sql.SQLException - if a database access error occurspublic java.math.BigDecimal getBigDecimal(java.lang.String columnName)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetcolumnName - the name of the column to retrieve the value fromjava.sql.SQLException - if an error occurs@Deprecated
public java.math.BigDecimal getBigDecimal(java.lang.String columnName,
int scale)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetcolumnName - scale - java.sql.SQLExceptionpublic java.io.InputStream getBinaryStream(int columnIndex)
throws java.sql.SQLException
getBinaryStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2...java.sql.SQLException - if a database access error occursgetAsciiStream,
getUnicodeStreampublic java.io.InputStream getBinaryStream(java.lang.String columnName)
throws java.sql.SQLException
getBinaryStream in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionpublic java.sql.Blob getBlob(int columnIndex)
throws java.sql.SQLException
getBlob in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if an error occurs.public java.sql.Blob getBlob(java.lang.String colName)
throws java.sql.SQLException
getBlob in interface java.sql.ResultSetcolName - the column namejava.sql.SQLException - if an error occurs.public boolean getBoolean(int columnIndex)
throws java.sql.SQLException
getBoolean in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2...java.sql.SQLException - if a database access error occurspublic boolean getBoolean(java.lang.String columnName)
throws java.sql.SQLException
getBoolean in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionpublic byte getByte(int columnIndex)
throws java.sql.SQLException
getByte in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2,...java.sql.SQLException - if a database access error occurspublic byte getByte(java.lang.String columnName)
throws java.sql.SQLException
getByte in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionpublic byte[] getBytes(int columnIndex)
throws java.sql.SQLException
Be warned If the blob is huge, then you may run out of memory.
getBytes in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database access error occursprotected byte[] getBytes(int columnIndex,
boolean noConversion)
throws java.sql.SQLException
java.sql.SQLExceptionpublic byte[] getBytes(java.lang.String columnName)
throws java.sql.SQLException
getBytes in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionpublic int getBytesSize()
throws java.sql.SQLException
getBytesSize in interface ResultSetInternalMethodsjava.sql.SQLExceptionprotected java.util.Calendar getCalendarInstanceForSessionOrNew()
throws java.sql.SQLException
java.sql.SQLExceptionpublic java.io.Reader getCharacterStream(int columnIndex)
throws java.sql.SQLException
Get the value of a column in the current row as a java.io.Reader.
getCharacterStream in interface java.sql.ResultSetcolumnIndex - the column to get the value fromjava.sql.SQLException - if an error occurspublic java.io.Reader getCharacterStream(java.lang.String columnName)
throws java.sql.SQLException
Get the value of a column in the current row as a java.io.Reader.
getCharacterStream in interface java.sql.ResultSetcolumnName - the column name to retrieve the value fromjava.sql.SQLException - if an error occurspublic java.sql.Clob getClob(int i)
throws java.sql.SQLException
getClob in interface java.sql.ResultSeti - the first column is 1, the second is 2, ...java.sql.SQLException - if an error occurspublic java.sql.Clob getClob(java.lang.String colName)
throws java.sql.SQLException
getClob in interface java.sql.ResultSetcolName - the column namejava.sql.SQLException - if an error occurspublic int getConcurrency()
throws java.sql.SQLException
getConcurrency in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurspublic java.lang.String getCursorName()
throws java.sql.SQLException
In SQL, a result table is retrieved though a cursor that is named. The current row of a result can be updated or deleted using a positioned update/delete statement that references the cursor name.
JDBC supports this SQL feature by providing the name of the SQL cursor used by a ResultSet. The current row of a ResulSet 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.ResultSetjava.sql.SQLException - if a database access error occurspublic java.sql.Date getDate(int columnIndex)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2...java.sql.SQLException - if a database access error occurspublic java.sql.Date getDate(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...cal - the calendar to use in constructing the datejava.sql.SQLException - if a database-access error occurs.public java.sql.Date getDate(java.lang.String columnName)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionpublic java.sql.Date getDate(java.lang.String columnName,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetcolumnName - is the SQL name of the columncal - the calendar to use in constructing the datejava.sql.SQLException - if a database-access error occurs.public double getDouble(int columnIndex)
throws java.sql.SQLException
getDouble in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2,...java.sql.SQLException - if a database access error occurspublic double getDouble(java.lang.String columnName)
throws java.sql.SQLException
getDouble in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionprotected double getDoubleInternal(int colIndex)
throws java.sql.SQLException
colIndex - the 1-based index of the column to retrieve a double from.java.sql.SQLException - if an error occursprotected double getDoubleInternal(java.lang.String stringVal,
int colIndex)
throws java.sql.SQLException
stringVal - the double as a StringcolIndex - the 1-based index of the column to retrieve a double from.java.sql.SQLException - if an error occurspublic int getFetchDirection()
throws java.sql.SQLException
getFetchDirection in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurspublic int getFetchSize()
throws java.sql.SQLException
getFetchSize in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurspublic char getFirstCharOfQuery()
getFirstCharOfQuery in interface ResultSetInternalMethodspublic float getFloat(int columnIndex)
throws java.sql.SQLException
getFloat in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2,...java.sql.SQLException - if a database access error occurspublic float getFloat(java.lang.String columnName)
throws java.sql.SQLException
getFloat in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionpublic int getInt(int columnIndex)
throws java.sql.SQLException
getInt in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2,...java.sql.SQLException - if a database access error occurspublic int getInt(java.lang.String columnName)
throws java.sql.SQLException
getInt in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionpublic long getLong(int columnIndex)
throws java.sql.SQLException
getLong in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2,...java.sql.SQLException - if a database access error occurspublic long getLong(java.lang.String columnName)
throws java.sql.SQLException
getLong in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionpublic java.sql.ResultSetMetaData getMetaData()
throws java.sql.SQLException
getMetaData in interface java.sql.ResultSetjava.sql.SQLException - if a database access error occursprotected java.sql.Array getNativeArray(int i)
throws java.sql.SQLException
i - the first column is 1, the second is 2, ...java.sql.SQLException - if a database error occursNotImplementedprotected java.io.InputStream getNativeAsciiStream(int columnIndex)
throws java.sql.SQLException
Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. Also, a stream may return 0 for available() whether there is data available or not.
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database access error occursgetBinaryStreamprotected java.math.BigDecimal getNativeBigDecimal(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occurs.protected java.math.BigDecimal getNativeBigDecimal(int columnIndex,
int scale)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2...scale - the number of digits to the right of the decimaljava.sql.SQLException - if a database access error occursprotected java.io.InputStream getNativeBinaryStream(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2...java.sql.SQLException - if a database access error occursgetAsciiStream,
getUnicodeStreamprotected java.sql.Blob getNativeBlob(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if an error occurs.public static boolean arraysEqual(byte[] left,
byte[] right)
protected byte getNativeByte(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2,...java.sql.SQLException - if a database access error occursprotected byte getNativeByte(int columnIndex,
boolean overflowCheck)
throws java.sql.SQLException
java.sql.SQLExceptionprotected byte[] getNativeBytes(int columnIndex,
boolean noConversion)
throws java.sql.SQLException
Be warned If the blob is huge, then you may run out of memory.
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database access error occursprotected java.io.Reader getNativeCharacterStream(int columnIndex)
throws java.sql.SQLException
Get the value of a column in the current row as a java.io.Reader.
columnIndex - the column to get the value fromjava.sql.SQLException - if an error occursprotected java.sql.Clob getNativeClob(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if an error occursprotected java.sql.Date getNativeDate(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2...java.sql.SQLException - if a database access error occursprotected java.sql.Date getNativeDate(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2, ...tz - the calendar to use in constructing the datejava.sql.SQLException - if a database-access error occurs.java.sql.Date getNativeDateViaParseConversion(int columnIndex)
throws java.sql.SQLException
java.sql.SQLExceptionprotected double getNativeDouble(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2,...java.sql.SQLException - if a database access error occursprotected float getNativeFloat(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2,...java.sql.SQLException - if a database access error occursprotected int getNativeInt(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2,...java.sql.SQLException - if a database access error occursprotected int getNativeInt(int columnIndex,
boolean overflowCheck)
throws java.sql.SQLException
java.sql.SQLExceptionprotected long getNativeLong(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2,...java.sql.SQLException - if a database access error occursprotected long getNativeLong(int columnIndex,
boolean overflowCheck,
boolean expandUnsignedLong)
throws java.sql.SQLException
java.sql.SQLExceptionprotected java.sql.Ref getNativeRef(int i)
throws java.sql.SQLException
i - the first column is 1, the second is 2, ...java.sql.SQLException - as this is not implementedNotImplementedprotected short getNativeShort(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2,...java.sql.SQLException - if a database access error occursprotected short getNativeShort(int columnIndex,
boolean overflowCheck)
throws java.sql.SQLException
java.sql.SQLExceptionprotected java.lang.String getNativeString(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2...java.sql.SQLException - if a database access error occursjava.sql.Time getNativeTimeViaParseConversion(int columnIndex,
java.util.Calendar targetCalendar,
java.util.TimeZone tz,
boolean rollForward)
throws java.sql.SQLException
java.sql.SQLExceptionjava.sql.Timestamp getNativeTimestampViaParseConversion(int columnIndex,
java.util.Calendar targetCalendar,
java.util.TimeZone tz,
boolean rollForward)
throws java.sql.SQLException
java.sql.SQLExceptionprotected java.io.InputStream getNativeUnicodeStream(int columnIndex)
throws java.sql.SQLException
columnIndex - the first column is 1, the second is 2...java.sql.SQLException - if a database access error occursgetAsciiStream,
getBinaryStreamprotected java.net.URL getNativeURL(int colIndex)
throws java.sql.SQLException
java.sql.SQLExceptionResultSet.getURL(int)public ResultSetInternalMethods getNextResultSet()
ResultSetInternalMethodsgetNextResultSet in interface ResultSetInternalMethodspublic java.lang.Object getObject(int columnIndex)
throws java.sql.SQLException
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 specified in the JDBC specification.
This method may also be used to read database specific abstract data types.
getObject in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2...java.sql.SQLException - if a database access error occurspublic <T> T getObject(int columnIndex,
java.lang.Class<T> type)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetjava.sql.SQLExceptionpublic <T> T getObject(java.lang.String columnLabel,
java.lang.Class<T> type)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetjava.sql.SQLExceptionpublic java.lang.Object getObject(int i,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
getObject in interface java.sql.ResultSeti - the first column is 1, the second is 2, ...map - the mapping from SQL type names to Java classesjava.sql.SQLException - because this is not implementedpublic java.lang.Object getObject(java.lang.String columnName)
throws java.sql.SQLException
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 specified in the JDBC specification.
This method may also be used to read database specific abstract data types.
getObject in interface java.sql.ResultSetcolumnName - is the SQL name of the columnjava.sql.SQLException - if a database access error occurspublic java.lang.Object getObject(java.lang.String colName,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetcolName - the column namemap - the mapping from SQL type names to Java classesjava.sql.SQLException - as this is not implementedpublic java.lang.Object getObjectStoredProc(int columnIndex,
int desiredSqlType)
throws java.sql.SQLException
ResultSetInternalMethodsgetObjectStoredProc in interface ResultSetInternalMethodsjava.sql.SQLExceptionpublic java.lang.Object getObjectStoredProc(int i,
java.util.Map<java.lang.Object,java.lang.Object> map,
int desiredSqlType)
throws java.sql.SQLException
ResultSetInternalMethodsgetObjectStoredProc in interface ResultSetInternalMethodsjava.sql.SQLExceptionpublic java.lang.Object getObjectStoredProc(java.lang.String columnName,
int desiredSqlType)
throws java.sql.SQLException
ResultSetInternalMethodsgetObjectStoredProc in interface ResultSetInternalMethodsjava.sql.SQLExceptionpublic java.lang.Object getObjectStoredProc(java.lang.String colName,
java.util.Map<java.lang.Object,java.lang.Object> map,
int desiredSqlType)
throws java.sql.SQLException
ResultSetInternalMethodsgetObjectStoredProc in interface ResultSetInternalMethodsjava.sql.SQLExceptionpublic java.sql.Ref getRef(int i)
throws java.sql.SQLException
getRef in interface java.sql.ResultSeti - the first column is 1, the second is 2, ...java.sql.SQLException - as this is not implementedNotImplementedpublic java.sql.Ref getRef(java.lang.String colName)
throws java.sql.SQLException
getRef in interface java.sql.ResultSetcolName - the column namejava.sql.SQLException - as this method is not implemented.NotImplementedpublic int getRow()
throws java.sql.SQLException
Determine the current row number. The first row is number 1, the second number 2, etc.
getRow in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs.public java.lang.String getServerInfo()
getServerInfo in interface ResultSetInternalMethodspublic short getShort(int columnIndex)
throws java.sql.SQLException
getShort in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2,...java.sql.SQLException - if a database access error occurspublic short getShort(java.lang.String columnName)
throws java.sql.SQLException
getShort in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionpublic java.sql.Statement getStatement()
throws java.sql.SQLException
getStatement in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurspublic java.lang.String getString(int columnIndex)
throws java.sql.SQLException
getString in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2...java.sql.SQLException - if a database access error occurspublic java.lang.String getString(java.lang.String columnName)
throws java.sql.SQLException
getString in interface java.sql.ResultSetcolumnName - is the SQL name of the columnjava.sql.SQLException - if a database access error occursprotected java.lang.String getStringInternal(int columnIndex,
boolean checkDateTypes)
throws java.sql.SQLException
java.sql.SQLExceptionpublic java.sql.Time getTime(int columnIndex)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2...java.sql.SQLException - if a database access error occurspublic java.sql.Time getTime(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...cal - the calendar to use in constructing the timejava.sql.SQLException - if a database-access error occurs.public java.sql.Time getTime(java.lang.String columnName)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetcolumnName - is the SQL name of the columnjava.sql.SQLException - if a database-access error occurs.public java.sql.Time getTime(java.lang.String columnName,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetcolumnName - is the SQL name of the columncal - the calendar to use in constructing the timejava.sql.SQLException - if a database-access error occurs.public java.sql.Timestamp getTimestamp(int columnIndex)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2...java.sql.SQLException - if a database access error occurspublic java.sql.Timestamp getTimestamp(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...cal - the calendar to use in constructing the timestampjava.sql.SQLException - if a database-access error occurs.public java.sql.Timestamp getTimestamp(java.lang.String columnName)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionpublic java.sql.Timestamp getTimestamp(java.lang.String columnName,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetcolumnName - is the SQL name of the columncal - the calendar to use in constructing the timestampjava.sql.SQLException - if a database-access error occurs.public int getType()
throws java.sql.SQLException
getType in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs@Deprecated
public java.io.InputStream getUnicodeStream(int columnIndex)
throws java.sql.SQLException
getUnicodeStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2...java.sql.SQLException - if a database access error occursgetAsciiStream,
getBinaryStream@Deprecated
public java.io.InputStream getUnicodeStream(java.lang.String columnName)
throws java.sql.SQLException
getUnicodeStream in interface java.sql.ResultSetcolumnName - java.sql.SQLExceptionpublic long getUpdateCount()
ResultSetInternalMethodsgetUpdateCount in interface ResultSetInternalMethodspublic long getUpdateID()
ResultSetInternalMethodsgetUpdateID in interface ResultSetInternalMethodspublic java.net.URL getURL(int colIndex)
throws java.sql.SQLException
getURL in interface java.sql.ResultSetjava.sql.SQLExceptionResultSet.getURL(int)public java.net.URL getURL(java.lang.String colName)
throws java.sql.SQLException
getURL in interface java.sql.ResultSetjava.sql.SQLExceptionResultSet.getURL(String)public java.sql.SQLWarning getWarnings()
throws java.sql.SQLException
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 warnings caused by statement methods (such as reading OUT parameters) will be chained on the Statement object.
getWarnings in interface java.sql.ResultSetjava.sql.SQLException - if a database access error occurs.public void insertRow()
throws java.sql.SQLException
insertRow in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs, if called when not on
the insert row, or if all non-nullable columns in the
insert row have not been given a valueNotUpdatablepublic boolean isAfterLast()
throws java.sql.SQLException
Determine if the cursor is after the last row in the result set.
isAfterLast in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs.public boolean isBeforeFirst()
throws java.sql.SQLException
Determine if the cursor is before the first row in the result set.
isBeforeFirst in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs.public boolean isFirst()
throws java.sql.SQLException
Determine if the cursor is on the first row of the result set.
isFirst in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs.public boolean isLast()
throws java.sql.SQLException
Determine if the cursor is on the last row of the result set. Note: Calling isLast() may be expensive since 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.ResultSetjava.sql.SQLException - if a database-access error occurs.public boolean last()
throws java.sql.SQLException
Moves to the last row in the result set.
last in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs, or result set type is
TYPE_FORWARD_ONLY.public void moveToCurrentRow()
throws java.sql.SQLException
moveToCurrentRow in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs, or the result set is
not updatableNotUpdatablepublic void moveToInsertRow()
throws java.sql.SQLException
moveToInsertRow in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs, or the result set is
not updatableNotUpdatablepublic boolean next()
throws java.sql.SQLException
If an input stream from the previous row is open, it is implicitly closed. The ResultSet's warning chain is cleared when a new row is read
next in interface java.sql.ResultSetjava.sql.SQLException - if a database access error occurspublic boolean prev()
throws java.sql.SQLException
If an input stream from the previous row is open, it is implicitly closed. The ResultSet's warning chain is cleared when a new row is read
java.sql.SQLException - if a database access error occurspublic boolean previous()
throws java.sql.SQLException
Moves to the previous row in the result set.
Note: previous() is not the same as relative(-1) since it makes sense to call previous() when there is no current row.
previous in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs, or result set type is
TYPE_FORWAR_DONLY.public void realClose(boolean calledExplicitly)
throws java.sql.SQLException
realClose in interface ResultSetInternalMethodscalledExplicitly - was realClose called by the standard ResultSet.close() method, or was it closed internally by the
driver?java.sql.SQLException - if an error occurspublic boolean isClosed()
throws java.sql.SQLException
isClosed in interface ResultSetInternalMethodsisClosed in interface java.sql.ResultSetjava.sql.SQLExceptionpublic boolean reallyResult()
ResultSetInternalMethodsreallyResult in interface ResultSetInternalMethodspublic void refreshRow()
throws java.sql.SQLException
refreshRow in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs, or if called when on
the insert row.NotUpdatablepublic boolean relative(int rows)
throws java.sql.SQLException
Moves a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the result set positions the cursor before/after the the first/last row. Calling relative(0) is valid, but does not change the cursor position.
Note: Calling relative(1) is different than calling next() since 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.ResultSetrows - the number of relative rows to move the cursor.java.sql.SQLException - if a database-access error occurs, or there is no current
row, or result set type is TYPE_FORWARD_ONLY.public boolean rowDeleted()
throws java.sql.SQLException
rowDeleted in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occursNotImplementedDatabaseMetaData.deletesAreDetected(int)public boolean rowInserted()
throws java.sql.SQLException
rowInserted in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occursNotImplementedDatabaseMetaData.insertsAreDetected(int)public boolean rowUpdated()
throws java.sql.SQLException
rowUpdated in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occursNotImplementedDatabaseMetaData.updatesAreDetected(int)protected void setBinaryEncoded()
public void setFetchDirection(int direction)
throws java.sql.SQLException
setFetchDirection in interface java.sql.ResultSetdirection - the direction to fetch rows in.java.sql.SQLException - if a database-access error occurs, or the result set type
is TYPE_FORWARD_ONLY and direction is not FETCH_FORWARD.
MM.MySQL actually ignores this, because it has the whole
result set anyway, so the direction is immaterial.public void setFetchSize(int rows)
throws java.sql.SQLException
setFetchSize in interface java.sql.ResultSetrows - the number of rows to fetchjava.sql.SQLException - if a database-access error occurs, or the condition 0 lteq
rows lteq this.getMaxRows() is not satisfied. Currently
ignored by this driver.public void setFirstCharOfQuery(char c)
setFirstCharOfQuery in interface ResultSetInternalMethodsc - the first character of the query...uppercasedprotected void setNextResultSet(ResultSetInternalMethods nextResultSet)
nextResultSet - Sets the next result set in the result set chain for multiple
result sets.public void setOwningStatement(StatementImpl owningStatement)
ResultSetInternalMethodssetOwningStatement in interface ResultSetInternalMethodsprotected void setResultSetConcurrency(int concurrencyFlag)
concurrencyFlag - CONCUR_UPDATABLE or CONCUR_READONLYprotected void setResultSetType(int typeFlag)
typeFlag - SCROLL_SENSITIVE or SCROLL_INSENSITIVE (we only support
SCROLL_INSENSITIVE)protected void setServerInfo(java.lang.String info)
info - the server info messagepublic void setStatementUsedForFetchingRows(PreparedStatement stmt)
setStatementUsedForFetchingRows in interface ResultSetInternalMethodspublic void setWrapperStatement(java.sql.Statement wrapperStatement)
setWrapperStatement in interface ResultSetInternalMethodswrapperStatement - The wrapperStatement to set.public java.lang.String toString()
toString in class java.lang.Objectpublic void updateArray(int arg0,
java.sql.Array arg1)
throws java.sql.SQLException
updateArray in interface java.sql.ResultSetjava.sql.SQLExceptionResultSet.updateArray(int, Array)public void updateArray(java.lang.String arg0,
java.sql.Array arg1)
throws java.sql.SQLException
updateArray in interface java.sql.ResultSetjava.sql.SQLExceptionResultSet.updateArray(String, Array)public void updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuelength - of the streamjava.sql.SQLException - if a database-access error occurspublic void updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
throws java.sql.SQLException
updateBigDecimal in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
throws java.sql.SQLException
updateBigDecimal in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuelength - of the streamjava.sql.SQLException - if a database-access error occurspublic void updateBlob(int arg0,
java.sql.Blob arg1)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLExceptionResultSet.updateBlob(int, Blob)public void updateBlob(java.lang.String arg0,
java.sql.Blob arg1)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLExceptionResultSet.updateBlob(String, Blob)public void updateBoolean(int columnIndex,
boolean x)
throws java.sql.SQLException
updateBoolean in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateBoolean(java.lang.String columnName,
boolean x)
throws java.sql.SQLException
updateBoolean in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateByte(int columnIndex,
byte x)
throws java.sql.SQLException
updateByte in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateByte(java.lang.String columnName,
byte x)
throws java.sql.SQLException
updateByte in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateBytes(int columnIndex,
byte[] x)
throws java.sql.SQLException
updateBytes in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateBytes(java.lang.String columnName,
byte[] x)
throws java.sql.SQLException
updateBytes in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuelength - the length of the streamjava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateCharacterStream(java.lang.String columnName,
java.io.Reader reader,
int length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetcolumnName - the name of the columnreader - the stream to update the column withlength - of the streamjava.sql.SQLException - if a database-access error occurspublic void updateClob(int arg0,
java.sql.Clob arg1)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLExceptionResultSet.updateClob(int, Clob)public void updateClob(java.lang.String columnName,
java.sql.Clob clob)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLExceptionResultSet.updateClob(String, Clob)public void updateDate(int columnIndex,
java.sql.Date x)
throws java.sql.SQLException
updateDate in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateDate(java.lang.String columnName,
java.sql.Date x)
throws java.sql.SQLException
updateDate in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateDouble(int columnIndex,
double x)
throws java.sql.SQLException
updateDouble in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateDouble(java.lang.String columnName,
double x)
throws java.sql.SQLException
updateDouble in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateFloat(int columnIndex,
float x)
throws java.sql.SQLException
updateFloat in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateFloat(java.lang.String columnName,
float x)
throws java.sql.SQLException
updateFloat in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateInt(int columnIndex,
int x)
throws java.sql.SQLException
updateInt in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateInt(java.lang.String columnName,
int x)
throws java.sql.SQLException
updateInt in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateLong(int columnIndex,
long x)
throws java.sql.SQLException
updateLong in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateLong(java.lang.String columnName,
long x)
throws java.sql.SQLException
updateLong in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateNull(int columnIndex)
throws java.sql.SQLException
updateNull in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...java.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateNull(java.lang.String columnName)
throws java.sql.SQLException
updateNull in interface java.sql.ResultSetcolumnName - the name of the columnjava.sql.SQLException - if a database-access error occurspublic void updateObject(int columnIndex,
java.lang.Object x)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateObject(int columnIndex,
java.lang.Object x,
int scale)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuescale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types
this is the number of digits after the decimal. For all other
types this value will be ignored.java.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateObject(java.lang.String columnName,
java.lang.Object x)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetcolumnName - 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. For all other
types this value will be ignored.java.sql.SQLException - if a database-access error occurspublic void updateRef(int arg0,
java.sql.Ref arg1)
throws java.sql.SQLException
updateRef in interface java.sql.ResultSetjava.sql.SQLExceptionResultSet.updateRef(int, Ref)public void updateRef(java.lang.String arg0,
java.sql.Ref arg1)
throws java.sql.SQLException
updateRef in interface java.sql.ResultSetjava.sql.SQLExceptionResultSet.updateRef(String, Ref)public void updateRow()
throws java.sql.SQLException
updateRow in interface java.sql.ResultSetjava.sql.SQLException - if a database-access error occurs, or if called when on
the insert rowNotUpdatablepublic void updateShort(int columnIndex,
short x)
throws java.sql.SQLException
updateShort in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateShort(java.lang.String columnName,
short x)
throws java.sql.SQLException
updateShort in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateString(int columnIndex,
java.lang.String x)
throws java.sql.SQLException
updateString in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateString(java.lang.String columnName,
java.lang.String x)
throws java.sql.SQLException
updateString in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateTime(int columnIndex,
java.sql.Time x)
throws java.sql.SQLException
updateTime in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateTime(java.lang.String columnName,
java.sql.Time x)
throws java.sql.SQLException
updateTime in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic void updateTimestamp(int columnIndex,
java.sql.Timestamp x)
throws java.sql.SQLException
updateTimestamp in interface java.sql.ResultSetcolumnIndex - the first column is 1, the second is 2, ...x - the new column valuejava.sql.SQLException - if a database-access error occursNotUpdatablepublic void updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
throws java.sql.SQLException
updateTimestamp in interface java.sql.ResultSetcolumnName - the name of the columnx - the new column valuejava.sql.SQLException - if a database-access error occurspublic boolean wasNull()
throws java.sql.SQLException
wasNull in interface java.sql.ResultSetjava.sql.SQLException - if a database access error occurredprotected java.util.Calendar getGmtCalendar()
protected ExceptionInterceptor getExceptionInterceptor()