| java.lang.Object
 com.mysql.jdbc.ResultSetImpl
All known Subclasses: com.mysql.jdbc.JDBC4ResultSet, com.mysql.jdbc.UpdatableResultSet,
| ResultSetImpl | | public class ResultSetImpl implements ResultSetInternalMethods(Code) | | 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.
author:
Mark Matthews
version:
$Id: ResultSetImpl.java 6576 2007-09-07 16:11:05Z mmatthews $
See Also: ResultSetMetaData
See Also: java.sql.ResultSet |
| Method Summary | |
| public boolean | absolute(int row)
JDBC 2.0
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. | | public void | afterLast()
JDBC 2.0
Moves to the end of the result set, just after the last row. | | public static boolean | arraysEqual(byte[] left, byte[] right)
| | public void | beforeFirst()
JDBC 2.0
Moves to the front of the result set, just before the first row. | | public void | buildIndexMapping()
Builds a hash between column names and their indices for fast retrieval. | | public 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. | | final protected void | checkClosed()
| | final protected void | checkColumnBounds(int columnIndex)
Checks if columnIndex is within the number of columns in this result set. | | protected void | checkRowPos()
| | public void | clearNextResult()
We can't do this ourselves, otherwise the contract for
Statement.getMoreResults() won't work correctly. | | public void | clearWarnings()
| | public 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 BigInteger | convertLongToUlong(long longVal)
Converts the given value as a java long, to an 'unsigned' long, using the
java.math.BigInteger class. | | public ResultSetInternalMethods | copy()
| | public void | deleteRow()
JDBC 2.0 Delete the current row from the result set and the underlying
database. | | protected synchronized Date | fastDateCreate(Calendar cal, int year, int month, int day)
| | protected synchronized Time | fastTimeCreate(Calendar cal, int hour, int minute, int second)
| | protected synchronized Timestamp | fastTimestampCreate(Calendar cal, int year, int month, int day, int hour, int minute, int seconds, int secondsPart)
| | public synchronized int | findColumn(String columnName)
| | public boolean | first()
JDBC 2.0
Moves to the first row in the result set. | | public java.sql.Array | getArray(int i)
JDBC 2.0 Get an array column.
Parameters:
i - the first column is 1, the second is 2, ... | | public java.sql.Array | getArray(String colName)
JDBC 2.0 Get an array column. | | public InputStream | getAsciiStream(int columnIndex)
A column value can be retrieved as a stream of ASCII characters and then
read in chunks from the stream. | | public InputStream | getAsciiStream(String columnName)
| | public BigDecimal | getBigDecimal(int columnIndex)
JDBC 2.0 Get the value of a column in the current row as a
java.math.BigDecimal object.
Parameters:
columnIndex - the first column is 1, the second is 2, ... | | public BigDecimal | getBigDecimal(int columnIndex, int scale)
| | public BigDecimal | getBigDecimal(String columnName)
JDBC 2.0 Get the value of a column in the current row as a
java.math.BigDecimal object. | | public BigDecimal | getBigDecimal(String columnName, int scale)
| | public InputStream | getBinaryStream(int columnIndex)
A column value can also be retrieved as a binary stream. | | public InputStream | getBinaryStream(String columnName)
| | public java.sql.Blob | getBlob(int columnIndex)
JDBC 2.0 Get a BLOB column.
Parameters:
columnIndex - the first column is 1, the second is 2, ... | | public java.sql.Blob | getBlob(String colName)
JDBC 2.0 Get a BLOB column. | | public boolean | getBoolean(int columnIndex)
Get the value of a column in the current row as a Java boolean
Parameters:
columnIndex - the first column is 1, the second is 2... | | public boolean | getBoolean(String columnName)
| | public byte | getByte(int columnIndex)
Get the value of a column in the current row as a Java byte.
Parameters:
columnIndex - the first column is 1, the second is 2,... | | public byte | getByte(String columnName)
| | public byte[] | getBytes(int columnIndex)
Get the value of a column in the current row as a Java byte array.
Be warned If the blob is huge, then you may run out of memory.
Parameters:
columnIndex - the first column is 1, the second is 2, ... | | protected byte[] | getBytes(int columnIndex, boolean noConversion)
| | public byte[] | getBytes(String columnName)
| | protected Calendar | getCalendarInstanceForSessionOrNew()
| | public java.io.Reader | getCharacterStream(int columnIndex)
JDBC 2.0
Get the value of a column in the current row as a java.io.Reader. | | public java.io.Reader | getCharacterStream(String columnName)
JDBC 2.0
Get the value of a column in the current row as a java.io.Reader. | | public java.sql.Clob | getClob(int i)
JDBC 2.0 Get a CLOB column.
Parameters:
i - the first column is 1, the second is 2, ... | | public java.sql.Clob | getClob(String colName)
JDBC 2.0 Get a CLOB column. | | public int | getConcurrency()
JDBC 2.0 Return the concurrency of this result set. | | public 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. | | public java.sql.Date | getDate(int columnIndex)
Get the value of a column in the current row as a java.sql.Date object
Parameters:
columnIndex - the first column is 1, the second is 2... | | public java.sql.Date | getDate(int columnIndex, Calendar cal)
JDBC 2.0 Get the value of a column in the current row as a java.sql.Date
object. | | public java.sql.Date | getDate(String columnName)
| | public java.sql.Date | getDate(String columnName, Calendar cal)
Get the value of a column in the current row as a java.sql.Date object. | | public double | getDouble(int columnIndex)
Get the value of a column in the current row as a Java double.
Parameters:
columnIndex - the first column is 1, the second is 2,... | | public double | getDouble(String columnName)
| | protected double | getDoubleInternal(int colIndex)
Converts a string representation of a number to a double. | | protected double | getDoubleInternal(String stringVal, int colIndex)
Converts a string representation of a number to a double. | | public int | getFetchDirection()
JDBC 2.0 Returns the fetch direction for this result set. | | public int | getFetchSize()
JDBC 2.0 Return the fetch size for this result set. | | public char | getFirstCharOfQuery()
Returns the first character of the query that this result set was created
from. | | public float | getFloat(int columnIndex)
Get the value of a column in the current row as a Java float.
Parameters:
columnIndex - the first column is 1, the second is 2,... | | public float | getFloat(String columnName)
| | protected Calendar | getGmtCalendar()
| | protected static ResultSetImpl | getInstance(long updateCount, long updateID, ConnectionImpl conn, StatementImpl creatorStmt)
| | protected static ResultSetImpl | getInstance(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. | | public int | getInt(int columnIndex)
Get the value of a column in the current row as a Java int.
Parameters:
columnIndex - the first column is 1, the second is 2,... | | public int | getInt(String columnName)
| | public long | getLong(int columnIndex)
Get the value of a column in the current row as a Java long.
Parameters:
columnIndex - the first column is 1, the second is 2,... | | public long | getLong(String columnName)
| | public java.sql.ResultSetMetaData | getMetaData()
| | protected java.sql.Array | getNativeArray(int i)
JDBC 2.0 Get an array column.
Parameters:
i - the first column is 1, the second is 2, ... | | protected 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 BigDecimal | getNativeBigDecimal(int columnIndex)
JDBC 2.0 Get the value of a column in the current row as a
java.math.BigDecimal object.
Parameters:
columnIndex - the first column is 1, the second is 2, ... | | protected BigDecimal | getNativeBigDecimal(int columnIndex, int scale)
| | protected 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.
Parameters:
columnIndex - the first column is 1, the second is 2, ... | | protected byte | getNativeByte(int columnIndex)
Get the value of a column in the current row as a Java byte.
Parameters:
columnIndex - the first column is 1, the second is 2,... | | 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.
Be warned If the blob is huge, then you may run out of memory.
Parameters:
columnIndex - the first column is 1, the second is 2, ... | | 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.
Parameters:
columnIndex - the first column is 1, the second is 2, ... | | protected java.sql.Date | getNativeDate(int columnIndex)
Get the value of a column in the current row as a java.sql.Date object
Parameters:
columnIndex - the first column is 1, the second is 2... | | protected java.sql.Date | getNativeDate(int columnIndex, TimeZone tz)
JDBC 2.0 Get the value of a column in the current row as a java.sql.Date
object. | | 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.
Parameters:
columnIndex - the first column is 1, the second is 2,... | | protected float | getNativeFloat(int columnIndex)
Get the value of a column in the current row as a Java float.
Parameters:
columnIndex - the first column is 1, the second is 2,... | | protected int | getNativeInt(int columnIndex)
Get the value of a column in the current row as a Java int.
Parameters:
columnIndex - the first column is 1, the second is 2,... | | 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.
Parameters:
columnIndex - the first column is 1, the second is 2,... | | 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.
Parameters:
i - the first column is 1, the second is 2, ... | | protected short | getNativeShort(int columnIndex)
Get the value of a column in the current row as a Java short.
Parameters:
columnIndex - the first column is 1, the second is 2,... | | protected short | getNativeShort(int columnIndex, boolean overflowCheck)
| | protected String | getNativeString(int columnIndex)
Get the value of a column in the current row as a Java String
Parameters:
columnIndex - the first column is 1, the second is 2... | | Time | getNativeTimeViaParseConversion(int columnIndex, Calendar targetCalendar, TimeZone tz, boolean rollForward)
| | Timestamp | getNativeTimestampViaParseConversion(int columnIndex, Calendar targetCalendar, TimeZone tz, boolean rollForward)
| | protected URL | getNativeURL(int colIndex)
| | protected InputStream | getNativeUnicodeStream(int columnIndex)
A column value can also be retrieved as a stream of Unicode characters.
We implement this as a binary stream.
Parameters:
columnIndex - the first column is 1, the second is 2... | | public ResultSetInternalMethods | getNextResultSet()
| | public 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.
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.
Parameters:
columnIndex - the first column is 1, the second is 2... | | public Object | getObject(int i, java.util.Map map)
JDBC 2.0 Returns the value of column i as a Java object. | | public Object | getObject(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. | | public Object | getObject(String colName, java.util.Map map)
JDBC 2.0 Returns the value of column i as a Java object. | | public Object | getObjectStoredProc(int columnIndex, int desiredSqlType)
| | public Object | getObjectStoredProc(int i, java.util.Map map, int desiredSqlType)
| | public Object | getObjectStoredProc(String columnName, int desiredSqlType)
| | public Object | getObjectStoredProc(String colName, java.util.Map map, int desiredSqlType)
| | public java.sql.Ref | getRef(int i)
JDBC 2.0 Get a REF(<structured-type>) column.
Parameters:
i - the first column is 1, the second is 2, ... | | public java.sql.Ref | getRef(String colName)
JDBC 2.0 Get a REF(<structured-type>) column. | | public int | getRow()
JDBC 2.0
Determine the current row number. | | public String | getServerInfo()
Returns the server info (if any), or null if none. | | public short | getShort(int columnIndex)
Get the value of a column in the current row as a Java short.
Parameters:
columnIndex - the first column is 1, the second is 2,... | | public short | getShort(String columnName)
| | public java.sql.Statement | getStatement()
JDBC 2.0 Return the Statement that produced the ResultSet. | | public String | getString(int columnIndex)
Get the value of a column in the current row as a Java String
Parameters:
columnIndex - the first column is 1, the second is 2... | | public String | getString(String columnName)
The following routines simply convert the columnName into a columnIndex
and then call the appropriate routine above. | | protected String | getStringInternal(int columnIndex, boolean checkDateTypes)
| | public Time | getTime(int columnIndex)
Get the value of a column in the current row as a java.sql.Time object
Parameters:
columnIndex - the first column is 1, the second is 2... | | public java.sql.Time | getTime(int columnIndex, Calendar cal)
Get the value of a column in the current row as a java.sql.Time object. | | public Time | getTime(String columnName)
Get the value of a column in the current row as a java.sql.Time object. | | public java.sql.Time | getTime(String columnName, Calendar cal)
Get the value of a column in the current row as a java.sql.Time object. | | public Timestamp | getTimestamp(int columnIndex)
Get the value of a column in the current row as a java.sql.Timestamp
object
Parameters:
columnIndex - the first column is 1, the second is 2... | | public java.sql.Timestamp | getTimestamp(int columnIndex, Calendar cal)
Get the value of a column in the current row as a java.sql.Timestamp
object. | | public Timestamp | getTimestamp(String columnName)
| | public java.sql.Timestamp | getTimestamp(String columnName, Calendar cal)
Get the value of a column in the current row as a java.sql.Timestamp
object. | | public int | getType()
JDBC 2.0 Return the type of this result set. | | public URL | getURL(int colIndex)
| | public URL | getURL(String colName)
| | public InputStream | getUnicodeStream(int columnIndex)
A column value can also be retrieved as a stream of Unicode characters.
We implement this as a binary stream.
Parameters:
columnIndex - the first column is 1, the second is 2... | | public InputStream | getUnicodeStream(String columnName)
| | public long | getUpdateCount()
| | public long | getUpdateID()
| | public java.sql.SQLWarning | getWarnings()
The first warning reported by calls on this ResultSet is returned.
Subsequent ResultSet warnings will be chained to this
java.sql.SQLWarning.
The warning chain is automatically cleared each time a new row is read.
Note: This warning chain only covers warnings caused by ResultSet
methods. | | public void | initializeFromCachedMetaData(CachedResultSetMetaData cachedMetaData)
| | public void | initializeWithMetadata()
| | public void | insertRow()
JDBC 2.0 Insert the contents of the insert row into the result set and
the database. | | public boolean | isAfterLast()
JDBC 2.0
Determine if the cursor is after the last row in the result set.
true if after the last row, false otherwise. | | public boolean | isBeforeFirst()
JDBC 2.0
Determine if the cursor is before the first row in the result set.
true if before the first row, false otherwise. | | public boolean | isFirst()
JDBC 2.0
Determine if the cursor is on the first row of the result set. | | public boolean | isLast()
JDBC 2.0
Determine if the cursor is on the last row of the result set. | | public boolean | last()
JDBC 2.0
Moves to the last row in the result set. | | public void | moveToCurrentRow()
JDBC 2.0 Move the cursor to the remembered cursor position, usually the
current row. | | public void | moveToInsertRow()
JDBC 2.0 Move to the insert row. | | public 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.
If an input stream from the previous row is open, it is implicitly
closed. | | public void | populateCachedMetaData(CachedResultSetMetaData cachedMetaData)
| | public 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.
If an input stream from the previous row is open, it is implicitly
closed. | | public boolean | previous()
JDBC 2.0
Moves to the previous row in the result set. | | public void | realClose(boolean calledExplicitly)
Closes this ResultSet and releases resources. | | public boolean | reallyResult()
| | public void | redefineFieldsForDBMD(Field[] f)
| | public void | refreshRow()
JDBC 2.0 Refresh the value of the current row with its current value in
the database. | | public boolean | relative(int rows)
JDBC 2.0
Moves a relative number of rows, either positive or negative. | | public boolean | rowDeleted()
JDBC 2.0 Determine if this row has been deleted. | | public boolean | rowInserted()
JDBC 2.0 Determine if the current row has been inserted. | | public 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. | | public 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. | | public 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. | | public void | setFirstCharOfQuery(char c)
Sets the first character of the query that this result set was created
from. | | protected void | setNextResultSet(ResultSetInternalMethods nextResultSet)
| | public void | setOwningStatement(com.mysql.jdbc.StatementImpl owningStatement)
| | protected void | setResultSetConcurrency(int concurrencyFlag)
| | protected void | setResultSetType(int typeFlag)
| | protected void | setServerInfo(String info)
| | public void | setStatementUsedForFetchingRows(PreparedStatement stmt)
| | public void | setWrapperStatement(java.sql.Statement wrapperStatement)
| | public String | toString()
| | public void | updateArray(int arg0, Array arg1)
| | public void | updateArray(String arg0, Array arg1)
| | public void | updateAsciiStream(int columnIndex, java.io.InputStream x, int length)
JDBC 2.0 Update a column with an ascii stream value. | | public void | updateAsciiStream(String columnName, java.io.InputStream x, int length)
JDBC 2.0 Update a column with an ascii stream value. | | public void | updateBigDecimal(int columnIndex, BigDecimal x)
JDBC 2.0 Update a column with a BigDecimal value. | | public void | updateBigDecimal(String columnName, BigDecimal x)
JDBC 2.0 Update a column with a BigDecimal value. | | public void | updateBinaryStream(int columnIndex, java.io.InputStream x, int length)
JDBC 2.0 Update a column with a binary stream value. | | public void | updateBinaryStream(String columnName, java.io.InputStream x, int length)
JDBC 2.0 Update a column with a binary stream value. | | public void | updateBlob(int arg0, java.sql.Blob arg1)
| | public void | updateBlob(String arg0, java.sql.Blob arg1)
| | public void | updateBoolean(int columnIndex, boolean x)
JDBC 2.0 Update a column with a boolean value. | | public void | updateBoolean(String columnName, boolean x)
JDBC 2.0 Update a column with a boolean value. | | public void | updateByte(int columnIndex, byte x)
JDBC 2.0 Update a column with a byte value. | | public void | updateByte(String columnName, byte x)
JDBC 2.0 Update a column with a byte value. | | public void | updateBytes(int columnIndex, byte[] x)
JDBC 2.0 Update a column with a byte array value. | | public void | updateBytes(String columnName, byte[] x)
JDBC 2.0 Update a column with a byte array value. | | public void | updateCharacterStream(int columnIndex, java.io.Reader x, int length)
JDBC 2.0 Update a column with a character stream value. | | public void | updateCharacterStream(String columnName, java.io.Reader reader, int length)
JDBC 2.0 Update a column with a character stream value. | | public void | updateClob(int arg0, java.sql.Clob arg1)
| | public void | updateClob(String columnName, java.sql.Clob clob)
| | public void | updateDate(int columnIndex, java.sql.Date x)
JDBC 2.0 Update a column with a Date value. | | public void | updateDate(String columnName, java.sql.Date x)
JDBC 2.0 Update a column with a Date value. | | public void | updateDouble(int columnIndex, double x)
JDBC 2.0 Update a column with a Double value. | | public void | updateDouble(String columnName, double x)
JDBC 2.0 Update a column with a double value. | | public void | updateFloat(int columnIndex, float x)
JDBC 2.0 Update a column with a float value. | | public void | updateFloat(String columnName, float x)
JDBC 2.0 Update a column with a float value. | | public void | updateInt(int columnIndex, int x)
JDBC 2.0 Update a column with an integer value. | | public void | updateInt(String columnName, int x)
JDBC 2.0 Update a column with an integer value. | | public void | updateLong(int columnIndex, long x)
JDBC 2.0 Update a column with a long value. | | public void | updateLong(String columnName, long x)
JDBC 2.0 Update a column with a long value. | | public void | updateNull(int columnIndex)
JDBC 2.0 Give a nullable column a null value. | | public void | updateNull(String columnName)
JDBC 2.0 Update a column with a null value. | | public void | updateObject(int columnIndex, Object x)
JDBC 2.0 Update a column with an Object value. | | public void | updateObject(int columnIndex, Object x, int scale)
JDBC 2.0 Update a column with an Object value. | | public void | updateObject(String columnName, Object x)
JDBC 2.0 Update a column with an Object value. | | public void | updateObject(String columnName, Object x, int scale)
JDBC 2.0 Update a column with an Object value. | | public void | updateRef(int arg0, Ref arg1)
| | public void | updateRef(String arg0, Ref arg1)
| | public void | updateRow()
JDBC 2.0 Update the underlying database with the new contents of the
current row. | | public void | updateShort(int columnIndex, short x)
JDBC 2.0 Update a column with a short value. | | public void | updateShort(String columnName, short x)
JDBC 2.0 Update a column with a short value. | | public void | updateString(int columnIndex, String x)
JDBC 2.0 Update a column with a String value. | | public void | updateString(String columnName, String x)
JDBC 2.0 Update a column with a String value. | | public void | updateTime(int columnIndex, java.sql.Time x)
JDBC 2.0 Update a column with a Time value. | | public void | updateTime(String columnName, java.sql.Time x)
JDBC 2.0 Update a column with a Time value. | | public void | updateTimestamp(int columnIndex, java.sql.Timestamp x)
JDBC 2.0 Update a column with a Timestamp value. | | public void | updateTimestamp(String columnName, java.sql.Timestamp x)
JDBC 2.0 Update a column with a Timestamp value. | | public boolean | wasNull()
A column may have the value of SQL NULL; wasNull() reports whether the
last column read had this special value. |
| EMPTY_SPACE | | final protected static char[] EMPTY_SPACE(Code) | | |
| MAX_DIFF_PREC | | final protected static double MAX_DIFF_PREC(Code) | | Epsillon between Float.MAX_VALUE and the double representation of said value.
|
| MIN_DIFF_PREC | | final protected static double MIN_DIFF_PREC(Code) | | Epsillon between Float.MIN_VALUE and the double representation of said value.
|
| catalog | | protected String catalog(Code) | | The catalog that was in use when we were created
|
| columnNameToIndex | | protected Map columnNameToIndex(Code) | | Map column names (and all of their permutations) to column indices
|
| columnUsed | | protected boolean[] columnUsed(Code) | | Keep track of columns accessed
|
| connectionId | | protected long connectionId(Code) | | |
| currentRow | | protected int currentRow(Code) | | The current row #, -1 == before start of result set
|
| doingUpdates | | protected boolean doingUpdates(Code) | | Are we in the middle of doing updates to the current row?
|
| fetchDirection | | protected int fetchDirection(Code) | | The direction to fetch rows (always FETCH_FORWARD)
|
| fetchSize | | protected int fetchSize(Code) | | The number of rows to fetch in one go...
|
| fields | | protected Field[] fields(Code) | | The fields for this result set
|
| firstCharOfQuery | | protected char firstCharOfQuery(Code) | | First character of the query that created this result set...Used to
determine whether or not to parse server info messages in certain
circumstances.
|
| fullColumnNameToIndex | | protected Map fullColumnNameToIndex(Code) | | Map of fully-specified column names to column indices
|
| hasBuiltIndexMapping | | protected boolean hasBuiltIndexMapping(Code) | | |
| isBinaryEncoded | | protected boolean isBinaryEncoded(Code) | | Is the data stored as strings (default) or natively (which is the case
with results from PrepStmts)
|
| isClosed | | protected boolean isClosed(Code) | | Has this result set been closed?
|
| onInsertRow | | protected boolean onInsertRow(Code) | | Are we on the insert row?
|
| pointOfOrigin | | protected Throwable pointOfOrigin(Code) | | StackTrace generated where ResultSet was created... used when profiling
|
| profileSql | | protected boolean profileSql(Code) | | Are we tracking items for profileSql?
|
| reallyResult | | protected boolean reallyResult(Code) | | Do we actually contain rows, or just information about
UPDATE/INSERT/DELETE?
|
| resultCounter | | protected static int resultCounter(Code) | | Counter used to generate IDs for profiling.
|
| resultId | | protected int resultId(Code) | | The id (used when profiling) to identify us
|
| resultSetConcurrency | | protected int resultSetConcurrency(Code) | | Are we read-only or updatable?
|
| resultSetType | | protected int resultSetType(Code) | | Are we scroll-sensitive/insensitive?
|
| retainOwningStatement | | protected boolean retainOwningStatement(Code) | | |
| serverInfo | | protected String serverInfo(Code) | | Any info message from the server that was created while generating this
result set (if 'info parsing' is enabled for the connection).
|
| updateCount | | protected long updateCount(Code) | | How many rows were affected by UPDATE/INSERT/DELETE?
|
| updateId | | protected long updateId(Code) | | Value generated for AUTO_INCREMENT columns
|
| useFastDateParsing | | protected boolean useFastDateParsing(Code) | | |
| useUsageAdvisor | | protected boolean useUsageAdvisor(Code) | | |
| wasNullFlag | | protected boolean wasNullFlag(Code) | | Did the previous value retrieval find a NULL?
|
| ResultSetImpl | | public ResultSetImpl(long updateCount, long updateID, ConnectionImpl conn, StatementImpl creatorStmt)(Code) | | Create a result set for an executeUpdate statement.
Parameters:
updateCount - the number of rows affected by the update
Parameters:
updateID - the autoincrement value (if any)
Parameters:
conn - DOCUMENT ME!
Parameters:
creatorStmt - DOCUMENT ME! |
| ResultSetImpl | | public ResultSetImpl(String catalog, Field[] fields, RowData tuples, ConnectionImpl conn, StatementImpl creatorStmt) throws SQLException(Code) | | Creates a new ResultSet object.
Parameters:
catalog - the database in use when we were created
Parameters:
fields - an array of Field objects (basically, the ResultSet MetaData)
Parameters:
tuples - actual row data
Parameters:
conn - the Connection that created us.
Parameters:
creatorStmt - DOCUMENT ME!
throws:
SQLException - if an error occurs |
| absolute | | public boolean absolute(int row) throws SQLException(Code) | | JDBC 2.0
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().
Parameters:
row - the row number to move to true if on the result set, false if off.
exception:
SQLException - if a database-access error occurs, or row is 0, or resultset type is TYPE_FORWARD_ONLY. |
| afterLast | | public void afterLast() throws SQLException(Code) | | JDBC 2.0
Moves to the end of the result set, just after the last row. Has no
effect if the result set contains no rows.
exception:
SQLException - if a database-access error occurs, or result set type isTYPE_FORWARD_ONLY. |
| arraysEqual | | public static boolean arraysEqual(byte[] left, byte[] right)(Code) | | |
| beforeFirst | | public void beforeFirst() throws SQLException(Code) | | JDBC 2.0
Moves to the front of the result set, just before the first row. Has no
effect if the result set contains no rows.
exception:
SQLException - if a database-access error occurs, or result set type isTYPE_FORWARD_ONLY |
| buildIndexMapping | | public void buildIndexMapping() throws SQLException(Code) | | Builds a hash between column names and their indices for fast retrieval.
|
| cancelRowUpdates | | public void cancelRowUpdates() throws SQLException(Code) | | 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. If no updates have been made or updateRow() has
already been called, then this method has no effect.
exception:
SQLException - if a database-access error occurs, or if called when onthe insert row.
throws:
NotUpdatable - DOCUMENT ME! |
| checkClosed | | final protected void checkClosed() throws SQLException(Code) | | Ensures that the result set is not closed
throws:
SQLException - if the result set is closed |
| checkColumnBounds | | final protected void checkColumnBounds(int columnIndex) throws SQLException(Code) | | Checks if columnIndex is within the number of columns in this result set.
Parameters:
columnIndex - the index to check
throws:
SQLException - if the index is out of bounds |
| checkRowPos | | protected void checkRowPos() throws SQLException(Code) | | Ensures that the cursor is positioned on a valid row and that the result
set is not closed
throws:
SQLException - if the result set is not in a valid state for traversal |
| clearNextResult | | public void clearNextResult()(Code) | | We can't do this ourselves, otherwise the contract for
Statement.getMoreResults() won't work correctly.
|
| clearWarnings | | public void clearWarnings() throws SQLException(Code) | | After this call, getWarnings returns null until a new warning is reported
for this ResultSet
exception:
SQLException - if a database access error occurs |
| close | | public void close() throws SQLException(Code) | | 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. The close method provides this immediate
release.
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.
exception:
SQLException - if a database access error occurs |
| convertLongToUlong | | protected static BigInteger convertLongToUlong(long longVal)(Code) | | Converts the given value as a java long, to an 'unsigned' long, using the
java.math.BigInteger class.
|
| deleteRow | | public void deleteRow() throws SQLException(Code) | | JDBC 2.0 Delete the current row from the result set and the underlying
database. Cannot be called when on the insert row.
exception:
SQLException - if a database-access error occurs, or if called when onthe insert row.
throws:
NotUpdatable - DOCUMENT ME! |
| fastDateCreate | | protected synchronized Date fastDateCreate(Calendar cal, int year, int month, int day)(Code) | | |
| fastTimestampCreate | | protected synchronized Timestamp fastTimestampCreate(Calendar cal, int year, int month, int day, int hour, int minute, int seconds, int secondsPart)(Code) | | |
| findColumn | | public synchronized int findColumn(String columnName) throws SQLException(Code) | | Map a ResultSet column name to a ResultSet column index
Parameters:
columnName - the name of the column the column index
exception:
SQLException - if a database access error occurs |
| first | | public boolean first() throws SQLException(Code) | | JDBC 2.0
Moves to the first row in the result set.
true if on a valid row, false if no rows in the result set.
exception:
SQLException - if a database-access error occurs, or result set type isTYPE_FORWARD_ONLY. |
| getAsciiStream | | public InputStream getAsciiStream(int columnIndex) throws SQLException(Code) | | A column value can be retrieved as a stream of ASCII characters and then
read in chunks from the stream. This method is particulary suitable for
retrieving large LONGVARCHAR values. The JDBC driver will do any
necessary conversion from the database format into ASCII.
Note: All the data in the returned stream must be read prior to
getting the value of any other column. The next call to a get method
implicitly closes the stream. Also, a stream may return 0 for available()
whether there is data available or not.
Parameters:
columnIndex - the first column is 1, the second is 2, ... a Java InputStream that delivers the database column value as astream of one byte ASCII characters. If the value is SQL NULLthen the result is null
exception:
SQLException - if a database access error occurs
See Also: getBinaryStream |
| getBigDecimal | | public BigDecimal getBigDecimal(int columnIndex) throws SQLException(Code) | | JDBC 2.0 Get the value of a column in the current row as a
java.math.BigDecimal object.
Parameters:
columnIndex - the first column is 1, the second is 2, ... the column value (full precision); if the value is SQL NULL, theresult is null
exception:
SQLException - if a database-access error occurs. |
| getBigDecimal | | public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException(Code) | | Get the value of a column in the current row as a java.math.BigDecimal
object
Parameters:
columnIndex - the first column is 1, the second is 2...
Parameters:
scale - the number of digits to the right of the decimal the column value; if the value is SQL NULL, null
exception:
SQLException - if a database access error occurs |
| getBigDecimal | | public BigDecimal getBigDecimal(String columnName) throws SQLException(Code) | | JDBC 2.0 Get the value of a column in the current row as a
java.math.BigDecimal object.
Parameters:
columnName - the name of the column to retrieve the value from the BigDecimal value in the column
throws:
SQLException - if an error occurs |
| getBigDecimal | | public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException(Code) | | DOCUMENT ME!
Parameters:
columnName - DOCUMENT ME!
Parameters:
scale - DOCUMENT ME! DOCUMENT ME!
throws:
SQLException - DOCUMENT ME! |
| getBinaryStream | | public InputStream getBinaryStream(int columnIndex) throws SQLException(Code) | | A column value can also be retrieved as a binary stream. This method is
suitable for retrieving LONGVARBINARY values.
Parameters:
columnIndex - the first column is 1, the second is 2... a Java InputStream that delivers the database column value as astream of bytes. If the value is SQL NULL, then the result isnull
exception:
SQLException - if a database access error occurs
See Also: getAsciiStream
See Also: getUnicodeStream |
| getBlob | | public java.sql.Blob getBlob(int columnIndex) throws SQLException(Code) | | JDBC 2.0 Get a BLOB column.
Parameters:
columnIndex - the first column is 1, the second is 2, ... an object representing a BLOB
throws:
SQLException - if an error occurs. |
| getBoolean | | public boolean getBoolean(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java boolean
Parameters:
columnIndex - the first column is 1, the second is 2... the column value, false for SQL NULL
exception:
SQLException - if a database access error occurs |
| getByte | | public byte getByte(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java byte.
Parameters:
columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL
exception:
SQLException - if a database access error occurs |
| getBytes | | public byte[] getBytes(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java byte array.
Be warned If the blob is huge, then you may run out of memory.
Parameters:
columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is null
exception:
SQLException - if a database access error occurs |
| getBytes | | protected byte[] getBytes(int columnIndex, boolean noConversion) throws SQLException(Code) | | |
| getCalendarInstanceForSessionOrNew | | protected Calendar getCalendarInstanceForSessionOrNew()(Code) | | Optimization to only use one calendar per-session, or calculate it for
each call, depending on user configuration
|
| getCharacterStream | | public java.io.Reader getCharacterStream(int columnIndex) throws SQLException(Code) | | JDBC 2.0
Get the value of a column in the current row as a java.io.Reader.
Parameters:
columnIndex - the column to get the value from the value in the column as a java.io.Reader.
throws:
SQLException - if an error occurs |
| getCharacterStream | | public java.io.Reader getCharacterStream(String columnName) throws SQLException(Code) | | JDBC 2.0
Get the value of a column in the current row as a java.io.Reader.
Parameters:
columnName - the column name to retrieve the value from the value as a java.io.Reader
throws:
SQLException - if an error occurs |
| getClob | | public java.sql.Clob getClob(int i) throws SQLException(Code) | | JDBC 2.0 Get a CLOB column.
Parameters:
i - the first column is 1, the second is 2, ... an object representing a CLOB
throws:
SQLException - if an error occurs |
| getConcurrency | | public int getConcurrency() throws SQLException(Code) | | JDBC 2.0 Return the concurrency of this result set. The concurrency used
is determined by the statement that created the result set.
the concurrency type, CONCUR_READ_ONLY, etc.
throws:
SQLException - if a database-access error occurs |
| getCursorName | | public String getCursorName() throws SQLException(Code) | | Get the name of the SQL cursor used by this ResultSet
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.
the ResultSet's SQL cursor name.
exception:
SQLException - if a database access error occurs |
| getDate | | public java.sql.Date getDate(int columnIndex) throws java.sql.SQLException(Code) | | Get the value of a column in the current row as a java.sql.Date object
Parameters:
columnIndex - the first column is 1, the second is 2... the column value; null if SQL NULL
exception:
java.sql.SQLException - if a database access error occurs |
| getDate | | public java.sql.Date getDate(int columnIndex, Calendar cal) throws SQLException(Code) | | JDBC 2.0 Get the value of a column in the current row as a java.sql.Date
object. Use the calendar to construct an appropriate millisecond value
for the Date, if the underlying database doesn't store timezone
information.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
cal - the calendar to use in constructing the date the column value; if the value is SQL NULL, the result is null
exception:
SQLException - if a database-access error occurs. |
| getDate | | public java.sql.Date getDate(String columnName, Calendar cal) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Date object.
Use the calendar to construct an appropriate millisecond value for the
Date, if the underlying database doesn't store timezone information.
Parameters:
columnName - is the SQL name of the column
Parameters:
cal - the calendar to use in constructing the date the column value; if the value is SQL NULL, the result is null
exception:
SQLException - if a database-access error occurs. |
| getDouble | | public double getDouble(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java double.
Parameters:
columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL
exception:
SQLException - if a database access error occurs |
| getDoubleInternal | | protected double getDoubleInternal(int colIndex) throws SQLException(Code) | | Converts a string representation of a number to a double. Need a faster
way to do this.
Parameters:
colIndex - the 1-based index of the column to retrieve a double from. the double value represented by the string in buf
throws:
SQLException - if an error occurs |
| getDoubleInternal | | protected double getDoubleInternal(String stringVal, int colIndex) throws SQLException(Code) | | Converts a string representation of a number to a double. Need a faster
way to do this.
Parameters:
stringVal - the double as a String
Parameters:
colIndex - the 1-based index of the column to retrieve a double from. the double value represented by the string in buf
throws:
SQLException - if an error occurs |
| getFetchDirection | | public int getFetchDirection() throws SQLException(Code) | | JDBC 2.0 Returns the fetch direction for this result set.
the fetch direction for this result set.
exception:
SQLException - if a database-access error occurs |
| getFetchSize | | public int getFetchSize() throws SQLException(Code) | | JDBC 2.0 Return the fetch size for this result set.
the fetch size for this result set.
exception:
SQLException - if a database-access error occurs |
| getFirstCharOfQuery | | public char getFirstCharOfQuery()(Code) | | Returns the first character of the query that this result set was created
from.
the first character of the query...uppercased |
| getFloat | | public float getFloat(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java float.
Parameters:
columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL
exception:
SQLException - if a database access error occurs |
| getInstance | | protected static ResultSetImpl getInstance(String catalog, Field[] fields, RowData tuples, ConnectionImpl conn, StatementImpl creatorStmt, boolean isUpdatable) throws SQLException(Code) | | 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.
|
| getInt | | public int getInt(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java int.
Parameters:
columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL
exception:
SQLException - if a database access error occurs |
| getLong | | public long getLong(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java long.
Parameters:
columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL
exception:
SQLException - if a database access error occurs |
| getMetaData | | public java.sql.ResultSetMetaData getMetaData() throws SQLException(Code) | | The numbers, types and properties of a ResultSet's columns are provided
by the getMetaData method
a description of the ResultSet's columns
exception:
SQLException - if a database access error occurs |
| getNativeArray | | protected java.sql.Array getNativeArray(int i) throws SQLException(Code) | | JDBC 2.0 Get an array column.
Parameters:
i - the first column is 1, the second is 2, ... an object representing an SQL array
throws:
SQLException - if a database error occurs
throws:
NotImplemented - DOCUMENT ME! |
| getNativeAsciiStream | | protected InputStream getNativeAsciiStream(int columnIndex) throws SQLException(Code) | | A column value can be retrieved as a stream of ASCII characters and then
read in chunks from the stream. This method is particulary suitable for
retrieving large LONGVARCHAR values. The JDBC driver will do any
necessary conversion from the database format into ASCII.
Note: All the data in the returned stream must be read prior to
getting the value of any other column. The next call to a get method
implicitly closes the stream. Also, a stream may return 0 for available()
whether there is data available or not.
Parameters:
columnIndex - the first column is 1, the second is 2, ... a Java InputStream that delivers the database column value as astream of one byte ASCII characters. If the value is SQL NULLthen the result is null
exception:
SQLException - if a database access error occurs
See Also: getBinaryStream |
| getNativeBigDecimal | | protected BigDecimal getNativeBigDecimal(int columnIndex) throws SQLException(Code) | | JDBC 2.0 Get the value of a column in the current row as a
java.math.BigDecimal object.
Parameters:
columnIndex - the first column is 1, the second is 2, ... the column value (full precision); if the value is SQL NULL, theresult is null
exception:
SQLException - if a database-access error occurs. |
| getNativeBigDecimal | | protected BigDecimal getNativeBigDecimal(int columnIndex, int scale) throws SQLException(Code) | | Get the value of a column in the current row as a java.math.BigDecimal
object
Parameters:
columnIndex - the first column is 1, the second is 2...
Parameters:
scale - the number of digits to the right of the decimal the column value; if the value is SQL NULL, null
exception:
SQLException - if a database access error occurs |
| getNativeBinaryStream | | protected InputStream getNativeBinaryStream(int columnIndex) throws SQLException(Code) | | A column value can also be retrieved as a binary stream. This method is
suitable for retrieving LONGVARBINARY values.
Parameters:
columnIndex - the first column is 1, the second is 2... a Java InputStream that delivers the database column value as astream of bytes. If the value is SQL NULL, then the result isnull
exception:
SQLException - if a database access error occurs
See Also: getAsciiStream
See Also: getUnicodeStream |
| getNativeBlob | | protected java.sql.Blob getNativeBlob(int columnIndex) throws SQLException(Code) | | JDBC 2.0 Get a BLOB column.
Parameters:
columnIndex - the first column is 1, the second is 2, ... an object representing a BLOB
throws:
SQLException - if an error occurs. |
| getNativeByte | | protected byte getNativeByte(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java byte.
Parameters:
columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL
exception:
SQLException - if a database access error occurs |
| getNativeByte | | protected byte getNativeByte(int columnIndex, boolean overflowCheck) throws SQLException(Code) | | |
| getNativeBytes | | protected byte[] getNativeBytes(int columnIndex, boolean noConversion) throws SQLException(Code) | | Get the value of a column in the current row as a Java byte array.
Be warned If the blob is huge, then you may run out of memory.
Parameters:
columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is null
exception:
SQLException - if a database access error occurs |
| getNativeCharacterStream | | protected java.io.Reader getNativeCharacterStream(int columnIndex) throws SQLException(Code) | | JDBC 2.0
Get the value of a column in the current row as a java.io.Reader.
Parameters:
columnIndex - the column to get the value from the value in the column as a java.io.Reader.
throws:
SQLException - if an error occurs |
| getNativeClob | | protected java.sql.Clob getNativeClob(int columnIndex) throws SQLException(Code) | | JDBC 2.0 Get a CLOB column.
Parameters:
columnIndex - the first column is 1, the second is 2, ... an object representing a CLOB
throws:
SQLException - if an error occurs |
| getNativeDate | | protected java.sql.Date getNativeDate(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Date object
Parameters:
columnIndex - the first column is 1, the second is 2... the column value; null if SQL NULL
exception:
SQLException - if a database access error occurs |
| getNativeDate | | protected java.sql.Date getNativeDate(int columnIndex, TimeZone tz) throws SQLException(Code) | | JDBC 2.0 Get the value of a column in the current row as a java.sql.Date
object. Use the calendar to construct an appropriate millisecond value
for the Date, if the underlying database doesn't store timezone
information.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
tz - the calendar to use in constructing the date the column value; if the value is SQL NULL, the result is null
exception:
SQLException - if a database-access error occurs. |
| getNativeDouble | | protected double getNativeDouble(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java double.
Parameters:
columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL
exception:
SQLException - if a database access error occurs |
| getNativeFloat | | protected float getNativeFloat(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java float.
Parameters:
columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL
exception:
SQLException - if a database access error occurs |
| getNativeInt | | protected int getNativeInt(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java int.
Parameters:
columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL
exception:
SQLException - if a database access error occurs |
| getNativeInt | | protected int getNativeInt(int columnIndex, boolean overflowCheck) throws SQLException(Code) | | |
| getNativeLong | | protected long getNativeLong(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java long.
Parameters:
columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL
exception:
SQLException - if a database access error occurs |
| getNativeLong | | protected long getNativeLong(int columnIndex, boolean overflowCheck, boolean expandUnsignedLong) throws SQLException(Code) | | |
| getNativeRef | | protected java.sql.Ref getNativeRef(int i) throws SQLException(Code) | | JDBC 2.0 Get a REF(<structured-type>) column.
Parameters:
i - the first column is 1, the second is 2, ... an object representing data of an SQL REF type
throws:
SQLException - as this is not implemented
throws:
NotImplemented - DOCUMENT ME! |
| getNativeShort | | protected short getNativeShort(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java short.
Parameters:
columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL
exception:
SQLException - if a database access error occurs |
| getNativeShort | | protected short getNativeShort(int columnIndex, boolean overflowCheck) throws SQLException(Code) | | |
| getNativeString | | protected String getNativeString(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java String
Parameters:
columnIndex - the first column is 1, the second is 2... the column value, null for SQL NULL
exception:
SQLException - if a database access error occurs |
| getNativeUnicodeStream | | protected InputStream getNativeUnicodeStream(int columnIndex) throws SQLException(Code) | | A column value can also be retrieved as a stream of Unicode characters.
We implement this as a binary stream.
Parameters:
columnIndex - the first column is 1, the second is 2... a Java InputStream that delivers the database column value as astream of two byte Unicode characters. If the value is SQL NULL,then the result is null
exception:
SQLException - if a database access error occurs
See Also: getAsciiStream
See Also: getBinaryStream |
| getObject | | public Object getObject(int columnIndex) throws SQLException(Code) | | 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.
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.
Parameters:
columnIndex - the first column is 1, the second is 2... a Object holding the column value
exception:
SQLException - if a database access error occurs |
| getObject | | public Object getObject(int i, java.util.Map map) throws SQLException(Code) | | JDBC 2.0 Returns the value of column i as a Java object. Use the map to
determine the class from which to construct data of SQL structured and
distinct types.
Parameters:
i - the first column is 1, the second is 2, ...
Parameters:
map - the mapping from SQL type names to Java classes an object representing the SQL value
throws:
SQLException - because this is not implemented |
| getObject | | public Object getObject(String columnName) throws SQLException(Code) | | 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.
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.
Parameters:
columnName - is the SQL name of the column a Object holding the column value
exception:
SQLException - if a database access error occurs |
| getObject | | public Object getObject(String colName, java.util.Map map) throws SQLException(Code) | | JDBC 2.0 Returns the value of column i as a Java object. Use the map to
determine the class from which to construct data of SQL structured and
distinct types.
Parameters:
colName - the column name
Parameters:
map - the mapping from SQL type names to Java classes an object representing the SQL value
throws:
SQLException - as this is not implemented |
| getRef | | public java.sql.Ref getRef(int i) throws SQLException(Code) | | JDBC 2.0 Get a REF(<structured-type>) column.
Parameters:
i - the first column is 1, the second is 2, ... an object representing data of an SQL REF type
throws:
SQLException - as this is not implemented
throws:
NotImplemented - DOCUMENT ME! |
| getRow | | public int getRow() throws SQLException(Code) | | JDBC 2.0
Determine the current row number. The first row is number 1, the second
number 2, etc.
the current row number, else return 0 if there is no current row
exception:
SQLException - if a database-access error occurs. |
| getServerInfo | | public String getServerInfo()(Code) | | Returns the server info (if any), or null if none.
server info created for this ResultSet |
| getShort | | public short getShort(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java short.
Parameters:
columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL
exception:
SQLException - if a database access error occurs |
| getStatement | | public java.sql.Statement getStatement() throws SQLException(Code) | | JDBC 2.0 Return the Statement that produced the ResultSet.
the Statment that produced the result set, or null if the resultwas produced some other way.
exception:
SQLException - if a database-access error occurs |
| getString | | public String getString(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java String
Parameters:
columnIndex - the first column is 1, the second is 2... the column value, null for SQL NULL
exception:
SQLException - if a database access error occurs |
| getString | | public String getString(String columnName) throws SQLException(Code) | | The following routines simply convert the columnName into a columnIndex
and then call the appropriate routine above.
Parameters:
columnName - is the SQL name of the column the column value
exception:
SQLException - if a database access error occurs |
| getTime | | public Time getTime(int columnIndex) throws java.sql.SQLException(Code) | | Get the value of a column in the current row as a java.sql.Time object
Parameters:
columnIndex - the first column is 1, the second is 2... the column value; null if SQL NULL
throws:
java.sql.SQLException - if a database access error occurs |
| getTime | | public java.sql.Time getTime(int columnIndex, Calendar cal) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Time object.
Use the calendar to construct an appropriate millisecond value for the
Time, if the underlying database doesn't store timezone information.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
cal - the calendar to use in constructing the time the column value; if the value is SQL NULL, the result is null
exception:
SQLException - if a database-access error occurs. |
| getTime | | public Time getTime(String columnName) throws java.sql.SQLException(Code) | | Get the value of a column in the current row as a java.sql.Time object.
Parameters:
columnName - is the SQL name of the column the column value; if the value is SQL NULL, the result is null
throws:
java.sql.SQLException - if a database-access error occurs. |
| getTime | | public java.sql.Time getTime(String columnName, Calendar cal) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Time object.
Use the calendar to construct an appropriate millisecond value for the
Time, if the underlying database doesn't store timezone information.
Parameters:
columnName - is the SQL name of the column
Parameters:
cal - the calendar to use in constructing the time the column value; if the value is SQL NULL, the result is null
exception:
SQLException - if a database-access error occurs. |
| getTimestamp | | public Timestamp getTimestamp(int columnIndex) throws java.sql.SQLException(Code) | | Get the value of a column in the current row as a java.sql.Timestamp
object
Parameters:
columnIndex - the first column is 1, the second is 2... the column value; null if SQL NULL
exception:
java.sql.SQLException - if a database access error occurs |
| getTimestamp | | public java.sql.Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Timestamp
object. Use the calendar to construct an appropriate millisecond value
for the Timestamp, if the underlying database doesn't store timezone
information.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
cal - the calendar to use in constructing the timestamp the column value; if the value is SQL NULL, the result is null
exception:
SQLException - if a database-access error occurs. |
| getTimestamp | | public java.sql.Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Timestamp
object. Use the calendar to construct an appropriate millisecond value
for the Timestamp, if the underlying database doesn't store timezone
information.
Parameters:
columnName - is the SQL name of the column
Parameters:
cal - the calendar to use in constructing the timestamp the column value; if the value is SQL NULL, the result is null
exception:
SQLException - if a database-access error occurs. |
| getType | | public int getType() throws SQLException(Code) | | JDBC 2.0 Return the type of this result set. The type is determined based
on the statement that created the result set.
TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, orTYPE_SCROLL_SENSITIVE
exception:
SQLException - if a database-access error occurs |
| getUnicodeStream | | public InputStream getUnicodeStream(int columnIndex) throws SQLException(Code) | | A column value can also be retrieved as a stream of Unicode characters.
We implement this as a binary stream.
Parameters:
columnIndex - the first column is 1, the second is 2... a Java InputStream that delivers the database column value as astream of two byte Unicode characters. If the value is SQL NULL,then the result is null
exception:
SQLException - if a database access error occurs
See Also: getAsciiStream
See Also: getBinaryStream |
| getUpdateCount | | public long getUpdateCount()(Code) | | |
| getUpdateID | | public long getUpdateID()(Code) | | |
| getWarnings | | public java.sql.SQLWarning getWarnings() throws SQLException(Code) | | The first warning reported by calls on this ResultSet is returned.
Subsequent ResultSet warnings will be chained to this
java.sql.SQLWarning.
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.
the first java.sql.SQLWarning or null;
exception:
SQLException - if a database access error occurs. |
| insertRow | | public void insertRow() throws SQLException(Code) | | JDBC 2.0 Insert the contents of the insert row into the result set and
the database. Must be on the insert row when this method is called.
exception:
SQLException - if a database-access error occurs, if called when not onthe insert row, or if all non-nullable columns in theinsert row have not been given a value
throws:
NotUpdatable - DOCUMENT ME! |
| isAfterLast | | public boolean isAfterLast() throws SQLException(Code) | | JDBC 2.0
Determine if the cursor is after the last row in the result set.
true if after the last row, false otherwise. Returns false whenthe result set contains no rows.
exception:
SQLException - if a database-access error occurs. |
| isBeforeFirst | | public boolean isBeforeFirst() throws SQLException(Code) | | JDBC 2.0
Determine if the cursor is before the first row in the result set.
true if before the first row, false otherwise. Returns false whenthe result set contains no rows.
exception:
SQLException - if a database-access error occurs. |
| isFirst | | public boolean isFirst() throws SQLException(Code) | | JDBC 2.0
Determine if the cursor is on the first row of the result set.
true if on the first row, false otherwise.
exception:
SQLException - if a database-access error occurs. |
| isLast | | public boolean isLast() throws SQLException(Code) | | JDBC 2.0
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.
true if on the last row, false otherwise.
exception:
SQLException - if a database-access error occurs. |
| last | | public boolean last() throws SQLException(Code) | | JDBC 2.0
Moves to the last row in the result set.
true if on a valid row, false if no rows in the result set.
exception:
SQLException - if a database-access error occurs, or result set type isTYPE_FORWARD_ONLY. |
| moveToCurrentRow | | public void moveToCurrentRow() throws SQLException(Code) | | JDBC 2.0 Move the cursor to the remembered cursor position, usually the
current row. Has no effect unless the cursor is on the insert row.
exception:
SQLException - if a database-access error occurs, or the result set isnot updatable
throws:
NotUpdatable - DOCUMENT ME! |
| moveToInsertRow | | public void moveToInsertRow() throws SQLException(Code) | | JDBC 2.0 Move to the insert row. The current cursor position is
remembered while the cursor is positioned on the insert row. The insert
row is a special row associated with an updatable result set. It is
essentially a buffer where a new row may be constructed by calling the
updateXXX() methods prior to inserting the row into the result set. Only
the updateXXX(), getXXX(), and insertRow() methods may be called when the
cursor is on the insert row. All of the columns in a result set must be
given a value each time this method is called before calling insertRow().
UpdateXXX()must be called before getXXX() on a column.
exception:
SQLException - if a database-access error occurs, or the result set isnot updatable
throws:
NotUpdatable - DOCUMENT ME! |
| next | | public boolean next() throws SQLException(Code) | | 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.
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
true if the new current is valid; false if there are no more rows
exception:
SQLException - if a database access error occurs |
| prev | | public boolean prev() throws java.sql.SQLException(Code) | | 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.
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
true if the new current is valid; false if there are no more rows
exception:
java.sql.SQLException - if a database access error occurs |
| previous | | public boolean previous() throws SQLException(Code) | | JDBC 2.0
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.
true if on a valid row, false if off the result set.
exception:
SQLException - if a database-access error occurs, or result set type isTYPE_FORWAR_DONLY. |
| realClose | | public void realClose(boolean calledExplicitly) throws SQLException(Code) | | Closes this ResultSet and releases resources.
Parameters:
calledExplicitly - was this called by close()?
throws:
SQLException - if an error occurs |
| reallyResult | | public boolean reallyResult()(Code) | | |
| redefineFieldsForDBMD | | public void redefineFieldsForDBMD(Field[] f)(Code) | | |
| refreshRow | | public void refreshRow() throws SQLException(Code) | | JDBC 2.0 Refresh the value of the current row with its current value in
the database. Cannot be called when on the insert row. The refreshRow()
method provides a way for an application to explicitly tell the JDBC
driver to refetch a row(s) from the database. An application may want to
call refreshRow() when caching or prefetching is being done by the JDBC
driver to fetch the latest value of a row from the database. The JDBC
driver may actually refresh multiple rows at once if the fetch size is
greater than one. All values are refetched subject to the transaction
isolation level and cursor sensitivity. If refreshRow() is called after
calling updateXXX(), but before calling updateRow() then the updates made
to the row are lost. Calling refreshRow() frequently will likely slow
performance.
exception:
SQLException - if a database-access error occurs, or if called when onthe insert row.
throws:
NotUpdatable - DOCUMENT ME! |
| relative | | public boolean relative(int rows) throws SQLException(Code) | | JDBC 2.0
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.
Parameters:
rows - the number of relative rows to move the cursor. true if on a row, false otherwise.
throws:
SQLException - if a database-access error occurs, or there is no currentrow, or result set type is TYPE_FORWARD_ONLY. |
| rowDeleted | | public boolean rowDeleted() throws SQLException(Code) | | JDBC 2.0 Determine if this row has been deleted. A deleted row may leave
a visible "hole" in a result set. This method can be used to detect holes
in a result set. The value returned depends on whether or not the result
set can detect deletions.
true if deleted and deletes are detected
exception:
SQLException - if a database-access error occurs
throws:
NotImplemented - DOCUMENT ME!
See Also: DatabaseMetaData.deletesAreDetected |
| rowUpdated | | public boolean rowUpdated() throws SQLException(Code) | | JDBC 2.0 Determine if the current row has been updated. The value
returned depends on whether or not the result set can detect updates.
true if the row has been visibly updated by the owner or another,and updates are detected
exception:
SQLException - if a database-access error occurs
throws:
NotImplemented - DOCUMENT ME!
See Also: DatabaseMetaData.updatesAreDetected |
| setBinaryEncoded | | protected void setBinaryEncoded()(Code) | | Flag that this result set is 'binary' encoded (from a PreparedStatement),
not stored as strings.
|
| setFetchDirection | | public void setFetchDirection(int direction) throws SQLException(Code) | | JDBC 2.0 Give a hint as to the direction in which the rows in this result
set will be processed. The initial value is determined by the statement
that produced the result set. The fetch direction may be changed at any
time.
Parameters:
direction - the direction to fetch rows in.
exception:
SQLException - if a database-access error occurs, or the result set typeis TYPE_FORWARD_ONLY and direction is not FETCH_FORWARD.MM.MySQL actually ignores this, because it has the wholeresult set anyway, so the direction is immaterial. |
| setFetchSize | | public void setFetchSize(int rows) throws SQLException(Code) | | 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. If the fetch size specified is zero, then the JDBC driver ignores
the value, and is free to make its own best guess as to what the fetch
size should be. The default value is set by the statement that creates
the result set. The fetch size may be changed at any time.
Parameters:
rows - the number of rows to fetch
exception:
SQLException - if a database-access error occurs, or the condition 0 lteqrows lteq this.getMaxRows() is not satisfied. Currentlyignored by this driver. |
| setFirstCharOfQuery | | public void setFirstCharOfQuery(char c)(Code) | | Sets the first character of the query that this result set was created
from.
Parameters:
c - the first character of the query...uppercased |
| setNextResultSet | | protected void setNextResultSet(ResultSetInternalMethods nextResultSet)(Code) | | DOCUMENT ME!
Parameters:
nextResultSet - Sets the next result set in the result set chain for multipleresult sets. |
| setResultSetConcurrency | | protected void setResultSetConcurrency(int concurrencyFlag)(Code) | | Sets the concurrency (JDBC2)
Parameters:
concurrencyFlag - CONCUR_UPDATABLE or CONCUR_READONLY |
| setResultSetType | | protected void setResultSetType(int typeFlag)(Code) | | Sets the result set type for (JDBC2)
Parameters:
typeFlag - SCROLL_SENSITIVE or SCROLL_INSENSITIVE (we only supportSCROLL_INSENSITIVE) |
| setServerInfo | | protected void setServerInfo(String info)(Code) | | Sets server info (if any)
Parameters:
info - the server info message |
| setWrapperStatement | | public void setWrapperStatement(java.sql.Statement wrapperStatement)(Code) | |
Parameters:
wrapperStatement - The wrapperStatement to set. |
| toString | | public String toString()(Code) | | DOCUMENT ME!
DOCUMENT ME! |
| updateAsciiStream | | public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0 Update a column with an ascii stream value. The updateXXX()
methods are used to update column values in the current row, or the
insert row. The updateXXX() methods do not update the underlying
database, instead the updateRow() or insertRow() methods are called to
update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
Parameters:
length - the length of the stream
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateAsciiStream | | public void updateAsciiStream(String columnName, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0 Update a column with an ascii stream value. The updateXXX()
methods are used to update column values in the current row, or the
insert row. The updateXXX() methods do not update the underlying
database, instead the updateRow() or insertRow() methods are called to
update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
Parameters:
length - of the stream
exception:
SQLException - if a database-access error occurs |
| updateBigDecimal | | public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException(Code) | | JDBC 2.0 Update a column with a BigDecimal value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateBigDecimal | | public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException(Code) | | JDBC 2.0 Update a column with a BigDecimal value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateBinaryStream | | public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0 Update a column with a binary stream value. The updateXXX()
methods are used to update column values in the current row, or the
insert row. The updateXXX() methods do not update the underlying
database, instead the updateRow() or insertRow() methods are called to
update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
Parameters:
length - the length of the stream
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateBinaryStream | | public void updateBinaryStream(String columnName, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0 Update a column with a binary stream value. The updateXXX()
methods are used to update column values in the current row, or the
insert row. The updateXXX() methods do not update the underlying
database, instead the updateRow() or insertRow() methods are called to
update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
Parameters:
length - of the stream
exception:
SQLException - if a database-access error occurs |
| updateBoolean | | public void updateBoolean(int columnIndex, boolean x) throws SQLException(Code) | | JDBC 2.0 Update a column with a boolean value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateBoolean | | public void updateBoolean(String columnName, boolean x) throws SQLException(Code) | | JDBC 2.0 Update a column with a boolean value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateByte | | public void updateByte(int columnIndex, byte x) throws SQLException(Code) | | JDBC 2.0 Update a column with a byte value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateByte | | public void updateByte(String columnName, byte x) throws SQLException(Code) | | JDBC 2.0 Update a column with a byte value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateBytes | | public void updateBytes(int columnIndex, byte[] x) throws SQLException(Code) | | JDBC 2.0 Update a column with a byte array value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateBytes | | public void updateBytes(String columnName, byte[] x) throws SQLException(Code) | | JDBC 2.0 Update a column with a byte array value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateCharacterStream | | public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws SQLException(Code) | | JDBC 2.0 Update a column with a character stream value. The updateXXX()
methods are used to update column values in the current row, or the
insert row. The updateXXX() methods do not update the underlying
database, instead the updateRow() or insertRow() methods are called to
update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
Parameters:
length - the length of the stream
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateCharacterStream | | public void updateCharacterStream(String columnName, java.io.Reader reader, int length) throws SQLException(Code) | | JDBC 2.0 Update a column with a character stream value. The updateXXX()
methods are used to update column values in the current row, or the
insert row. The updateXXX() methods do not update the underlying
database, instead the updateRow() or insertRow() methods are called to
update the database.
Parameters:
columnName - the name of the column
Parameters:
reader - the stream to update the column with
Parameters:
length - of the stream
throws:
SQLException - if a database-access error occurs |
| updateDate | | public void updateDate(int columnIndex, java.sql.Date x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Date value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateDate | | public void updateDate(String columnName, java.sql.Date x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Date value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateDouble | | public void updateDouble(int columnIndex, double x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Double value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateDouble | | public void updateDouble(String columnName, double x) throws SQLException(Code) | | JDBC 2.0 Update a column with a double value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateFloat | | public void updateFloat(int columnIndex, float x) throws SQLException(Code) | | JDBC 2.0 Update a column with a float value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateFloat | | public void updateFloat(String columnName, float x) throws SQLException(Code) | | JDBC 2.0 Update a column with a float value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateInt | | public void updateInt(int columnIndex, int x) throws SQLException(Code) | | JDBC 2.0 Update a column with an integer value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateInt | | public void updateInt(String columnName, int x) throws SQLException(Code) | | JDBC 2.0 Update a column with an integer value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateLong | | public void updateLong(int columnIndex, long x) throws SQLException(Code) | | JDBC 2.0 Update a column with a long value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateLong | | public void updateLong(String columnName, long x) throws SQLException(Code) | | JDBC 2.0 Update a column with a long value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateNull | | public void updateNull(int columnIndex) throws SQLException(Code) | | JDBC 2.0 Give a nullable column a null value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateNull | | public void updateNull(String columnName) throws SQLException(Code) | | JDBC 2.0 Update a column with a null value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
exception:
SQLException - if a database-access error occurs |
| updateObject | | public void updateObject(int columnIndex, Object x) throws SQLException(Code) | | JDBC 2.0 Update a column with an Object value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateObject | | public void updateObject(int columnIndex, Object x, int scale) throws SQLException(Code) | | JDBC 2.0 Update a column with an Object value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
Parameters:
scale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC typesthis is the number of digits after the decimal. For all othertypes this value will be ignored.
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateObject | | public void updateObject(String columnName, Object x) throws SQLException(Code) | | JDBC 2.0 Update a column with an Object value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateObject | | public void updateObject(String columnName, Object x, int scale) throws SQLException(Code) | | JDBC 2.0 Update a column with an Object value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
Parameters:
scale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC typesthis is the number of digits after the decimal. For all othertypes this value will be ignored.
exception:
SQLException - if a database-access error occurs |
| updateRow | | public void updateRow() throws SQLException(Code) | | JDBC 2.0 Update the underlying database with the new contents of the
current row. Cannot be called when on the insert row.
exception:
SQLException - if a database-access error occurs, or if called when onthe insert row
throws:
NotUpdatable - DOCUMENT ME! |
| updateShort | | public void updateShort(int columnIndex, short x) throws SQLException(Code) | | JDBC 2.0 Update a column with a short value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateShort | | public void updateShort(String columnName, short x) throws SQLException(Code) | | JDBC 2.0 Update a column with a short value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateString | | public void updateString(int columnIndex, String x) throws SQLException(Code) | | JDBC 2.0 Update a column with a String value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateString | | public void updateString(String columnName, String x) throws SQLException(Code) | | JDBC 2.0 Update a column with a String value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateTime | | public void updateTime(int columnIndex, java.sql.Time x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Time value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateTime | | public void updateTime(String columnName, java.sql.Time x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Time value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| updateTimestamp | | public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Timestamp value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs
throws:
NotUpdatable - DOCUMENT ME! |
| updateTimestamp | | public void updateTimestamp(String columnName, java.sql.Timestamp x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Timestamp value. The updateXXX() methods
are used to update column values in the current row, or the insert row.
The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters:
columnName - the name of the column
Parameters:
x - the new column value
exception:
SQLException - if a database-access error occurs |
| wasNull | | public boolean wasNull() throws SQLException(Code) | | A column may have the value of SQL NULL; wasNull() reports whether the
last column read had this special value. Note that you must first call
getXXX on a column to try to read its value and then call wasNull() to
find if the value was SQL NULL
true if the last column read was SQL NULL
exception:
SQLException - if a database access error occurred |
|
|