Interface ResultRow
- All Known Implementing Classes:
DelegatingResultRow
ResultSet
.
This interface replicates the value retrieval API of ResultSet
and serves as a view of the current row in a result set.
The main purpose of this interface is to support iteration over result sets.
-
Method Summary
Modifier and TypeMethodDescriptionint
findColumn
(String columnLabel) Retrieves index of a column with the specified label.boolean
getBoolean
(int columnIndex) Retrieves value from column at the specified index and returns it as aboolean
.boolean
getBoolean
(String columnLabel) Retrieves value from column with the specified label and returns it as aboolean
.byte
getByte
(int columnIndex) Retrieves value from column at the specified index and returns it asbyte
.byte
Retrieves value from column with the specified label and returns it asbyte
.int
Gets the count of available columns.double
getDouble
(int columnIndex) Retrieves value from column at the specified index and returns it asdouble
.double
Retrieves value from column with the specified label and returns it asdouble
.float
getFloat
(int columnIndex) Retrieves value from column at the specified index and returns it asfloat
.float
Retrieves value from column with the specified label and returns it asfloat
.int
getIndex()
Gets the index of this row (first row has index 0).int
getInt
(int columnIndex) Retrieves value from column at the specified index and returns it asint
.int
Retrieves value from column with the specified label and returns it asint
.long
getLong
(int columnIndex) Retrieves value from column at the specified index and returns it aslong
.long
Retrieves value from column with the specified label and returns it aslong
.getObject
(int columnIndex) Retrieves value from column at the specified index and returns it asObject
.<T> T
Retrieves value from column at the specified index and returns it as an instance of the specified class.Retrieves value from column with the specified label and returns it asObject
.<T> T
Retrieves value from column with the specified label and returns it as an instance of the specified class.short
getShort
(int columnIndex) Retrieves value of column at the specified index and returns it asshort
.short
Retrieves value of column with the specified label and returns it asshort
.getString
(int columnIndex) Retrieves value of column at the specified index and returns it asString
.Retrieves value of column with the specified label and returns it asString
.boolean
isBound
(int variableIndex) Checks whether a value at the specified index is bound in the current result row.boolean
Checks whether a value of the specified variable is bound in the current result row.
-
Method Details
-
findColumn
Retrieves index of a column with the specified label.- Parameters:
columnLabel
- Label of the column- Returns:
- index of the column or -1 if there is no such column
- Throws:
IllegalStateException
- If called on a closed result set
-
getColumnCount
int getColumnCount()Gets the count of available columns.This number corresponds to the number of result variables bound in the query.
- Returns:
- Number of columns in the result set
- Throws:
IllegalStateException
- If called on a closed result set
-
isBound
Checks whether a value at the specified index is bound in the current result row.Note that this method will return
false
also in case the index is out of range of the variables known to the result set as a whole.- Parameters:
variableIndex
- Index of the variable- Returns:
true
when value is bound in the current row,false
otherwise- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- When unable to resolve binding status
-
isBound
Checks whether a value of the specified variable is bound in the current result row.Note that this method will return
false
also in case the variable is not known to the result set at all.- Parameters:
variableName
- Variable name- Returns:
true
when value is bound in the current row,false
otherwise- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- When unable to resolve binding status
-
getBoolean
Retrieves value from column at the specified index and returns it as aboolean
.- Parameters:
columnIndex
- Column index, the first column has index 0- Returns:
boolean
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If thecolumnIndex
is not a valid column index, the value cannot be cast toboolean
or there occurs some other error
-
getBoolean
Retrieves value from column with the specified label and returns it as aboolean
.- Parameters:
columnLabel
- Label of the column- Returns:
boolean
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If there is no column with the specified label, the value cannot be cast toboolean
or there occurs some other error
-
getByte
Retrieves value from column at the specified index and returns it asbyte
.- Parameters:
columnIndex
- Column index, the first column has index 0- Returns:
byte
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If thecolumnIndex
is not a valid column index, the value cannot be cast tobyte
or there occurs some other error
-
getByte
Retrieves value from column with the specified label and returns it asbyte
.- Parameters:
columnLabel
- Label of the column- Returns:
byte
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If there is no column with the specified label, the value cannot be cast tobyte
or there occurs some other error
-
getDouble
Retrieves value from column at the specified index and returns it asdouble
.- Parameters:
columnIndex
- Column index, the first column has index 0- Returns:
double
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If thecolumnIndex
is not a valid column index, the value cannot be cast todouble
or there occurs some other error
-
getDouble
Retrieves value from column with the specified label and returns it asdouble
.- Parameters:
columnLabel
- Label of the column- Returns:
double
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If there is no column with the specified label, the value cannot be cast todouble
or there occurs some other error
-
getFloat
Retrieves value from column at the specified index and returns it asfloat
.- Parameters:
columnIndex
- Column index, the first column has index 0- Returns:
float
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If thecolumnIndex
is not a valid column index, the value cannot be cast tofloat
or there occurs some other error
-
getFloat
Retrieves value from column with the specified label and returns it asfloat
.- Parameters:
columnLabel
- Label of the column- Returns:
float
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If there is no column with the specified label, the value cannot be cast tofloat
or there occurs some other error
-
getInt
Retrieves value from column at the specified index and returns it asint
.- Parameters:
columnIndex
- Column index, the first column has index 0- Returns:
int
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If thecolumnIndex
is not a valid column index, the value cannot be cast toint
or there occurs some other error
-
getInt
Retrieves value from column with the specified label and returns it asint
.- Parameters:
columnLabel
- Label of the column- Returns:
int
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If there is no column with the specified label, the value cannot be cast toint
or there occurs some other error
-
getLong
Retrieves value from column at the specified index and returns it aslong
.- Parameters:
columnIndex
- Column index, the first column has index 0- Returns:
long
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If thecolumnIndex
is not a valid column index, the value cannot be cast tolong
or there occurs some other error
-
getLong
Retrieves value from column with the specified label and returns it aslong
.- Parameters:
columnLabel
- Label of the column- Returns:
long
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If there is no column with the specified label, the value cannot be cast tolong
or there occurs some other error
-
getObject
Retrieves value from column at the specified index and returns it asObject
.- Parameters:
columnIndex
- Column index, the first column has index 0- Returns:
- column value cast to
Object
- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If thecolumnIndex
is not a valid column index or there occurs some other error
-
getObject
Retrieves value from column with the specified label and returns it asObject
.- Parameters:
columnLabel
- Label of the column- Returns:
- column value cast to
Object
- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If there is no column with the specified label or there occurs some other error
-
getObject
Retrieves value from column at the specified index and returns it as an instance of the specified class.The mechanism of transforming the value to the specified class is not specified, it can be merely type casting or calling a constructor of the specified type.
- Type Parameters:
T
- Return type- Parameters:
columnIndex
- Column index, the first column has index 0cls
- Requested class type- Returns:
- Value of the column
- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If thecolumnIndex
is not a valid column index, the value cannot be cast to the specified type or there occurs some other error
-
getObject
Retrieves value from column with the specified label and returns it as an instance of the specified class.The mechanism of transforming the value to the specified class is not specified, it can be merely type casting or calling a constructor of the specified type.
- Type Parameters:
T
- Return type- Parameters:
columnLabel
- Label of the columncls
- Requested class type- Returns:
- Value of the column.
- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If there is no column with the specified label, the value cannot be cast to the specified type or there occurs some other error
-
getShort
Retrieves value of column at the specified index and returns it asshort
.- Parameters:
columnIndex
- Column index, the first column has index 0- Returns:
short
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If thecolumnIndex
is not a valid column index, the value cannot be cast toshort
or there occurs some other error
-
getShort
Retrieves value of column with the specified label and returns it asshort
.- Parameters:
columnLabel
- Label of the column- Returns:
short
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If there is no column with the specified label, the value cannot be cast toshort
or there occurs some other error
-
getString
Retrieves value of column at the specified index and returns it asString
.- Parameters:
columnIndex
- Column index, the first column has index 0- Returns:
String
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If thecolumnIndex
is not a valid column index, the value cannot be cast toString
or there occurs some other error
-
getString
Retrieves value of column with the specified label and returns it asString
.- Parameters:
columnLabel
- Label of the column- Returns:
String
value- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If there is no column with the specified label, the value cannot be cast toString
or there occurs some other error
-
getIndex
Gets the index of this row (first row has index 0).- Returns:
- Index of this row
- Throws:
IllegalStateException
- If called on a closed result setOntoDriverException
- If some other error occurs
-