|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Object | +--jasp.adodb.Recordset
A Recordset object represents the entire set of records from a base table or the results of an executed command. At any time, the Recordset object refers to only a single record within the set as the current record.
| Constructor Summary | |
Recordset()
Constructs a Recordset object. |
|
| Method Summary | |
void |
_xResync(int option)
Refreshes the data in the current Recordset object from the underlying database. |
void |
AddNew()
Creates a new empty record for an updatable Recordset object. |
void |
AddNew(variant fdlist,
variant vallist)
Creates a new record for an updatable Recordset object. |
void |
AssignProps()
|
void |
Cancel()
Cancels execution of a pending,asynchronous Execute or Open method call |
void |
CancelBatch()
Cancels a pending batch update. |
void |
CancelBatch(variant affected)
Cancels a pending batch update. |
void |
CancelUpdate()
Cancels any changes made to the current record or to a new record prior to calling the Update method. |
java.lang.Object |
clone()
Implements the clone method |
Recordset |
Clone()
Creates a duplicate Recordset object from an existing Recordset object. |
Recordset |
Clone(int i)
Creates a duplicate Recordset object from an existing Recordset object. |
void |
Close()
Free all resource and set the state to closed. |
int |
CompareBookmarks(double variant,
double variant1)
Compares two bookmarks and returns an indication of their relative values. |
void |
Delete()
Delete the currect record. |
void |
Delete(variant Affect)
Deletes the affected records. |
void |
Find(java.lang.String s)
Searches a Recordset for the record that satisfies the specified criteria. |
void |
Find(java.lang.String criteria,
boolean matchcase)
Searches a Recordset for the record that satisfies the specified criteria. |
void |
Find(java.lang.String criteria,
int skip)
Searches a Recordset for the record that satisfies the specified criteria. |
void |
Find(java.lang.String criteria,
int skip,
int direction)
Searches a Recordset for the record that satisfies the specified criteria. |
void |
Find(java.lang.String criteria,
int SkipNum,
int Direction,
double start)
Searches a Recordset for the record that satisfies the specified criteria. |
void |
Find(java.lang.String criteria,
int SkipNum,
int Direction,
double start,
boolean matchcase)
Searches a Recordset for the record that satisfies the specified criteria. |
void |
Find(java.lang.String criteria,
int SkipNum,
variant Direction,
double start)
Searches a Recordset for the record that satisfies the specified criteria. |
void |
Find(java.lang.String criteria,
variant skip,
int direction)
Searches a Recordset for the record that satisfies the specifies criteria. |
void |
Find(java.lang.String criteria,
variant SkipNum,
int Direction,
double start)
Searches a Recordset for the record that satisfies the specified criteria.If the criteria is met, the recordset position is set on the found record;otherwise,the position is set the end of the recordset. |
void |
Find(java.lang.String criteria,
variant SkipNum,
variant Direction,
double start)
Searches a Recordset for the record that satisfies the specified criteria. |
int |
getAbsolutePage()
Returns the page number that the current record resides |
int |
getAbsolutePosition()
Returns the absolute position of currect record in a recordset object. |
Command |
getActiveCommand()
Returns the active command. |
Connection |
getActiveConnection()
The method returns the messages that Indicates to which Connection object the specified Command or Recordset object currently belongs. |
boolean |
getBOF()
Returns boolean values that indicate whether the current record positing is before the first record in the Recordset object. |
double |
getBookmark()
Returns the unique identifies for the currect record in a recordset object. |
int |
getCacheSize()
Returns the number of records from a Recordset object that are cached locally in memory. |
int |
getCursorLocation()
Indicates the location of the cursor engine. |
int |
getCursorType()
Returns the CursoyType of the Recordset. |
int |
getEditMode()
Returns the editing status of the current record. |
boolean |
getEOF()
Returns boolean values that indicate whether the current record positing is the after last record in the Recordset object. |
Fields |
getFields()
Returns the fields collection, the collection contains all field information. |
Field |
getFields(int idx)
Gets a Field from the Fields collection. |
Field |
getFields(java.lang.String name)
Gets a Field from the Fields collection. |
Field |
getFields(variant var)
Gets a Field from the Fields collection. |
java.lang.String |
getFilter()
Returns A filter for data in a Recordset. |
Field |
getItem(int idx)
Gets a Field with specific index from the Fields collection. |
Field |
getItem(java.lang.String name)
Gets a Field with specific name from the Fields collection. |
Field |
getItem(variant var)
Gets a Field from the Fields collection. |
int |
getLockType()
Returns the type of locks placed on records during editing . |
int |
getMarshalOptions()
Retuens a integer value that records to be marshaled back to the server . |
int |
getMaxRecords()
Returns a maximum number of records from query |
int |
getObjectState()
Returns the object state of the current RecordSet. |
int |
getPageCount()
Returns the number of pages in a recordset object |
int |
getPageSize()
Returns the how many record in every page,defaut is 10 |
Properties |
getProperties()
Returns the Properties collection of the RecordSet. |
int |
getRecordCount()
Returns the current number of records in a Recordset object. |
vbarray |
GetRows()
Retrieves multiple records of a Recordset object into any array. |
vbarray |
GetRows(int Rows)
Retrieves Rows records of a Recordset object into any array. |
vbarray |
GetRows(int Rows,
double dbStart)
Retrieves Rows records of a Recordset object into any array start with dbStart. |
variant |
GetRows(int Rows,
double dbStart,
variant fieldlist)
Retrieves Rows records of a Recordset object into any array start with dbStart. |
variant |
GetRows(int Rows,
variant dbStart,
variant fieldlist)
Retrieves Rows records of a Recordset object into any array start with dbStart. |
vbarray |
GetRows(variant Rows,
double dbStart)
Retrieves Rows records of a Recordset object into any array start with dbStart. |
variant |
GetRows(variant Rows,
double dbStart,
variant fieldlist)
Retrieves multiple records of a Recordset object into any array. |
variant |
GetRows(variant Rows,
variant dbStart,
variant fieldlist)
Retrieves Rows records of a Recordset object into any array start with dbStart. |
java.lang.String |
getSort()
where each name is a Field in the Recordset, and is optionally followed by a blank and the keyword ASCENDING or DESCENDING, which specifies the field sort order. |
java.lang.String |
getSource()
Returns the source for the data in a Recordset Object. |
int |
getState()
Returns the State of the RecordSet object. |
int |
getStatus()
Returns the status of the currect records. |
java.lang.String |
GetString()
Returns the Recordset as a string. |
java.lang.String |
GetString(int adClipString)
Returns the Recordset as a string. |
java.lang.String |
GetString(int adClipString,
int NumRows)
Returns the Recordset as a string. |
java.lang.String |
GetString(int adClipString,
int NumRows,
java.lang.String ColumnDelimiter)
Returns the Recordset as a string. |
java.lang.String |
GetString(int adClipString,
int NumRows,
java.lang.String ColumnDelimiter,
java.lang.String RowDelimiter)
Returns the Recordset as a string. |
java.lang.String |
GetString(int adClipString,
int NumRows,
java.lang.String ColumnDelimiter,
java.lang.String RowDelimiter,
java.lang.String NullExpr)
Returns the Recordset as a string. |
java.lang.String |
GetString(int adClipString,
int NumRows,
variant ColumnDelimiter,
java.lang.String RowDelimiter)
Returns the Recordset as a string. |
java.lang.String |
GetString(int adClipString,
variant NumRows,
java.lang.String ColumnDelimiter)
Returns the Recordset as a string. |
java.lang.String |
GetString(int adClipString,
variant NumRows,
java.lang.String ColumnDelimiter,
java.lang.String RowDelimiter)
Returns the Recordset as a string. |
java.lang.String |
GetString(variant adClipString,
int NumRows)
Returns the Recordset as a string. |
java.lang.String |
GetString(variant adClipString,
int NumRows,
java.lang.String ColumnDelimiter)
Returns the Recordset as a string. |
java.lang.String |
GetString(variant adClipString,
int NumRows,
java.lang.String ColumnDelimiter,
java.lang.String RowDelimiter)
Returns the Recordset as a string. |
java.lang.String |
GetString(variant adClipString,
int NumRows,
java.lang.String ColumnDelimiter,
java.lang.String RowDelimiter,
java.lang.String NullExpr)
Returns the Recordset as a string. |
java.lang.String |
GetString(variant adClipString,
variant NumRows,
java.lang.String ColumnDelimiter)
Returns the Recordset as a string. |
java.lang.String |
GetString(variant adClipString,
variant NumRows,
java.lang.String ColumnDelimiter,
java.lang.String RowDelimiter)
Returns the Recordset as a string. |
java.lang.String |
GetString(variant adClipString,
variant NumRows,
java.lang.String ColumnDelimiter,
java.lang.String RowDelimiter,
java.lang.String NullExpr)
Returns the Recordset as a string. |
java.lang.String |
GetString(variant adClipString,
variant NumRows,
variant ColumnDelimiter,
java.lang.String RowDelimiter,
java.lang.String NullExpr)
Returns the Recordset as a string. |
java.lang.String |
GetString(variant adClipString,
variant NumRows,
variant ColumnDelimiter,
variant RowDelimiter,
java.lang.String NullExpr)
Returns the Recordset as a string. |
java.lang.String |
GetString(variant adClipString,
variant NumRows,
variant ColumnDelimiter,
variant RowDelimiter,
variant NullExpr)
Returns the Recordset as a string. |
void |
Move(int NumRecords)
Moves the position of the currect record in a recordset object |
void |
Move(int NumRecords,
double start)
From a specific a position Moves the position of the current record in a Recordset object. |
void |
MoveFirst()
Moves to the first record in a specified Recordset object and makes that record the current record. |
void |
MoveLast()
Moves to the last record in a specified Recordset object and makes that record the current record. |
void |
MoveNext()
Moves to the next record in a specified Recordset object and makes that record the current record. |
void |
MovePrevious()
Moves to the previous record in a specified Recordset object and makes that record the current record. |
Recordset |
NextRecordset()
Clears the current Recordset object and returns the next Recordset by advancing through a series of commands. |
Recordset |
NextRecordset(variant RecordsAffected)
Clears the current Recordset object and returns the next Recodset by advancing through a series of commands. |
void |
Open()
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
Connection conObject)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
Connection conObject,
int cursortype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
Connection conObject,
int cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
Connection con,
int cursortype,
int locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
java.lang.String ConnectStr)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
java.lang.String ConnectStr,
int cursortype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
java.lang.String ConnectStr,
int cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
java.lang.String con,
int cursortype,
int locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
variant ConnectStr,
int cursortype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
variant conObject,
int cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
variant con,
int cursortype,
int locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
variant con,
int cursortype,
variant locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
variant conObject,
variant cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
variant con,
variant cursortype,
int locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(Command cmd,
variant con,
variant cursortype,
variant locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String CommandText)
opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
Connection conObject)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
Connection conObject,
int cursortype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
Connection conObject,
int cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
Connection con,
int cursortype,
int locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
Connection ConnectStr,
int cursortype,
variant locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
Connection conObject,
variant cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
Connection ConnectStr,
variant cursortype,
variant locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
java.lang.String ConnectStr)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
java.lang.String ConnectStr,
int cursortype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
java.lang.String ConnectStr,
int cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
java.lang.String ConnectStr,
int cursortype,
int locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
java.lang.String conObject,
int cursortype,
variant locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
java.lang.String con,
variant cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
java.lang.String ConnectStr,
variant cursortype,
variant locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
variant ConnectObj)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
variant ConnectObj,
int cursortype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
variant con,
int cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
variant ConnectStr,
int cursortype,
int locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
variant ConnectStr,
int cursortype,
variant locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
variant conObject,
variant cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
variant ConnectStr,
variant cursortype,
int locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(java.lang.String source,
variant ConnectStr,
variant cursortype,
variant locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
Connection conObject)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
Connection ConnectObj,
int cursortype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
Connection conObject,
int cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
Connection ConnectStr,
int cursortype,
int locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
Connection ConnectStr,
int cursortype,
variant locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
Connection conObject,
variant cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
Connection ConnectStr,
variant cursortype,
variant locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
java.lang.String ConnectStr)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
java.lang.String ConnectObj,
int cursortype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
java.lang.String conObject,
int cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
java.lang.String ConnectStr,
int cursortype,
int locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
java.lang.String conObject,
int cursortype,
variant locktype,
int Option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
java.lang.String conObject,
variant cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
variant ConnectObj,
int cursortype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
variant conObject,
int cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
variant ConnectStr,
int cursortype,
int locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
variant conObject,
int cursortype,
variant locktype,
int Option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
variant conObject,
variant cursortype,
int locktype)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
variant ConnectStr,
variant cursortype,
int locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
void |
Open(variant source,
variant ConnectStr,
variant cursortype,
variant locktype,
int option)
Opens a cursor that represents records from a base table, the results of a query, or a previously saved Recordset |
Property |
Properties(int index)
Gets a Property from the Properties collection. |
Property |
Properties(java.lang.String name)
Gets a Property from the Properties collection. |
Property |
Properties(variant var)
Gets a Property from the Properties collection. |
void |
Requery()
Updates the data in a Recordset object by re-executing the query on which the object is based. |
void |
Requery(int i)
Updates the data in a Recordset object by re-executing the query on which the object is based. |
void |
Resync()
Refreshes the data in the current Recordset object from the underlying database |
void |
Resync(variant varoption)
Refreshes the data in the current Recordset object from the underlying database |
void |
Resync(variant i,
variant j)
Refreshes the data in the current Recordset object from the underlying database |
void |
Save()
Save the recordset to a file. Note: Please set the the XML parser to the Classpath, for example: xmlparsev2.jar(Oracle XML Parser) or jaxp.jar. |
void |
Save(java.lang.String s)
Saves the Recordset into a file. |
void |
Save(java.lang.String s,
int i)
Saves the Recordset into a file. |
void |
setAbsolutePage(int abspage)
Indicates quick move currect record to specific page. |
void |
setAbsolutePosition(int absposition)
Sets the absolute position. Sets a int value from 1 to the number of records in the Recordset object (RecordCount). |
void |
setActiveConnection(Connection obj)
Sets the active connection. |
void |
setActiveConnection(java.lang.String connectStr)
Sets the active connection. |
void |
setBookmark(double bookmark)
Sets the bookmark value for quick move curect record to specific position. |
void |
setCacheSize(int cachesize)
Sets the number of records from a Recordset object that are cached locally in memory. |
void |
setCursorLocation(int cursorlocation)
Sets the location of the cursor engine. |
void |
setCursorType(int cursortype)
Set the Cursor type for query data from database |
void |
setFields(int index,
boolean val)
Sets a Field value in the Fields collection. |
void |
setFields(int index,
double val)
Sets a Field value in the Fields collection. |
void |
setFields(int index,
float val)
Sets a Field value in the Fields collection. |
void |
setFields(int index,
int val)
Sets a Field value in the Fields collection. |
void |
setFields(int index,
long val)
Sets a Field value in the Fields collection. |
void |
setFields(int index,
short val)
Sets a Field value in the Fields collection. |
void |
setFields(int index,
java.lang.String val)
Sets a Field value in the Fields collection. |
void |
setFields(int index,
variant val)
Sets a Field value in the Fields collection. |
void |
setFields(java.lang.String Name,
boolean val)
Sets a Field value in the Fields collection. |
void |
setFields(java.lang.String Name,
double val)
Sets a Field value in the Fields collection. |
void |
setFields(java.lang.String Name,
float val)
Sets a Field value in the Fields collection. |
void |
setFields(java.lang.String Name,
int val)
Sets a Field value in the Fields collection. |
void |
setFields(java.lang.String Name,
long val)
Sets a Field value in the Fields collection. |
void |
setFields(java.lang.String Name,
short val)
Sets a Field value in the Fields collection. |
void |
setFields(java.lang.String Name,
java.lang.String val)
Sets a Field value in the Fields collection. |
void |
setFields(java.lang.String Name,
variant val)
Sets a Field value in the Fields collection. |
void |
setFields(variant var,
variant val)
Sets a Field value in the Fields collection. |
void |
setFilter(int filter)
Indicates a filter for data in a Recordset. |
void |
setFilter(java.lang.String filter)
Indicates a filter for data in a Recordset. |
void |
setItem(int index,
boolean val)
Sets a Field value in the Fields collection. |
void |
setItem(int index,
double val)
Sets a Field value in the Fields collection. |
void |
setItem(int index,
float val)
Sets a Field value in the Fields collection. |
void |
setItem(int index,
int val)
Sets a Field value in the Fields collection. |
void |
setItem(int index,
long val)
Sets a Field value in the Fields collection. |
void |
setItem(int index,
short val)
Sets a Field value in the Fields collection. |
void |
setItem(int index,
java.lang.String val)
Sets a Field value in the Fields collection. |
void |
setItem(int index,
variant val)
Sets a Field value in the Fields collection. |
void |
setItem(java.lang.String Name,
boolean val)
Sets a Field value in the Fields collection. |
void |
setItem(java.lang.String Name,
double val)
Sets a Field value in the Fields collection. |
void |
setItem(java.lang.String Name,
float val)
Sets a Field value in the Fields collection. |
void |
setItem(java.lang.String Name,
int val)
Sets a Field value in the Fields collection. |
void |
setItem(java.lang.String Name,
long val)
Sets a Field value in the Fields collection. |
void |
setItem(java.lang.String Name,
short val)
Sets a Field value in the Fields collection. |
void |
setItem(java.lang.String Name,
java.lang.String val)
Sets a Field value in the Fields collection. |
void |
setItem(java.lang.String Name,
variant val)
Sets a Field value in the Fields collection. |
void |
setItem(variant var,
variant val)
Sets a Field value in the Fields collection. |
void |
setLockType(int locktype)
Sets the type of locks placed on records during editing. |
void |
setMarshalOptions(int state)
Indicates which records to be marshaled back to the server. UNSUPPORT |
void |
setMaxRecords(int maxrd)
Sets the MaxRecords property to maxrd. |
void |
setPageSize(int pagesize)
Sets the how many record in every page |
void |
setSort(java.lang.String sort)
Specifies one or more fild names the Recordset is sorted on, and whether each field is sorted in ascending or descending order . |
void |
setSource(java.lang.Object obj)
Indicates the source for the data in a Recordset object(Command object, SQL statement,table name,or stored procedure). |
boolean |
Supports(int alngConstants)
Determines whether a specified Recordset object supports a particular type of functionality. |
void |
Update()
Saves any changes you make to the current record of a Recordset object. |
void |
Update(variant fdlist,
variant vallist)
Saves changes you make to the current record of a Recordset object. |
void |
UpdateBatch()
If you are editing the current record or adding a new record when you call the UpdateBatch method, ADO will automatically call the Update method to save any pending changes to the current record before transmitting the batched changes to the provider. |
void |
UpdateBatch(variant Affect)
If you are editing the current record or adding a new record when you call the UpdateBatch method, ADO will automatically call the Update method to save any pending changes to the current record before transmitting the batched changes to the provider. |
| Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Constructor Detail |
public Recordset()
| Method Detail |
public int getAbsolutePage()
throws java.lang.Exception
public void setAbsolutePage(int abspage)
throws java.lang.Exception
public int getState()
public double getBookmark()
throws java.lang.Exception
public void setBookmark(double bookmark)
throws java.lang.Exception
public int getCursorLocation()
public void setCursorLocation(int cursorlocation)
throws java.lang.Exception
public int getStatus()
throws java.lang.Exception
public int getMaxRecords()
public void setMaxRecords(int maxrd)
throws java.lang.Exception
public java.lang.String GetString(int adClipString,
int NumRows,
java.lang.String ColumnDelimiter,
java.lang.String RowDelimiter,
java.lang.String NullExpr)
throws java.lang.Exception
adClipString - Specifies that the Recordset should be converted to the following format.
NumRows - The number of rows in the recordset to convert.If NumRows is not specified,
or if it is greater than the total number of rows in the recordset,
then all the rows in the recordset are converted.ColumnDelimiter - Delimiter used between columns if specified,otherwise the TAB character.RowDelimiter - Delimiter used between rows if specified,otherwise the CARRIAGE RETURN character.NullExpr - Expression used in place of a NULL value if specified,otherwise the empty string.
public java.lang.String GetString(variant adClipString,
variant NumRows,
variant ColumnDelimiter,
variant RowDelimiter,
variant NullExpr)
throws java.lang.Exception
adClipString - Specifies that the Recordset should be converted to the following format.
NumRows - The number of rows in the recordset to convert.If NumRows is not specified,
or if it is greater than the total number of rows in the recordset,
then all the rows in the recordset are converted.ColumnDelimiter - Delimiter used between columns if specified,otherwise the TAB character.RowDelimiter - Delimiter used between rows if specified,otherwise the CARRIAGE RETURN character.NullExpr - Expression used in place of a NULL value if specified,otherwise the empty string.
public java.lang.String GetString(variant adClipString,
int NumRows,
java.lang.String ColumnDelimiter,
java.lang.String RowDelimiter,
java.lang.String NullExpr)
throws java.lang.Exception
adClipString - Specifies that the Recordset should be converted to the following format.
NumRows - The number of rows in the recordset to convert.If NumRows is not specified,
or if it is greater than the total number of rows in the recordset,
then all the rows in the recordset are converted.ColumnDelimiter - Delimiter used between columns if specified,otherwise the TAB character.RowDelimiter - Delimiter used between rows if specified,otherwise the CARRIAGE RETURN character.NullExpr - Expression used in place of a NULL value if specified,otherwise the empty string.
public java.lang.String GetString(variant adClipString,
variant NumRows,
java.lang.String ColumnDelimiter,
java.lang.String RowDelimiter,
java.lang.String NullExpr)
throws java.lang.Exception
adClipString - Specifies that the Recordset should be converted to the following format.
NumRows - The number of rows in the recordset to convert.If NumRows is not specified,
or if it is greater than the total number of rows in the recordset,
then all the rows in the recordset are converted.ColumnDelimiter - Delimiter used between columns if specified,otherwise the TAB character.RowDelimiter - Delimiter used between rows if specified,otherwise the CARRIAGE RETURN character.NullExpr - Expression used in place of a NULL value if specified,otherwise the empty string.
public java.lang.String GetString(variant adClipString,
variant NumRows,
variant ColumnDelimiter,
java.lang.String RowDelimiter,
java.lang.String NullExpr)
throws java.lang.Exception
adClipString - Specifies that the Recordset should be converted to the following format.
NumRows - The number of rows in the recordset to convert.If NumRows is not specified,
or if it is greater than the total number of rows in the recordset,
then all the rows in the recordset are converted.ColumnDelimiter - Delimiter used between columns if specified,otherwise the TAB character.RowDelimiter - Delimiter used between rows if specified,otherwise the CARRIAGE RETURN character.NullExpr - Expression used in place of a NULL value if specified,otherwise the empty string.
public java.lang.String GetString(variant adClipString,
variant NumRows,
variant ColumnDelimiter,
variant RowDelimiter,
java.lang.String NullExpr)
throws java.lang.Exception
adClipString - Specifies that the Recordset should be converted to the following format.
NumRows - The number of rows in the recordset to convert.If NumRows is not specified,
or if it is greater than the total number of rows in the recordset,
then all the rows in the recordset are converted.ColumnDelimiter - Delimiter used between columns if specified,otherwise the TAB character.RowDelimiter - Delimiter used between rows if specified,otherwise the CARRIAGE RETURN character.NullExpr - Expression used in place of a NULL value if specified,otherwise the empty string.
public java.lang.String GetString(variant adClipString,
variant NumRows,
java.lang.String ColumnDelimiter,
java.lang.String RowDelimiter)
throws java.lang.Exception
GetString(2,NumRows,ColumnDelimiter,RowDelimiter,"").
public java.lang.String GetString(int adClipString,
int NumRows,
java.lang.String ColumnDelimiter,
java.lang.String RowDelimiter)
throws java.lang.Exception
GetString(2,NumRows,ColumnDelimiter,RowDelimiter,"")