|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||
java.lang.Objectorg.h2.tools.SimpleResultSet
public class SimpleResultSet
This class is a simple result set and meta data implementation. It can be used in Java functions that return a result set. Only the most basic methods are implemented, the others throw an exception. This implementation is standalone, and only relies on standard classes. It can be extended easily if required. An application can create a result set using the following code:
SimpleResultSet rs = new SimpleResultSet();
rs.addColumn("ID", Types.INTEGER, 10, 0);
rs.addColumn("NAME", Types.VARCHAR, 255, 0);
rs.addRow(0, "Hello" });
rs.addRow(1, "World" });
| Nested Class Summary | |
|---|---|
static class |
SimpleResultSet.SimpleArray
A simple array implementation, backed by an object array |
| Field Summary |
|---|
| Fields inherited from interface java.sql.ResultSet |
|---|
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE |
| Fields inherited from interface java.sql.ResultSetMetaData |
|---|
columnNoNulls, columnNullable, columnNullableUnknown |
| Constructor Summary | |
|---|---|
SimpleResultSet()
This constructor is used if the result set is later populated with addRow. |
|
SimpleResultSet(SimpleRowSource source)
This constructor is used if the result set should retrieve the rows using the specified row source object. |
|
| Method Summary | |
|---|---|
boolean |
absolute(int row)
INTERNAL |
void |
addColumn(java.lang.String name,
int sqlType,
int precision,
int scale)
Adds a column to the result set. |
void |
addRow(java.lang.Object... row)
Add a new row to the result set. |
void |
afterLast()
INTERNAL |
void |
beforeFirst()
Moves the current position to before the first row, that means resets the result set. |
void |
cancelRowUpdates()
INTERNAL |
void |
clearWarnings()
INTERNAL |
void |
close()
Closes the result set and releases the resources. |
void |
deleteRow()
INTERNAL |
int |
findColumn(java.lang.String columnLabel)
Searches for a specific column in the result set. |
boolean |
first()
INTERNAL |
java.sql.Array |
getArray(int columnIndex)
Returns the value as a java.sql.Array. |
java.sql.Array |
getArray(java.lang.String columnLabel)
Returns the value as a java.sql.Array. |
java.io.InputStream |
getAsciiStream(int columnIndex)
INTERNAL |
java.io.InputStream |
getAsciiStream(java.lang.String columnLabel)
INTERNAL |
boolean |
getAutoClose()
Get the current auto-close behavior. |
java.math.BigDecimal |
getBigDecimal(int columnIndex)
Returns the value as a java.math.BigDecimal. |
java.math.BigDecimal |
getBigDecimal(int columnIndex,
int scale)
Deprecated. INTERNAL |
java.math.BigDecimal |
getBigDecimal(java.lang.String columnLabel)
Returns the value as a java.math.BigDecimal. |
java.math.BigDecimal |
getBigDecimal(java.lang.String columnLabel,
int scale)
Deprecated. INTERNAL |
java.io.InputStream |
getBinaryStream(int columnIndex)
Returns the value as a java.io.InputStream. |
java.io.InputStream |
getBinaryStream(java.lang.String columnLabel)
Returns the value as a java.io.InputStream. |
java.sql.Blob |
getBlob(int columnIndex)
Returns the value as a java.sql.Blob. |
java.sql.Blob |
getBlob(java.lang.String columnLabel)
Returns the value as a java.sql.Blob. |
boolean |
getBoolean(int columnIndex)
Returns the value as a boolean. |
boolean |
getBoolean(java.lang.String columnLabel)
Returns the value as a boolean. |
byte |
getByte(int columnIndex)
Returns the value as a byte. |
byte |
getByte(java.lang.String columnLabel)
Returns the value as a byte. |
byte[] |
getBytes(int columnIndex)
Returns the value as a byte array. |
byte[] |
getBytes(java.lang.String columnLabel)
Returns the value as a byte array. |
java.lang.String |
getCatalogName(int columnIndex)
Returns null. |
java.io.Reader |
getCharacterStream(int columnIndex)
Returns the value as a java.io.Reader. |
java.io.Reader |
getCharacterStream(java.lang.String columnLabel)
Returns the value as a java.io.Reader. |
java.sql.Clob |
getClob(int columnIndex)
Returns the value as a java.sql.Clob. |
java.sql.Clob |
getClob(java.lang.String columnLabel)
Returns the value as a java.sql.Clob. |
java.lang.String |
getColumnClassName(int columnIndex)
Returns the Java class name if this column. |
int |
getColumnCount()
Returns the column count. |
int |
getColumnDisplaySize(int columnIndex)
Returns 15. |
java.lang.String |
getColumnLabel(int columnIndex)
Returns the column label. |
java.lang.String |
getColumnName(int columnIndex)
Returns the column name. |
int |
getColumnType(int columnIndex)
Returns the SQL type. |
java.lang.String |
getColumnTypeName(int columnIndex)
Returns the data type name of a column. |
int |
getConcurrency()
Returns ResultSet.CONCUR_READ_ONLY. |
java.lang.String |
getCursorName()
INTERNAL |
java.sql.Date |
getDate(int columnIndex)
Returns the value as an java.sql.Date. |
java.sql.Date |
getDate(int columnIndex,
java.util.Calendar cal)
INTERNAL |
java.sql.Date |
getDate(java.lang.String columnLabel)
Returns the value as a java.sql.Date. |
java.sql.Date |
getDate(java.lang.String columnLabel,
java.util.Calendar cal)
INTERNAL |
double |
getDouble(int columnIndex)
Returns the value as an double. |
double |
getDouble(java.lang.String columnLabel)
Returns the value as a double. |
int |
getFetchDirection()
Returns ResultSet.FETCH_FORWARD. |
int |
getFetchSize()
Returns 0. |
float |
getFloat(int columnIndex)
Returns the value as a float. |
float |
getFloat(java.lang.String columnLabel)
Returns the value as a float. |
int |
getHoldability()
Returns the current result set holdability. |
int |
getInt(int columnIndex)
Returns the value as an int. |
int |
getInt(java.lang.String columnLabel)
Returns the value as an int. |
long |
getLong(int columnIndex)
Returns the value as a long. |
long |
getLong(java.lang.String columnLabel)
Returns the value as a long. |
java.sql.ResultSetMetaData |
getMetaData()
Returns a reference to itself. |
java.lang.Object |
getObject(int columnIndex)
Returns the value as an Object. |
java.lang.Object |
getObject(int columnIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
INTERNAL |
java.lang.Object |
getObject(java.lang.String columnLabel)
Returns the value as an Object. |
java.lang.Object |
getObject(java.lang.String columnLabel,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
INTERNAL |
int |
getPrecision(int columnIndex)
Returns the precision. |
java.sql.Ref |
getRef(int columnIndex)
INTERNAL |
java.sql.Ref |
getRef(java.lang.String columnLabel)
INTERNAL |
int |
getRow()
Returns the row number (1, 2,...) or 0 for no row. |
int |
getScale(int columnIndex)
Returns the scale. |
java.lang.String |
getSchemaName(int columnIndex)
Returns null. |
short |
getShort(int columnIndex)
Returns the value as a short. |
short |
getShort(java.lang.String columnLabel)
Returns the value as a short. |
java.sql.Statement |
getStatement()
Returns null. |
java.lang.String |
getString(int columnIndex)
Returns the value as a String. |
java.lang.String |
getString(java.lang.String columnLabel)
Returns the value as a String. |
java.lang.String |
getTableName(int columnIndex)
Returns null. |
java.sql.Time |
getTime(int columnIndex)
Returns the value as an java.sql.Time. |
java.sql.Time |
getTime(int columnIndex,
java.util.Calendar cal)
INTERNAL |
java.sql.Time |
getTime(java.lang.String columnLabel)
Returns the value as a java.sql.Time. |
java.sql.Time |
getTime(java.lang.String columnLabel,
java.util.Calendar cal)
INTERNAL |
java.sql.Timestamp |
getTimestamp(int columnIndex)
Returns the value as an java.sql.Timestamp. |
java.sql.Timestamp |
getTimestamp(int columnIndex,
java.util.Calendar cal)
INTERNAL |
java.sql.Timestamp |
getTimestamp(java.lang.String columnLabel)
Returns the value as a java.sql.Timestamp. |
java.sql.Timestamp |
getTimestamp(java.lang.String columnLabel,
java.util.Calendar cal)
INTERNAL |
int |
getType()
Returns ResultSet.TYPE_FORWARD_ONLY. |
java.io.InputStream |
getUnicodeStream(int columnIndex)
Deprecated. INTERNAL |
java.io.InputStream |
getUnicodeStream(java.lang.String columnLabel)
Deprecated. INTERNAL |
java.net.URL |
getURL(int columnIndex)
INTERNAL |
java.net.URL |
getURL(java.lang.String columnLabel)
INTERNAL |
java.sql.SQLWarning |
getWarnings()
Returns null. |
void |
insertRow()
INTERNAL |
boolean |
isAfterLast()
INTERNAL |
boolean |
isAutoIncrement(int columnIndex)
Returns false. |
boolean |
isBeforeFirst()
INTERNAL |
boolean |
isCaseSensitive(int columnIndex)
Returns true. |
boolean |
isClosed()
Returns whether this result set has been closed. |
boolean |
isCurrency(int columnIndex)
Returns false. |
boolean |
isDefinitelyWritable(int columnIndex)
Returns false. |
boolean |
isFirst()
INTERNAL |
boolean |
isLast()
INTERNAL |
int |
isNullable(int columnIndex)
Returns ResultSetMetaData.columnNullableUnknown. |
boolean |
isReadOnly(int columnIndex)
Returns true. |
boolean |
isSearchable(int columnIndex)
Returns true. |
boolean |
isSigned(int columnIndex)
Returns true. |
boolean |
isWritable(int columnIndex)
Returns false. |
boolean |
last()
INTERNAL |
void |
moveToCurrentRow()
INTERNAL |
void |
moveToInsertRow()
INTERNAL |
boolean |
next()
Moves the cursor to the next row of the result set. |
boolean |
previous()
INTERNAL |
void |
refreshRow()
INTERNAL |
boolean |
relative(int offset)
INTERNAL |
boolean |
rowDeleted()
INTERNAL |
boolean |
rowInserted()
INTERNAL |
boolean |
rowUpdated()
INTERNAL |
void |
setAutoClose(boolean autoClose)
Set the auto-close behavior. |
void |
setFetchDirection(int direction)
INTERNAL |
void |
setFetchSize(int rows)
INTERNAL |
void |
updateArray(int columnIndex,
java.sql.Array x)
INTERNAL |
void |
updateArray(java.lang.String columnLabel,
java.sql.Array x)
INTERNAL |
void |
updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
INTERNAL |
void |
updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
int length)
INTERNAL |
void |
updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
INTERNAL |
void |
updateBigDecimal(java.lang.String columnLabel,
java.math.BigDecimal x)
INTERNAL |
void |
updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
INTERNAL |
void |
updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
int length)
INTERNAL |
void |
updateBlob(int columnIndex,
java.sql.Blob x)
INTERNAL |
void |
updateBlob(java.lang.String columnLabel,
java.sql.Blob x)
INTERNAL |
void |
updateBoolean(int columnIndex,
boolean x)
INTERNAL |
void |
updateBoolean(java.lang.String columnLabel,
boolean x)
INTERNAL |
void |
updateByte(int columnIndex,
byte x)
INTERNAL |
void |
updateByte(java.lang.String columnLabel,
byte x)
INTERNAL |
void |
updateBytes(int columnIndex,
byte[] x)
INTERNAL |
void |
updateBytes(java.lang.String columnLabel,
byte[] x)
INTERNAL |
void |
updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
INTERNAL |
void |
updateCharacterStream(java.lang.String columnLabel,
java.io.Reader x,
int length)
INTERNAL |
void |
updateClob(int columnIndex,
java.sql.Clob x)
INTERNAL |
void |
updateClob(java.lang.String columnLabel,
java.sql.Clob x)
INTERNAL |
void |
updateDate(int columnIndex,
java.sql.Date x)
INTERNAL |
void |
updateDate(java.lang.String columnLabel,
java.sql.Date x)
INTERNAL |
void |
updateDouble(int columnIndex,
double x)
INTERNAL |
void |
updateDouble(java.lang.String columnLabel,
double x)
INTERNAL |
void |
updateFloat(int columnIndex,
float x)
INTERNAL |
void |
updateFloat(java.lang.String columnLabel,
float x)
INTERNAL |
void |
updateInt(int columnIndex,
int x)
INTERNAL |
void |
updateInt(java.lang.String columnLabel,
int x)
INTERNAL |
void |
updateLong(int columnIndex,
long x)
INTERNAL |
void |
updateLong(java.lang.String columnLabel,
long x)
INTERNAL |
void |
updateNull(int columnIndex)
INTERNAL |
void |
updateNull(java.lang.String columnLabel)
INTERNAL |
void |
updateObject(int columnIndex,
java.lang.Object x)
INTERNAL |
void |
updateObject(int columnIndex,
java.lang.Object x,
int scale)
INTERNAL |
void |
updateObject(java.lang.String columnLabel,
java.lang.Object x)
INTERNAL |
void |
updateObject(java.lang.String columnLabel,
java.lang.Object x,
int scale)
INTERNAL |
void |
updateRef(int columnIndex,
java.sql.Ref x)
INTERNAL |
void |
updateRef(java.lang.String columnLabel,
java.sql.Ref x)
INTERNAL |
void |
updateRow()
INTERNAL |
void |
updateShort(int columnIndex,
short x)
INTERNAL |
void |
updateShort(java.lang.String columnLabel,
short x)
INTERNAL |
void |
updateString(int columnIndex,
java.lang.String x)
INTERNAL |
void |
updateString(java.lang.String columnLabel,
java.lang.String x)
INTERNAL |
void |
updateTime(int columnIndex,
java.sql.Time x)
INTERNAL |
void |
updateTime(java.lang.String columnLabel,
java.sql.Time x)
INTERNAL |
void |
updateTimestamp(int columnIndex,
java.sql.Timestamp x)
INTERNAL |
void |
updateTimestamp(java.lang.String columnLabel,
java.sql.Timestamp x)
INTERNAL |
boolean |
wasNull()
Returns whether the last column accessed was null. |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Constructor Detail |
|---|
public SimpleResultSet()
public SimpleResultSet(SimpleRowSource source)
source - the row source| Method Detail |
|---|
public void addColumn(java.lang.String name,
int sqlType,
int precision,
int scale)
name - null is replaced with C1, C2,...sqlType - the value returned in getColumnType(..) (ignored internally)precision - the precisionscale - the scalepublic void addRow(java.lang.Object... row)
row - the row as an array of objectspublic int getConcurrency()
getConcurrency in interface java.sql.ResultSetpublic int getFetchDirection()
getFetchDirection in interface java.sql.ResultSetpublic int getFetchSize()
getFetchSize in interface java.sql.ResultSetpublic int getRow()
getRow in interface java.sql.ResultSetpublic int getType()
getType in interface java.sql.ResultSetpublic void close()
close in interface java.sql.ResultSet
public boolean next()
throws java.sql.SQLException
next in interface java.sql.ResultSetjava.sql.SQLException
public void beforeFirst()
throws java.sql.SQLException
beforeFirst in interface java.sql.ResultSetjava.sql.SQLExceptionpublic boolean wasNull()
wasNull in interface java.sql.ResultSet
public int findColumn(java.lang.String columnLabel)
throws java.sql.SQLException
findColumn in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException - if the column is not found or if the result set is
closedpublic java.sql.ResultSetMetaData getMetaData()
getMetaData in interface java.sql.ResultSetpublic java.sql.SQLWarning getWarnings()
getWarnings in interface java.sql.ResultSetpublic java.sql.Statement getStatement()
getStatement in interface java.sql.ResultSetpublic void clearWarnings()
clearWarnings in interface java.sql.ResultSet
public java.sql.Array getArray(int columnIndex)
throws java.sql.SQLException
getArray in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public java.sql.Array getArray(java.lang.String columnLabel)
throws java.sql.SQLException
getArray in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.io.InputStream getAsciiStream(int columnIndex)
throws java.sql.SQLException
getAsciiStream in interface java.sql.ResultSetjava.sql.SQLException
public java.io.InputStream getAsciiStream(java.lang.String columnLabel)
throws java.sql.SQLException
getAsciiStream in interface java.sql.ResultSetjava.sql.SQLException
public java.math.BigDecimal getBigDecimal(int columnIndex)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(java.lang.String columnLabel)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int columnIndex,
int scale)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetjava.sql.SQLException
public java.math.BigDecimal getBigDecimal(java.lang.String columnLabel,
int scale)
throws java.sql.SQLException
getBigDecimal in interface java.sql.ResultSetjava.sql.SQLException
public java.io.InputStream getBinaryStream(int columnIndex)
throws java.sql.SQLException
getBinaryStream in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public java.io.InputStream getBinaryStream(java.lang.String columnLabel)
throws java.sql.SQLException
getBinaryStream in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.sql.Blob getBlob(int columnIndex)
throws java.sql.SQLException
getBlob in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public java.sql.Blob getBlob(java.lang.String columnLabel)
throws java.sql.SQLException
getBlob in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public boolean getBoolean(int columnIndex)
throws java.sql.SQLException
getBoolean in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public boolean getBoolean(java.lang.String columnLabel)
throws java.sql.SQLException
getBoolean in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public byte getByte(int columnIndex)
throws java.sql.SQLException
getByte in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public byte getByte(java.lang.String columnLabel)
throws java.sql.SQLException
getByte in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public byte[] getBytes(int columnIndex)
throws java.sql.SQLException
getBytes in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public byte[] getBytes(java.lang.String columnLabel)
throws java.sql.SQLException
getBytes in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.io.Reader getCharacterStream(int columnIndex)
throws java.sql.SQLException
getCharacterStream in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public java.io.Reader getCharacterStream(java.lang.String columnLabel)
throws java.sql.SQLException
getCharacterStream in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.sql.Clob getClob(int columnIndex)
throws java.sql.SQLException
getClob in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public java.sql.Clob getClob(java.lang.String columnLabel)
throws java.sql.SQLException
getClob in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.sql.Date getDate(int columnIndex)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public java.sql.Date getDate(java.lang.String columnLabel)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.sql.Date getDate(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetjava.sql.SQLException
public java.sql.Date getDate(java.lang.String columnLabel,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.ResultSetjava.sql.SQLException
public double getDouble(int columnIndex)
throws java.sql.SQLException
getDouble in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public double getDouble(java.lang.String columnLabel)
throws java.sql.SQLException
getDouble in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public float getFloat(int columnIndex)
throws java.sql.SQLException
getFloat in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public float getFloat(java.lang.String columnLabel)
throws java.sql.SQLException
getFloat in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public int getInt(int columnIndex)
throws java.sql.SQLException
getInt in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public int getInt(java.lang.String columnLabel)
throws java.sql.SQLException
getInt in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public long getLong(int columnIndex)
throws java.sql.SQLException
getLong in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public long getLong(java.lang.String columnLabel)
throws java.sql.SQLException
getLong in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.lang.Object getObject(int columnIndex)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public java.lang.Object getObject(java.lang.String columnLabel)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.lang.Object getObject(int columnIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetjava.sql.SQLException
public java.lang.Object getObject(java.lang.String columnLabel,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
getObject in interface java.sql.ResultSetjava.sql.SQLException
public java.sql.Ref getRef(int columnIndex)
throws java.sql.SQLException
getRef in interface java.sql.ResultSetjava.sql.SQLException
public java.sql.Ref getRef(java.lang.String columnLabel)
throws java.sql.SQLException
getRef in interface java.sql.ResultSetjava.sql.SQLException
public short getShort(int columnIndex)
throws java.sql.SQLException
getShort in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public short getShort(java.lang.String columnLabel)
throws java.sql.SQLException
getShort in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.lang.String getString(int columnIndex)
throws java.sql.SQLException
getString in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public java.lang.String getString(java.lang.String columnLabel)
throws java.sql.SQLException
getString in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.sql.Time getTime(int columnIndex)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public java.sql.Time getTime(java.lang.String columnLabel)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.sql.Time getTime(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetjava.sql.SQLException
public java.sql.Time getTime(java.lang.String columnLabel,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.ResultSetjava.sql.SQLException
public java.sql.Timestamp getTimestamp(int columnIndex)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetcolumnIndex - (1,2,...)
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String columnLabel)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetcolumnLabel - the column label
java.sql.SQLException
public java.sql.Timestamp getTimestamp(int columnIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetjava.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String columnLabel,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.ResultSetjava.sql.SQLException
public java.io.InputStream getUnicodeStream(int columnIndex)
throws java.sql.SQLException
getUnicodeStream in interface java.sql.ResultSetjava.sql.SQLException
public java.io.InputStream getUnicodeStream(java.lang.String columnLabel)
throws java.sql.SQLException
getUnicodeStream in interface java.sql.ResultSetjava.sql.SQLException
public java.net.URL getURL(int columnIndex)
throws java.sql.SQLException
getURL in interface java.sql.ResultSetjava.sql.SQLException
public java.net.URL getURL(java.lang.String columnLabel)
throws java.sql.SQLException
getURL in interface java.sql.ResultSetjava.sql.SQLException
public void updateArray(int columnIndex,
java.sql.Array x)
throws java.sql.SQLException
updateArray in interface java.sql.ResultSetjava.sql.SQLException
public void updateArray(java.lang.String columnLabel,
java.sql.Array x)
throws java.sql.SQLException
updateArray in interface java.sql.ResultSetjava.sql.SQLException
public void updateAsciiStream(int columnIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetjava.sql.SQLException
public void updateAsciiStream(java.lang.String columnLabel,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateAsciiStream in interface java.sql.ResultSetjava.sql.SQLException
public void updateBigDecimal(int columnIndex,
java.math.BigDecimal x)
throws java.sql.SQLException
updateBigDecimal in interface java.sql.ResultSetjava.sql.SQLException
public void updateBigDecimal(java.lang.String columnLabel,
java.math.BigDecimal x)
throws java.sql.SQLException
updateBigDecimal in interface java.sql.ResultSetjava.sql.SQLException
public void updateBinaryStream(int columnIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLException
public void updateBinaryStream(java.lang.String columnLabel,
java.io.InputStream x,
int length)
throws java.sql.SQLException
updateBinaryStream in interface java.sql.ResultSetjava.sql.SQLException
public void updateBlob(int columnIndex,
java.sql.Blob x)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLException
public void updateBlob(java.lang.String columnLabel,
java.sql.Blob x)
throws java.sql.SQLException
updateBlob in interface java.sql.ResultSetjava.sql.SQLException
public void updateBoolean(int columnIndex,
boolean x)
throws java.sql.SQLException
updateBoolean in interface java.sql.ResultSetjava.sql.SQLException
public void updateBoolean(java.lang.String columnLabel,
boolean x)
throws java.sql.SQLException
updateBoolean in interface java.sql.ResultSetjava.sql.SQLException
public void updateByte(int columnIndex,
byte x)
throws java.sql.SQLException
updateByte in interface java.sql.ResultSetjava.sql.SQLException
public void updateByte(java.lang.String columnLabel,
byte x)
throws java.sql.SQLException
updateByte in interface java.sql.ResultSetjava.sql.SQLException
public void updateBytes(int columnIndex,
byte[] x)
throws java.sql.SQLException
updateBytes in interface java.sql.ResultSetjava.sql.SQLException
public void updateBytes(java.lang.String columnLabel,
byte[] x)
throws java.sql.SQLException
updateBytes in interface java.sql.ResultSetjava.sql.SQLException
public void updateCharacterStream(int columnIndex,
java.io.Reader x,
int length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetjava.sql.SQLException
public void updateCharacterStream(java.lang.String columnLabel,
java.io.Reader x,
int length)
throws java.sql.SQLException
updateCharacterStream in interface java.sql.ResultSetjava.sql.SQLException
public void updateClob(int columnIndex,
java.sql.Clob x)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLException
public void updateClob(java.lang.String columnLabel,
java.sql.Clob x)
throws java.sql.SQLException
updateClob in interface java.sql.ResultSetjava.sql.SQLException
public void updateDate(int columnIndex,
java.sql.Date x)
throws java.sql.SQLException
updateDate in interface java.sql.ResultSetjava.sql.SQLException
public void updateDate(java.lang.String columnLabel,
java.sql.Date x)
throws java.sql.SQLException
updateDate in interface java.sql.ResultSetjava.sql.SQLException
public void updateDouble(int columnIndex,
double x)
throws java.sql.SQLException
updateDouble in interface java.sql.ResultSetjava.sql.SQLException
public void updateDouble(java.lang.String columnLabel,
double x)
throws java.sql.SQLException
updateDouble in interface java.sql.ResultSetjava.sql.SQLException
public void updateFloat(int columnIndex,
float x)
throws java.sql.SQLException
updateFloat in interface java.sql.ResultSetjava.sql.SQLException
public void updateFloat(java.lang.String columnLabel,
float x)
throws java.sql.SQLException
updateFloat in interface java.sql.ResultSetjava.sql.SQLException
public void updateInt(int columnIndex,
int x)
throws java.sql.SQLException
updateInt in interface java.sql.ResultSetjava.sql.SQLException
public void updateInt(java.lang.String columnLabel,
int x)
throws java.sql.SQLException
updateInt in interface java.sql.ResultSetjava.sql.SQLException
public void updateLong(int columnIndex,
long x)
throws java.sql.SQLException
updateLong in interface java.sql.ResultSetjava.sql.SQLException
public void updateLong(java.lang.String columnLabel,
long x)
throws java.sql.SQLException
updateLong in interface java.sql.ResultSetjava.sql.SQLException
public void updateNull(int columnIndex)
throws java.sql.SQLException
updateNull in interface java.sql.ResultSetjava.sql.SQLException
public void updateNull(java.lang.String columnLabel)
throws java.sql.SQLException
updateNull in interface java.sql.ResultSetjava.sql.SQLException
public void updateObject(int columnIndex,
java.lang.Object x)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetjava.sql.SQLException
public void updateObject(java.lang.String columnLabel,
java.lang.Object x)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetjava.sql.SQLException
public void updateObject(int columnIndex,
java.lang.Object x,
int scale)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetjava.sql.SQLException
public void updateObject(java.lang.String columnLabel,
java.lang.Object x,
int scale)
throws java.sql.SQLException
updateObject in interface java.sql.ResultSetjava.sql.SQLException
public void updateRef(int columnIndex,
java.sql.Ref x)
throws java.sql.SQLException
updateRef in interface java.sql.ResultSetjava.sql.SQLException
public void updateRef(java.lang.String columnLabel,
java.sql.Ref x)
throws java.sql.SQLException
updateRef in interface java.sql.ResultSetjava.sql.SQLException
public void updateShort(int columnIndex,
short x)
throws java.sql.SQLException
updateShort in interface java.sql.ResultSetjava.sql.SQLException
public void updateShort(java.lang.String columnLabel,
short x)
throws java.sql.SQLException
updateShort in interface java.sql.ResultSetjava.sql.SQLException
public void updateString(int columnIndex,
java.lang.String x)
throws java.sql.SQLException
updateString in interface java.sql.ResultSetjava.sql.SQLException
public void updateString(java.lang.String columnLabel,
java.lang.String x)
throws java.sql.SQLException
updateString in interface java.sql.ResultSetjava.sql.SQLException
public void updateTime(int columnIndex,
java.sql.Time x)
throws java.sql.SQLException
updateTime in interface java.sql.ResultSetjava.sql.SQLException
public void updateTime(java.lang.String columnLabel,
java.sql.Time x)
throws java.sql.SQLException
updateTime in interface java.sql.ResultSetjava.sql.SQLException
public void updateTimestamp(int columnIndex,
java.sql.Timestamp x)
throws java.sql.SQLException
updateTimestamp in interface java.sql.ResultSetjava.sql.SQLException
public void updateTimestamp(java.lang.String columnLabel,
java.sql.Timestamp x)
throws java.sql.SQLException
updateTimestamp in interface java.sql.ResultSetjava.sql.SQLExceptionpublic int getColumnCount()
getColumnCount in interface java.sql.ResultSetMetaDatapublic int getColumnDisplaySize(int columnIndex)
getColumnDisplaySize in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public int getColumnType(int columnIndex)
throws java.sql.SQLException
getColumnType in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
java.sql.SQLException
public int getPrecision(int columnIndex)
throws java.sql.SQLException
getPrecision in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
java.sql.SQLException
public int getScale(int columnIndex)
throws java.sql.SQLException
getScale in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
java.sql.SQLExceptionpublic int isNullable(int columnIndex)
isNullable in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public boolean isAutoIncrement(int columnIndex)
isAutoIncrement in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public boolean isCaseSensitive(int columnIndex)
isCaseSensitive in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public boolean isCurrency(int columnIndex)
isCurrency in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public boolean isDefinitelyWritable(int columnIndex)
isDefinitelyWritable in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public boolean isReadOnly(int columnIndex)
isReadOnly in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public boolean isSearchable(int columnIndex)
isSearchable in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public boolean isSigned(int columnIndex)
isSigned in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public boolean isWritable(int columnIndex)
isWritable in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public java.lang.String getCatalogName(int columnIndex)
getCatalogName in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public java.lang.String getColumnClassName(int columnIndex)
throws java.sql.SQLException
getColumnClassName in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
java.sql.SQLException
public java.lang.String getColumnLabel(int columnIndex)
throws java.sql.SQLException
getColumnLabel in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
java.sql.SQLException
public java.lang.String getColumnName(int columnIndex)
throws java.sql.SQLException
getColumnName in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
java.sql.SQLException
public java.lang.String getColumnTypeName(int columnIndex)
throws java.sql.SQLException
getColumnTypeName in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
java.sql.SQLExceptionpublic java.lang.String getSchemaName(int columnIndex)
getSchemaName in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public java.lang.String getTableName(int columnIndex)
getTableName in interface java.sql.ResultSetMetaDatacolumnIndex - (1,2,...)
public void afterLast()
throws java.sql.SQLException
afterLast in interface java.sql.ResultSetjava.sql.SQLException
public void cancelRowUpdates()
throws java.sql.SQLException
cancelRowUpdates in interface java.sql.ResultSetjava.sql.SQLException
public void deleteRow()
throws java.sql.SQLException
deleteRow in interface java.sql.ResultSetjava.sql.SQLException
public void insertRow()
throws java.sql.SQLException
insertRow in interface java.sql.ResultSetjava.sql.SQLException
public void moveToCurrentRow()
throws java.sql.SQLException
moveToCurrentRow in interface java.sql.ResultSetjava.sql.SQLException
public void moveToInsertRow()
throws java.sql.SQLException
moveToInsertRow in interface java.sql.ResultSetjava.sql.SQLException
public void refreshRow()
throws java.sql.SQLException
refreshRow in interface java.sql.ResultSetjava.sql.SQLException
public void updateRow()
throws java.sql.SQLException
updateRow in interface java.sql.ResultSetjava.sql.SQLException
public boolean first()
throws java.sql.SQLException
first in interface java.sql.ResultSetjava.sql.SQLException
public boolean isAfterLast()
throws java.sql.SQLException
isAfterLast in interface java.sql.ResultSetjava.sql.SQLException
public boolean isBeforeFirst()
throws java.sql.SQLException
isBeforeFirst in interface java.sql.ResultSetjava.sql.SQLException
public boolean isFirst()
throws java.sql.SQLException
isFirst in interface java.sql.ResultSetjava.sql.SQLException
public boolean isLast()
throws java.sql.SQLException
isLast in interface java.sql.ResultSetjava.sql.SQLException
public boolean last()
throws java.sql.SQLException
last in interface java.sql.ResultSetjava.sql.SQLException
public boolean previous()
throws java.sql.SQLException
previous in interface java.sql.ResultSetjava.sql.SQLException
public boolean rowDeleted()
throws java.sql.SQLException
rowDeleted in interface java.sql.ResultSetjava.sql.SQLException
public boolean rowInserted()
throws java.sql.SQLException
rowInserted in interface java.sql.ResultSetjava.sql.SQLException
public boolean rowUpdated()
throws java.sql.SQLException
rowUpdated in interface java.sql.ResultSetjava.sql.SQLException
public void setFetchDirection(int direction)
throws java.sql.SQLException
setFetchDirection in interface java.sql.ResultSetjava.sql.SQLException
public void setFetchSize(int rows)
throws java.sql.SQLException
setFetchSize in interface java.sql.ResultSetjava.sql.SQLException
public boolean absolute(int row)
throws java.sql.SQLException
absolute in interface java.sql.ResultSetjava.sql.SQLException
public boolean relative(int offset)
throws java.sql.SQLException
relative in interface java.sql.ResultSetjava.sql.SQLException
public java.lang.String getCursorName()
throws java.sql.SQLException
getCursorName in interface java.sql.ResultSetjava.sql.SQLExceptionpublic int getHoldability()
public boolean isClosed()
public void setAutoClose(boolean autoClose)
autoClose - the new valuepublic boolean getAutoClose()
|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||