Top Description Inners Fields Constructors Methods
org.h2.tools

public Class SimpleResultSet

extends Object
implements ResultSet, ResultSetMetaData
Class Inheritance
All Implemented Interfaces
java.sql.ResultSetMetaData, java.sql.Wrapper, java.sql.ResultSet, java.lang.AutoCloseable
Imports
java.io.InputStream, .Reader, java.math.BigDecimal, .BigInteger, java.net.URL, java.sql.Array, .Blob, .Clob, .Date, .NClob, .Ref, .ResultSet, .ResultSetMetaData, .RowId, .SQLException, .SQLWarning, .SQLXML, .Statement, .Time, .Timestamp, .Types, java.util.ArrayList, .Calendar, .Map, .UUID, org.h2.api.ErrorCode, org.h2.message.DbException, org.h2.util.Bits, .JdbcUtils, .MathUtils, .SimpleColumnInfo, .Utils, org.h2.value.DataType, .Value, .ValueToObjectConverter

This class is a simple result set and meta data implementation. It can be used in Java functions that return a result set. Only the most basic methods are implemented, the others throw an exception. This implementation is standalone, and only relies on standard classes. It can be extended easily if required. An application can create a result set using the following code:
SimpleResultSet rs = new SimpleResultSet();
rs.addColumn("ID", Types.INTEGER, 10, 0);
rs.addColumn("NAME", Types.VARCHAR, 255, 0);
rs.addRow(0, "Hello" });
rs.addRow(1, "World" });

Nested and Inner Type Summary

Modifier and TypeClass and Description
public static class
SimpleResultSet.SimpleArray

A simple array implementation, backed by an object array

Field Summary

Modifier and TypeField and Description
private boolean
private ArrayList<SimpleColumnInfo>
private Object[]
private int
private ArrayList<Object[]>
private SimpleRowSource
private boolean

Constructor Summary

AccessConstructor and Description
public
SimpleResultSet()

This constructor is used if the result set is later populated with addRow.

public
SimpleResultSet(SimpleRowSource
the row source
source
)

This constructor is used if the result set should retrieve the rows using the specified row source object.

Method Summary

Modifier and TypeMethod and Description
public boolean
absolute(int
the number of the row to which the cursor should move. A value of zero indicates that the cursor will be positioned before the first row; a positive number indicates the row number counting from the beginning of the result set; a negative number indicates the row number counting from the end of the result set
row
)

Implements java.sql.ResultSet.absolute.

INTERNAL

public void
addColumn(String
null is replaced with C1, C2,...
name
,
int
the value returned in getColumnType(..)
sqlType
,
int
the precision
precision
,
int
the scale
scale
)

Adds a column to the result set.

public void
addColumn(String
null is replaced with C1, C2,...
name
,
int
the value returned in getColumnType(..)
sqlType
,
String
the type name return in getColumnTypeName(..)
sqlTypeName
,
int
the precision
precision
,
int
the scale
scale
)

Adds a column to the result set.

public void
addRow(Object...
the row as an array of objects
row
)

Add a new row to the result set.

public void
private static InputStream
private static Reader
public void
beforeFirst()

Implements java.sql.ResultSet.beforeFirst.

Moves the current position to before the first row, that means the result set is reset.

public void
private void
private void
checkColumnIndex(int columnIndex)

public void
public void
close()

Implements java.sql.ResultSet.close.

Closes the result set and releases the resources.

public void
public int

Returns:

the column index (1,2,...)
findColumn
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.findColumn.

Searches for a specific column in the result set.

public boolean
first()

Implements java.sql.ResultSet.first.

INTERNAL

private Object
get(int columnIndex)

public Array

Returns:

the value
getArray
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getArray.

Returns the value as a java.sql.Array.

public Array

Returns:

the value
getArray
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getArray.

Returns the value as a java.sql.Array.

public InputStream
getAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getAsciiStream.

INTERNAL

public InputStream
getAsciiStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getAsciiStream.

INTERNAL

public boolean

Returns:

the auto-close value
getAutoClose
()

Get the current auto-close behavior.

public BigDecimal

Returns:

the value
getBigDecimal
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getBigDecimal.

Returns the value as a java.math.BigDecimal.

public BigDecimal

Returns:

the value
getBigDecimal
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getBigDecimal.

Returns the value as a java.math.BigDecimal.

public BigDecimal
getBigDecimal(int
the first column is 1, the second is 2, ...
columnIndex
,
int
the number of digits to the right of the decimal point
scale
)

Implements java.sql.ResultSet.getBigDecimal.

Deprecated INTERNAL

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.BigDecimal in the Java programming language.

public BigDecimal
getBigDecimal(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
int
the number of digits to the right of the decimal point
scale
)

Implements java.sql.ResultSet.getBigDecimal.

Deprecated INTERNAL

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal in the Java programming language.

public InputStream

Returns:

the value
getBinaryStream
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getBinaryStream.

Returns the value as a java.io.InputStream.

public InputStream

Returns:

the value
getBinaryStream
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getBinaryStream.

Returns the value as a java.io.InputStream.

public Blob

Returns:

the value
getBlob
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getBlob.

Returns the value as a java.sql.Blob.

public Blob

Returns:

the value
getBlob
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getBlob.

Returns the value as a java.sql.Blob.

public boolean

Returns:

the value
getBoolean
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getBoolean.

Returns the value as a boolean.

public boolean

Returns:

the value
getBoolean
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getBoolean.

Returns the value as a boolean.

public byte

Returns:

the value
getByte
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getByte.

Returns the value as a byte.

public byte

Returns:

the value
getByte
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getByte.

Returns the value as a byte.

public byte[]

Returns:

the value
getBytes
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getBytes.

Returns the value as a byte array.

public byte[]

Returns:

the value
getBytes
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getBytes.

Returns the value as a byte array.

public String

Returns:

empty string
getCatalogName
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.getCatalogName.

Returns empty string.

public Reader

Returns:

the value
getCharacterStream
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getCharacterStream.

Returns the value as a java.io.Reader.

public Reader

Returns:

the value
getCharacterStream
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getCharacterStream.

Returns the value as a java.io.Reader.

public Clob

Returns:

the value
getClob
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getClob.

Returns the value as a java.sql.Clob.

public Clob

Returns:

the value
getClob
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getClob.

Returns the value as a java.sql.Clob.

private SimpleColumnInfo
getColumn(int i)

public String

Returns:

the class name
getColumnClassName
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.getColumnClassName.

Returns the Java class name if this column.

public int

Returns:

the column count
getColumnCount
()

Implements java.sql.ResultSetMetaData.getColumnCount.

Returns the column count.

public int

Returns:

15
getColumnDisplaySize
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.getColumnDisplaySize.

Returns 15.

public String

Returns:

the column label
getColumnLabel
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.getColumnLabel.

Returns the column label.

public String

Returns:

the column name
getColumnName
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.getColumnName.

Returns the column name.

public int

Returns:

the SQL type
getColumnType
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.getColumnType.

Returns the SQL type.

public String

Returns:

the type name
getColumnTypeName
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.getColumnTypeName.

Returns the data type name of a column.

public int

Returns:

CONCUR_READ_ONLY
getConcurrency
()

Implements java.sql.ResultSet.getConcurrency.

Returns ResultSet.CONCUR_READ_ONLY.

public String
public Date

Returns:

the value
getDate
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getDate.

Returns the value as an java.sql.Date.

public Date

Returns:

the value
getDate
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getDate.

Returns the value as a java.sql.Date.

public Date
getDate(int
the first column is 1, the second is 2, ...
columnIndex
,
Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getDate.

INTERNAL

public Date
getDate(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getDate.

INTERNAL

public double

Returns:

the value
getDouble
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getDouble.

Returns the value as an double.

public double

Returns:

the value
getDouble
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getDouble.

Returns the value as a double.

public int

Returns:

FETCH_FORWARD
getFetchDirection
()

Implements java.sql.ResultSet.getFetchDirection.

Returns ResultSet.FETCH_FORWARD.

public int

Returns:

0
getFetchSize
()

Implements java.sql.ResultSet.getFetchSize.

Returns 0.

public float

Returns:

the value
getFloat
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getFloat.

Returns the value as a float.

public float

Returns:

the value
getFloat
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getFloat.

Returns the value as a float.

public int

Returns:

the holdability
getHoldability
()

Implements java.sql.ResultSet.getHoldability.

Returns the current result set holdability.

public int

Returns:

the value
getInt
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getInt.

Returns the value as an int.

public int

Returns:

the value
getInt
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getInt.

Returns the value as an int.

public long

Returns:

the value
getLong
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getLong.

Returns the value as a long.

public long

Returns:

the value
getLong
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getLong.

Returns the value as a long.

public ResultSetMetaData

Returns:

this
getMetaData
()

Implements java.sql.ResultSet.getMetaData.

Returns a reference to itself.

public Reader
getNCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getNCharacterStream.

INTERNAL

public Reader
getNCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getNCharacterStream.

INTERNAL

public NClob
getNClob(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getNClob.

INTERNAL

public NClob
getNClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getNClob.

INTERNAL

public String
getNString(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getNString.

INTERNAL

public String
getNString(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getNString.

INTERNAL

public Object

Returns:

the value
getObject
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getObject.

Returns the value as an Object.

public Object

Returns:

the value
getObject
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getObject.

Returns the value as an Object.

public <T> T

Returns:

the value
getObject
(int
the column index (1, 2, ...)
columnIndex
,
Class<T>
the class of the returned value
type
)

Implements java.sql.ResultSet.getObject.

Returns the value as an Object of the specified type.

public <T> T

Returns:

the value
getObject
(String
the column name
columnName
,
Class<T>
the class of the returned value
type
)

Implements java.sql.ResultSet.getObject.

Returns the value as an Object of the specified type.

public Object
getObject(int
the first column is 1, the second is 2, ...
columnIndex
,
Map<String, Class<?>>
a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language
map
)

Implements java.sql.ResultSet.getObject.

INTERNAL

public Object
getObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Map<String, Class<?>>
a java.util.Map object that contains the mapping from SQL type names to classes in the Java programming language
map
)

Implements java.sql.ResultSet.getObject.

INTERNAL

public int

Returns:

the precision
getPrecision
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.getPrecision.

Returns the precision.

public Ref
getRef(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getRef.

INTERNAL

public Ref
getRef(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getRef.

INTERNAL

public int

Returns:

0
getRow
()

Implements java.sql.ResultSet.getRow.

Returns the row number (1, 2,...) or 0 for no row.

public RowId
getRowId(int
the first column is 1, the second 2, ...
columnIndex
)

Implements java.sql.ResultSet.getRowId.

INTERNAL

public RowId
getRowId(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getRowId.

INTERNAL

public int

Returns:

the scale
getScale
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.getScale.

Returns the scale.

public String

Returns:

empty string
getSchemaName
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.getSchemaName.

Returns empty string.

public short

Returns:

the value
getShort
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getShort.

Returns the value as a short.

public short

Returns:

the value
getShort
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getShort.

Returns the value as a short.

public SQLXML
getSQLXML(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getSQLXML.

INTERNAL

public SQLXML
getSQLXML(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getSQLXML.

INTERNAL

public Statement

Returns:

null
getStatement
()

Implements java.sql.ResultSet.getStatement.

Returns null.

public String

Returns:

the value
getString
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getString.

Returns the value as a String.

public String

Returns:

the value
getString
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getString.

Returns the value as a String.

public String

Returns:

empty string
getTableName
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.getTableName.

Returns empty string.

public Time

Returns:

the value
getTime
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getTime.

Returns the value as an java.sql.Time.

public Time

Returns:

the value
getTime
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getTime.

Returns the value as a java.sql.Time.

public Time
getTime(int
the first column is 1, the second is 2, ...
columnIndex
,
Calendar
the java.util.Calendar object to use in constructing the time
cal
)

Implements java.sql.ResultSet.getTime.

INTERNAL

public Time
getTime(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Calendar
the java.util.Calendar object to use in constructing the time
cal
)

Implements java.sql.ResultSet.getTime.

INTERNAL

public Timestamp

Returns:

the value
getTimestamp
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSet.getTimestamp.

Returns the value as an java.sql.Timestamp.

public Timestamp

Returns:

the value
getTimestamp
(String
the column label
columnLabel
)

Implements java.sql.ResultSet.getTimestamp.

Returns the value as a java.sql.Timestamp.

public Timestamp
getTimestamp(int
the first column is 1, the second is 2, ...
columnIndex
,
Calendar
the java.util.Calendar object to use in constructing the timestamp
cal
)

Implements java.sql.ResultSet.getTimestamp.

INTERNAL

public Timestamp
getTimestamp(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Calendar
the java.util.Calendar object to use in constructing the date
cal
)

Implements java.sql.ResultSet.getTimestamp.

INTERNAL

public int

Returns:

TYPE_FORWARD_ONLY or TYPE_SCROLL_INSENSITIVE
getType
()

Implements java.sql.ResultSet.getType.

Returns the result set type.

public InputStream
getUnicodeStream(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.getUnicodeStream.

Deprecated INTERNAL

Retrieves the value of the designated column in the current row of this ResultSet object as as a stream of two-byte 3 characters.

public InputStream
getUnicodeStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getUnicodeStream.

Deprecated INTERNAL

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of two-byte Unicode characters.

pack-priv static SQLException
public URL
getURL(int
the index of the column 1 is the first, 2 is the second,...
columnIndex
)

Implements java.sql.ResultSet.getURL.

INTERNAL

public URL
getURL(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.getURL.

INTERNAL

public SQLWarning

Returns:

null
getWarnings
()

Implements java.sql.ResultSet.getWarnings.

Returns null.

public void
public boolean
public boolean

Returns:

false
isAutoIncrement
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.isAutoIncrement.

Returns false.

public boolean
public boolean

Returns:

true
isCaseSensitive
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.isCaseSensitive.

Returns true.

public boolean

Returns:

true if the result set was closed
isClosed
()

Implements java.sql.ResultSet.isClosed.

Returns whether this result set has been closed.

public boolean

Returns:

false
isCurrency
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.isCurrency.

Returns false.

public boolean

Returns:

false
isDefinitelyWritable
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.isDefinitelyWritable.

Returns false.

public boolean
isFirst()

Implements java.sql.ResultSet.isFirst.

INTERNAL

public boolean
isLast()

Implements java.sql.ResultSet.isLast.

INTERNAL

public int

Returns:

columnNullableUnknown
isNullable
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.isNullable.

Returns ResultSetMetaData.columnNullableUnknown.

public boolean

Returns:

true
isReadOnly
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.isReadOnly.

Returns true.

public boolean

Returns:

true
isSearchable
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.isSearchable.

Returns true.

public boolean

Returns:

true
isSigned
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.isSigned.

Returns true.

public boolean

Returns:

whether or not the interface is assignable from this class
isWrapperFor
(Class<?>
the class
iface
)

Implements java.sql.Wrapper.isWrapperFor.

Checks if unwrap can return an object of this class.

public boolean

Returns:

false
isWritable
(int
(1,2,...)
columnIndex
)

Implements java.sql.ResultSetMetaData.isWritable.

Returns false.

public boolean
last()

Implements java.sql.ResultSet.last.

INTERNAL

public void
public void
public boolean

Returns:

true if successful, false if there are no more rows
next
()

Implements java.sql.ResultSet.next.

Moves the cursor to the next row of the result set.

public boolean
previous()

Implements java.sql.ResultSet.previous.

INTERNAL

public void
public boolean
relative(int
an int specifying the number of rows to move from the current row; a positive number moves the cursor forward; a negative number moves the cursor backward
offset
)

Implements java.sql.ResultSet.relative.

INTERNAL

public boolean
public boolean
public boolean
public void
setAutoClose(boolean
the new value
autoClose
)

Set the auto-close behavior.

public void
setFetchDirection(int
an int specifying the suggested fetch direction; one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
direction
)

Implements java.sql.ResultSet.setFetchDirection.

INTERNAL

public void
setFetchSize(int
the number of rows to fetch
rows
)

Implements java.sql.ResultSet.setFetchSize.

INTERNAL

public <T> T

Returns:

this
unwrap
(Class<T>
the class
iface
)

Implements java.sql.Wrapper.unwrap.

Return an object of this class if possible.

private void
update(int columnIndex, Object obj)

private void
update(String columnLabel, Object obj)

public void
updateArray(int
the first column is 1, the second is 2, ...
columnIndex
,
Array
the new column value
x
)

Implements java.sql.ResultSet.updateArray.

INTERNAL

public void
updateArray(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Array
the new column value
x
)

Implements java.sql.ResultSet.updateArray.

INTERNAL

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateAsciiStream.

INTERNAL

public void
updateAsciiStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateAsciiStream.

INTERNAL

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

INTERNAL

public void
updateAsciiStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

INTERNAL

public void
updateAsciiStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

INTERNAL

public void
updateAsciiStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateAsciiStream.

INTERNAL

public void
updateBigDecimal(int
the first column is 1, the second is 2, ...
columnIndex
,
BigDecimal
the new column value
x
)

Implements java.sql.ResultSet.updateBigDecimal.

INTERNAL

public void
updateBigDecimal(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
BigDecimal
the new column value
x
)

Implements java.sql.ResultSet.updateBigDecimal.

INTERNAL

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateBinaryStream.

INTERNAL

public void
updateBinaryStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
the new column value
x
)

Implements java.sql.ResultSet.updateBinaryStream.

INTERNAL

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

INTERNAL

public void
updateBinaryStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

INTERNAL

public void
updateBinaryStream(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

INTERNAL

public void
updateBinaryStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateBinaryStream.

INTERNAL

public void
updateBlob(int
the first column is 1, the second is 2, ...
columnIndex
,
Blob
the new column value
x
)

Implements java.sql.ResultSet.updateBlob.

INTERNAL

public void
updateBlob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Blob
the new column value
x
)

Implements java.sql.ResultSet.updateBlob.

INTERNAL

public void
updateBlob(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
An object that contains the data to set the parameter value to.
x
)

Implements java.sql.ResultSet.updateBlob.

INTERNAL

public void
updateBlob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
An object that contains the data to set the parameter value to.
x
)

Implements java.sql.ResultSet.updateBlob.

INTERNAL

public void
updateBlob(int
the first column is 1, the second is 2, ...
columnIndex
,
InputStream
An object that contains the data to set the parameter value to.
x
,
long
the number of bytes in the parameter data.
length
)

Implements java.sql.ResultSet.updateBlob.

INTERNAL

public void
updateBlob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
InputStream
An object that contains the data to set the parameter value to.
x
,
long
the number of bytes in the parameter data.
length
)

Implements java.sql.ResultSet.updateBlob.

INTERNAL

public void
updateBoolean(int
the first column is 1, the second is 2, ...
columnIndex
,
boolean
the new column value
x
)

Implements java.sql.ResultSet.updateBoolean.

INTERNAL

public void
updateBoolean(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
boolean
the new column value
x
)

Implements java.sql.ResultSet.updateBoolean.

INTERNAL

public void
updateByte(int
the first column is 1, the second is 2, ...
columnIndex
,
byte
the new column value
x
)

Implements java.sql.ResultSet.updateByte.

INTERNAL

public void
updateByte(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
byte
the new column value
x
)

Implements java.sql.ResultSet.updateByte.

INTERNAL

public void
updateBytes(int
the first column is 1, the second is 2, ...
columnIndex
,
byte[]
the new column value
x
)

Implements java.sql.ResultSet.updateBytes.

INTERNAL

public void
updateBytes(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
byte[]
the new column value
x
)

Implements java.sql.ResultSet.updateBytes.

INTERNAL

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
)

Implements java.sql.ResultSet.updateCharacterStream.

INTERNAL

public void
updateCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
the java.io.Reader object containing the new column value
x
)

Implements java.sql.ResultSet.updateCharacterStream.

INTERNAL

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

INTERNAL

public void
updateCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
the java.io.Reader object containing the new column value
x
,
int
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

INTERNAL

public void
updateCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

INTERNAL

public void
updateCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
the java.io.Reader object containing the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateCharacterStream.

INTERNAL

public void
updateClob(int
the first column is 1, the second is 2, ...
columnIndex
,
Clob
the new column value
x
)

Implements java.sql.ResultSet.updateClob.

INTERNAL

public void
updateClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Clob
the new column value
x
)

Implements java.sql.ResultSet.updateClob.

INTERNAL

public void
updateClob(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
x
)

Implements java.sql.ResultSet.updateClob.

INTERNAL

public void
updateClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
An object that contains the data to set the parameter value to.
x
)

Implements java.sql.ResultSet.updateClob.

INTERNAL

public void
updateClob(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
x
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateClob.

INTERNAL

public void
updateClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
An object that contains the data to set the parameter value to.
x
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateClob.

INTERNAL

public void
updateDate(int
the first column is 1, the second is 2, ...
columnIndex
,
Date
the new column value
x
)

Implements java.sql.ResultSet.updateDate.

INTERNAL

public void
updateDate(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Date
the new column value
x
)

Implements java.sql.ResultSet.updateDate.

INTERNAL

public void
updateDouble(int
the first column is 1, the second is 2, ...
columnIndex
,
double
the new column value
x
)

Implements java.sql.ResultSet.updateDouble.

INTERNAL

public void
updateDouble(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
double
the new column value
x
)

Implements java.sql.ResultSet.updateDouble.

INTERNAL

public void
updateFloat(int
the first column is 1, the second is 2, ...
columnIndex
,
float
the new column value
x
)

Implements java.sql.ResultSet.updateFloat.

INTERNAL

public void
updateFloat(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
float
the new column value
x
)

Implements java.sql.ResultSet.updateFloat.

INTERNAL

public void
updateInt(int
the first column is 1, the second is 2, ...
columnIndex
,
int
the new column value
x
)

Implements java.sql.ResultSet.updateInt.

INTERNAL

public void
updateInt(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
int
the new column value
x
)

Implements java.sql.ResultSet.updateInt.

INTERNAL

public void
updateLong(int
the first column is 1, the second is 2, ...
columnIndex
,
long
the new column value
x
)

Implements java.sql.ResultSet.updateLong.

INTERNAL

public void
updateLong(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
long
the new column value
x
)

Implements java.sql.ResultSet.updateLong.

INTERNAL

public void
updateNCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
)

Implements java.sql.ResultSet.updateNCharacterStream.

INTERNAL

public void
updateNCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
the java.io.Reader object containing the new column value
x
)

Implements java.sql.ResultSet.updateNCharacterStream.

INTERNAL

public void
updateNCharacterStream(int
the first column is 1, the second is 2, ...
columnIndex
,
Reader
the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateNCharacterStream.

INTERNAL

public void
updateNCharacterStream(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
the java.io.Reader object containing the new column value
x
,
long
the length of the stream
length
)

Implements java.sql.ResultSet.updateNCharacterStream.

INTERNAL

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex
,
NClob
the value for the column to be updated
x
)

Implements java.sql.ResultSet.updateNClob.

INTERNAL

public void
updateNClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
NClob
the value for the column to be updated
x
)

Implements java.sql.ResultSet.updateNClob.

INTERNAL

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
x
)

Implements java.sql.ResultSet.updateNClob.

INTERNAL

public void
updateNClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
An object that contains the data to set the parameter value to.
x
)

Implements java.sql.ResultSet.updateNClob.

INTERNAL

public void
updateNClob(int
the first column is 1, the second 2, ...
columnIndex
,
Reader
An object that contains the data to set the parameter value to.
x
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateNClob.

INTERNAL

public void
updateNClob(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Reader
An object that contains the data to set the parameter value to.
x
,
long
the number of characters in the parameter data.
length
)

Implements java.sql.ResultSet.updateNClob.

INTERNAL

public void
updateNString(int
the first column is 1, the second 2, ...
columnIndex
,
String
the value for the column to be updated
x
)

Implements java.sql.ResultSet.updateNString.

INTERNAL

public void
updateNString(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
String
the value for the column to be updated
x
)

Implements java.sql.ResultSet.updateNString.

INTERNAL

public void
updateNull(int
the first column is 1, the second is 2, ...
columnIndex
)

Implements java.sql.ResultSet.updateNull.

INTERNAL

public void
updateNull(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
)

Implements java.sql.ResultSet.updateNull.

INTERNAL

public void
updateObject(int
the first column is 1, the second is 2, ...
columnIndex
,
Object
the new column value
x
)

Implements java.sql.ResultSet.updateObject.

INTERNAL

public void
updateObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Object
the new column value
x
)

Implements java.sql.ResultSet.updateObject.

INTERNAL

public void
updateObject(int
the first column is 1, the second is 2, ...
columnIndex
,
Object
the new column value
x
,
int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scale
)

Implements java.sql.ResultSet.updateObject.

INTERNAL

public void
updateObject(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Object
the new column value
x
,
int
for an object of java.math.BigDecimal , this is the number of digits after the decimal point. For Java Object types InputStream and Reader, this is the length of the data in the stream or reader. For all other types, this value will be ignored.
scale
)

Implements java.sql.ResultSet.updateObject.

INTERNAL

public void
updateRef(int
the first column is 1, the second is 2, ...
columnIndex
,
Ref
the new column value
x
)

Implements java.sql.ResultSet.updateRef.

INTERNAL

public void
updateRef(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Ref
the new column value
x
)

Implements java.sql.ResultSet.updateRef.

INTERNAL

public void
public void
updateRowId(int
the first column is 1, the second 2, ...
columnIndex
,
RowId
the column value
x
)

Implements java.sql.ResultSet.updateRowId.

INTERNAL

public void
updateRowId(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
RowId
the column value
x
)

Implements java.sql.ResultSet.updateRowId.

INTERNAL

public void
updateShort(int
the first column is 1, the second is 2, ...
columnIndex
,
short
the new column value
x
)

Implements java.sql.ResultSet.updateShort.

INTERNAL

public void
updateShort(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
short
the new column value
x
)

Implements java.sql.ResultSet.updateShort.

INTERNAL

public void
updateSQLXML(int
the first column is 1, the second 2, ...
columnIndex
,
SQLXML
the value for the column to be updated
x
)

Implements java.sql.ResultSet.updateSQLXML.

INTERNAL

public void
updateSQLXML(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
SQLXML
the column value
x
)

Implements java.sql.ResultSet.updateSQLXML.

INTERNAL

public void
updateString(int
the first column is 1, the second is 2, ...
columnIndex
,
String
the new column value
x
)

Implements java.sql.ResultSet.updateString.

INTERNAL

public void
updateString(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
String
the new column value
x
)

Implements java.sql.ResultSet.updateString.

INTERNAL

public void
updateTime(int
the first column is 1, the second is 2, ...
columnIndex
,
Time
the new column value
x
)

Implements java.sql.ResultSet.updateTime.

INTERNAL

public void
updateTime(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Time
the new column value
x
)

Implements java.sql.ResultSet.updateTime.

INTERNAL

public void
updateTimestamp(int
the first column is 1, the second is 2, ...
columnIndex
,
Timestamp
the new column value
x
)

Implements java.sql.ResultSet.updateTimestamp.

INTERNAL

public void
updateTimestamp(String
the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
columnLabel
,
Timestamp
the new column value
x
)

Implements java.sql.ResultSet.updateTimestamp.

INTERNAL

public boolean

Returns:

true if the last column accessed was null
wasNull
()

Implements java.sql.ResultSet.wasNull.

Returns whether the last column accessed was null.

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait