|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
ResultSet to map selected records of table in the database.
Method Summary | |
boolean |
absolute(int row)
Moves the cursor to the specified row of the result set. |
void |
afterLast()
Moves the cursor after the last row of the result set. |
void |
beforeFirst()
Moves the cursor before the first row of the result set. |
void |
cancelRowUpdates()
Cancels any updates made to this row. |
void |
clearWarnings()
Clears any warnings reported on this object. |
void |
closeResultSet()
Immediately releases ResultSet object's resources, close the cursor. |
int |
delete(java.lang.String sWhere)
Delete table records according to the where condition if any. |
void |
deleteRow()
Deletes the contents of the current row from the database. |
int |
findColumn(java.lang.String index)
Returns the column index for the named column in the result set. |
boolean |
first()
Moves the cursor to the first row of the result set. |
java.io.InputStream |
getAsciiStream(int index)
Retrieves the value of the specified column value as a stream of ASCII characters. |
java.io.InputStream |
getAsciiStream(java.lang.String columnName)
Retrieves the value of the specified column as a stream of ASCII characters. |
java.io.InputStream |
getBinaryStream(int index)
Retrieves the value of the specified column as a stream of un-interpreted bytes. |
java.io.InputStream |
getBinaryStream(java.lang.String columnName)
Retrieves the value of the specified column as a stream of un-interpreted bytes. |
java.io.Reader |
getCharacterStream(int index)
Retrieves the value of the specified column as a Reader object. |
java.io.Reader |
getCharacterStream(java.lang.String columnName)
Retrieves the value of the specified column as a Reader object. |
int |
getRow()
Retrieves the current row number in the result set. |
ResultSetAgent |
getRSAgent()
Gets the ResultSetAgent that holds the result set. |
void |
insert()
Prepares a SQL statement for insert. |
void |
insertRow()
Inserts the contents of the current row into the database. |
boolean |
isAfterLast()
Determines whether the cursor is after the last row of the result set. |
boolean |
isBeforeFirst()
Determines whether the cursor is before the first row of the result set. |
boolean |
isFirst()
Determines whether the cursor is on the first row of the result set. |
boolean |
isLast()
Determines whether the cursor is on the last row of the result set. |
boolean |
last()
Moves the cursor to the last row of the result set. |
void |
moveToCurrentRow()
Moves the current position to the current row. |
void |
moveToInsertRow()
Moves the current position to a new insert row. |
boolean |
next()
Moves the cursor to the next row of the result set. |
boolean |
previous()
Moves the cursor to the previous row of the result set. |
void |
refreshRow()
Refreshes the current row with its most recent value from the database. |
boolean |
relative(int rows)
Moves the cursor to the specified row relative to current row of the result set. |
boolean |
rowDeleted()
Checks if the current row has been deleted. |
boolean |
rowInserted()
Checks if the current row has been inserted. |
boolean |
rowUpdated()
Checks if the current row has been updated. |
void |
select(java.lang.String sWhere)
Select table records according to the where condition if any. |
void |
setColumns(java.lang.String[] columns)
Specifies the desired columns of the table. |
void |
setTable(java.lang.String table)
Sets the name of the table that is being processed. |
void |
update(java.lang.String sWhere)
Update table records according to the where condition if any. |
void |
updateRow()
Updates the contents of the current row into the database. |
boolean |
wasNull()
Checks if the last data retrieved is NULL. |
Methods inherited from interface com.stc.connector.appconn.db.StatementAgent |
cancel, clearBatch, executeBatch, getFetchDirection, getFetchSize, getMaxFieldSize, getMaxRows, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetType, getUpdateCount, getWarnings, isClosed, queryName, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, stmtInvoke |
Method Detail |
public boolean absolute(int row) throws java.sql.SQLException
row
- the row index.java.sql.SQLException
- when SQL problems occur.public void afterLast() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when SQL problems occur.public void beforeFirst() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when SQL problems occur.public void cancelRowUpdates() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when SQL problems occur.public void clearWarnings() throws java.sql.SQLException
clearWarnings
in interface StatementAgent
void
- None.java.sql.SQLException
- when SQL problems occur.public void closeResultSet() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when SQL problems occur.public int delete(java.lang.String sWhere) throws java.sql.SQLException
sWhere
- the where clausejava.sql.SQLException
- when SQL problems occur.public void deleteRow() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when SQL problems occur.public int findColumn(java.lang.String index) throws java.sql.SQLException
index
- the column name.java.sql.SQLException
- when SQL problems occur.public boolean first() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public java.io.InputStream getAsciiStream(int index) throws java.sql.SQLException
index
- the column index.java.sql.SQLException
- when SQL problems occur.public java.io.InputStream getAsciiStream(java.lang.String columnName) throws java.sql.SQLException
columnName
- the column name.java.sql.SQLException
- when SQL problems occur.public java.io.InputStream getBinaryStream(int index) throws java.sql.SQLException
index
- the column index.java.sql.SQLException
- when SQL problems occur.public java.io.InputStream getBinaryStream(java.lang.String columnName) throws java.sql.SQLException
columnName
- the column name.java.sql.SQLException
- when SQL problems occur.public java.io.Reader getCharacterStream(int index) throws java.sql.SQLException
index
- the column index.java.sql.SQLException
- when SQL problems occur.public java.io.Reader getCharacterStream(java.lang.String columnName) throws java.sql.SQLException
columnName
- the column name.java.sql.SQLException
- when SQL problems occur.public int getRow() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public ResultSetAgent getRSAgent()
public void insert() throws java.sql.SQLException
java.sql.SQLException
- when failing to prepare the insert operation.public void insertRow() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when SQL problems occur.public boolean isAfterLast() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public boolean isBeforeFirst() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public boolean isFirst() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public boolean isLast() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public boolean last() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public void moveToCurrentRow() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when SQL problems occur.public void moveToInsertRow() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when SQL problems occur.public boolean next() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public boolean previous() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public void refreshRow() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when SQL problems occur.public boolean relative(int rows) throws java.sql.SQLException
rows
- number of rows relative to the current one.java.sql.SQLException
- when SQL problems occur.public boolean rowDeleted() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public boolean rowInserted() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public boolean rowUpdated() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.public void select(java.lang.String sWhere) throws java.sql.SQLException
sWhere
- the where clausevoid
- None.java.sql.SQLException
- when SQL problems occur.public void setColumns(java.lang.String[] columns)
columns
- an array of column names.
void
- None.public void setTable(java.lang.String table)
table
- the name of the table.
void
- None.public void update(java.lang.String sWhere) throws java.sql.SQLException
sWhere
- the where clausevoid
- None.java.sql.SQLException
- when SQL problems occur.public void updateRow() throws java.sql.SQLException
void
- None.java.sql.SQLException
- when SQL problems occur.public boolean wasNull() throws java.sql.SQLException
java.sql.SQLException
- when SQL problems occur.
|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Copyright 2004 by SeeBeyond Technology Corporation. All Rights Reserved.