| Method | Description |
| set/getXxx |
Set/Get method for every column in the table. Use these to access the data after
retrieval from the database, or to set it for updates and searches etc. |
| retrieveByKey, retrieveByIndex |
Retrieves a record from the database, based upon the current key/index values
that are within the object. |
| retrieveAllLikeKey, retrieveAllLikeIndex |
As above except that all matches are returned in a Vector.
SQL wildcards (percent signs) may be used. The current object value are unchanged. |
| updateByKey, updateByIndex |
Updates the current object contents to the database. |
| deleteByKey, deleteByIndex |
Deletes the current object from the database based upon key/index. |
| countByKey, countByIndex |
Counts the matches for the current key/index. Keys will only ever
return 0 or 1 as keys are unique. |
| countLikeKey, countLikeIndex |
As above except wildcards may be used. |
| retrieveAllWhere |
Retrieve a Vector of objects based on a custom where clause.
Note that this method does not have the type safety of the other methods.
This should be avoided if possible. |
| insert |
Inserts the current record into the database. |
| count |
Counts the number of rows in the table. |
| getFromResultSet |
A convenience method mainly provided for extended classes. This updates all
the internal values based on a result set containing these. i.e. a select * from .... |