| java.lang.Object org.mandarax.jdbc.AbstractReadOnlyResultSet org.mandarax.jdbc.StaticResultSet
StaticResultSet | public class StaticResultSet extends AbstractReadOnlyResultSet (Code) | | Implementation of a static result set - used in meta data.
The static result set consists of a list of columns and a list of list of values.
author: Jens Dietrich version: 3.3.2 <29 December 2004> since: 3.0 |
Field Summary | |
protected int | pos |
Method Summary | |
public boolean | absolute(int resultNo) Moves the cursor to the given result number.
Parameters: resultNo - the number of results. | public void | afterLast() Moves the cursor to the end of this ResultSet object, just after the last row. | public void | beforeFirst() Moves the cursor to the front of this ResultSet object, just before the first row. | public void | close() Closes the result set. | public int | findColumn(String columnName) Find the column (=slot) index. | public boolean | first() Moves the cursor to the first row in this ResultSet object. | List | getColumnNames() | int[] | getColumnTypes() Get the column types. | public int | getCursorPosition() Get the current position of the cursor. | public static ResultSet | getEmptyResultSet(String[] columnNames) Get an empty result set for an array of columnn names. | public ResultSetMetaData | getMetaData() Return the result set meta data. | public Object | getObject(int columnIndex) Get the object in the result at a certain index. | public Object | getObject(String columnName) Get the result for a certain column name. | public Object | getObject(String colName, Map map) | public int | getResultNumber() Retrieves the current result number. | public int | getRow() Retrieves the current row number. | public Statement | getStatement() Get the statement. | public boolean | isAfterLast() Retrieves whether the cursor is after the last result in this ResultSet object. | public boolean | isBeforeFirst() Retrieves whether the cursor is before the first row in this ResultSet object. | public boolean | isFirst() Indicates whether the cursor is at the first position. | public boolean | isLast() Indicates whether the cursor is at the last position. | public boolean | last() Moves the cursor to the last row in this ResultSet object. | public boolean | next() Moves the cursor down one row from its current position. | public boolean | previous() Moves the cursor to the previous row in this ResultSet object. | public boolean | relative(int offset) Moves the cursor a relative number of results, either positive or negative. |
StaticResultSet | public StaticResultSet(List columnNames, List values)(Code) | | Constructor.
Parameters: columnNames - a list of column names Parameters: values - a list of list of values |
StaticResultSet | public StaticResultSet(String[] columnNames, List values)(Code) | | Constructor.
Parameters: columnNames - an array of column names Parameters: values - a list of list of values |
StaticResultSet | public StaticResultSet(String[] columnNames, List values, int[] columnTypes)(Code) | | Constructor.
Parameters: columnNames - an array of column names Parameters: values - a list of list of values Parameters: columnTypes - an array of column types (defined in Types) |
absolute | public boolean absolute(int resultNo) throws SQLException(Code) | | Moves the cursor to the given result number.
Parameters: resultNo - the number of results. true if the cursor is on the result set; false otherwise |
afterLast | public void afterLast() throws SQLException(Code) | | Moves the cursor to the end of this ResultSet object, just after the last row.
This method has no effect if the result set contains no rows.
|
beforeFirst | public void beforeFirst() throws SQLException(Code) | | Moves the cursor to the front of this ResultSet object, just before the first row.
This method has no effect if the result set contains no rows.
|
first | public boolean first() throws SQLException(Code) | | Moves the cursor to the first row in this ResultSet object.
true if the cursor is on a valid row; false if there are no rows in the result set |
getColumnNames | List getColumnNames()(Code) | | Get the column names
List |
getColumnTypes | int[] getColumnTypes()(Code) | | Get the column types.
int[] |
getCursorPosition | public int getCursorPosition() throws SQLException(Code) | | Get the current position of the cursor.
an integer |
getEmptyResultSet | public static ResultSet getEmptyResultSet(String[] columnNames)(Code) | | Get an empty result set for an array of columnn names.
Parameters: columnNames - an array of column names a result set |
getResultNumber | public int getResultNumber() throws SQLException(Code) | | Retrieves the current result number. Numbering starts with 1.
a number |
isAfterLast | public boolean isAfterLast() throws SQLException(Code) | | Retrieves whether the cursor is after the last result in this ResultSet object.
true if the cursor is after the last result; false if the cursor is at any other position or the result set contains no results |
isBeforeFirst | public boolean isBeforeFirst() throws SQLException(Code) | | Retrieves whether the cursor is before the first row in this ResultSet object.
true if the cursor is before the first row; false if the cursor is at any other position or the result set contains no rows |
isFirst | public boolean isFirst() throws SQLException(Code) | | Indicates whether the cursor is at the first position.
a boolean |
isLast | public boolean isLast() throws SQLException(Code) | | Indicates whether the cursor is at the last position.
a boolean |
last | public boolean last() throws SQLException(Code) | | Moves the cursor to the last row in this ResultSet object.
true if the cursor is on a valid row; false if there are no rows in the results |
next | public boolean next() throws SQLException(Code) | | Moves the cursor down one row from its current position. A ResultSet cursor is initially positioned
before the first row; the first call to the method next makes the first row the current row;
the second call makes the second row the current row, and so on.
true if the new current row is valid; false if there are no more rows |
previous | public boolean previous() throws SQLException(Code) | | Moves the cursor to the previous row in this ResultSet object.
true if the cursor is on a valid row; false if it is off the result set |
relative | public boolean relative(int offset) throws SQLException(Code) | | Moves the cursor a relative number of results, either positive or negative.
Parameters: offset - the number of results true if the cursor is on the result set; false otherwise. |
Methods inherited from org.mandarax.jdbc.AbstractReadOnlyResultSet | public void cancelRowUpdates() throws SQLException(Code)(Java Doc) public void clearWarnings() throws SQLException(Code)(Java Doc) public void deleteRow() throws SQLException(Code)(Java Doc) public Array getArray(int i) throws SQLException(Code)(Java Doc) public Array getArray(String colName) throws SQLException(Code)(Java Doc) public InputStream getAsciiStream(int columnIndex) throws SQLException(Code)(Java Doc) public InputStream getAsciiStream(String columnName) throws SQLException(Code)(Java Doc) public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException(Code)(Java Doc) public BigDecimal getBigDecimal(String columnName, int scale) throws SQLException(Code)(Java Doc) public BigDecimal getBigDecimal(int columnIndex) throws SQLException(Code)(Java Doc) public BigDecimal getBigDecimal(String columnName) throws SQLException(Code)(Java Doc) public InputStream getBinaryStream(int columnIndex) throws SQLException(Code)(Java Doc) public InputStream getBinaryStream(String columnName) throws SQLException(Code)(Java Doc) public Blob getBlob(int i) throws SQLException(Code)(Java Doc) public Blob getBlob(String colName) throws SQLException(Code)(Java Doc) public boolean getBoolean(int columnIndex) throws SQLException(Code)(Java Doc) public boolean getBoolean(String columnName) throws SQLException(Code)(Java Doc) public byte getByte(int columnIndex) throws SQLException(Code)(Java Doc) public byte getByte(String columnName) throws SQLException(Code)(Java Doc) public byte[] getBytes(int columnIndex) throws SQLException(Code)(Java Doc) public byte[] getBytes(String columnName) throws SQLException(Code)(Java Doc) public Reader getCharacterStream(int columnIndex) throws SQLException(Code)(Java Doc) public Reader getCharacterStream(String columnName) throws SQLException(Code)(Java Doc) public Clob getClob(int i) throws SQLException(Code)(Java Doc) public Clob getClob(String colName) throws SQLException(Code)(Java Doc) public int getConcurrency() throws SQLException(Code)(Java Doc) public String getCursorName() throws SQLException(Code)(Java Doc) public java.sql.Date getDate(int columnIndex) throws SQLException(Code)(Java Doc) public java.sql.Date getDate(String columnName) throws SQLException(Code)(Java Doc) public java.sql.Date getDate(int columnIndex, Calendar cal) throws SQLException(Code)(Java Doc) public java.sql.Date getDate(String columnName, Calendar cal) throws SQLException(Code)(Java Doc) public double getDouble(int columnIndex) throws SQLException(Code)(Java Doc) public double getDouble(String columnName) throws SQLException(Code)(Java Doc) public int getFetchDirection() throws SQLException(Code)(Java Doc) public int getFetchSize() throws SQLException(Code)(Java Doc) public float getFloat(int columnIndex) throws SQLException(Code)(Java Doc) public float getFloat(String columnName) throws SQLException(Code)(Java Doc) public int getInt(int columnIndex) throws SQLException(Code)(Java Doc) public int getInt(String columnName) throws SQLException(Code)(Java Doc) public long getLong(int columnIndex) throws SQLException(Code)(Java Doc) public long getLong(String columnName) throws SQLException(Code)(Java Doc) public Object getObject(int i, Map map) throws SQLException(Code)(Java Doc) public Object getObject(String colName, Map map) throws SQLException(Code)(Java Doc) public Ref getRef(int i) throws SQLException(Code)(Java Doc) public Ref getRef(String colName) throws SQLException(Code)(Java Doc) public short getShort(int columnIndex) throws SQLException(Code)(Java Doc) public short getShort(String columnName) throws SQLException(Code)(Java Doc) public String getString(int columnIndex) throws SQLException(Code)(Java Doc) public String getString(String columnName) throws SQLException(Code)(Java Doc) public Time getTime(int columnIndex) throws SQLException(Code)(Java Doc) public Time getTime(String columnName) throws SQLException(Code)(Java Doc) public Time getTime(int columnIndex, Calendar cal) throws SQLException(Code)(Java Doc) public Time getTime(String columnName, Calendar cal) throws SQLException(Code)(Java Doc) public Timestamp getTimestamp(int columnIndex) throws SQLException(Code)(Java Doc) public Timestamp getTimestamp(String columnName) throws SQLException(Code)(Java Doc) public Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException(Code)(Java Doc) public Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException(Code)(Java Doc) public int getType() throws SQLException(Code)(Java Doc) public URL getURL(int columnIndex) throws SQLException(Code)(Java Doc) public URL getURL(String columnName) throws SQLException(Code)(Java Doc) public InputStream getUnicodeStream(int columnIndex) throws SQLException(Code)(Java Doc) public InputStream getUnicodeStream(String columnName) throws SQLException(Code)(Java Doc) public SQLWarning getWarnings() throws SQLException(Code)(Java Doc) public void insertRow() throws SQLException(Code)(Java Doc) public void moveToCurrentRow() throws SQLException(Code)(Java Doc) public void moveToInsertRow() throws SQLException(Code)(Java Doc) public void refreshRow() throws SQLException(Code)(Java Doc) public boolean rowDeleted() throws SQLException(Code)(Java Doc) public boolean rowInserted() throws SQLException(Code)(Java Doc) public boolean rowUpdated() throws SQLException(Code)(Java Doc) public void setFetchDirection(int direction) throws SQLException(Code)(Java Doc) public void setFetchSize(int rows) throws SQLException(Code)(Java Doc) public void updateArray(int columnIndex, Array x) throws SQLException(Code)(Java Doc) public void updateArray(String columnName, Array x) throws SQLException(Code)(Java Doc) public void updateAsciiStream(int columnIndex, InputStream x, int length) throws SQLException(Code)(Java Doc) public void updateAsciiStream(String columnName, InputStream x, int length) throws SQLException(Code)(Java Doc) public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException(Code)(Java Doc) public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException(Code)(Java Doc) public void updateBinaryStream(int columnIndex, InputStream x, int length) throws SQLException(Code)(Java Doc) public void updateBinaryStream(String columnName, InputStream x, int length) throws SQLException(Code)(Java Doc) public void updateBlob(int columnIndex, Blob x) throws SQLException(Code)(Java Doc) public void updateBlob(String columnName, Blob x) throws SQLException(Code)(Java Doc) public void updateBoolean(int columnIndex, boolean x) throws SQLException(Code)(Java Doc) public void updateBoolean(String columnName, boolean x) throws SQLException(Code)(Java Doc) public void updateByte(int columnIndex, byte x) throws SQLException(Code)(Java Doc) public void updateByte(String columnName, byte x) throws SQLException(Code)(Java Doc) public void updateBytes(int columnIndex, byte[] x) throws SQLException(Code)(Java Doc) public void updateBytes(String columnName, byte[] x) throws SQLException(Code)(Java Doc) public void updateCharacterStream(int columnIndex, Reader x, int length) throws SQLException(Code)(Java Doc) public void updateCharacterStream(String columnName, Reader reader, int length) throws SQLException(Code)(Java Doc) public void updateClob(int columnIndex, Clob x) throws SQLException(Code)(Java Doc) public void updateClob(String columnName, Clob x) throws SQLException(Code)(Java Doc) public void updateDate(int columnIndex, java.sql.Date x) throws SQLException(Code)(Java Doc) public void updateDate(String columnName, java.sql.Date x) throws SQLException(Code)(Java Doc) public void updateDouble(int columnIndex, double x) throws SQLException(Code)(Java Doc) public void updateDouble(String columnName, double x) throws SQLException(Code)(Java Doc) public void updateFloat(int columnIndex, float x) throws SQLException(Code)(Java Doc) public void updateFloat(String columnName, float x) throws SQLException(Code)(Java Doc) public void updateInt(int columnIndex, int x) throws SQLException(Code)(Java Doc) public void updateInt(String columnName, int x) throws SQLException(Code)(Java Doc) public void updateLong(int columnIndex, long x) throws SQLException(Code)(Java Doc) public void updateLong(String columnName, long x) throws SQLException(Code)(Java Doc) public void updateNull(int columnIndex) throws SQLException(Code)(Java Doc) public void updateNull(String columnName) throws SQLException(Code)(Java Doc) public void updateObject(int columnIndex, Object x, int scale) throws SQLException(Code)(Java Doc) public void updateObject(int columnIndex, Object x) throws SQLException(Code)(Java Doc) public void updateObject(String columnName, Object x, int scale) throws SQLException(Code)(Java Doc) public void updateObject(String columnName, Object x) throws SQLException(Code)(Java Doc) public void updateRef(int columnIndex, Ref x) throws SQLException(Code)(Java Doc) public void updateRef(String columnName, Ref x) throws SQLException(Code)(Java Doc) public void updateRow() throws SQLException(Code)(Java Doc) public void updateShort(int columnIndex, short x) throws SQLException(Code)(Java Doc) public void updateShort(String columnName, short x) throws SQLException(Code)(Java Doc) public void updateString(int columnIndex, String x) throws SQLException(Code)(Java Doc) public void updateString(String columnName, String x) throws SQLException(Code)(Java Doc) public void updateTime(int columnIndex, Time x) throws SQLException(Code)(Java Doc) public void updateTime(String columnName, Time x) throws SQLException(Code)(Java Doc) public void updateTimestamp(int columnIndex, Timestamp x) throws SQLException(Code)(Java Doc) public void updateTimestamp(String columnName, Timestamp x) throws SQLException(Code)(Java Doc) public boolean wasNull() throws SQLException(Code)(Java Doc)
|
|
|