Method Summary
All Methods Instance Methods Abstract Methods
boolean
Check the current record is equal to key using definition of index.
void
void
Delete record by row's ID.
Get table's schema definition.
Get definitions of table's indexes.
Get indexes which are related with table.
Get name of index which has been auto-created for primary key.
long
boolean
Go to record with given rowID.
long
Write an new entry into the table.
long
Insert record by values by names of fields.
long
boolean
boolean
Locate record which using index by key.
void
Update an entry in the table by rowId.
void
void
void
Update the current entry in the table.
long
Update the rowId and values in current entry in the table.
long
Update the rowId and values an entry in the table by rowId.
Methods inherited from interface org.tmatesoft.sqljet.core.internal.table.ISqlJetBtreeTable
clear , close , eof , first , getBlob , getEncoding , getFieldsCount , getFieldType , getFloat , getInteger , getKeySize , getRecord , getString , getValue , getValues , hasMoved , insert , isNull , last , lock , lockTable , moveTo , newRowId , newRowId , next , popState , previous , pushState , unlock
Method Details
getDefinition
Get table's schema definition.
Returns:
getIndexDefinitions
Get definitions of table's indexes.
Returns:
getIndexesTables
Get indexes which are related with table.
Returns:
goToRow
Go to record with given rowID. Return boolean to indicate success.
Parameters:
rowId
-
Returns:
Throws:
SqlJetException
insert
Write an new entry into the table.
Parameters:
values
-
Throws:
SqlJetException
update
Update an entry in the table by rowId.
Parameters:
rowId
-
values
-
Throws:
SqlJetException
updateCurrent
Update the current entry in the table.
Parameters:
values
-
Throws:
SqlJetException
updateWithRowId
Update the rowId and values an entry in the table by rowId.
Parameters:
rowId
-
values
-
Throws:
SqlJetException
updateCurrentWithRowId
Update the rowId and values in current entry in the table.
Parameters:
values
-
Throws:
SqlJetException
delete
Delete record by row's ID.
Parameters:
rowId
-
Throws:
SqlJetException
checkIndex
Check the current record is equal to key using definition of index.
Parameters:
indexName
-
key
-
Returns:
Throws:
SqlJetException
getPrimaryKeyIndex
Get name of index which has been auto-created for primary key.
Returns:
the primaryKeyIndex
locate
Locate record which using index by key. Key is values for fields which
are defined in index. If record is found then returns true. If next is
true then locate record by next entry in index for key.
Parameters:
indexName
-
next
-
key
-
Returns:
Throws:
SqlJetException
insert
Insert record by values by names of fields.
Parameters:
values
-
Returns:
Throws:
SqlJetException
isIndexExists
boolean isIndexExists (String indexName)
Parameters:
indexName
-
Returns:
insertWithRowId
Parameters:
rowId
-
values
-
Returns:
Throws:
SqlJetException
getIndex
Parameters:
indexName
-
Returns: