|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.mysql.jdbc.ResultSetImpl
public class ResultSetImpl
A ResultSet provides access to a table of data generated by executing a Statement. The table rows are retrieved in sequence. Within a row its column values can be accessed in any order.
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.
ResultSetMetaData
,
ResultSet
Field Summary | |
---|---|
protected java.lang.String |
catalog
The catalog that was in use when we were created |
protected java.util.Map |
columnLabelToIndex
Map column names (and all of their permutations) to column indices |
protected java.util.Map |
columnNameToIndex
|
protected java.util.Map |
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 ConnectionImpl |
connection
The Connection instance that created us |
protected long |
connectionId
|
protected int |
currentRow
The current row #, -1 == before start of result set |
(package private) java.util.TimeZone |
defaultTimeZone
|
protected boolean |
doingUpdates
Are we in the middle of doing updates to the current row? |
protected static char[] |
EMPTY_SPACE
|
protected com.mysql.jdbc.profiler.ProfilerEventHandler |
eventSink
|
(package private) java.util.Calendar |
fastDateCal
|
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 |
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.Throwable |
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? |
protected 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
|
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 | |
---|---|
ResultSetImpl(long updateCount,
long updateID,
ConnectionImpl conn,
StatementImpl creatorStmt)
Create a result set for an executeUpdate statement. |
|
ResultSetImpl(java.lang.String catalog,
Field[] fields,
RowData tuples,
ConnectionImpl conn,
StatementImpl creatorStmt)
Creates a new ResultSet object. |
Method Summary | |
---|---|
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 void |
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)
DOCUMENT ME! |
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)
DOCUMENT ME! |
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)
DOCUMENT ME! |
byte |
getByte(int columnIndex)
Get the value of a column in the current row as a Java byte. |
byte |
getByte(java.lang.String columnName)
DOCUMENT ME! |
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)
DOCUMENT ME! |
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)
DOCUMENT ME! |
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)
DOCUMENT ME! |
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)
DOCUMENT ME! |
protected java.util.Calendar |
getGmtCalendar()
|
protected static ResultSetImpl |
getInstance(long updateCount,
long updateID,
ConnectionImpl conn,
StatementImpl creatorStmt)
|
protected static ResultSetImpl |
getInstance(java.lang.String catalog,
Field[] fields,
RowData tuples,
ConnectionImpl 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)
DOCUMENT ME! |
long |
getLong(int columnIndex)
Get the value of a column in the current row as a Java long. |
long |
getLong(java.lang.String columnName)
DOCUMENT ME! |
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()
DOCUMENT ME! |
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. |
java.lang.Object |
getObject(int i,
java.util.Map 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. |
java.lang.Object |
getObject(java.lang.String colName,
java.util.Map 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 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 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)
DOCUMENT ME! |
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)
DOCUMENT ME! |
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 |
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)
DOCUMENT ME! |
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()
DOCUMENT ME! |
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. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Methods inherited from interface java.sql.ResultSet |
---|
getHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRowId, getRowId, getSQLXML, getSQLXML, isClosed, 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, updateSQLXML |
Methods inherited from interface java.sql.Wrapper |
---|
isWrapperFor, unwrap |
Field Detail |
---|
protected static final double MIN_DIFF_PREC
protected static final double MAX_DIFF_PREC
protected static int resultCounter
protected java.lang.String catalog
protected java.util.Map columnLabelToIndex
protected java.util.Map columnToIndexCache
protected boolean[] columnUsed
protected ConnectionImpl connection
protected long connectionId
protected int currentRow
java.util.TimeZone defaultTimeZone
protected boolean doingUpdates
protected com.mysql.jdbc.profiler.ProfilerEventHandler eventSink
java.util.Calendar fastDateCal
protected int fetchDirection
protected int fetchSize
protected Field[] fields
protected char firstCharOfQuery
protected java.util.Map fullColumnNameToIndex
protected java.util.Map columnNameToIndex
protected boolean hasBuiltIndexMapping
protected boolean isBinaryEncoded
protected boolean isClosed
protected ResultSetInternalMethods nextResultSet
protected boolean onInsertRow
protected StatementImpl owningStatement
protected java.lang.Throwable 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
protected static final char[] EMPTY_SPACE
protected boolean useLegacyDatetimeCode
Constructor Detail |
---|
public ResultSetImpl(long updateCount, long updateID, ConnectionImpl conn, StatementImpl creatorStmt)
updateCount
- the number of rows affected by the updateupdateID
- the autoincrement value (if any)conn
- DOCUMENT ME!creatorStmt
- DOCUMENT ME!public ResultSetImpl(java.lang.String catalog, Field[] fields, RowData tuples, ConnectionImpl 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
- DOCUMENT ME!
java.sql.SQLException
- if an error occursMethod Detail |
---|
protected static java.math.BigInteger convertLongToUlong(long longVal)
protected static ResultSetImpl getInstance(long updateCount, long updateID, ConnectionImpl conn, StatementImpl creatorStmt) throws java.sql.SQLException
java.sql.SQLException
protected static ResultSetImpl getInstance(java.lang.String catalog, Field[] fields, RowData tuples, ConnectionImpl conn, StatementImpl creatorStmt, boolean isUpdatable) throws java.sql.SQLException
java.sql.SQLException
public void initializeWithMetadata() throws java.sql.SQLException
initializeWithMetadata
in interface ResultSetInternalMethods
java.sql.SQLException
public 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.ResultSet
row
- the row number to move to
java.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.ResultSet
java.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.ResultSet
java.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 ResultSetInternalMethods
java.sql.SQLException
public void cancelRowUpdates() throws java.sql.SQLException
cancelRowUpdates
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or if called when on
the insert row.
NotUpdatable
- DOCUMENT ME!protected final void 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 check
java.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 ResultSetInternalMethods
public void clearWarnings() throws java.sql.SQLException
clearWarnings
in interface java.sql.ResultSet
java.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.sql.ResultSet
java.sql.SQLException
- if a database access error occurspublic ResultSetInternalMethods copy() throws java.sql.SQLException
ResultSetInternalMethods
copy
in interface ResultSetInternalMethods
java.sql.SQLException
public void redefineFieldsForDBMD(Field[] f)
ResultSetInternalMethods
redefineFieldsForDBMD
in interface ResultSetInternalMethods
f
- 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 ResultSetInternalMethods
java.sql.SQLException
public void initializeFromCachedMetaData(CachedResultSetMetaData cachedMetaData)
initializeFromCachedMetaData
in interface ResultSetInternalMethods
public void deleteRow() throws java.sql.SQLException
deleteRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or if called when on
the insert row.
NotUpdatable
- DOCUMENT ME!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) throws java.sql.SQLException
java.sql.SQLException
protected java.sql.Timestamp fastTimestampCreate(java.util.Calendar cal, int year, int month, int day, int hour, int minute, int seconds, int secondsPart)
public int findColumn(java.lang.String columnName) throws java.sql.SQLException
findColumn
in interface java.sql.ResultSet
java.sql.SQLException
public boolean first() throws java.sql.SQLException
Moves to the first row in the result set.
first
in interface java.sql.ResultSet
java.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.ResultSet
i
- the first column is 1, the second is 2, ...
java.sql.SQLException
- if a database error occurs
NotImplemented
- DOCUMENT ME!public java.sql.Array getArray(java.lang.String colName) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
colName
- the column name
java.sql.SQLException
- if a database error occurs
NotImplemented
- DOCUMENT ME!public 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.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
java.sql.SQLException
- if a database access error occursgetBinaryStream
public java.io.InputStream getAsciiStream(java.lang.String columnName) throws java.sql.SQLException
getAsciiStream
in interface java.sql.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
java.sql.SQLException
- if a database-access error occurs.public java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2...scale
- the number of digits to the right of the decimal
java.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.ResultSet
columnName
- the name of the column to retrieve the value from
java.sql.SQLException
- if an error occurspublic java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnName
- DOCUMENT ME!scale
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public java.io.InputStream getBinaryStream(int columnIndex) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2...
java.sql.SQLException
- if a database access error occursgetAsciiStream
,
getUnicodeStream
public java.io.InputStream getBinaryStream(java.lang.String columnName) throws java.sql.SQLException
getBinaryStream
in interface java.sql.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public java.sql.Blob getBlob(int columnIndex) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
columnIndex
- 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.ResultSet
colName
- the column name
java.sql.SQLException
- if an error occurs.public boolean getBoolean(int columnIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.ResultSet
columnIndex
- 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.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public byte getByte(int columnIndex) throws java.sql.SQLException
getByte
in interface java.sql.ResultSet
columnIndex
- 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.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public 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.ResultSet
columnIndex
- 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.SQLException
public byte[] getBytes(java.lang.String columnName) throws java.sql.SQLException
getBytes
in interface java.sql.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public int getBytesSize() throws java.sql.SQLException
getBytesSize
in interface ResultSetInternalMethods
java.sql.SQLException
protected java.util.Calendar getCalendarInstanceForSessionOrNew()
public 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.ResultSet
columnIndex
- the column to get the value from
java.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.ResultSet
columnName
- the column name to retrieve the value from
java.sql.SQLException
- if an error occurspublic java.sql.Clob getClob(int i) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
i
- 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.ResultSet
colName
- the column name
java.sql.SQLException
- if an error occurspublic int getConcurrency() throws java.sql.SQLException
getConcurrency
in interface java.sql.ResultSet
java.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.ResultSet
java.sql.SQLException
- if a database access error occurspublic java.sql.Date getDate(int columnIndex) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
columnIndex
- 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.ResultSet
columnIndex
- the first column is 1, the second is 2, ...cal
- the calendar to use in constructing the date
java.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.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public java.sql.Date getDate(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
columnName
- is the SQL name of the columncal
- the calendar to use in constructing the date
java.sql.SQLException
- if a database-access error occurs.public double getDouble(int columnIndex) throws java.sql.SQLException
getDouble
in interface java.sql.ResultSet
columnIndex
- 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.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!protected 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.ResultSet
java.sql.SQLException
- if a database-access error occurspublic int getFetchSize() throws java.sql.SQLException
getFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurspublic char getFirstCharOfQuery()
getFirstCharOfQuery
in interface ResultSetInternalMethods
public float getFloat(int columnIndex) throws java.sql.SQLException
getFloat
in interface java.sql.ResultSet
columnIndex
- 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.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public int getInt(int columnIndex) throws java.sql.SQLException
getInt
in interface java.sql.ResultSet
columnIndex
- 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.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public long getLong(int columnIndex) throws java.sql.SQLException
getLong
in interface java.sql.ResultSet
columnIndex
- 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.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.ResultSet
java.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 occurs
NotImplemented
- DOCUMENT ME!protected 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 occursgetBinaryStream
protected 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 decimal
java.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
,
getUnicodeStream
protected 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.SQLException
protected 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 from
java.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 date
java.sql.SQLException
- if a database-access error occurs.java.sql.Date getNativeDateViaParseConversion(int columnIndex) throws java.sql.SQLException
java.sql.SQLException
protected 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.SQLException
protected 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.SQLException
protected 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 implemented
NotImplemented
- DOCUMENT ME!protected 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.SQLException
protected 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.SQLException
java.sql.Timestamp getNativeTimestampViaParseConversion(int columnIndex, java.util.Calendar targetCalendar, java.util.TimeZone tz, boolean rollForward) throws java.sql.SQLException
java.sql.SQLException
protected 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
,
getBinaryStream
protected java.net.URL getNativeURL(int colIndex) throws java.sql.SQLException
java.sql.SQLException
ResultSet.getURL(int)
public ResultSetInternalMethods getNextResultSet()
getNextResultSet
in interface ResultSetInternalMethods
public 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.ResultSet
columnIndex
- the first column is 1, the second is 2...
java.sql.SQLException
- if a database access error occurspublic java.lang.Object getObject(int i, java.util.Map map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
i
- the first column is 1, the second is 2, ...map
- the mapping from SQL type names to Java classes
java.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.ResultSet
columnName
- is the SQL name of the column
java.sql.SQLException
- if a database access error occurspublic java.lang.Object getObject(java.lang.String colName, java.util.Map map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
colName
- the column namemap
- the mapping from SQL type names to Java classes
java.sql.SQLException
- as this is not implementedpublic java.lang.Object getObjectStoredProc(int columnIndex, int desiredSqlType) throws java.sql.SQLException
ResultSetInternalMethods
getObjectStoredProc
in interface ResultSetInternalMethods
java.sql.SQLException
public java.lang.Object getObjectStoredProc(int i, java.util.Map map, int desiredSqlType) throws java.sql.SQLException
ResultSetInternalMethods
getObjectStoredProc
in interface ResultSetInternalMethods
java.sql.SQLException
public java.lang.Object getObjectStoredProc(java.lang.String columnName, int desiredSqlType) throws java.sql.SQLException
ResultSetInternalMethods
getObjectStoredProc
in interface ResultSetInternalMethods
java.sql.SQLException
public java.lang.Object getObjectStoredProc(java.lang.String colName, java.util.Map map, int desiredSqlType) throws java.sql.SQLException
ResultSetInternalMethods
getObjectStoredProc
in interface ResultSetInternalMethods
java.sql.SQLException
public java.sql.Ref getRef(int i) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
i
- the first column is 1, the second is 2, ...
java.sql.SQLException
- as this is not implemented
NotImplemented
- DOCUMENT ME!public java.sql.Ref getRef(java.lang.String colName) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
colName
- the column name
java.sql.SQLException
- as this method is not implemented.
NotImplemented
- DOCUMENT ME!public 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.ResultSet
java.sql.SQLException
- if a database-access error occurs.public java.lang.String getServerInfo()
getServerInfo
in interface ResultSetInternalMethods
public short getShort(int columnIndex) throws java.sql.SQLException
getShort
in interface java.sql.ResultSet
columnIndex
- 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.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public java.sql.Statement getStatement() throws java.sql.SQLException
getStatement
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurspublic java.lang.String getString(int columnIndex) throws java.sql.SQLException
getString
in interface java.sql.ResultSet
columnIndex
- 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.ResultSet
columnName
- is the SQL name of the column
java.sql.SQLException
- if a database access error occursprotected java.lang.String getStringInternal(int columnIndex, boolean checkDateTypes) throws java.sql.SQLException
java.sql.SQLException
public java.sql.Time getTime(int columnIndex) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
columnIndex
- 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.ResultSet
columnIndex
- the first column is 1, the second is 2, ...cal
- the calendar to use in constructing the time
java.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.ResultSet
columnName
- is the SQL name of the column
java.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.ResultSet
columnName
- is the SQL name of the columncal
- the calendar to use in constructing the time
java.sql.SQLException
- if a database-access error occurs.public java.sql.Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
columnIndex
- 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.ResultSet
columnIndex
- the first column is 1, the second is 2, ...cal
- the calendar to use in constructing the timestamp
java.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.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public java.sql.Timestamp getTimestamp(java.lang.String columnName, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
columnName
- is the SQL name of the columncal
- the calendar to use in constructing the timestamp
java.sql.SQLException
- if a database-access error occurs.public int getType() throws java.sql.SQLException
getType
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurspublic java.io.InputStream getUnicodeStream(int columnIndex) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2...
java.sql.SQLException
- if a database access error occursgetAsciiStream
,
getBinaryStream
public java.io.InputStream getUnicodeStream(java.lang.String columnName) throws java.sql.SQLException
getUnicodeStream
in interface java.sql.ResultSet
columnName
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!public long getUpdateCount()
ResultSetInternalMethods
getUpdateCount
in interface ResultSetInternalMethods
public long getUpdateID()
ResultSetInternalMethods
getUpdateID
in interface ResultSetInternalMethods
public java.net.URL getURL(int colIndex) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
ResultSet.getURL(int)
public java.net.URL getURL(java.lang.String colName) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
ResultSet.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.ResultSet
java.sql.SQLException
- if a database access error occurs.public void insertRow() throws java.sql.SQLException
insertRow
in interface java.sql.ResultSet
java.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 value
NotUpdatable
- DOCUMENT ME!public boolean isAfterLast() throws java.sql.SQLException
Determine if the cursor is after the last row in the result set.
isAfterLast
in interface java.sql.ResultSet
java.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.ResultSet
java.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.ResultSet
java.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.ResultSet
java.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.ResultSet
java.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.ResultSet
java.sql.SQLException
- if a database-access error occurs, or the result set is
not updatable
NotUpdatable
- DOCUMENT ME!public void moveToInsertRow() throws java.sql.SQLException
moveToInsertRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or the result set is
not updatable
NotUpdatable
- DOCUMENT ME!public 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.ResultSet
java.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.ResultSet
java.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 ResultSetInternalMethods
calledExplicitly
- was this called by close()?
java.sql.SQLException
- if an error occurspublic boolean reallyResult()
ResultSetInternalMethods
reallyResult
in interface ResultSetInternalMethods
public void refreshRow() throws java.sql.SQLException
refreshRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or if called when on
the insert row.
NotUpdatable
- DOCUMENT ME!public 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.ResultSet
rows
- 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.ResultSet
java.sql.SQLException
- if a database-access error occurs
NotImplemented
- DOCUMENT ME!DatabaseMetaData.deletesAreDetected(int)
public boolean rowInserted() throws java.sql.SQLException
rowInserted
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs
NotImplemented
- DOCUMENT ME!DatabaseMetaData.insertsAreDetected(int)
public boolean rowUpdated() throws java.sql.SQLException
rowUpdated
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs
NotImplemented
- DOCUMENT ME!DatabaseMetaData.updatesAreDetected(int)
protected void setBinaryEncoded()
public void setFetchDirection(int direction) throws java.sql.SQLException
setFetchDirection
in interface java.sql.ResultSet
direction
- 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.ResultSet
rows
- the number of rows to fetch
java.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 ResultSetInternalMethods
c
- 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)
ResultSetInternalMethods
setOwningStatement
in interface ResultSetInternalMethods
protected 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 ResultSetInternalMethods
public void setWrapperStatement(java.sql.Statement wrapperStatement)
setWrapperStatement
in interface ResultSetInternalMethods
wrapperStatement
- The wrapperStatement to set.public java.lang.String toString()
toString
in class java.lang.Object
public void updateArray(int arg0, java.sql.Array arg1) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
ResultSet.updateArray(int, Array)
public void updateArray(java.lang.String arg0, java.sql.Array arg1) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
ResultSet.updateArray(String, Array)
public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column valuelength
- of the stream
java.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.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws java.sql.SQLException
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 updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnName
- the name of the columnx
- the new column valuelength
- of the stream
java.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.ResultSet
java.sql.SQLException
ResultSet.updateBlob(int, Blob)
public void updateBlob(java.lang.String arg0, java.sql.Blob arg1) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
ResultSet.updateBlob(String, Blob)
public void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateBoolean(java.lang.String columnName, boolean x) throws java.sql.SQLException
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(int columnIndex, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateByte(java.lang.String columnName, byte x) throws java.sql.SQLException
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 updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateBytes(java.lang.String columnName, byte[] x) throws java.sql.SQLException
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 updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column valuelength
- the length of the stream
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnName
- the name of the columnreader
- the stream to update the column withlength
- of the stream
java.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.ResultSet
java.sql.SQLException
ResultSet.updateClob(int, Clob)
public void updateClob(java.lang.String columnName, java.sql.Clob clob) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
ResultSet.updateClob(String, Clob)
public void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateDate(java.lang.String columnName, java.sql.Date x) throws java.sql.SQLException
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 updateDouble(int columnIndex, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateDouble(java.lang.String columnName, double x) throws java.sql.SQLException
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 updateFloat(int columnIndex, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateFloat(java.lang.String columnName, float x) throws java.sql.SQLException
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 updateInt(int columnIndex, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateInt(java.lang.String columnName, int x) throws java.sql.SQLException
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(int columnIndex, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateLong(java.lang.String columnName, long x) throws java.sql.SQLException
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 updateNull(int columnIndex) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateNull(java.lang.String columnName) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
columnName
- the name of the column
java.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.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnIndex
- 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 occurs
NotUpdatable
- DOCUMENT ME!public void updateObject(java.lang.String columnName, java.lang.Object x) throws java.sql.SQLException
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 updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws java.sql.SQLException
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. 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.ResultSet
java.sql.SQLException
ResultSet.updateRef(int, Ref)
public void updateRef(java.lang.String arg0, java.sql.Ref arg1) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
ResultSet.updateRef(String, Ref)
public void updateRow() throws java.sql.SQLException
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or if called when on
the insert row
NotUpdatable
- DOCUMENT ME!public void updateShort(int columnIndex, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateShort(java.lang.String columnName, short x) throws java.sql.SQLException
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 updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateString(java.lang.String columnName, java.lang.String x) throws java.sql.SQLException
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 updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateTime(java.lang.String columnName, java.sql.Time x) throws java.sql.SQLException
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(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
columnIndex
- the first column is 1, the second is 2, ...x
- the new column value
java.sql.SQLException
- if a database-access error occurs
NotUpdatable
- DOCUMENT ME!public void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x) throws java.sql.SQLException
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 boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.ResultSet
java.sql.SQLException
- if a database access error occurredprotected java.util.Calendar getGmtCalendar()
protected ExceptionInterceptor getExceptionInterceptor()
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |