|
SQLJet Home | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface ISqlJetCursor
This class represents table cursor that may be used to browse over records in the table, to modify or delete existing records.
Method Summary | |
---|---|
void |
close()
Closes the cursor. |
void |
delete()
Deletes the current record. |
boolean |
eof()
Tests whether this cursor is positioned behind the last record. |
boolean |
first()
Goes to the first record. |
byte[] |
getBlobAsArray(int field)
Returns specified field's value as BLOB. |
byte[] |
getBlobAsArray(java.lang.String fieldName)
Returns specified field's value as BLOB. |
java.io.InputStream |
getBlobAsStream(int field)
Returns specified field's value as BLOB. |
java.io.InputStream |
getBlobAsStream(java.lang.String fieldName)
Returns specified field's value as BLOB. |
boolean |
getBoolean(int field)
Returns specified field's value as boolean. |
boolean |
getBoolean(java.lang.String fieldName)
Returns specified field's value as boolean. |
int |
getFieldsCount()
Returns number of fields in the current record. |
SqlJetValueType |
getFieldType(int field)
Returns field type. |
SqlJetValueType |
getFieldType(java.lang.String fieldName)
Returns field type. |
double |
getFloat(int field)
Returns specified field's value as float. |
double |
getFloat(java.lang.String fieldName)
Returns specified field's value as float. |
long |
getInteger(int field)
Returns specified field's value as integer. |
long |
getInteger(java.lang.String fieldName)
Returns specified field's value as integer. |
long |
getLimit()
Returns limit of this cursor. |
long |
getRowCount()
Returns number of rows accessible with this cursor. |
long |
getRowId()
Gets row Id of the current record. |
long |
getRowIndex()
Returns index of the current row. |
java.lang.String |
getString(int field)
Returns specified field's value as String. |
java.lang.String |
getString(java.lang.String fieldName)
Returns specified field's value as String. |
java.lang.Object |
getValue(int field)
Returns value of the field of the specified index in the current row. |
java.lang.Object |
getValue(java.lang.String fieldName)
Returns value of the field with the specified name in the current row. |
boolean |
goTo(long rowId)
Goes to the record with the specified row Id. |
boolean |
goToRow(long rowIndex)
Goes to the row with the specified index. |
boolean |
isNull(int field)
Tests field value for null. |
boolean |
isNull(java.lang.String fieldName)
Tests field value for null. |
boolean |
last()
Goes to the last record. |
boolean |
next()
Goes to the next record. |
boolean |
previous()
Goes to the previous record. |
ISqlJetCursor |
reverse()
Returns cursor with the order reversed. |
void |
setLimit(long limit)
Sets limit for this cursor. |
void |
update(java.lang.Object... values)
Updates the current record. |
void |
updateByFieldNames(java.util.Map<java.lang.String,java.lang.Object> values)
Updates the current record. |
void |
updateByFieldNamesOr(SqlJetConflictAction onConflict,
java.util.Map<java.lang.String,java.lang.Object> values)
Updates the current record. |
void |
updateOr(SqlJetConflictAction onConflict,
java.lang.Object... values)
Updates the current record. |
long |
updateWithRowId(long rowId,
java.lang.Object... values)
Updates rowId and values in the current record. |
long |
updateWithRowIdOr(SqlJetConflictAction onConflict,
long rowId,
java.lang.Object... values)
Updates rowId and values in the current record. |
Method Detail |
---|
void close() throws SqlJetException
SqlJetException
long getRowId() throws SqlJetException
SqlJetException
boolean goTo(long rowId) throws SqlJetException
rowId
- row Id
SqlJetException
boolean eof() throws SqlJetException
SqlJetException
boolean first() throws SqlJetException
SqlJetException
boolean last() throws SqlJetException
SqlJetException
boolean next() throws SqlJetException
SqlJetException
boolean previous() throws SqlJetException
SqlJetException
int getFieldsCount() throws SqlJetException
SqlJetException
SqlJetValueType getFieldType(int field) throws SqlJetException
field
- index of the field
SqlJetException
SqlJetValueType getFieldType(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the field
SqlJetException
boolean isNull(int field) throws SqlJetException
field
- number of field begin from zero
SqlJetException
boolean isNull(java.lang.String fieldName) throws SqlJetException
SqlJetException
java.lang.String getString(int field) throws SqlJetException
field
- index of the field
SqlJetException
java.lang.String getString(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the field
SqlJetException
long getInteger(int field) throws SqlJetException
field
- index of the field
SqlJetException
long getInteger(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the field
SqlJetException
double getFloat(int field) throws SqlJetException
field
- index of the field
SqlJetException
double getFloat(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the field
SqlJetException
boolean getBoolean(int field) throws SqlJetException
field
- index of the field
SqlJetException
boolean getBoolean(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the field
SqlJetException
byte[] getBlobAsArray(int field) throws SqlJetException
field
- index of the field
SqlJetException
byte[] getBlobAsArray(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the field
SqlJetException
java.io.InputStream getBlobAsStream(int field) throws SqlJetException
field
- number of field begin from zero
SqlJetException
java.io.InputStream getBlobAsStream(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the field
SqlJetException
java.lang.Object getValue(int field) throws SqlJetException
field
- index of the field
SqlJetException
java.lang.Object getValue(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the field
SqlJetException
void update(java.lang.Object... values) throws SqlJetException
values
- New record values.
SqlJetException
long updateWithRowId(long rowId, java.lang.Object... values) throws SqlJetException
values
- New record values.
SqlJetException
void updateByFieldNames(java.util.Map<java.lang.String,java.lang.Object> values) throws SqlJetException
values
- New record values mapped by field names.
SqlJetException
void updateOr(SqlJetConflictAction onConflict, java.lang.Object... values) throws SqlJetException
SqlJetConflictAction
.
onConflict
- SqlJetConflictAction
.values
- New record values.
SqlJetException
long updateWithRowIdOr(SqlJetConflictAction onConflict, long rowId, java.lang.Object... values) throws SqlJetException
SqlJetConflictAction
.
onConflict
- SqlJetConflictAction
.values
- New record values.
SqlJetException
void updateByFieldNamesOr(SqlJetConflictAction onConflict, java.util.Map<java.lang.String,java.lang.Object> values) throws SqlJetException
SqlJetConflictAction
.
onConflict
- SqlJetConflictAction
.values
- New record values mapped by field names.
SqlJetException
void delete() throws SqlJetException
SqlJetException
ISqlJetCursor reverse() throws SqlJetException
SqlJetException
long getRowCount() throws SqlJetException
SqlJetException
long getRowIndex() throws SqlJetException
SqlJetException
boolean goToRow(long rowIndex) throws SqlJetException
rowIndex
-
SqlJetException
void setLimit(long limit) throws SqlJetException
limit
- limit to set or zero to drop the limit.
SqlJetException
long getLimit()
|
SQLJet Home | ||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |