|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.mysql.jdbc.ResultSet
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 |
columnNameToIndex
Map column names (and all of their permutations) to column indices |
protected boolean[] |
columnUsed
Keep track of columns accessed |
protected Connection |
connection
The Connection instance that created us |
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? |
protected com.mysql.jdbc.profiler.ProfileEventSink |
eventSink
|
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 ResultSet |
nextResultSet
|
protected boolean |
onInsertRow
Are we on the insert row? |
protected Statement |
owningStatement
The statement that created us |
protected java.lang.Throwable |
pointOfOrigin
StackTrace generated where ResultSet was created... |
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). |
protected java.util.Calendar |
sessionCalendar
|
protected java.lang.Object[] |
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 |
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 | |
ResultSet(long updateCount,
long updateID,
Connection conn,
Statement creatorStmt)
Create a result set for an executeUpdate statement. |
|
ResultSet(java.lang.String catalog,
Field[] fields,
RowData tuples,
Connection conn,
Statement creatorStmt)
Creates a new ResultSet object. |
Method Summary | |
boolean |
absolute(int row)
JDBC 2.0 |
void |
afterLast()
JDBC 2.0 |
void |
beforeFirst()
JDBC 2.0 |
protected 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 |
protected 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. |
protected ResultSet |
copy()
|
void |
deleteRow()
JDBC 2.0 Delete the current row from the result set and the underlying database. |
int |
findColumn(java.lang.String columnName)
Map a ResultSet column name to a ResultSet column index |
boolean |
first()
JDBC 2.0 |
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 strea. |
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! |
java.io.Reader |
getCharacterStream(int columnIndex)
JDBC 2.0 |
java.io.Reader |
getCharacterStream(java.lang.String columnName)
JDBC 2.0 |
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 |
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. |
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. |
protected 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()
|
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 strea. |
protected java.sql.Blob |
getNativeBlob(int columnIndex)
JDBC 2.0 Get a BLOB column. |
protected boolean |
getNativeBoolean(int columnIndex)
Get the value of a column in the current row as a Java boolean |
protected byte |
getNativeByte(int columnIndex)
Get the value of a column in the current row as a Java byte. |
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 |
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.TimeZone tz)
JDBC 2.0 Get the value of a column in the current row as a java.sql.Date object. |
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 long |
getNativeLong(int columnIndex)
Get the value of a column in the current row as a Java long. |
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 java.lang.String |
getNativeString(int columnIndex)
Get the value of a column in the current row as a Java String |
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)
|
protected ResultSet |
getNextResultSet()
DOCUMENT ME! |
java.lang.Object |
getObject(int columnIndex)
Get the value of a column in the current row 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 |
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. |
protected java.lang.Object |
getObjectStoredProc(int columnIndex,
int desiredSqlType)
|
protected java.lang.Object |
getObjectStoredProc(int i,
java.util.Map map,
int desiredSqlType)
|
protected java.lang.Object |
getObjectStoredProc(java.lang.String columnName,
int desiredSqlType)
|
protected java.lang.Object |
getObjectStoredProc(java.lang.String colName,
java.util.Map map,
int desiredSqlType)
|
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 |
protected 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. |
(package private) long |
getUpdateCount()
|
(package private) long |
getUpdateID()
|
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 |
insertRow()
JDBC 2.0 Insert the contents of the insert row into the result set and the database. |
boolean |
isAfterLast()
JDBC 2.0 |
boolean |
isBeforeFirst()
JDBC 2.0 |
boolean |
isFirst()
JDBC 2.0 |
boolean |
isLast()
JDBC 2.0 |
boolean |
last()
JDBC 2.0 |
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. |
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 |
protected void |
realClose(boolean calledExplicitly)
Closes this ResultSet and releases resources. |
(package private) boolean |
reallyResult()
|
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 |
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. |
protected void |
setFirstCharOfQuery(char c)
Sets the first character of the query that this result set was created from. |
protected void |
setNextResultSet(ResultSet nextResultSet)
DOCUMENT ME! |
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 |
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 |
Field Detail |
protected static int resultCounter
protected java.lang.String catalog
protected java.util.Map columnNameToIndex
protected boolean[] columnUsed
protected Connection connection
protected int currentRow
protected boolean doingUpdates
protected com.mysql.jdbc.profiler.ProfileEventSink eventSink
protected int fetchDirection
protected int fetchSize
protected Field[] fields
protected char firstCharOfQuery
protected java.util.Map fullColumnNameToIndex
protected boolean hasBuiltIndexMapping
protected boolean isBinaryEncoded
protected boolean isClosed
protected ResultSet nextResultSet
protected boolean onInsertRow
protected Statement 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
protected java.util.Calendar sessionCalendar
protected java.util.Calendar gmtCalendar
protected java.lang.Object[] 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
Constructor Detail |
public ResultSet(long updateCount, long updateID, Connection conn, Statement creatorStmt)
updateCount
- the number of rows affected by the updateupdateID
- the autoincrement value (if any)conn
- DOCUMENT ME!creatorStmt
- DOCUMENT ME!public ResultSet(java.lang.String catalog, Field[] fields, RowData tuples, Connection conn, Statement 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)
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_ONLYprotected void buildIndexMapping() throws java.sql.SQLException
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 traversalprotected void clearNextResult()
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 occursprotected final ResultSet copy() throws java.sql.SQLException
java.sql.SQLException
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!public int findColumn(java.lang.String columnName) throws java.sql.SQLException
findColumn
in interface java.sql.ResultSet
columnName
- the name of the column
java.sql.SQLException
- if a database access error occurspublic 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 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 occursprotected char getFirstCharOfQuery()
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.protected boolean getNativeBoolean(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) throws java.sql.SQLException
columnIndex
- the first column is 1, the second is 2,...
java.sql.SQLException
- if a database access error occursprotected 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.TimeZone tz) 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.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 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 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 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 occursprotected 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
getURL(int)
protected ResultSet getNextResultSet()
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 implementedprotected java.lang.Object getObjectStoredProc(int columnIndex, int desiredSqlType) throws java.sql.SQLException
java.sql.SQLException
protected java.lang.Object getObjectStoredProc(int i, java.util.Map map, int desiredSqlType) throws java.sql.SQLException
java.sql.SQLException
protected java.lang.Object getObjectStoredProc(java.lang.String columnName, int desiredSqlType) throws java.sql.SQLException
java.sql.SQLException
protected java.lang.Object getObjectStoredProc(java.lang.String colName, java.util.Map map, int desiredSqlType) throws java.sql.SQLException
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.protected java.lang.String getServerInfo()
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!long getUpdateCount()
long getUpdateID()
public java.net.URL getURL(int colIndex) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
getURL(int)
public java.net.URL getURL(java.lang.String colName) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
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.protected void realClose(boolean calledExplicitly) throws java.sql.SQLException
calledExplicitly
- was this called by close()?
java.sql.SQLException
- if an error occursboolean reallyResult()
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.protected void setFirstCharOfQuery(char c)
c
- the first character of the query...uppercasedprotected void setNextResultSet(ResultSet nextResultSet)
nextResultSet
- Sets the next result set in the result set chain for multiple
result sets.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 setWrapperStatement(java.sql.Statement wrapperStatement)
wrapperStatement
- The wrapperStatement to set.public java.lang.String toString()
public void updateArray(int arg0, java.sql.Array arg1) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
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
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
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
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
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
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
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
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()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |