public abstract class JRResultSet
extends java.lang.Object
implements java.sql.ResultSet
Constructor and Description |
---|
JRResultSet()
Constructs an uninitialized JRResultSet.
|
Modifier and Type | Method and Description |
---|---|
boolean |
absolute(int row)
JDBC 2.0
|
void |
afterLast()
JDBC 2.0
|
void |
beforeFirst()
JDBC 2.0
|
void |
cancelRowUpdates()
JDBC 2.0
The cancelRowUpdates() method may be called after calling an
updateXXX() method(s) and before calling updateRow() to rollback
the updates made to a row.
|
void |
clearWarnings()
Clears all the SQLWarnings after the calling getWarnings returns null.
|
abstract void |
close()
Closes the JResultSet and releases the resources.
|
void |
deleteRow()
JDBC 2.0
Deletes the current row from the result set and the underlying
database.
|
int |
findColumn(java.lang.String columnName)
Maps a name of a column to a column index.
|
boolean |
first()
JDBC 2.0
|
java.sql.Array |
getArray(int i)
JDBC 2.0
Gets an array column.
|
java.sql.Array |
getArray(java.lang.String colName)
JDBC 2.0
Gets an array column.
|
java.io.InputStream |
getAsciiStream(int columnIndex)
Gets the value of a column in the current row as a stream of ASCII characters,
and then this column value can be read in chunks from the this stream.
|
java.io.InputStream |
getAsciiStream(java.lang.String columnName)
Gets the value of a column in the current row as a stream of ASCII characters
and then the value of the column can be read in chunks from this stream.
|
java.math.BigDecimal |
getBigDecimal(int columnIndex)
JDBC 2.0
Gets the value of a column in the current row as a java.math.BigDecimal
object.
|
abstract java.math.BigDecimal |
getBigDecimal(int columnIndex,
int scale)
Gets the value of a column in the current row as a java.lang.BigDecimal object.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName)
JDBC 2.0
Gets the value of a column in the current row as a java.math.BigDecimal
object.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String columnName,
int scale)
Gets the value of a column in the current row as a java.lang.BigDecimal object.
|
abstract java.io.InputStream |
getBinaryStream(int columnIndex)
Gets the value of a column in the current row as a stream of uninterpreted bytes, then this
column value can be read in chunks from the this stream.
|
java.io.InputStream |
getBinaryStream(java.lang.String columnName)
Gets the value of a column in the current row as a stream of uninterpreted bytes
and then the value of the column can be read in chunks from this stream.
|
java.sql.Blob |
getBlob(int i)
JDBC 2.0
Gets a BLOB column.
|
java.sql.Blob |
getBlob(java.lang.String colName)
JDBC 2.0
Gets a BLOB column.
|
abstract boolean |
getBoolean(int columnIndex)
Gets the value of a column in the current row as a Java boolean.
|
boolean |
getBoolean(java.lang.String columnName)
Gets the value of a column in the current row as a Java boolean.
|
abstract byte |
getByte(int columnIndex)
Gets the value of a column in the current row as a Java byte.
|
byte |
getByte(java.lang.String columnName)
Gets the value of a column in the current row as a Java byte.
|
byte[] |
getBytes(int columnIndex)
Gets the value of a column in the current row as a Java byte array.
|
byte[] |
getBytes(java.lang.String columnName)
Gets the value of a column in the current row as a Java byte array.
|
java.io.Reader |
getCharacterStream(int columnIndex)
JDBC 2.0
|
java.io.Reader |
getCharacterStream(java.lang.String columnName)
JDBC 2.0
|
java.sql.Clob |
getClob(int i)
JDBC 2.0
Gets a CLOB column.
|
java.sql.Clob |
getClob(java.lang.String colName)
JDBC 2.0
Gets a CLOB column.
|
int |
getConcurrency()
JDBC 2.0
Returns the concurrency of this result set.
|
java.lang.String |
getCursorName()
Gets the name of the SQL cursor used by current ResultSet.
|
abstract java.sql.Date |
getDate(int columnIndex)
Gets the value of a column in the current row as a java.sql.Date object.
|
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar cal)
JDBC 2.0
Gets the value of a column in the current row as a java.sql.Date
object.
|
java.sql.Date |
getDate(java.lang.String columnName)
Gets the value of a column in the current row as a java.sql.Date object.
|
java.sql.Date |
getDate(java.lang.String col,
java.util.Calendar c) |
abstract double |
getDouble(int columnIndex)
Gets the value of a column in the current row as a Java double.
|
double |
getDouble(java.lang.String columnName)
Gets the value of a column in the current row as a Java double.
|
int |
getFetchDirection()
JDBC 2.0
Returns the fetched direction for this result set.
|
int |
getFetchSize()
JDBC 2.0
Returns the fetched size for this result set.
|
abstract float |
getFloat(int columnIndex)
Gets the value of a column in the current row as a Java float.
|
float |
getFloat(java.lang.String columnName)
Gets the value of a column in the current row as a Java float.
|
abstract int |
getInt(int columnIndex)
Gets the value of a column in the current row as a Java int.
|
int |
getInt(java.lang.String columnName)
Gets the value of a column in the current row as a Java int.
|
abstract long |
getLong(int columnIndex)
Gets the value of a column in the current row as a Java long
|
long |
getLong(java.lang.String columnName)
Gets the value of a column in the current row as a Java long.
|
java.sql.ResultSetMetaData |
getMetaData()
Gets the number, types and properties of ResultSet's columns.
|
java.lang.Object |
getObject(int columnIndex)
Gets the value of a column in the current row as a Java object.
|
java.lang.Object |
getObject(int i,
java.util.Map map)
JDBC 2.0
Returns the value of column @i as a Java object.
|
java.lang.Object |
getObject(java.lang.String columnName)
Gets the value of a column in the current row as a Java object.
|
java.lang.Object |
getObject(java.lang.String colName,
java.util.Map map)
JDBC 2.0
Returns the value of column @i as a Java object.
|
java.sql.Ref |
getRef(int i)
JDBC 2.0
Gets a REF(<structured-type>) column.
|
java.sql.Ref |
getRef(java.lang.String colName)
JDBC 2.0
Gets a REF(<structured-type>) column.
|
int |
getRow()
JDBC 2.0
|
abstract short |
getShort(int columnIndex)
Gets the value of a column in the current row as a Java short.
|
short |
getShort(java.lang.String columnName)
Gets the value of a column in the current row as a Java Short.
|
java.sql.Statement |
getStatement()
JDBC 2.0
Returns the Statement that produces the ResultSet.
|
abstract java.lang.String |
getString(int columnIndex)
Gets the value of a column in the current row as a Java String.
|
java.lang.String |
getString(java.lang.String columnName)
Gets the value of a column in the current row as a Java String.
|
abstract java.sql.Time |
getTime(int columnIndex)
Gets the value of a column in the current row as a java.sql.Time object.
|
java.sql.Time |
getTime(int col,
java.util.Calendar c) |
java.sql.Time |
getTime(java.lang.String columnName)
Gets the value of a column in the current row as a java.aql.Time object.
|
java.sql.Time |
getTime(java.lang.String col,
java.util.Calendar c) |
abstract java.sql.Timestamp |
getTimestamp(int columnIndex)
Gets the value of a column in the current row as a java.sql.Timestamp object.
|
java.sql.Timestamp |
getTimestamp(int col,
java.util.Calendar c) |
java.sql.Timestamp |
getTimestamp(java.lang.String columnName)
Gets the value of a column in the current row as a java.sql.Timestamp object.
|
java.sql.Timestamp |
getTimestamp(java.lang.String col,
java.util.Calendar c) |
int |
getType()
JDBC 2.0
Returns the type of this result set.
|
java.io.InputStream |
getUnicodeStream(int columnIndex)
Gets the value of a column in the current row as a stream of Unicode characters,
and then this column value can be read in chunks from the this stream.
|
java.io.InputStream |
getUnicodeStream(java.lang.String columnName)
Gets the value of a column in the current row as a stream of Unicode characters
and then the value of the column can be read in chunks from this stream.
|
java.net.URL |
getURL(int columnIndex) |
java.net.URL |
getURL(java.lang.String columnName) |
java.sql.SQLWarning |
getWarnings()
Gets the first SQLWarnings of the ResultSet warning chain.
|
abstract void |
initialize(JRColDesc[] colDescs,
java.lang.String[] args)
Initializes this JRResultSet.
|
void |
insertRow()
JDBC 2.0
Inserts the contents of the inserted row into the result set and
the database, which must be on the inserted row when this method is called.
|
boolean |
isAfterLast()
JDBC 2.0
|
boolean |
isBeforeFirst()
JDBC 2.0
|
boolean |
isFirst()
JDBC 2.0
|
boolean |
isLast()
JDBC 2.0
|
boolean |
last()
JDBC 2.0
|
void |
moveToCurrentRow()
JDBC 2.0
Moves the cursor to the remembered cursor position, which is usually the
current row.
|
void |
moveToInsertRow()
JDBC 2.0
Moves to the inserted row.
|
abstract boolean |
next()
Fetches a new row of data and returns true if it is OK.
|
boolean |
previous()
JDBC 2.0
|
void |
refreshRow()
JDBC 2.0
Refreshes the value of the current row with its current value in
the database.
|
boolean |
relative(int rows)
JDBC 2.0
|
boolean |
rowDeleted()
JDBC 2.0
Determines if this row has been deleted.
|
boolean |
rowInserted()
JDBC 2.0
Determines if the current row has been inserted.
|
boolean |
rowUpdated()
JDBC 2.0
Determines if the current row has been updated.
|
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.
|
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.
|
void |
updateArray(int columnIndex,
java.sql.Array x) |
void |
updateArray(java.lang.String columnName,
java.sql.Array x) |
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
JDBC 2.0
Updates a column with an ascii stream value.
|
void |
updateAsciiStream(java.lang.String columnName,
java.io.InputStream x,
int length)
JDBC 2.0
Updates a column with an ascii stream value.
|
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
JDBC 2.0
Updates a column with a BigDecimal value.
|
void |
updateBigDecimal(java.lang.String columnName,
java.math.BigDecimal x)
JDBC 2.0
Updates a column with a BigDecimal value.
|
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
JDBC 2.0
Updates a column with a binary stream value.
|
void |
updateBinaryStream(java.lang.String columnName,
java.io.InputStream x,
int length)
JDBC 2.0
Updates a column with a binary stream value.
|
void |
updateBlob(int columnIndex,
java.sql.Blob x) |
void |
updateBlob(java.lang.String columnName,
java.sql.Blob x) |
void |
updateBoolean(int columnIndex,
boolean x)
JDBC 2.0
Updates a column with a boolean value.
|
void |
updateBoolean(java.lang.String columnName,
boolean x)
JDBC 2.0
Updates a column with a boolean value.
|
void |
updateByte(int columnIndex,
byte x)
JDBC 2.0
Updates a column with a byte value.
|
void |
updateByte(java.lang.String columnName,
byte x)
JDBC 2.0
Updates a column with a byte value.
|
void |
updateBytes(int columnIndex,
byte[] x)
JDBC 2.0
Updates a column with a byte array value.
|
void |
updateBytes(java.lang.String columnName,
byte[] x)
JDBC 2.0
Updates a column with a byte array value.
|
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
JDBC 2.0
Updates a column with a character stream value.
|
void |
updateCharacterStream(java.lang.String columnName,
java.io.Reader reader,
int length)
JDBC 2.0
Updates a column with a character stream value.
|
void |
updateClob(int columnIndex,
java.sql.Clob x) |
void |
updateClob(java.lang.String columnName,
java.sql.Clob x) |
void |
updateDate(int columnIndex,
java.sql.Date x)
JDBC 2.0
Updates a column with a Date value.
|
void |
updateDate(java.lang.String columnName,
java.sql.Date x)
JDBC 2.0
Updates a column with a Date value.
|
void |
updateDouble(int columnIndex,
double x)
JDBC 2.0
Updates a column with a Double value.
|
void |
updateDouble(java.lang.String columnName,
double x)
JDBC 2.0
Updates a column with a double value.
|
void |
updateFloat(int columnIndex,
float x)
JDBC 2.0
Updates a column with a float value.
|
void |
updateFloat(java.lang.String columnName,
float x)
JDBC 2.0
Updates a column with a float value.
|
void |
updateInt(int columnIndex,
int x)
JDBC 2.0
Updates a column with an integer value.
|
void |
updateInt(java.lang.String columnName,
int x)
JDBC 2.0
Updates a column with an integer value.
|
void |
updateLong(int columnIndex,
long x)
JDBC 2.0
Updates a column with a long value.
|
void |
updateLong(java.lang.String columnName,
long x)
JDBC 2.0
Updates a column with a long value.
|
void |
updateNull(int columnIndex)
JDBC 2.0
Gives a nullable column a null value.
|
void |
updateNull(java.lang.String columnName)
JDBC 2.0
Updates a column with a null value.
|
void |
updateObject(int columnIndex,
java.lang.Object x)
JDBC 2.0
Updates a column with an Object value.
|
void |
updateObject(int columnIndex,
java.lang.Object x,
int scale)
JDBC 2.0
Updates a column with an Object value.
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x)
JDBC 2.0
Updates a column with an Object value.
|
void |
updateObject(java.lang.String columnName,
java.lang.Object x,
int scale)
JDBC 2.0
Updates a column with an Object value.
|
void |
updateRef(int columnIndex,
java.sql.Ref x) |
void |
updateRef(java.lang.String columnName,
java.sql.Ref x) |
void |
updateRow()
JDBC 2.0
Updates the underlying database with the new contents of the
current row.
|
void |
updateShort(int columnIndex,
short x)
JDBC 2.0
Updates a column with a short value.
|
void |
updateShort(java.lang.String columnName,
short x)
JDBC 2.0
Updates a column with a short value.
|
void |
updateString(int columnIndex,
java.lang.String x)
JDBC 2.0
Updates a column with a String value.
|
void |
updateString(java.lang.String columnName,
java.lang.String x)
JDBC 2.0
Updates a column with a String value.
|
void |
updateTime(int columnIndex,
java.sql.Time x)
JDBC 2.0
Updates a column with a Time value.
|
void |
updateTime(java.lang.String columnName,
java.sql.Time x)
JDBC 2.0
Updates a column with a Time value.
|
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x)
JDBC 2.0
Updates a column with a Timestamp value.
|
void |
updateTimestamp(java.lang.String columnName,
java.sql.Timestamp x)
JDBC 2.0
Updates a column with a Timestamp value.
|
abstract boolean |
wasNull()
To judge whether the last column read has a NULL value.
|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
getHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getRowId, getRowId, getSQLXML, getSQLXML, isClosed, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateObject, updateObject, updateObject, updateObject, updateRowId, updateRowId, updateSQLXML, updateSQLXML
public abstract void initialize(JRColDesc[] colDescs, java.lang.String[] args) throws JRResultSetException
colDescs
- the descriptions of columns in the result set.args
- the arguments of this class.JRResultSetException
- when a data source error occurs.public abstract boolean next() throws JRResultSetException
next
in interface java.sql.ResultSet
JRResultSetException
- when a data source error occurs.public abstract void close() throws JRResultSetException
close
in interface java.lang.AutoCloseable
close
in interface java.sql.ResultSet
JRResultSetException
- when a data source error occurs.public abstract boolean wasNull() throws JRResultSetException
wasNull
in interface java.sql.ResultSet
JRResultSetException
- when a data source error occurs.public abstract java.lang.String getString(int columnIndex) throws JRResultSetException
getString
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public abstract boolean getBoolean(int columnIndex) throws JRResultSetException
getBoolean
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public abstract byte getByte(int columnIndex) throws JRResultSetException
getByte
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public abstract short getShort(int columnIndex) throws JRResultSetException
getShort
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public abstract int getInt(int columnIndex) throws JRResultSetException
getInt
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public abstract long getLong(int columnIndex) throws JRResultSetException
getLong
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public abstract float getFloat(int columnIndex) throws JRResultSetException
getFloat
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public abstract double getDouble(int columnIndex) throws JRResultSetException
getDouble
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public abstract java.math.BigDecimal getBigDecimal(int columnIndex, int scale) throws JRResultSetException
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...scale
- the number of digits to the right of the decimal.JRResultSetException
- if a data source error occurs.public abstract java.sql.Date getDate(int columnIndex) throws JRResultSetException
getDate
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public abstract java.sql.Time getTime(int columnIndex) throws JRResultSetException
getTime
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public abstract java.sql.Timestamp getTimestamp(int columnIndex) throws JRResultSetException
getTimestamp
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public abstract java.io.InputStream getBinaryStream(int columnIndex) throws JRResultSetException
getBinaryStream
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public byte[] getBytes(int columnIndex) throws JRResultSetException
getBytes
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public java.io.InputStream getAsciiStream(int columnIndex) throws JRResultSetException
getAsciiStream
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public java.io.InputStream getUnicodeStream(int columnIndex) throws JRResultSetException
getUnicodeStream
in interface java.sql.ResultSet
columnIndex
- The index number of the column. The first column is 1, the second is 2,...JRResultSetException
- if a data source error occurs.public java.lang.String getString(java.lang.String columnName) throws JRResultSetException
getString
in interface java.sql.ResultSet
columnName
- is the SQL name of the column.JRResultSetException
- if a data source error occurs.public boolean getBoolean(java.lang.String columnName) throws JRResultSetException
getBoolean
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public byte getByte(java.lang.String columnName) throws JRResultSetException
getByte
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public short getShort(java.lang.String columnName) throws JRResultSetException
getShort
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public int getInt(java.lang.String columnName) throws JRResultSetException
getInt
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public long getLong(java.lang.String columnName) throws JRResultSetException
getLong
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public float getFloat(java.lang.String columnName) throws JRResultSetException
getFloat
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public double getDouble(java.lang.String columnName) throws JRResultSetException
getDouble
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public java.math.BigDecimal getBigDecimal(java.lang.String columnName, int scale) throws JRResultSetException
getBigDecimal
in interface java.sql.ResultSet
columnName
- The SQL name of the column.scale
- The number of digits to the right of the decimal.JRResultSetException
- if a data source error occurs.public byte[] getBytes(java.lang.String columnName) throws JRResultSetException
getBytes
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public java.sql.Date getDate(java.lang.String columnName) throws JRResultSetException
getDate
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public java.sql.Time getTime(java.lang.String columnName) throws JRResultSetException
getTime
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public java.sql.Timestamp getTimestamp(java.lang.String columnName) throws JRResultSetException
getTimestamp
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public java.io.InputStream getAsciiStream(java.lang.String columnName) throws JRResultSetException
getAsciiStream
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public java.io.InputStream getUnicodeStream(java.lang.String columnName) throws JRResultSetException
getUnicodeStream
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public java.io.InputStream getBinaryStream(java.lang.String columnName) throws JRResultSetException
getBinaryStream
in interface java.sql.ResultSet
columnName
- The SQL name of the column.JRResultSetException
- if a data source error occurs.public java.sql.SQLWarning getWarnings() throws JRResultSetException
This warning chain only covers warnings caused by ResultSet methods.
getWarnings
in interface java.sql.ResultSet
JRResultSetException
- when a data source error occurs.public void clearWarnings() throws JRResultSetException
clearWarnings
in interface java.sql.ResultSet
JRResultSetException
- when a data source error occurs.public java.lang.String getCursorName() throws JRResultSetException
getCursorName
in interface java.sql.ResultSet
JRResultSetException
public java.sql.ResultSetMetaData getMetaData() throws JRResultSetException
getMetaData
in interface java.sql.ResultSet
JRResultSetException
public java.lang.Object getObject(int columnIndex) throws JRResultSetException
getObject
in interface java.sql.ResultSet
columnIndex
- The Index number of the current column. The first column is 1, the second is 2,...JRResultSetException
public java.lang.Object getObject(java.lang.String columnName) throws JRResultSetException
getObject
in interface java.sql.ResultSet
columnName
- The name of the current column.JRResultSetException
public int findColumn(java.lang.String columnName) throws JRResultSetException
findColumn
in interface java.sql.ResultSet
columnName
- The name of the column.JRResultSetException
public java.io.Reader getCharacterStream(int columnIndex) throws java.sql.SQLException
getCharacterStream
in interface java.sql.ResultSet
columnIndex
- the Index number of the current column. The first column is 1, the second is 2,...
Gets the value of a column in the current row as a java.io.Reader.
java.sql.SQLException
public java.io.Reader getCharacterStream(java.lang.String columnName) throws java.sql.SQLException
Gets the value of a column in the current row as a java.io.Reader.
getCharacterStream
in interface java.sql.ResultSet
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int columnIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...java.sql.SQLException
- if a database-access error occurs.public java.math.BigDecimal getBigDecimal(java.lang.String columnName) throws java.sql.SQLException
getBigDecimal
in interface java.sql.ResultSet
java.sql.SQLException
public boolean isBeforeFirst() throws java.sql.SQLException
Determines if the cursor is before the first row in the result set.
isBeforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.public boolean isAfterLast() throws java.sql.SQLException
Determines if the cursor is after the last row in the result set.
isAfterLast
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.public boolean isFirst() throws java.sql.SQLException
Determines if the cursor is on the first row of the result set.
isFirst
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.public boolean isLast() throws java.sql.SQLException
Determines if the cursor is on the last row of the result set. Note: Calling isLast() may be expensive since the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.
isLast
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.public void beforeFirst() throws java.sql.SQLException
Moves to the front of the result set, which is just before the first row. It has no effect if the result set contains no rows.
beforeFirst
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or
result set type is TYPE_FORWARD_ONLY.public void afterLast() throws java.sql.SQLException
Moves to the end of the result set, which is just after the last row. It has no effect if the result set contains no rows.
afterLast
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or
result set type is TYPE_FORWARD_ONLY.public boolean first() throws java.sql.SQLException
Moves to the first row in the result set.
first
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or
the result set type is TYPE_FORWARD_ONLY.public boolean last() throws java.sql.SQLException
Moves to the last row in the result set.
last
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or
the result set type is TYPE_FORWARD_ONLY.public int getRow() throws java.sql.SQLException
Determines the current row number. The first row is number 1, the second number 2, etc.
getRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.public boolean absolute(int row) throws java.sql.SQLException
Moves to an absolute row number in the result set.
If the row is positive, moves to an absolute row with respect to the beginning of the result set. The first row is row 1, the second is row 2, etc.
If the row is negative, moves to an absolute row position with respect to the end of result set. For example, calling absolute(-1) positions the cursor on the last row, absolute(-2) indicates the next-to-last row, etc.
Two attempts to position the cursor beyond the first/last row in the result set, and leaves the cursor before/after the first/last row, respectively.
Note: calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().
absolute
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or
the row is 0, or the result set type is TYPE_FORWARD_ONLY.public boolean relative(int rows) throws java.sql.SQLException
Moves a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the the result set positions the cursor before/after the the first/last row. Calling relative(0) is valid, but does not change the cursor position.
Note: Calling relative(1) is different than calling next() since it makes sense to call next() when there is no current row, for example, when the cursor is positioned before the first row or after the last row of the result set.
relative
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or there
is no current row, or the result set type is TYPE_FORWARD_ONLY.public boolean previous() throws java.sql.SQLException
Moves to the previous row in the result set.
Note: previous() is not the same as relative(-1) since it makes sense to call previous() when there is no current row.
previous
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or
the result set type is TYPE_FORWAR_DONLY.public void setFetchDirection(int direction) throws java.sql.SQLException
setFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or
the result set type is TYPE_FORWARD_ONLY and the direction is not
FETCH_FORWARD.public int getFetchDirection() throws java.sql.SQLException
getFetchDirection
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.public void setFetchSize(int rows) throws java.sql.SQLException
setFetchSize
in interface java.sql.ResultSet
rows
- the number of rows to fetch.java.sql.SQLException
- if a database-access error occurs, or the
condition 0 <= rows <= this.getMaxRows() is not satisfied.public int getFetchSize() throws java.sql.SQLException
getFetchSize
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.public int getType() throws java.sql.SQLException
getType
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.public int getConcurrency() throws java.sql.SQLException
getConcurrency
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.public boolean rowUpdated() throws java.sql.SQLException
rowUpdated
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.DatabaseMetaData#updatesAreDetected.
public boolean rowInserted() throws java.sql.SQLException
rowInserted
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.DatabaseMetaData#insertsAreDetected.
public boolean rowDeleted() throws java.sql.SQLException
rowDeleted
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.DatabaseMetaData#deletesAreDetected.
public void updateNull(int columnIndex) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...java.sql.SQLException
- if a database-access error occurs.public void updateBoolean(int columnIndex, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateByte(int columnIndex, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateShort(int columnIndex, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateInt(int columnIndex, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateLong(int columnIndex, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateFloat(int columnIndex, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateDouble(int columnIndex, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateBigDecimal(int columnIndex, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateString(int columnIndex, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateBytes(int columnIndex, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateDate(int columnIndex, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateTime(int columnIndex, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.length
- The length of the stream.java.sql.SQLException
- if a database-access error occurs.public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.length
- The length of the stream.java.sql.SQLException
- if a database-access error occurs.public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.length
- The length of the stream.java.sql.SQLException
- if a database-access error occurs.public void updateObject(int columnIndex, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.scale
- For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types,
this is the number of digits after the decimal. For all other
types, this value will be ignored.java.sql.SQLException
- if a database-access error occurs.public void updateObject(int columnIndex, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateNull(java.lang.String columnName) throws java.sql.SQLException
updateNull
in interface java.sql.ResultSet
columnName
- The name of the column.java.sql.SQLException
- if a database-access error occurs.public void updateBoolean(java.lang.String columnName, boolean x) throws java.sql.SQLException
updateBoolean
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateByte(java.lang.String columnName, byte x) throws java.sql.SQLException
updateByte
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateShort(java.lang.String columnName, short x) throws java.sql.SQLException
updateShort
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateInt(java.lang.String columnName, int x) throws java.sql.SQLException
updateInt
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateLong(java.lang.String columnName, long x) throws java.sql.SQLException
updateLong
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateFloat(java.lang.String columnName, float x) throws java.sql.SQLException
updateFloat
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateDouble(java.lang.String columnName, double x) throws java.sql.SQLException
updateDouble
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x) throws java.sql.SQLException
updateBigDecimal
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateString(java.lang.String columnName, java.lang.String x) throws java.sql.SQLException
updateString
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateBytes(java.lang.String columnName, byte[] x) throws java.sql.SQLException
updateBytes
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateDate(java.lang.String columnName, java.sql.Date x) throws java.sql.SQLException
updateDate
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateTime(java.lang.String columnName, java.sql.Time x) throws java.sql.SQLException
updateTime
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateTimestamp(java.lang.String columnName, java.sql.Timestamp x) throws java.sql.SQLException
updateTimestamp
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
updateAsciiStream
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.length
- of the stream.java.sql.SQLException
- if a database-access error occurs.public void updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length) throws java.sql.SQLException
updateBinaryStream
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.length
- of the stream.java.sql.SQLException
- if a database-access error occurs.public void updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length) throws java.sql.SQLException
updateCharacterStream
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.length
- of the stream.java.sql.SQLException
- if a database-access error occurs.public void updateObject(java.lang.String columnName, java.lang.Object x, int scale) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.scale
- For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types,
this is the number of digits after the decimal. For all other
types, this value will be ignored.java.sql.SQLException
- if a database-access error occurs.public void updateObject(java.lang.String columnName, java.lang.Object x) throws java.sql.SQLException
updateObject
in interface java.sql.ResultSet
columnName
- The name of the column.x
- The new column value.java.sql.SQLException
- if a database-access error occurs.public void insertRow() throws java.sql.SQLException
insertRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs,
if called when not on the inserted row, or if all non-nullable columns in
the inserted row have not been given a value.public void updateRow() throws java.sql.SQLException
updateRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or
if called when on the inserted row.public void deleteRow() throws java.sql.SQLException
deleteRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or if
called when on the inserted row.public void refreshRow() throws java.sql.SQLException
refreshRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or if
called when on the inserted row.public void cancelRowUpdates() throws java.sql.SQLException
cancelRowUpdates
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs, or if
called when on the inserted row.public void moveToInsertRow() throws java.sql.SQLException
moveToInsertRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs,
or the result set is not updatable.public void moveToCurrentRow() throws java.sql.SQLException
moveToCurrentRow
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs,
or the result set is not updatable.public java.sql.Statement getStatement() throws java.sql.SQLException
getStatement
in interface java.sql.ResultSet
java.sql.SQLException
- if a database-access error occurs.public java.lang.Object getObject(int i, java.util.Map map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
i
- The first column is 1, the second is 2, ...map
- The mapping from SQL type names to Java classes.java.sql.SQLException
public java.sql.Ref getRef(int i) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
i
- The first column is 1, the second is 2, ...java.sql.SQLException
public java.sql.Blob getBlob(int i) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
i
- The first column is 1, the second is 2, ...java.sql.SQLException
public java.sql.Clob getClob(int i) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
i
- The first column is 1, the second is 2, ...java.sql.SQLException
public java.sql.Array getArray(int i) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
i
- The first column is 1, the second is 2, ...java.sql.SQLException
public java.lang.Object getObject(java.lang.String colName, java.util.Map map) throws java.sql.SQLException
getObject
in interface java.sql.ResultSet
colName
- The column name.map
- The mapping from SQL type names to Java classes.java.sql.SQLException
public java.sql.Ref getRef(java.lang.String colName) throws java.sql.SQLException
getRef
in interface java.sql.ResultSet
colName
- The column name.java.sql.SQLException
public java.sql.Blob getBlob(java.lang.String colName) throws java.sql.SQLException
getBlob
in interface java.sql.ResultSet
colName
- The column name.java.sql.SQLException
public java.sql.Clob getClob(java.lang.String colName) throws java.sql.SQLException
getClob
in interface java.sql.ResultSet
colName
- The column name.java.sql.SQLException
public java.sql.Array getArray(java.lang.String colName) throws java.sql.SQLException
getArray
in interface java.sql.ResultSet
colName
- The column name.java.sql.SQLException
public java.sql.Date getDate(int columnIndex, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
columnIndex
- The first column is 1, the second is 2, ...cal
- The calendar to use when the date is constructed.java.sql.SQLException
- if a database-access error occurs.public java.sql.Time getTime(int col, java.util.Calendar c) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Time getTime(java.lang.String col, java.util.Calendar c) throws java.sql.SQLException
getTime
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Date getDate(java.lang.String col, java.util.Calendar c) throws java.sql.SQLException
getDate
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Timestamp getTimestamp(int col, java.util.Calendar c) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String col, java.util.Calendar c) throws java.sql.SQLException
getTimestamp
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBlob(int columnIndex, java.sql.Blob x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateBlob(java.lang.String columnName, java.sql.Blob x) throws java.sql.SQLException
updateBlob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateClob(int columnIndex, java.sql.Clob x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateClob(java.lang.String columnName, java.sql.Clob x) throws java.sql.SQLException
updateClob
in interface java.sql.ResultSet
java.sql.SQLException
public void updateArray(int columnIndex, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
public void updateArray(java.lang.String columnName, java.sql.Array x) throws java.sql.SQLException
updateArray
in interface java.sql.ResultSet
java.sql.SQLException
public void updateRef(java.lang.String columnName, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
public void updateRef(int columnIndex, java.sql.Ref x) throws java.sql.SQLException
updateRef
in interface java.sql.ResultSet
java.sql.SQLException
public java.net.URL getURL(java.lang.String columnName) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException
public java.net.URL getURL(int columnIndex) throws java.sql.SQLException
getURL
in interface java.sql.ResultSet
java.sql.SQLException