| java.lang.Object
 com.sqlmagic.tinysql.tinySQLResultSet
| tinySQLResultSet | | public class tinySQLResultSet implements java.sql.ResultSet(Code) | |
author:
Thomas Morgner
author:
author:
- tinySQLResultSet now holds a reference
author:
to statement which created it. If the resultset was not created by an statement,
author:
null is returned (f.i. used in DatabaseMetaData-Queries).
author:
- Changed the code to support setting a fetchsize for queries.
author:
- Parsing of dates corrected to format yyyyMMdd
author:
- Now supporting the FetchDirection methods, getType().
author:
- Concurrency is not returned as CONCUR_READ_ONLY as lowest common standard.
author:
- getColumnTypes returns now values given in tsResultSet and does not try to
author:
guess from strings.
author:
|
| Field Summary | |
| int | CONCUR_READ_ONLY
JDBC 2.0
The concurrency mode for a ResultSet object
that may NOT be updated. | | int | CONCUR_UPDATABLE
JDBC 2.0
The concurrency mode for a ResultSet object
that may be updated. | | int | FETCH_FORWARD
JDBC 2.0
The rows in a result set will be processed in a forward direction;
first-to-last. | | int | FETCH_REVERSE
JDBC 2.0
The rows in a result set will be processed in a reverse direction;
last-to-first. | | int | FETCH_UNKNOWN
JDBC 2.0
The order in which rows in a result set will be processed is unknown. | | int | TYPE_FORWARD_ONLY
JDBC 2.0
The type for a ResultSet object whose cursor may
move only forward. | | int | TYPE_SCROLL_INSENSITIVE
JDBC 2.0
The type for a ResultSet object that is scrollable
but generally not sensitive to changes made by others. | | int | TYPE_SCROLL_SENSITIVE
JDBC 2.0
The type for a ResultSet object that is scrollable
and generally sensitive to changes made by others. |
| Method Summary | |
| public boolean | absolute(int row)
JDBC 2.0
Moves the cursor to the given row number in the result set.
If the row number is positive, the cursor moves to
the given row number with respect to the
beginning of the result set. | | public void | afterLast()
JDBC 2.0
Moves the cursor to the end of the result set, just after the last
row. | | public void | beforeFirst()
JDBC 2.0
Moves the cursor to the front of the result set, just before the
first row. | | public void | cancelRowUpdates()
JDBC 2.0
Cancels the updates made to a row.
This method may be called after calling an
updateXXX method(s) and before calling updateRow to rollback
the updates made to a row. | | public void | clearWarnings()
Clear the chain of warnings. | | public void | close()
| | public void | deleteRow()
JDBC 2.0
Deletes the current row from the result set and the underlying
database. | | public int | findColumn(String name)
Given a column name, this method returns the column number for that
name. | | public boolean | first()
JDBC 2.0
Moves the cursor to the first row in the result set. | | public Array | getArray(int i)
JDBC 2.0
Gets an SQL ARRAY value from the current row of this ResultSet object.
Parameters:
i - the first column is 1, the second is 2, ... | | public Array | getArray(String colName)
JDBC 2.0
Gets an SQL ARRAY value in the current row of this ResultSet object. | | public java.io.InputStream | getAsciiStream(int column)
This is not currently supported. | | public java.io.InputStream | getAsciiStream(String columnName)
This is unsupported, but we'll try to call the corresponding
call by column index. | | public BigDecimal | getBigDecimal(int column, int scale)
| | public BigDecimal | getBigDecimal(String columnName, int scale)
| | public BigDecimal | getBigDecimal(int columnIndex)
JDBC 2.0
Gets the value of a column in the current row as a java.math.BigDecimal
object with full precision.
Parameters:
columnIndex - the first column is 1, the second is 2, ... | | public BigDecimal | getBigDecimal(String columnName)
JDBC 2.0
Gets the value of a column in the current row as a java.math.BigDecimal
object with full precision. | | public java.io.InputStream | getBinaryStream(int column)
This is not currently supported. | | public java.io.InputStream | getBinaryStream(String columnName)
This is unsupported, but we'll try to call the corresponding
call by column index. | | public Blob | getBlob(int i)
JDBC 2.0
Gets a BLOB value in the current row of this ResultSet object.
Parameters:
i - the first column is 1, the second is 2, ... | | public Blob | getBlob(String colName)
JDBC 2.0
Gets a BLOB value in the current row of this ResultSet object. | | public boolean | getBoolean(int column)
| | public boolean | getBoolean(String columnName)
| | public byte | getByte(int column)
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 column)
Get the value of a column in the current row as a Java byte array. | | public byte[] | getBytes(String columnName)
| | public java.io.Reader | getCharacterStream(int columnIndex)
JDBC 2.0
Gets the value of a column in the current row as a java.io.Reader. | | public java.io.Reader | getCharacterStream(String columnName)
JDBC 2.0
Gets the value of a column in the current row as a java.io.Reader. | | public Clob | getClob(int i)
JDBC 2.0
Gets a CLOB value in the current row of this ResultSet object.
Parameters:
i - the first column is 1, the second is 2, ... | | public Clob | getClob(String colName)
JDBC 2.0
Gets a CLOB value in the current row of this ResultSet object. | | public int | getConcurrency()
JDBC 2.0
Returns the concurrency mode of this result set. | | public String | getCursorName()
Get the name of the cursor corresponding to this result set. | | public java.sql.Date | getDate(int column)
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(int columnIndex, Calendar cal)
JDBC 2.0
Gets the value of a column in the current row as a java.sql.Date
object. | | public java.sql.Date | getDate(String columnName, Calendar cal)
Gets the value of a column in the current row as a java.sql.Date
object. | | public double | getDouble(int column)
| | public double | getDouble(String columnName)
| | public int | getFetchDirection()
JDBC 2.0
Returns the fetch direction for this result set. | | public int | getFetchSize()
JDBC 2.0
Returns the fetch size for this result set. | | public float | getFloat(int column)
Return a column as a float. | | public float | getFloat(String columnName)
| | public int | getInt(int column)
Retrieve a column from the current row as an int
See Also: java.sql.ResultSet.getInt
exception:
SQLException - bad things... | | public int | getInt(String columnName)
| | public long | getLong(int column)
| | public long | getLong(String columnName)
| | public ResultSetMetaData | getMetaData()
| | public Object | getObject(int column, int type, int scale)
| | public Object | getObject(int column, int type)
Same as above, except with a default scale to 0. | | public Object | getObject(int column)
Same as above, except using the column's default SQL type. | | public Object | getObject(String columnName, int sqlType, int scale)
| | public Object | getObject(String columnName, int type)
Same as above, except defaulting scale to 0. | | public Object | getObject(String columnName)
| | public Object | getObject(int i, java.util.Map map)
JDBC 2.0
Returns the value of a column in the current row as a Java object. | | public Object | getObject(String colName, java.util.Map map)
JDBC 2.0
Returns the value in the specified column as a Java object. | | public Ref | getRef(int i)
JDBC 2.0
Gets a REF(<structured-type>) column value from the current row.
Parameters:
i - the first column is 1, the second is 2, ... | | public Ref | getRef(String colName)
JDBC 2.0
Gets a REF(<structured-type>) column value from the current row. | | public int | getRow()
JDBC 2.0
Retrieves the current row number. | | public short | getShort(int column)
Get the value of a column in the current row as a short. | | public short | getShort(String columnName)
| | public Statement | getStatement()
JDBC 2.0
Returns the Statement that produced this ResultSet object. | | public String | getString(int column)
Gets the value of a column (by index) as a String. | | public String | getString(String name)
Return the String value of a column given its name, rather than
its index. | | public java.sql.Time | getTime(int column)
Get the value of a column in the current row as a java.sql.Time object. | | public java.sql.Time | getTime(String columnName)
| | public java.sql.Time | getTime(int columnIndex, Calendar cal)
Gets the value of a column in the current row as a java.sql.Time
object. | | public java.sql.Time | getTime(String columnName, Calendar cal)
Gets the value of a column in the current row as a java.sql.Time
object. | | public java.sql.Timestamp | getTimestamp(int column)
| | public java.sql.Timestamp | getTimestamp(String columnName)
| | public java.sql.Timestamp | getTimestamp(int columnIndex, Calendar cal)
Gets the value of a column in the current row as a java.sql.Timestamp
object. | | public java.sql.Timestamp | getTimestamp(String columnName, Calendar cal)
Gets the value of a column in the current row as a java.sql.Timestamp
object. | | public int | getType()
JDBC 2.0
Returns the type of this result set. | | public java.io.InputStream | getUnicodeStream(int column)
This is not currently supported. | | public java.io.InputStream | getUnicodeStream(String columnName)
This is unsupported, but we'll try to call the corresponding
call by column index. | | public SQLWarning | getWarnings()
Return the warning chain. | | public void | insertRow()
JDBC 2.0
Inserts the contents of the insert row into the result set and
the database. | | public boolean | isAfterLast()
JDBC 2.0
Indicates whether the cursor is after the last row in the result
set. | | public boolean | isBeforeFirst()
JDBC 2.0
Indicates whether the cursor is before the first row in the result
set. | | public boolean | isFirst()
JDBC 2.0
Indicates whether the cursor is on the first row of the result set. | | public boolean | isLast()
JDBC 2.0
Indicates whether the cursor is on the last row of the result set. | | public boolean | last()
JDBC 2.0
Moves the cursor to the last row in the result set. | | public void | moveToCurrentRow()
JDBC 2.0
Moves the cursor to the remembered cursor position, usually the
current row. | | public void | moveToInsertRow()
JDBC 2.0
Moves the cursor to the insert row. | | public synchronized boolean | next()
Advance to the next row in the result set. | | public boolean | previous()
JDBC 2.0
Moves the cursor to the previous row in the result set. | | public void | refreshRow()
JDBC 2.0
Refreshes the current row with its most recent value in
the database. | | public boolean | relative(int rows)
JDBC 2.0
Moves the cursor 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. | | public boolean | rowDeleted()
JDBC 2.0
Indicates whether a row has been deleted. | | public boolean | rowInserted()
JDBC 2.0
Indicates whether the current row has had an insertion. | | public boolean | rowUpdated()
JDBC 2.0
Indicates whether the current row has been updated. | | public void | setFetchDirection(int direction)
JDBC 2.0
Gives 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
Gives the JDBC driver a hint as to the number of rows that should
be fetched from the database when more rows are needed for this result
set. | | public void | updateAsciiStream(int columnIndex, java.io.InputStream x, int length)
JDBC 2.0
Updates a column with an ascii stream value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateAsciiStream(String columnName, java.io.InputStream x, int length)
JDBC 2.0
Updates a column with an ascii stream value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBigDecimal(int columnIndex, BigDecimal x)
JDBC 2.0
Updates a column with a BigDecimal value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBigDecimal(String columnName, BigDecimal x)
JDBC 2.0
Updates a column with a BigDecimal value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBinaryStream(int columnIndex, java.io.InputStream x, int length)
JDBC 2.0
Updates a column with a binary stream value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBinaryStream(String columnName, java.io.InputStream x, int length)
JDBC 2.0
Updates a column with a binary stream value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBoolean(int columnIndex, boolean x)
JDBC 2.0
Updates a column with a boolean value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBoolean(String columnName, boolean x)
JDBC 2.0
Updates a column with a boolean value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateByte(int columnIndex, byte x)
JDBC 2.0
Updates a column with a byte value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateByte(String columnName, byte x)
JDBC 2.0
Updates a column with a byte value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBytes(int columnIndex, byte x)
JDBC 2.0
Updates a column with a byte array value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBytes(String columnName, byte x)
JDBC 2.0
Updates a column with a byte array value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateCharacterStream(int columnIndex, java.io.Reader x, int length)
JDBC 2.0
Updates a column with a character stream value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateCharacterStream(String columnName, java.io.Reader reader, int length)
JDBC 2.0
Updates a column with a character stream value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateDate(int columnIndex, java.sql.Date x)
JDBC 2.0
Updates a column with a Date value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateDate(String columnName, java.sql.Date x)
JDBC 2.0
Updates a column with a Date value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateDouble(int columnIndex, double x)
JDBC 2.0
Updates a column with a Double value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateDouble(String columnName, double x)
JDBC 2.0
Updates a column with a double value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateFloat(int columnIndex, float x)
JDBC 2.0
Updates a column with a float value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateFloat(String columnName, float x)
JDBC 2.0
Updates a column with a float value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateInt(int columnIndex, int x)
JDBC 2.0
Updates a column with an integer value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateInt(String columnName, int x)
JDBC 2.0
Updates a column with an integer value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateLong(int columnIndex, long x)
JDBC 2.0
Updates a column with a long value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateLong(String columnName, long x)
JDBC 2.0
Updates a column with a long value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateNull(int columnIndex)
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. | | public void | updateNull(String columnName)
JDBC 2.0
Updates a column with a null value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateObject(int columnIndex, Object x, int scale)
JDBC 2.0
Updates a column with an Object value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateObject(int columnIndex, Object x)
JDBC 2.0
Updates a column with an Object value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateObject(String columnName, Object x, int scale)
JDBC 2.0
Updates a column with an Object value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateObject(String columnName, Object x)
JDBC 2.0
Updates a column with an Object value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateRow()
JDBC 2.0
Updates the underlying database with the new contents of the
current row. | | public void | updateShort(int columnIndex, short x)
JDBC 2.0
Updates a column with a short value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateShort(String columnName, short x)
JDBC 2.0
Updates a column with a short value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateString(int columnIndex, String x)
JDBC 2.0
Updates a column with a String value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateString(String columnName, String x)
JDBC 2.0
Updates a column with a String value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateTime(int columnIndex, java.sql.Time x)
JDBC 2.0
Updates a column with a Time value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateTime(String columnName, java.sql.Time x)
JDBC 2.0
Updates a column with a Time value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateTimestamp(int columnIndex, java.sql.Timestamp x)
JDBC 2.0
Updates a column with a Timestamp value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateTimestamp(String columnName, java.sql.Timestamp x)
JDBC 2.0
Updates a column with a Timestamp value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public boolean | wasNull()
Returns whether or not the last column read was null. |
| CONCUR_READ_ONLY | | int CONCUR_READ_ONLY(Code) | | JDBC 2.0
The concurrency mode for a ResultSet object
that may NOT be updated.
|
| CONCUR_UPDATABLE | | int CONCUR_UPDATABLE(Code) | | JDBC 2.0
The concurrency mode for a ResultSet object
that may be updated.
|
| FETCH_FORWARD | | int FETCH_FORWARD(Code) | | JDBC 2.0
The rows in a result set will be processed in a forward direction;
first-to-last.
|
| FETCH_REVERSE | | int FETCH_REVERSE(Code) | | JDBC 2.0
The rows in a result set will be processed in a reverse direction;
last-to-first.
|
| FETCH_UNKNOWN | | int FETCH_UNKNOWN(Code) | | JDBC 2.0
The order in which rows in a result set will be processed is unknown.
|
| TYPE_FORWARD_ONLY | | int TYPE_FORWARD_ONLY(Code) | | JDBC 2.0
The type for a ResultSet object whose cursor may
move only forward.
|
| TYPE_SCROLL_INSENSITIVE | | int TYPE_SCROLL_INSENSITIVE(Code) | | JDBC 2.0
The type for a ResultSet object that is scrollable
but generally not sensitive to changes made by others.
|
| TYPE_SCROLL_SENSITIVE | | int TYPE_SCROLL_SENSITIVE(Code) | | JDBC 2.0
The type for a ResultSet object that is scrollable
and generally sensitive to changes made by others.
|
| tinySQLResultSet | | public tinySQLResultSet(tsResultSet res, tinySQLStatement inputStatement)(Code) | | Given a tsResultSet, this will construct a new tinySQLResultSet
Parameters:
res - the tsResultSet from a query |
| absolute | | public boolean absolute(int row) throws SQLException(Code) | | JDBC 2.0
Moves the cursor to the given row number in the result set.
If the row number is positive, the cursor moves to
the given row number with respect to the
beginning of the result set. The first row is row 1, the second
is row 2, and so on.
If the given row number is negative, the cursor moves to
an absolute row position with respect to
the end of the result set. For example, calling
absolute(-1) positions the
cursor on the last row, absolute(-2) indicates the next-to-last
row, and so on.
An attempt to position the cursor beyond the first/last row in
the result set leaves the cursor before/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().
true if the cursor is on the result set; false otherwise
exception:
SQLException - if a database access error occurs or row is 0, or result set type is TYPE_FORWARD_ONLY. |
| afterLast | | public void afterLast() throws SQLException(Code) | | JDBC 2.0
Moves the cursor 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 the result set type is TYPE_FORWARD_ONLY |
| beforeFirst | | public void beforeFirst() throws SQLException(Code) | | JDBC 2.0
Moves the cursor 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 the result set type is TYPE_FORWARD_ONLY |
| cancelRowUpdates | | public void cancelRowUpdates() throws SQLException(Code) | | JDBC 2.0
Cancels the updates made to a row.
This 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 ifcalled when on the insert row |
| deleteRow | | public void deleteRow() throws SQLException(Code) | | JDBC 2.0
Deletes 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 ifcalled when on the insert row. |
| findColumn | | public int findColumn(String name) throws SQLException(Code) | | Given a column name, this method returns the column number for that
name. Column name to number mappings are kept inside a Hashtable.
Applications that do not need the overhead of this calculation are
not penalized since the mapping only occurs on the first attempt to
access a column number by name.
exception:
java.sql.SQLException - thrown if a bad name is passed
Parameters:
name - the name of the column desired the column number, 1 being the first column |
| first | | public boolean first() throws SQLException(Code) | | JDBC 2.0
Moves the cursor to the first row in the result set.
true if the cursor is on a valid row; false ifthere are no rows in the result set
exception:
SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY |
| getArray | | public Array getArray(int i) throws SQLException(Code) | | JDBC 2.0
Gets an SQL ARRAY value from the current row of this ResultSet object.
Parameters:
i - the first column is 1, the second is 2, ... an Array object representing the SQL ARRAY value inthe specified column |
| getArray | | public Array getArray(String colName) throws SQLException(Code) | | JDBC 2.0
Gets an SQL ARRAY value in the current row of this ResultSet object.
Parameters:
colName - the name of the column from which to retrieve the value an Array object representing the SQL ARRAY value inthe specified column |
| getBigDecimal | | public BigDecimal getBigDecimal(int column, int scale) throws SQLException(Code) | | Return a column as a BigDecimal object
See Also: java.sql.ResultSet.getBigDecimal
exception:
SQLException - in case of a problem
Parameters:
column - the column being retrieved
Parameters:
scale - the number of digits to the right of the decimal the column as a BigDecimal |
| getBigDecimal | | public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException(Code) | | Get the value of a named column as a BigDecimal object
Parameters:
columnName - is the SQL name of the column the column value; if isNull the value is null |
| getBigDecimal | | public BigDecimal getBigDecimal(int columnIndex) throws SQLException(Code) | | JDBC 2.0
Gets the value of a column in the current row as a java.math.BigDecimal
object with full precision.
Parameters:
columnIndex - the first column is 1, the second is 2, ... the column value (full precision); if the value is SQL NULL, the result is null
exception:
SQLException - if a database access error occurs |
| getBigDecimal | | public BigDecimal getBigDecimal(String columnName) throws SQLException(Code) | | JDBC 2.0
Gets the value of a column in the current row as a java.math.BigDecimal
object with full precision.
Parameters:
columnName - the column name the column value (full precision); if the value is SQL NULL, the result is null
exception:
SQLException - if a database access error occurs |
| getBlob | | public Blob getBlob(int i) throws SQLException(Code) | | JDBC 2.0
Gets a BLOB value in the current row of this ResultSet object.
Parameters:
i - the first column is 1, the second is 2, ... a Blob object representing the SQL BLOB value inthe specified column |
| getBlob | | public Blob getBlob(String colName) throws SQLException(Code) | | JDBC 2.0
Gets a BLOB value in the current row of this ResultSet object.
Parameters:
colName - the name of the column from which to retrieve the value a Blob object representing the SQL BLOB value inthe specified column |
| getBoolean | | public boolean getBoolean(int column) throws SQLException(Code) | | Get the value of a column in the current row as boolean
See Also: java.sql.ResultSet.getBoolean
exception:
SQLException - Harum Scarum's coming down fast, Clay...
Parameters:
column - the column index false for "", null, or "0"; true otherwise |
| getBoolean | | public boolean getBoolean(String columnName) throws SQLException(Code) | | Get the value of a boolean column in the current row
Parameters:
columnName - is the SQL name of the column the column value; if isNull the value is false |
| getByte | | public byte getByte(int column) 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 |
| getByte | | public byte getByte(String columnName) throws SQLException(Code) | | Returns the column as a byte based on column name
|
| getBytes | | public byte[] getBytes(int column) throws SQLException(Code) | | Get the value of a column in the current row as a Java byte array.
See Also: java.sql.ResultSet.getBytes
exception:
SQLException - thrown in case of trouble
Parameters:
column - the column being retrieved a byte array that is the value of the column |
| getBytes | | public byte[] getBytes(String columnName) throws SQLException(Code) | | Get the value of a named column as a byte array
Parameters:
columnName - is the SQL name of the column the column value; if isNull the value is null |
| getCharacterStream | | public java.io.Reader getCharacterStream(int columnIndex) throws SQLException(Code) | | JDBC 2.0
Gets the value of a column in the current row as a java.io.Reader.
Parameters:
columnIndex - the first column is 1, the second is 2, ... |
| getCharacterStream | | public java.io.Reader getCharacterStream(String columnName) throws SQLException(Code) | | JDBC 2.0
Gets the value of a column in the current row as a java.io.Reader.
Parameters:
columnName - the name of the column the value in the specified column as a java.io.Reader |
| getClob | | public Clob getClob(int i) throws SQLException(Code) | | JDBC 2.0
Gets a CLOB value in the current row of this ResultSet object.
Parameters:
i - the first column is 1, the second is 2, ... a Clob object representing the SQL CLOB value inthe specified column |
| getClob | | public Clob getClob(String colName) throws SQLException(Code) | | JDBC 2.0
Gets a CLOB value in the current row of this ResultSet object.
Parameters:
colName - the name of the column from which to retrieve the value a Clob object representing the SQL CLOB value inthe specified column |
| getConcurrency | | public int getConcurrency() throws SQLException(Code) | | JDBC 2.0
Returns the concurrency mode of this result set. The concurrency
used is determined by the statement that created the result set.
the concurrency type, CONCUR_READ_ONLY or CONCUR_UPDATABLE
exception:
SQLException - if a database access error occurs |
| getDate | | public java.sql.Date getDate(int column) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Date object.
See Also: java.sqlResultSet.getDate
exception:
SQLException - thrown in case of error
Parameters:
column - the column being retrieved the java.sql.Date object for the column |
| getDate | | public java.sql.Date getDate(String columnName) throws SQLException(Code) | | Get a named column as a java.sql.Date
Parameters:
columnName - is the SQL name of the column the column value; if isNull the value is null |
| getDate | | public java.sql.Date getDate(int columnIndex, Calendar cal) throws SQLException(Code) | | JDBC 2.0
Gets the value of a column in the current row as a java.sql.Date
object. This method uses the given calendar to construct an appropriate millisecond
value for the Date if the underlying database does not store
timezone information.
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) | | Gets the value of a column in the current row as a java.sql.Date
object. This method uses the given calendar to construct an appropriate millisecond
value for the Date, if the underlying database does not store
timezone information.
Parameters:
columnName - the SQL name of the column from which to retrieve the value
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(String columnName) throws SQLException(Code) | | Get the double value of a named column
Parameters:
columnName - is the SQL name of the column the column value; if isNull the value is 0 |
| getFetchDirection | | public int getFetchDirection() throws SQLException(Code) | | JDBC 2.0
Returns the fetch direction for this result set.
the current fetch direction for this result set
exception:
SQLException - if a database access error occurs |
| getFetchSize | | public int getFetchSize() throws SQLException(Code) | | JDBC 2.0
Returns the fetch size for this result set.
the current fetch size for this result set
exception:
SQLException - if a database access error occurs |
| getFloat | | public float getFloat(String columnName) throws SQLException(Code) | | Get the float value of a column by name
Parameters:
columnName - is the SQL name of the column the column value; if isNull the value is 0 |
| getInt | | public int getInt(int column) throws SQLException(Code) | | Retrieve a column from the current row as an int
See Also: java.sql.ResultSet.getInt
exception:
SQLException - bad things... the wind began to howl...
Parameters:
column - the column being retrieved the column as an integer |
| getInt | | public int getInt(String columnName) throws SQLException(Code) | | Get the integer value of a column by name
Parameters:
columnName - is the SQL name of the column the column value; if isNull the value is 0 |
| getLong | | public long getLong(String columnName) throws SQLException(Code) | | Get the long value of a column by name
Parameters:
columnName - is the SQL name of the column the column value; if isNull the value is 0 |
| getObject | | public Object getObject(int column, int type, int scale) throws SQLException(Code) | | Retrieves data as objects
See Also: java.sql.ResultSet.getObject
exception:
SQLException - in the event of an error
Parameters:
column - the column desired
Parameters:
type - the SQL data type of the field the column specified as an Object |
| getObject | | public Object getObject(int column, int type) throws SQLException(Code) | | Same as above, except with a default scale to 0.
|
| getObject | | public Object getObject(int column) throws SQLException(Code) | | Same as above, except using the column's default SQL type.
|
| getObject | | public Object getObject(String columnName, int sqlType, int scale) throws SQLException(Code) | | Get the value of a named column as an object
Parameters:
columnName - the SQL column name
Parameters:
sqlType - SQL type code defined by java.sql.Types the parameter as an Object |
| getObject | | public Object getObject(int i, java.util.Map map) throws SQLException(Code) | | JDBC 2.0
Returns the value of a column in the current row as a Java object.
This method uses the given Map object
for the custom mapping of the
SQL structured or distinct type that is being retrieved.
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 |
| getObject | | public Object getObject(String colName, java.util.Map map) throws SQLException(Code) | | JDBC 2.0
Returns the value in the specified column as a Java object.
This method uses the specified Map object for
custom mapping if appropriate.
Parameters:
colName - the name of the column from which to retrieve the value
Parameters:
map - the mapping from SQL type names to Java classes an object representing the SQL value in the specified column |
| getRef | | public Ref getRef(int i) throws SQLException(Code) | | JDBC 2.0
Gets a REF(<structured-type>) column value from the current row.
Parameters:
i - the first column is 1, the second is 2, ... a Ref object representing an SQL REF value |
| getRef | | public Ref getRef(String colName) throws SQLException(Code) | | JDBC 2.0
Gets a REF(<structured-type>) column value from the current row.
Parameters:
colName - the column name a Ref object representing the SQL REF value inthe specified column |
| getRow | | public int getRow() throws SQLException(Code) | | JDBC 2.0
Retrieves the current row number. The first row is number 1, the
second number 2, and so on.
the current row number; 0 if there is no current row
exception:
SQLException - if a database access error occurs |
| getShort | | public short getShort(String columnName) throws SQLException(Code) | | Get the value of a short by column name
Parameters:
columnName - is the SQL name of the column the column value; if isNull the value is 0 |
| getStatement | | public Statement getStatement() throws SQLException(Code) | | JDBC 2.0
Returns the Statement that produced this ResultSet object.
If the result set was generated some other way, such as by a
DatabaseMetaData method, this method returns null.
the Statment that produced the result set ornull if the result set was produced some other way
exception:
SQLException - if a database access error occurs |
| getTime | | public java.sql.Time getTime(String columnName) throws SQLException(Code) | | Get a named column as a java.sql.Time
Parameters:
columnName - is the SQL name of the column the column value; if isNull the value is null |
| getTime | | public java.sql.Time getTime(int columnIndex, Calendar cal) throws SQLException(Code) | | Gets the value of a column in the current row as a java.sql.Time
object. This method uses the given calendar to construct an appropriate millisecond
value for the Time if the underlying database does not 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 java.sql.Time getTime(String columnName, Calendar cal) throws SQLException(Code) | | Gets the value of a column in the current row as a java.sql.Time
object. This method uses the given calendar to construct an appropriate millisecond
value for the Time if the underlying database does not store
timezone information.
Parameters:
columnName - 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 java.sql.Timestamp getTimestamp(String columnName) throws SQLException(Code) | | Get a named column as a java.sql.Time
Parameters:
columnName - is the SQL name of the column the column value; if isNull the value is null |
| getTimestamp | | public java.sql.Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException(Code) | | Gets the value of a column in the current row as a java.sql.Timestamp
object. This method uses the given calendar to construct an appropriate millisecond
value for the Timestamp if the underlying database does not store
timezone information.
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) | | Gets the value of a column in the current row as a java.sql.Timestamp
object. This method uses the given calendar to construct an appropriate millisecond
value for the Timestamp if the underlying database does not store
timezone information.
Parameters:
columnName - 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
Returns the type of this result set. The type is determined by
the statement that created the result set.
TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, orTYPE_SCROLL_SENSITIVE
exception:
SQLException - if a database access error occurs |
| insertRow | | public void insertRow() throws SQLException(Code) | | JDBC 2.0
Inserts 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 on the insert row, or if not all of non-nullable columns inthe insert row have been given a value |
| isAfterLast | | public boolean isAfterLast() throws SQLException(Code) | | JDBC 2.0
Indicates whether the cursor is after the last row in the result
set.
true if the cursor is after the last row, false otherwise. Returnsfalse when the result set contains no rows.
exception:
SQLException - if a database access error occurs |
| isBeforeFirst | | public boolean isBeforeFirst() throws SQLException(Code) | | JDBC 2.0
Indicates whether the cursor is before the first row in the result
set.
true if the cursor is before the first row, false otherwise. Returnsfalse when the result set contains no rows.
exception:
SQLException - if a database access error occurs |
| isFirst | | public boolean isFirst() throws SQLException(Code) | | JDBC 2.0
Indicates whether the cursor is on the first row of the result set.
true if the cursor is on the first row, false otherwise.
exception:
SQLException - if a database access error occurs |
| isLast | | public boolean isLast() throws SQLException(Code) | | JDBC 2.0
Indicates whether the cursor is on the last row of the result set.
Note: Calling the method isLast may be expensive
because the JDBC driver
might need to fetch ahead one row in order to determine
whether the current row is the last row in the result set.
true if the cursor is 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 the cursor to the last row in the result set.
true if the cursor is on a valid row;false if there are no rows in the result set
exception:
SQLException - if a database access error occurs or theresult set type is TYPE_FORWARD_ONLY. |
| moveToCurrentRow | | public void moveToCurrentRow() throws SQLException(Code) | | JDBC 2.0
Moves the cursor to the remembered cursor position, usually the
current row. This method has no effect if the cursor is not on the insert
row.
exception:
SQLException - if a database access error occursor the result set is not updatable |
| moveToInsertRow | | public void moveToInsertRow() throws SQLException(Code) | | JDBC 2.0
Moves the cursor 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.
The method updateXXX must be called before a
getXXX method can be called on a column value.
exception:
SQLException - if a database access error occursor the result set is not updatable |
| previous | | public boolean previous() throws SQLException(Code) | | JDBC 2.0
Moves the cursor to the previous row in the result set.
Note: previous() is not the same as
relative(-1) because it
makes sense to callprevious() when there is no current row.
true if the cursor is on a valid row; false if it is off the result set
exception:
SQLException - if a database access error occurs or theresult set type is TYPE_FORWARD_ONLY |
| refreshRow | | public void refreshRow() throws SQLException(Code) | | JDBC 2.0
Refreshes the current row with its most recent 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 the method refreshRow frequently
will likely slow performance.
exception:
SQLException - if a database access error occurs or ifcalled when on the insert row |
| relative | | public boolean relative(int rows) throws SQLException(Code) | | JDBC 2.0
Moves the cursor 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 from calling next()
because is makes sense to call next() when there is no current row,
for example, when the cursor is positioned before the first row
or after the last row of the result set.
true if the cursor is on a row; false otherwise
exception:
SQLException - if a database access error occurs, thereis no current row, or the result set type is TYPE_FORWARD_ONLY |
| rowDeleted | | public boolean rowDeleted() throws SQLException(Code) | | JDBC 2.0
Indicates whether a 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 a row was deleted and deletions are detected
exception:
SQLException - if a database access error occurs
See Also: DatabaseMetaData.deletesAreDetected |
| rowInserted | | public boolean rowInserted() throws SQLException(Code) | | JDBC 2.0
Indicates whether the current row has had an insertion. The value returned
depends on whether or not the result set can detect visible inserts.
true if a row has had an insertion and insertions are detected
exception:
SQLException - if a database access error occurs
See Also: DatabaseMetaData.insertsAreDetected |
| rowUpdated | | public boolean rowUpdated() throws SQLException(Code) | | JDBC 2.0
Indicates whether 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 oranother, and updates are detected
exception:
SQLException - if a database access error occurs
See Also: DatabaseMetaData.updatesAreDetected |
| setFetchDirection | | public void setFetchDirection(int direction) throws SQLException(Code) | | JDBC 2.0
Gives 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.
exception:
SQLException - if a database access error occurs orthe result set type is TYPE_FORWARD_ONLY and the fetch direction is not FETCH_FORWARD. |
| setFetchSize | | public void setFetchSize(int rows) throws SQLException(Code) | | JDBC 2.0
Gives the JDBC driver a hint as to the number of rows that should
be fetched from the database when more rows are needed for this result
set. If the fetch size specified is zero, the JDBC driver
ignores the value and is free to make its own best guess as to what
the fetch size should be. The default value is set by the statement
that created 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 thecondition 0 <= rows <= this.getMaxRows() is not satisfied. |
| updateAsciiStream | | public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0
Updates 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 |
| updateAsciiStream | | public void updateAsciiStream(String columnName, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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 |
| updateBigDecimal | | public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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 |
| updateBinaryStream | | public void updateBinaryStream(String columnName, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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 |
| updateBoolean | | public void updateBoolean(String columnName, boolean x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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 |
| updateByte | | public void updateByte(String columnName, byte x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates a column with a byte array value.
The updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.
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 |
| updateBytes | | public void updateBytes(String columnName, byte x) throws SQLException(Code) | | JDBC 2.0
Updates a column with a byte array value.
The updateXXX methods are used to update column values in the
current row, or the insert row. The updateXXX methods do not
update the underlying database; instead the updateRow or insertRow
methods are called to update the database.
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
Updates 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 |
| updateCharacterStream | | public void updateCharacterStream(String columnName, java.io.Reader reader, int length) throws SQLException(Code) | | JDBC 2.0
Updates 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:
x - the new column value
Parameters:
length - of the stream
exception:
SQLException - if a database access error occurs |
| updateDate | | public void updateDate(int columnIndex, java.sql.Date x) throws SQLException(Code) | | JDBC 2.0
Updates 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 |
| updateDate | | public void updateDate(String columnName, java.sql.Date x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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 |
| updateDouble | | public void updateDouble(String columnName, double x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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 |
| updateFloat | | public void updateFloat(String columnName, float x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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 |
| updateInt | | public void updateInt(String columnName, int x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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 |
| updateLong | | public void updateLong(String columnName, long x) throws SQLException(Code) | | JDBC 2.0
Updates 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 |
| updateNull | | public void updateNull(String columnName) throws SQLException(Code) | | JDBC 2.0
Updates 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, int scale) throws SQLException(Code) | | JDBC 2.0
Updates 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 |
| updateObject | | public void updateObject(int columnIndex, Object x) throws SQLException(Code) | | JDBC 2.0
Updates 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 |
| updateObject | | public void updateObject(String columnName, Object x, int scale) throws SQLException(Code) | | JDBC 2.0
Updates 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 |
| updateObject | | public void updateObject(String columnName, Object x) throws SQLException(Code) | | JDBC 2.0
Updates 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 |
| updateRow | | public void updateRow() throws SQLException(Code) | | JDBC 2.0
Updates 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 orif called when on the insert row |
| updateShort | | public void updateShort(int columnIndex, short x) throws SQLException(Code) | | JDBC 2.0
Updates 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 |
| updateShort | | public void updateShort(String columnName, short x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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 |
| updateString | | public void updateString(String columnName, String x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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 |
| updateTime | | public void updateTime(String columnName, java.sql.Time x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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 |
| updateTimestamp | | public void updateTimestamp(String columnName, java.sql.Timestamp x) throws SQLException(Code) | | JDBC 2.0
Updates 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) | | Returns whether or not the last column read was null.
tinySQL doesn't have nulls, so this is inconsequential...
See Also: java.sql.ResultSet.wasNull true if the column was null, false otherwise |
|
|