public interface ISqlJetCursor
Modifier and Type | Method and Description |
---|---|
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.Object[] |
getRowValues()
Returns all field values of 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.
|
void close() throws SqlJetException
SqlJetException
long getRowId() throws SqlJetException
SqlJetException
boolean goTo(long rowId) throws SqlJetException
rowId
- row IdSqlJetException
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 fieldSqlJetException
SqlJetValueType getFieldType(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the fieldSqlJetException
boolean isNull(int field) throws SqlJetException
field
- number of field begin from zeroSqlJetException
boolean isNull(java.lang.String fieldName) throws SqlJetException
SqlJetException
java.lang.String getString(int field) throws SqlJetException
field
- index of the fieldSqlJetException
java.lang.String getString(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the fieldSqlJetException
long getInteger(int field) throws SqlJetException
field
- index of the fieldSqlJetException
long getInteger(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the fieldSqlJetException
double getFloat(int field) throws SqlJetException
field
- index of the fieldSqlJetException
double getFloat(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the fieldSqlJetException
boolean getBoolean(int field) throws SqlJetException
field
- index of the fieldSqlJetException
boolean getBoolean(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the fieldSqlJetException
byte[] getBlobAsArray(int field) throws SqlJetException
field
- index of the fieldSqlJetException
byte[] getBlobAsArray(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the fieldSqlJetException
java.io.InputStream getBlobAsStream(int field) throws SqlJetException
field
- number of field begin from zeroSqlJetException
java.io.InputStream getBlobAsStream(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the fieldSqlJetException
java.lang.Object getValue(int field) throws SqlJetException
field
- index of the fieldSqlJetException
java.lang.Object getValue(java.lang.String fieldName) throws SqlJetException
fieldName
- name of the fieldSqlJetException
java.lang.Object[] getRowValues() throws SqlJetException
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()
Copyright © 2009-2010 TMate Software Ltd. All Rights Reserved.