| java.lang.Object
 net.xoetrope.optional.data.sql.DatabaseTable
net.xoetrope.optional.data.sql.CachedDatabaseTable
| CachedDatabaseTable | | public class CachedDatabaseTable extends DatabaseTable (Code) | | A class that extends the DatabaseTable class by caching the data from the
query result set.
Copyright (c) Xoetrope Ltd. 2001-2003
$Revision: 1.2 $
|
| CachedDatabaseTable | | public CachedDatabaseTable(String sqlStr, String connName, boolean writable)(Code) | | Setup a table with the full sql statement
Parameters:
sqlStr - the full SQL statement
Parameters:
connName - the connection name
Parameters:
writable - |
| CachedDatabaseTable | | public CachedDatabaseTable(String tableName, String fields, String where, String connName, boolean writable)(Code) | | Create a new database table wrapper
Parameters:
tableName - the table name
Parameters:
fields - the fields to retrieve
Parameters:
where - the where clause to use in the query
Parameters:
conn - the connection name
Parameters:
allowWrites - true if the result set is to be updatable |
| cacheData | | protected void cacheData()(Code) | | Internally store the latest result set data
|
| getValue | | public String getValue(int fieldIdx)(Code) | | Get a field value from the current row
Parameters:
fieldIdx - the field (zero based) to retrieve |
| getValue | | public String getValue(int rowIdx, int fieldIdx)(Code) | | Get a field value
Parameters:
rowIdx - the row (zero based) to retrieve
Parameters:
fieldIdx - the field (zero based) to retrieve |
| setValue | | public void setValue(int fieldIdx, String value)(Code) | | Set the cache value for a field. This method does not write the data back
to the database.
Parameters:
rowIdx - the row (zero based) to retrieve
Parameters:
fieldIdx - the field (zero based) to retrieve |
|
|