Spring Framework 6.1.4 · org.springframework.jdbc.support.rowset.SqlRowSet

Method Summary

Modifier and Type	Method and Description
public boolean	Returns: `true` if the cursor is on the row set, `false` otherwise absolute(int the number of the row where the cursor should move row) Move the cursor to the given row number in the row set, just after the last row.
public void	afterLast() Move the cursor to the end of this row set.
public void	beforeFirst() Move the cursor to the front of this row set, just before the first row.
public int	Returns: the column index for the given column label findColumn(String the name of the column columnLabel) Map the given column label to its column index.
public boolean	Returns: `true` if the cursor is on a valid row, `false` otherwise first() Move the cursor to the first row of this row set.
public BigDecimal	Returns: an BigDecimal object representing the column value getBigDecimal(int the column index columnIndex) Retrieve the value of the indicated column in the current row as a BigDecimal object.
public BigDecimal	Returns: an BigDecimal object representing the column value getBigDecimal(String the column label columnLabel) Retrieve the value of the indicated column in the current row as a BigDecimal object.
public boolean	Returns: a boolean representing the column value getBoolean(int the column index columnIndex) Retrieve the value of the indicated column in the current row as a boolean.
public boolean	Returns: a boolean representing the column value getBoolean(String the column label columnLabel) Retrieve the value of the indicated column in the current row as a boolean.
public byte	Returns: a byte representing the column value getByte(int the column index columnIndex) Retrieve the value of the indicated column in the current row as a byte.
public byte	Returns: a byte representing the column value getByte(String the column label columnLabel) Retrieve the value of the indicated column in the current row as a byte.
public Date	Returns: a Date object representing the column value getDate(int the column index columnIndex) Retrieve the value of the indicated column in the current row as a Date object.
public Date	Returns: a Date object representing the column value getDate(String the column label columnLabel) Retrieve the value of the indicated column in the current row as a Date object.
public Date	Returns: a Date object representing the column value getDate(int the column index columnIndex, Calendar the Calendar to use in constructing the Date cal) Retrieve the value of the indicated column in the current row as a Date object.
public Date	Returns: a Date object representing the column value getDate(String the column label columnLabel, Calendar the Calendar to use in constructing the Date cal) Retrieve the value of the indicated column in the current row as a Date object.
public double	Returns: a Double object representing the column value getDouble(int the column index columnIndex) Retrieve the value of the indicated column in the current row as a Double object.
public double	Returns: a Double object representing the column value getDouble(String the column label columnLabel) Retrieve the value of the indicated column in the current row as a Double object.
public float	Returns: a float representing the column value getFloat(int the column index columnIndex) Retrieve the value of the indicated column in the current row as a float.
public float	Returns: a float representing the column value getFloat(String the column label columnLabel) Retrieve the value of the indicated column in the current row as a float.
public int	Returns: an int representing the column value getInt(int the column index columnIndex) Retrieve the value of the indicated column in the current row as an int.
public int	Returns: an int representing the column value getInt(String the column label columnLabel) Retrieve the value of the indicated column in the current row as an int.
public long	Returns: a long representing the column value getLong(int the column index columnIndex) Retrieve the value of the indicated column in the current row as a long.
public long	Returns: a long representing the column value getLong(String the column label columnLabel) Retrieve the value of the indicated column in the current row as a long.
public SqlRowSetMetaData	Returns: a corresponding SqlRowSetMetaData instance getMetaData() Retrieve the meta-data, i.e. number, types and properties for the columns of this row set.
public String	Returns: a String representing the column value getNString(int the column index columnIndex) Retrieve the value of the indicated column in the current row as a String (for NCHAR, NVARCHAR, LONGNVARCHAR columns).
public String	Returns: a String representing the column value getNString(String the column label columnLabel) Retrieve the value of the indicated column in the current row as a String (for NCHAR, NVARCHAR, LONGNVARCHAR columns).
public Object	Returns: an Object representing the column value getObject(int the column index columnIndex) Retrieve the value of the indicated column in the current row as an Object.
public Object	Returns: an Object representing the column value getObject(String the column label columnLabel) Retrieve the value of the indicated column in the current row as an Object.
public Object	Returns: an Object representing the column value getObject(int the column index columnIndex, Map<String, Class<?>> a Map object containing the mapping from SQL types to Java types map) Retrieve the value of the indicated column in the current row as an Object.
public Object	Returns: an Object representing the column value getObject(String the column label columnLabel, Map<String, Class<?>> a Map object containing the mapping from SQL types to Java types map) Retrieve the value of the indicated column in the current row as an Object.
public <T> T	Returns: an Object representing the column value getObject(int the column index columnIndex, Class<T> the Java type to convert the designated column to type) Retrieve the value of the indicated column in the current row as an Object.
public <T> T	Returns: an Object representing the column value getObject(String the column label columnLabel, Class<T> the Java type to convert the designated column to type) Retrieve the value of the indicated column in the current row as an Object.
public int	Returns: the current row number getRow() Retrieve the current row number.
public short	Returns: a short representing the column value getShort(int the column index columnIndex) Retrieve the value of the indicated column in the current row as a short.
public short	Returns: a short representing the column value getShort(String the column label columnLabel) Retrieve the value of the indicated column in the current row as a short.
public String	Returns: a String representing the column value getString(int the column index columnIndex) Retrieve the value of the indicated column in the current row as a String.
public String	Returns: a String representing the column value getString(String the column label columnLabel) Retrieve the value of the indicated column in the current row as a String.
public Time	Returns: a Time object representing the column value getTime(int the column index columnIndex) Retrieve the value of the indicated column in the current row as a Time object.
public Time	Returns: a Time object representing the column value getTime(String the column label columnLabel) Retrieve the value of the indicated column in the current row as a Time object.
public Time	Returns: a Time object representing the column value getTime(int the column index columnIndex, Calendar the Calendar to use in constructing the Date cal) Retrieve the value of the indicated column in the current row as a Time object.
public Time	Returns: a Time object representing the column value getTime(String the column label columnLabel, Calendar the Calendar to use in constructing the Date cal) Retrieve the value of the indicated column in the current row as a Time object.
public Timestamp	Returns: a Timestamp object representing the column value getTimestamp(int the column index columnIndex) Retrieve the value of the indicated column in the current row as a Timestamp object.
public Timestamp	Returns: a Timestamp object representing the column value getTimestamp(String the column label columnLabel) Retrieve the value of the indicated column in the current row as a Timestamp object.
public Timestamp	Returns: a Timestamp object representing the column value getTimestamp(int the column index columnIndex, Calendar the Calendar to use in constructing the Date cal) Retrieve the value of the indicated column in the current row as a Timestamp object.
public Timestamp	Returns: a Timestamp object representing the column value getTimestamp(String the column label columnLabel, Calendar the Calendar to use in constructing the Date cal) Retrieve the value of the indicated column in the current row as a Timestamp object.
public boolean	Returns: `true` if the cursor is after the last row, `false` otherwise isAfterLast() Retrieve whether the cursor is after the last row of this row set.
public boolean	Returns: `true` if the cursor is before the first row, `false` otherwise isBeforeFirst() Retrieve whether the cursor is before the first row of this row set.
public boolean	Returns: `true` if the cursor is after the first row, `false` otherwise isFirst() Retrieve whether the cursor is on the first row of this row set.
public boolean	Returns: `true` if the cursor is after the last row, `false` otherwise isLast() Retrieve whether the cursor is on the last row of this row set.
public boolean	Returns: `true` if the cursor is on a valid row, `false` otherwise last() Move the cursor to the last row of this row set.
public boolean	Returns: `true` if the new row is valid, `false` if there are no more rows next() Move the cursor to the next row.
public boolean	Returns: `true` if the new row is valid, `false` if it is off the row set previous() Move the cursor to the previous row.
public boolean	Returns: `true` if the cursor is on a row, `false` otherwise relative(int rows) Move the cursor a relative number of rows, either positive or negative.
public boolean	Returns: `true` if the most recent column retrieved was SQL `NULL`, `false` otherwise wasNull() Report whether the last column read had a value of SQL `NULL`.

Method Detail

absolute back to summary

absolute	back to summary
public boolean absolute(int row) throws InvalidResultSetAccessException Move the cursor to the given row number in the row set, just after the last row. Parameters row:int the number of the row where the cursor should move Returns:boolean `true` if the cursor is on the row set, `false` otherwise See Also `java.sql.ResultSet#absolute(int)`

public boolean absolute(int row) throws InvalidResultSetAccessException

Move the cursor to the given row number in the row set, just after the last row.

Parameters

row:int: the number of the row where the cursor should move

Returns:boolean

true if the cursor is on the row set, false otherwise

See Also

java.sql.ResultSet#absolute(int)

afterLast back to summary

afterLast	back to summary
public void afterLast() throws InvalidResultSetAccessException Move the cursor to the end of this row set. See Also `java.sql.ResultSet#afterLast()`

public void afterLast() throws InvalidResultSetAccessException

Move the cursor to the end of this row set.

See Also: java.sql.ResultSet#afterLast()

beforeFirst back to summary

beforeFirst	back to summary
public void beforeFirst() throws InvalidResultSetAccessException Move the cursor to the front of this row set, just before the first row. See Also `java.sql.ResultSet#beforeFirst()`

public void beforeFirst() throws InvalidResultSetAccessException

Move the cursor to the front of this row set, just before the first row.

See Also: java.sql.ResultSet#beforeFirst()

findColumn back to summary

findColumn	back to summary
public int findColumn(String columnLabel) throws InvalidResultSetAccessException Map the given column label to its column index. Parameters columnLabel:String the name of the column Returns:int the column index for the given column label See Also `java.sql.ResultSet#findColumn(String)`

public int findColumn(String columnLabel) throws InvalidResultSetAccessException

Map the given column label to its column index.

Parameters

columnLabel:String: the name of the column

Returns:int

the column index for the given column label

See Also

java.sql.ResultSet#findColumn(String)

first back to summary

first	back to summary
public boolean first() throws InvalidResultSetAccessException Move the cursor to the first row of this row set. Returns:boolean `true` if the cursor is on a valid row, `false` otherwise See Also `java.sql.ResultSet#first()`

public boolean first() throws InvalidResultSetAccessException

Move the cursor to the first row of this row set.

Returns:boolean: true if the cursor is on a valid row, false otherwise
See Also: java.sql.ResultSet#first()

getBigDecimal back to summary

getBigDecimal	back to summary
public BigDecimal getBigDecimal(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a BigDecimal object. Parameters columnIndex:int the column index Returns:BigDecimal an BigDecimal object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getBigDecimal(int)`

public BigDecimal getBigDecimal(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a BigDecimal object.

Parameters

columnIndex:int: the column index

Returns:BigDecimal

an BigDecimal object representing the column value

Annotations

@Nullable

See Also

java.sql.ResultSet#getBigDecimal(int)

getBigDecimal back to summary

getBigDecimal	back to summary
public BigDecimal getBigDecimal(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a BigDecimal object. Parameters columnLabel:String the column label Returns:BigDecimal an BigDecimal object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getBigDecimal(String)`

public BigDecimal getBigDecimal(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a BigDecimal object.

Parameters

columnLabel:String: the column label

Returns:BigDecimal

an BigDecimal object representing the column value

Annotations

@Nullable

getBoolean back to summary

getBoolean	back to summary
public boolean getBoolean(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a boolean. Parameters columnIndex:int the column index Returns:boolean a boolean representing the column value See Also `java.sql.ResultSet#getBoolean(int)`

public boolean getBoolean(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a boolean.

Parameters

columnIndex:int: the column index

Returns:boolean

a boolean representing the column value

See Also

java.sql.ResultSet#getBoolean(int)

getBoolean back to summary

getBoolean	back to summary
public boolean getBoolean(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a boolean. Parameters columnLabel:String the column label Returns:boolean a boolean representing the column value See Also `java.sql.ResultSet#getBoolean(String)`

public boolean getBoolean(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a boolean.

Parameters

columnLabel:String: the column label

Returns:boolean

a boolean representing the column value

See Also

java.sql.ResultSet#getBoolean(String)

getByte back to summary

getByte	back to summary
public byte getByte(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a byte. Parameters columnIndex:int the column index Returns:byte a byte representing the column value See Also `java.sql.ResultSet#getByte(int)`

public byte getByte(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a byte.

Parameters

columnIndex:int: the column index

Returns:byte

a byte representing the column value

See Also

java.sql.ResultSet#getByte(int)

getByte back to summary

getByte	back to summary
public byte getByte(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a byte. Parameters columnLabel:String the column label Returns:byte a byte representing the column value See Also `java.sql.ResultSet#getByte(String)`

public byte getByte(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a byte.

Parameters

columnLabel:String: the column label

Returns:byte

a byte representing the column value

See Also

java.sql.ResultSet#getByte(String)

getDate back to summary

getDate	back to summary
public Date getDate(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Date object. Parameters columnIndex:int the column index Returns:Date a Date object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getDate(int)`

public Date getDate(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Date object.

Parameters

columnIndex:int: the column index

Returns:Date

a Date object representing the column value

Annotations

@Nullable

See Also

java.sql.ResultSet#getDate(int)

getDate back to summary

getDate	back to summary
public Date getDate(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Date object. Parameters columnLabel:String the column label Returns:Date a Date object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getDate(String)`

public Date getDate(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Date object.

Parameters

columnLabel:String: the column label

Returns:Date

a Date object representing the column value

Annotations

@Nullable

See Also

java.sql.ResultSet#getDate(String)

getDate back to summary

getDate	back to summary
public Date getDate(int columnIndex, Calendar cal) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Date object. Parameters columnIndex:int the column index cal:Calendar the Calendar to use in constructing the Date Returns:Date a Date object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getDate(int, Calendar)`

public Date getDate(int columnIndex, Calendar cal) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Date object.

Parameters

columnIndex:int: the column index
cal:Calendar: the Calendar to use in constructing the Date

Returns:Date

a Date object representing the column value

Annotations

@Nullable

getDate back to summary

getDate	back to summary
public Date getDate(String columnLabel, Calendar cal) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Date object. Parameters columnLabel:String the column label cal:Calendar the Calendar to use in constructing the Date Returns:Date a Date object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getDate(String, Calendar)`

public Date getDate(String columnLabel, Calendar cal) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Date object.

Parameters

columnLabel:String: the column label
cal:Calendar: the Calendar to use in constructing the Date

Returns:Date

a Date object representing the column value

Annotations

@Nullable

getDouble back to summary

getDouble	back to summary
public double getDouble(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Double object. Parameters columnIndex:int the column index Returns:double a Double object representing the column value See Also `java.sql.ResultSet#getDouble(int)`

public double getDouble(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Double object.

Parameters

columnIndex:int: the column index

Returns:double

a Double object representing the column value

See Also

java.sql.ResultSet#getDouble(int)

getDouble back to summary

getDouble	back to summary
public double getDouble(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Double object. Parameters columnLabel:String the column label Returns:double a Double object representing the column value See Also `java.sql.ResultSet#getDouble(String)`

public double getDouble(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Double object.

Parameters

columnLabel:String: the column label

Returns:double

a Double object representing the column value

See Also

java.sql.ResultSet#getDouble(String)

getFloat back to summary

getFloat	back to summary
public float getFloat(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a float. Parameters columnIndex:int the column index Returns:float a float representing the column value See Also `java.sql.ResultSet#getFloat(int)`

public float getFloat(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a float.

Parameters

columnIndex:int: the column index

Returns:float

a float representing the column value

See Also

java.sql.ResultSet#getFloat(int)

getFloat back to summary

getFloat	back to summary
public float getFloat(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a float. Parameters columnLabel:String the column label Returns:float a float representing the column value See Also `java.sql.ResultSet#getFloat(String)`

public float getFloat(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a float.

Parameters

columnLabel:String: the column label

Returns:float

a float representing the column value

See Also

java.sql.ResultSet#getFloat(String)

getInt back to summary

getInt	back to summary
public int getInt(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as an int. Parameters columnIndex:int the column index Returns:int an int representing the column value See Also `java.sql.ResultSet#getInt(int)`

public int getInt(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as an int.

Parameters

columnIndex:int: the column index

Returns:int

an int representing the column value

See Also

java.sql.ResultSet#getInt(int)

getInt back to summary

getInt	back to summary
public int getInt(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as an int. Parameters columnLabel:String the column label Returns:int an int representing the column value See Also `java.sql.ResultSet#getInt(String)`

public int getInt(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as an int.

Parameters

columnLabel:String: the column label

Returns:int

an int representing the column value

See Also

java.sql.ResultSet#getInt(String)

getLong back to summary

getLong	back to summary
public long getLong(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a long. Parameters columnIndex:int the column index Returns:long a long representing the column value See Also `java.sql.ResultSet#getLong(int)`

public long getLong(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a long.

Parameters

columnIndex:int: the column index

Returns:long

a long representing the column value

See Also

java.sql.ResultSet#getLong(int)

getLong back to summary

getLong	back to summary
public long getLong(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a long. Parameters columnLabel:String the column label Returns:long a long representing the column value See Also `java.sql.ResultSet#getLong(String)`

public long getLong(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a long.

Parameters

columnLabel:String: the column label

Returns:long

a long representing the column value

See Also

java.sql.ResultSet#getLong(String)

getMetaData back to summary

public SqlRowSetMetaData getMetaData()

Retrieve the meta-data, i.e. number, types and properties for the columns of this row set.

Returns:SqlRowSetMetaData: a corresponding SqlRowSetMetaData instance
See Also: java.sql.ResultSet#getMetaData()

getNString back to summary

getNString	back to summary
public String getNString(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a String (for NCHAR, NVARCHAR, LONGNVARCHAR columns). Parameters columnIndex:int the column index Returns:String a String representing the column value Annotations @Nullable Since 4.1.3 See Also `java.sql.ResultSet#getNString(int)`

public String getNString(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a String (for NCHAR, NVARCHAR, LONGNVARCHAR columns).

Parameters

columnIndex:int: the column index

Returns:String

a String representing the column value

Annotations

@Nullable

Since

4.1.3

See Also

java.sql.ResultSet#getNString(int)

getNString back to summary

getNString	back to summary
public String getNString(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a String (for NCHAR, NVARCHAR, LONGNVARCHAR columns). Parameters columnLabel:String the column label Returns:String a String representing the column value Annotations @Nullable Since 4.1.3 See Also `java.sql.ResultSet#getNString(String)`

public String getNString(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a String (for NCHAR, NVARCHAR, LONGNVARCHAR columns).

Parameters

columnLabel:String: the column label

Returns:String

a String representing the column value

Annotations

@Nullable

Since

4.1.3

See Also

java.sql.ResultSet#getNString(String)

getObject back to summary

getObject	back to summary
public Object getObject(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as an Object. Parameters columnIndex:int the column index Returns:Object an Object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getObject(int)`

public Object getObject(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as an Object.

Parameters

columnIndex:int: the column index

Returns:Object

an Object representing the column value

Annotations

@Nullable

See Also

java.sql.ResultSet#getObject(int)

getObject back to summary

getObject	back to summary
public Object getObject(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as an Object. Parameters columnLabel:String the column label Returns:Object an Object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getObject(String)`

public Object getObject(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as an Object.

Parameters

columnLabel:String: the column label

Returns:Object

an Object representing the column value

Annotations

@Nullable

See Also

java.sql.ResultSet#getObject(String)

getObject back to summary

getObject	back to summary
public Object getObject(int columnIndex, Map<String, Class<?>> map) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as an Object. Parameters columnIndex:int the column index map:Map<String, Class<?>> a Map object containing the mapping from SQL types to Java types Returns:Object an Object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getObject(int, Map)`

public Object getObject(int columnIndex, Map<String, Class<?>> map) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as an Object.

Parameters

columnIndex:int: the column index
map:Map<String, Class<?>>: a Map object containing the mapping from SQL types to Java types

Returns:Object

an Object representing the column value

Annotations

@Nullable

getObject back to summary

getObject	back to summary
public Object getObject(String columnLabel, Map<String, Class<?>> map) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as an Object. Parameters columnLabel:String the column label map:Map<String, Class<?>> a Map object containing the mapping from SQL types to Java types Returns:Object an Object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getObject(String, Map)`

public Object getObject(String columnLabel, Map<String, Class<?>> map) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as an Object.

Parameters

columnLabel:String: the column label
map:Map<String, Class<?>>: a Map object containing the mapping from SQL types to Java types

Returns:Object

an Object representing the column value

Annotations

@Nullable

getObject back to summary

getObject	back to summary
public <T> T getObject(int columnIndex, Class<T> type) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as an Object. Parameters columnIndex:int the column index type:Class<T> the Java type to convert the designated column to Returns:T an Object representing the column value Annotations @Nullable Since 4.1.3 See Also `java.sql.ResultSet#getObject(int, Class)`

public <T> T getObject(int columnIndex, Class<T> type) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as an Object.

Parameters

columnIndex:int: the column index
type:Class<T>: the Java type to convert the designated column to

Returns:T

an Object representing the column value

Annotations

@Nullable

Since

4.1.3

getObject back to summary

getObject	back to summary
public <T> T getObject(String columnLabel, Class<T> type) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as an Object. Parameters columnLabel:String the column label type:Class<T> the Java type to convert the designated column to Returns:T an Object representing the column value Annotations @Nullable Since 4.1.3 See Also `java.sql.ResultSet#getObject(String, Class)`

public <T> T getObject(String columnLabel, Class<T> type) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as an Object.

Parameters

columnLabel:String: the column label
type:Class<T>: the Java type to convert the designated column to

Returns:T

an Object representing the column value

Annotations

@Nullable

Since

4.1.3

getRow back to summary

getRow	back to summary
public int getRow() throws InvalidResultSetAccessException Retrieve the current row number. Returns:int the current row number See Also `java.sql.ResultSet#getRow()`

public int getRow() throws InvalidResultSetAccessException

Retrieve the current row number.

Returns:int: the current row number
See Also: java.sql.ResultSet#getRow()

getShort back to summary

getShort	back to summary
public short getShort(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a short. Parameters columnIndex:int the column index Returns:short a short representing the column value See Also `java.sql.ResultSet#getShort(int)`

public short getShort(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a short.

Parameters

columnIndex:int: the column index

Returns:short

a short representing the column value

See Also

java.sql.ResultSet#getShort(int)

getShort back to summary

getShort	back to summary
public short getShort(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a short. Parameters columnLabel:String the column label Returns:short a short representing the column value See Also `java.sql.ResultSet#getShort(String)`

public short getShort(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a short.

Parameters

columnLabel:String: the column label

Returns:short

a short representing the column value

See Also

java.sql.ResultSet#getShort(String)

getString back to summary

getString	back to summary
public String getString(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a String. Parameters columnIndex:int the column index Returns:String a String representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getString(int)`

public String getString(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a String.

Parameters

columnIndex:int: the column index

Returns:String

a String representing the column value

Annotations

@Nullable

See Also

java.sql.ResultSet#getString(int)

getString back to summary

getString	back to summary
public String getString(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a String. Parameters columnLabel:String the column label Returns:String a String representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getString(String)`

public String getString(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a String.

Parameters

columnLabel:String: the column label

Returns:String

a String representing the column value

Annotations

@Nullable

See Also

java.sql.ResultSet#getString(String)

getTime back to summary

getTime	back to summary
public Time getTime(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Time object. Parameters columnIndex:int the column index Returns:Time a Time object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getTime(int)`

public Time getTime(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Time object.

Parameters

columnIndex:int: the column index

Returns:Time

a Time object representing the column value

Annotations

@Nullable

See Also

java.sql.ResultSet#getTime(int)

getTime back to summary

getTime	back to summary
public Time getTime(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Time object. Parameters columnLabel:String the column label Returns:Time a Time object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getTime(String)`

public Time getTime(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Time object.

Parameters

columnLabel:String: the column label

Returns:Time

a Time object representing the column value

Annotations

@Nullable

See Also

java.sql.ResultSet#getTime(String)

getTime back to summary

getTime	back to summary
public Time getTime(int columnIndex, Calendar cal) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Time object. Parameters columnIndex:int the column index cal:Calendar the Calendar to use in constructing the Date Returns:Time a Time object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getTime(int, Calendar)`

public Time getTime(int columnIndex, Calendar cal) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Time object.

Parameters

columnIndex:int: the column index
cal:Calendar: the Calendar to use in constructing the Date

Returns:Time

a Time object representing the column value

Annotations

@Nullable

getTime back to summary

getTime	back to summary
public Time getTime(String columnLabel, Calendar cal) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Time object. Parameters columnLabel:String the column label cal:Calendar the Calendar to use in constructing the Date Returns:Time a Time object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getTime(String, Calendar)`

public Time getTime(String columnLabel, Calendar cal) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Time object.

Parameters

columnLabel:String: the column label
cal:Calendar: the Calendar to use in constructing the Date

Returns:Time

a Time object representing the column value

Annotations

@Nullable

getTimestamp back to summary

getTimestamp	back to summary
public Timestamp getTimestamp(int columnIndex) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Timestamp object. Parameters columnIndex:int the column index Returns:Timestamp a Timestamp object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getTimestamp(int)`

public Timestamp getTimestamp(int columnIndex) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Timestamp object.

Parameters

columnIndex:int: the column index

Returns:Timestamp

a Timestamp object representing the column value

Annotations

@Nullable

See Also

java.sql.ResultSet#getTimestamp(int)

getTimestamp back to summary

getTimestamp	back to summary
public Timestamp getTimestamp(String columnLabel) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Timestamp object. Parameters columnLabel:String the column label Returns:Timestamp a Timestamp object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getTimestamp(String)`

public Timestamp getTimestamp(String columnLabel) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Timestamp object.

Parameters

columnLabel:String: the column label

Returns:Timestamp

a Timestamp object representing the column value

Annotations

@Nullable

getTimestamp back to summary

getTimestamp	back to summary
public Timestamp getTimestamp(int columnIndex, Calendar cal) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Timestamp object. Parameters columnIndex:int the column index cal:Calendar the Calendar to use in constructing the Date Returns:Timestamp a Timestamp object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getTimestamp(int, Calendar)`

public Timestamp getTimestamp(int columnIndex, Calendar cal) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Timestamp object.

Parameters

columnIndex:int: the column index
cal:Calendar: the Calendar to use in constructing the Date

Returns:Timestamp

a Timestamp object representing the column value

Annotations

@Nullable

getTimestamp back to summary

getTimestamp	back to summary
public Timestamp getTimestamp(String columnLabel, Calendar cal) throws InvalidResultSetAccessException Retrieve the value of the indicated column in the current row as a Timestamp object. Parameters columnLabel:String the column label cal:Calendar the Calendar to use in constructing the Date Returns:Timestamp a Timestamp object representing the column value Annotations @Nullable See Also `java.sql.ResultSet#getTimestamp(String, Calendar)`

public Timestamp getTimestamp(String columnLabel, Calendar cal) throws InvalidResultSetAccessException

Retrieve the value of the indicated column in the current row as a Timestamp object.

Parameters

columnLabel:String: the column label
cal:Calendar: the Calendar to use in constructing the Date

Returns:Timestamp

a Timestamp object representing the column value

Annotations

@Nullable

isAfterLast back to summary

isAfterLast	back to summary
public boolean isAfterLast() throws InvalidResultSetAccessException Retrieve whether the cursor is after the last row of this row set. Returns:boolean `true` if the cursor is after the last row, `false` otherwise See Also `java.sql.ResultSet#isAfterLast()`

public boolean isAfterLast() throws InvalidResultSetAccessException

Retrieve whether the cursor is after the last row of this row set.

Returns:boolean: true if the cursor is after the last row, false otherwise
See Also: java.sql.ResultSet#isAfterLast()

isBeforeFirst back to summary

isBeforeFirst	back to summary
public boolean isBeforeFirst() throws InvalidResultSetAccessException Retrieve whether the cursor is before the first row of this row set. Returns:boolean `true` if the cursor is before the first row, `false` otherwise See Also `java.sql.ResultSet#isBeforeFirst()`

public boolean isBeforeFirst() throws InvalidResultSetAccessException

Retrieve whether the cursor is before the first row of this row set.

Returns:boolean: true if the cursor is before the first row, false otherwise
See Also: java.sql.ResultSet#isBeforeFirst()

isFirst back to summary

isFirst	back to summary
public boolean isFirst() throws InvalidResultSetAccessException Retrieve whether the cursor is on the first row of this row set. Returns:boolean `true` if the cursor is after the first row, `false` otherwise See Also `java.sql.ResultSet#isFirst()`

public boolean isFirst() throws InvalidResultSetAccessException

Retrieve whether the cursor is on the first row of this row set.

Returns:boolean: true if the cursor is after the first row, false otherwise
See Also: java.sql.ResultSet#isFirst()

isLast back to summary

isLast	back to summary
public boolean isLast() throws InvalidResultSetAccessException Retrieve whether the cursor is on the last row of this row set. Returns:boolean `true` if the cursor is after the last row, `false` otherwise See Also `java.sql.ResultSet#isLast()`

public boolean isLast() throws InvalidResultSetAccessException

Retrieve whether the cursor is on the last row of this row set.

Returns:boolean: true if the cursor is after the last row, false otherwise
See Also: java.sql.ResultSet#isLast()

last back to summary

public boolean last() throws InvalidResultSetAccessException

Move the cursor to the last row of this row set.

Returns:boolean: true if the cursor is on a valid row, false otherwise
See Also: java.sql.ResultSet#last()

next back to summary

public boolean next() throws InvalidResultSetAccessException

Move the cursor to the next row.

Returns:boolean: true if the new row is valid, false if there are no more rows
See Also: java.sql.ResultSet#next()

previous back to summary

public boolean previous() throws InvalidResultSetAccessException

Move the cursor to the previous row.

Returns:boolean: true if the new row is valid, false if it is off the row set
See Also: java.sql.ResultSet#previous()

relative back to summary

public boolean relative(int rows) throws InvalidResultSetAccessException

Move the cursor a relative number of rows, either positive or negative.

Returns:boolean: true if the cursor is on a row, false otherwise
See Also: java.sql.ResultSet#relative(int)

wasNull back to summary

public boolean wasNull() throws InvalidResultSetAccessException

Report whether the last column read had a value of SQL NULL.

Note that you must first call one of the getter methods and then call the wasNull() method.

Returns:boolean: true if the most recent column retrieved was SQL NULL, false otherwise
See Also: java.sql.ResultSet#wasNull()

public Interface SqlRowSet

Method Summary

Method Detail