| java.lang.Object
 com.salmonllc.sql.DataStoreBuffer
com.salmonllc.sql.DataStore
com.salmonllc.examples.example8.ContactModel
| ContactModel | | public class ContactModel extends DataStore implements Remotable(Code) | | ContactModel: A SOFIA generated model
|
| Method Summary | |
| public String | getContactAddress()
Retrieve the value of the contact.address column for the current row. | | public String | getContactAddress(int row)
Retrieve the value of the contact.address column for the specified row. | | public String | getContactAltPhone()
Retrieve the value of the contact.alt_phone column for the current row. | | public String | getContactAltPhone(int row)
Retrieve the value of the contact.alt_phone column for the specified row. | | public String | getContactCellPhone()
Retrieve the value of the contact.cell_phone column for the current row. | | public String | getContactCellPhone(int row)
Retrieve the value of the contact.cell_phone column for the specified row. | | public String | getContactCity()
Retrieve the value of the contact.city column for the current row. | | public String | getContactCity(int row)
Retrieve the value of the contact.city column for the specified row. | | public int | getContactContactId()
Retrieve the value of the contact.contact_id column for the current row. | | public int | getContactContactId(int row)
Retrieve the value of the contact.contact_id column for the specified row. | | public String | getContactEmailAddress()
Retrieve the value of the contact.email_address column for the current row. | | public String | getContactEmailAddress(int row)
Retrieve the value of the contact.email_address column for the specified row. | | public String | getContactFirstName()
Retrieve the value of the contact.first_name column for the current row. | | public String | getContactFirstName(int row)
Retrieve the value of the contact.first_name column for the specified row. | | public String | getContactLastName()
Retrieve the value of the contact.last_name column for the current row. | | public String | getContactLastName(int row)
Retrieve the value of the contact.last_name column for the specified row. | | public String | getContactMainPhone()
Retrieve the value of the contact.main_phone column for the current row. | | public String | getContactMainPhone(int row)
Retrieve the value of the contact.main_phone column for the specified row. | | public String | getContactState()
Retrieve the value of the contact.state column for the current row. | | public String | getContactState(int row)
Retrieve the value of the contact.state column for the specified row. | | public String | getContactZip()
Retrieve the value of the contact.zip column for the current row. | | public String | getContactZip(int row)
Retrieve the value of the contact.zip column for the specified row. | | public boolean | request(String reqType, HttpServletRequest req, boolean sessionValid, String userID, String password, String criteria)
This method gets fired before each remote request to the DataStore is made (including the create method).
true if the request should be granted and false if the request should be denied.
Parameters:
reqType - The type of request being made. | | public void | setContactAddress(String newValue)
Set the value of the contact.address column for the current row. | | public void | setContactAddress(int row, String newValue)
Set the value of the contact.address column for the specified row. | | public void | setContactAltPhone(String newValue)
Set the value of the contact.alt_phone column for the current row. | | public void | setContactAltPhone(int row, String newValue)
Set the value of the contact.alt_phone column for the specified row. | | public void | setContactCellPhone(String newValue)
Set the value of the contact.cell_phone column for the current row. | | public void | setContactCellPhone(int row, String newValue)
Set the value of the contact.cell_phone column for the specified row. | | public void | setContactCity(String newValue)
Set the value of the contact.city column for the current row. | | public void | setContactCity(int row, String newValue)
Set the value of the contact.city column for the specified row. | | public void | setContactContactId(int newValue)
Set the value of the contact.contact_id column for the current row. | | public void | setContactContactId(int row, int newValue)
Set the value of the contact.contact_id column for the specified row. | | public void | setContactEmailAddress(String newValue)
Set the value of the contact.email_address column for the current row. | | public void | setContactEmailAddress(int row, String newValue)
Set the value of the contact.email_address column for the specified row. | | public void | setContactFirstName(String newValue)
Set the value of the contact.first_name column for the current row. | | public void | setContactFirstName(int row, String newValue)
Set the value of the contact.first_name column for the specified row. | | public void | setContactLastName(String newValue)
Set the value of the contact.last_name column for the current row. | | public void | setContactLastName(int row, String newValue)
Set the value of the contact.last_name column for the specified row. | | public void | setContactMainPhone(String newValue)
Set the value of the contact.main_phone column for the current row. | | public void | setContactMainPhone(int row, String newValue)
Set the value of the contact.main_phone column for the specified row. | | public void | setContactState(String newValue)
Set the value of the contact.state column for the current row. | | public void | setContactState(int row, String newValue)
Set the value of the contact.state column for the specified row. | | public void | setContactZip(String newValue)
Set the value of the contact.zip column for the current row. | | public void | setContactZip(int row, String newValue)
Set the value of the contact.zip column for the specified row. | | public void | update(DBConnection conn, boolean handleTrans)
Override the update method so that the contact id is generated for all new rows and every modified row is validated. |
| CONTACT_ADDRESS | | final public static String CONTACT_ADDRESS(Code) | | |
| CONTACT_ALT_PHONE | | final public static String CONTACT_ALT_PHONE(Code) | | |
| CONTACT_CELL_PHONE | | final public static String CONTACT_CELL_PHONE(Code) | | |
| CONTACT_CONTACT_ID | | final public static String CONTACT_CONTACT_ID(Code) | | |
| CONTACT_EMAIL_ADDRESS | | final public static String CONTACT_EMAIL_ADDRESS(Code) | | |
| CONTACT_FIRST_NAME | | final public static String CONTACT_FIRST_NAME(Code) | | |
| CONTACT_LAST_NAME | | final public static String CONTACT_LAST_NAME(Code) | | |
| CONTACT_MAIN_PHONE | | final public static String CONTACT_MAIN_PHONE(Code) | | |
| ContactModel | | public ContactModel(String appName)(Code) | | Create a new ContactModel object.
Parameters:
appName - The SOFIA application name |
| ContactModel | | public ContactModel(String appName, String profile)(Code) | | Create a new ContactModel object.
Parameters:
appName - The SOFIA application name
Parameters:
profile - The database profile to use |
| getContactAltPhone | | public String getContactAltPhone(int row) throws DataStoreException(Code) | | Retrieve the value of the contact.alt_phone column for the specified row.
Parameters:
row - which row in the table String
throws:
DataStoreException - |
| getContactCellPhone | | public String getContactCellPhone(int row) throws DataStoreException(Code) | | Retrieve the value of the contact.cell_phone column for the specified row.
Parameters:
row - which row in the table String
throws:
DataStoreException - |
| getContactContactId | | public int getContactContactId(int row) throws DataStoreException(Code) | | Retrieve the value of the contact.contact_id column for the specified row.
Parameters:
row - which row in the table int
throws:
DataStoreException - |
| getContactEmailAddress | | public String getContactEmailAddress(int row) throws DataStoreException(Code) | | Retrieve the value of the contact.email_address column for the specified row.
Parameters:
row - which row in the table String
throws:
DataStoreException - |
| getContactFirstName | | public String getContactFirstName(int row) throws DataStoreException(Code) | | Retrieve the value of the contact.first_name column for the specified row.
Parameters:
row - which row in the table String
throws:
DataStoreException - |
| getContactLastName | | public String getContactLastName(int row) throws DataStoreException(Code) | | Retrieve the value of the contact.last_name column for the specified row.
Parameters:
row - which row in the table String
throws:
DataStoreException - |
| getContactMainPhone | | public String getContactMainPhone(int row) throws DataStoreException(Code) | | Retrieve the value of the contact.main_phone column for the specified row.
Parameters:
row - which row in the table String
throws:
DataStoreException - |
| request | | public boolean request(String reqType, HttpServletRequest req, boolean sessionValid, String userID, String password, String criteria) throws DataStoreException(Code) | | This method gets fired before each remote request to the DataStore is made (including the create method).
true if the request should be granted and false if the request should be denied.
Parameters:
reqType - The type of request being made. See operation constants for valid values.
Parameters:
req - javax.servlet.http.HttpServletRequest The servlet request used.
Parameters:
sessionValid - true if this request came from a valid session or false if a new one had to be created.
Parameters:
userID - The user id making the request
Parameters:
password - The password of the user id making the request
Parameters:
criteria - The selection criteria passed from the request |
| setContactAddress | | public void setContactAddress(int row, String newValue) throws DataStoreException(Code) | | Set the value of the contact.address column for the specified row.
Parameters:
row - which row in the table
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| setContactAltPhone | | public void setContactAltPhone(int row, String newValue) throws DataStoreException(Code) | | Set the value of the contact.alt_phone column for the specified row.
Parameters:
row - which row in the table
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| setContactCellPhone | | public void setContactCellPhone(int row, String newValue) throws DataStoreException(Code) | | Set the value of the contact.cell_phone column for the specified row.
Parameters:
row - which row in the table
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| setContactCity | | public void setContactCity(int row, String newValue) throws DataStoreException(Code) | | Set the value of the contact.city column for the specified row.
Parameters:
row - which row in the table
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| setContactContactId | | public void setContactContactId(int newValue) throws DataStoreException(Code) | | Set the value of the contact.contact_id column for the current row.
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| setContactContactId | | public void setContactContactId(int row, int newValue) throws DataStoreException(Code) | | Set the value of the contact.contact_id column for the specified row.
Parameters:
row - which row in the table
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| setContactEmailAddress | | public void setContactEmailAddress(String newValue) throws DataStoreException(Code) | | Set the value of the contact.email_address column for the current row.
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| setContactEmailAddress | | public void setContactEmailAddress(int row, String newValue) throws DataStoreException(Code) | | Set the value of the contact.email_address column for the specified row.
Parameters:
row - which row in the table
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| setContactFirstName | | public void setContactFirstName(int row, String newValue) throws DataStoreException(Code) | | Set the value of the contact.first_name column for the specified row.
Parameters:
row - which row in the table
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| setContactLastName | | public void setContactLastName(int row, String newValue) throws DataStoreException(Code) | | Set the value of the contact.last_name column for the specified row.
Parameters:
row - which row in the table
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| setContactMainPhone | | public void setContactMainPhone(int row, String newValue) throws DataStoreException(Code) | | Set the value of the contact.main_phone column for the specified row.
Parameters:
row - which row in the table
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| setContactState | | public void setContactState(int row, String newValue) throws DataStoreException(Code) | | Set the value of the contact.state column for the specified row.
Parameters:
row - which row in the table
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| setContactZip | | public void setContactZip(int row, String newValue) throws DataStoreException(Code) | | Set the value of the contact.zip column for the specified row.
Parameters:
row - which row in the table
Parameters:
newValue - the new item value
throws:
DataStoreException - |
| Methods inherited from com.salmonllc.sql.DataStore | public void addColumn(String column, int type)(Code)(Java Doc)
public void addColumn(String column, int type, boolean primaryKey, boolean updatable)(Code)(Java Doc)
public void addColumn(String table, String column, int type)(Code)(Java Doc)
public void addColumn(String table, String column, int type, boolean primaryKey, boolean updateable)(Code)(Java Doc)
public void addColumn(String table, String column, int type, boolean primaryKey, boolean updateable, String internalName)(Code)(Java Doc)
public void addFormattedColumn(String table, String column, int type, boolean primaryKey, boolean updateable, String colFormat)(Code)(Java Doc)
public void addJoin(String columnList1, String columnList2, boolean outerJoin)(Code)(Java Doc)
public void addJoin(String columnList1, String columnList2, boolean outerJoin, int relationType)(Code)(Java Doc)
public void addSQLPreviewListener(SQLPreviewListener p)(Code)(Java Doc)
public void addTableAlias(String table, String alias)(Code)(Java Doc)
public boolean allDataRetrieved()(Code)(Java Doc)
public void autoRetrieve()(Code)(Java Doc)
public synchronized void buildBuffer(DBConnection conn, String sql) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public synchronized void buildBuffer(String sql) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public static String buildCriteriaString(AutoRetrieveCriteria crit)(Code)(Java Doc)
public String buildCriteriaStringForRow(int row, String table) throws DataStoreException(Code)(Java Doc)
public void cancelRetrieve()(Code)(Java Doc)
public String computeTableAndFieldName(String fieldName)(Code)(Java Doc)
public String computeTableName(String nameIn)(Code)(Java Doc)
public static DataStoreBuffer constructDataStore(String className, String applicationName)(Code)(Java Doc)
public static DataStoreBuffer constructDataStore(String className, String applicationName, String profileName)(Code)(Java Doc)
public void destroy() throws Exception(Code)(Java Doc)
public int estimateRowsRetrieved() throws DataStoreException, SQLException(Code)(Java Doc)
public int estimateRowsRetrieved(DBConnection conn) throws SQLException(Code)(Java Doc)
public int estimateRowsRetrieved(DBConnection conn, QBEBuilder criteria) throws SQLException(Code)(Java Doc)
public int estimateRowsRetrieved(QBEBuilder criteria) throws DataStoreException, SQLException(Code)(Java Doc)
public int estimateRowsRetrieved(DBConnection conn, String criteria) throws SQLException(Code)(Java Doc)
public int estimateRowsRetrieved(DBConnection conn, String criteria, PreparedStatementParms psp) throws SQLException(Code)(Java Doc)
public int estimateRowsRetrieved(String criteria) throws DataStoreException, SQLException(Code)(Java Doc)
public int estimateRowsRetrieved(String criteria, PreparedStatementParms psp) throws DataStoreException, SQLException(Code)(Java Doc)
public synchronized void execute(DBConnection conn, String sql) throws java.sql.SQLException(Code)(Java Doc)
public synchronized void execute(String sql) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public synchronized void executePrepStmt(DBConnection conn, String stmt) throws java.sql.SQLException(Code)(Java Doc)
public synchronized void executePrepStmt(DBConnection conn, String stmt, PreparedStatementParms parms) throws java.sql.SQLException(Code)(Java Doc)
public void executePrepStmt(String stmt) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public synchronized void executePrepStmt(String stmt, PreparedStatementParms parms) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public synchronized void executeProc(DBConnection conn, String proc) throws java.sql.SQLException(Code)(Java Doc)
public synchronized void executeProc(DBConnection conn, String proc, StoredProcedureParms parms) throws java.sql.SQLException(Code)(Java Doc)
public void executeProc(String proc) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public synchronized void executeProc(String proc, StoredProcedureParms parms) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public String exportAsSQL(DBConnection conn, String sDBType, String separator) throws Exception(Code)(Java Doc)
public String fixQuote(String data)(Code)(Java Doc)
public String formatDateTime(java.util.Date data)(Code)(Java Doc)
public String getAlias(int tableNo) throws DataStoreException(Code)(Java Doc)
public int getAliasCount()(Code)(Java Doc)
public String getAppName()(Code)(Java Doc)
public boolean getAutoValidate()(Code)(Java Doc)
public boolean getBatchInserts()(Code)(Java Doc)
public boolean getCheckConcurrency()(Code)(Java Doc)
public String getColumnDBColumnName(int col) throws DataStoreException(Code)(Java Doc)
public String getColumnDatabaseName(int col) throws DataStoreException(Code)(Java Doc)
public String getColumnFormat(int col) throws DataStoreException(Code)(Java Doc)
public String getColumnInternalName(int col) throws DataStoreException(Code)(Java Doc)
public String getColumnTableName(int col) throws DataStoreException(Code)(Java Doc)
public ColumnDefinition[] getColumnsForTable(String table)(Code)(Java Doc)
public boolean getConcurrencyCheckColumn(int col) throws DataStoreException(Code)(Java Doc)
public boolean getConcurrencyCheckColumn(String col) throws DataStoreException(Code)(Java Doc)
public String getCriteria()(Code)(Java Doc)
public String getDBMS()(Code)(Java Doc)
public String getDbProfile()(Code)(Java Doc)
public String getDefaultTable()(Code)(Java Doc)
public boolean getDistinct()(Code)(Java Doc)
public boolean getEnableCancel()(Code)(Java Doc)
public boolean getEnableThreads()(Code)(Java Doc)
public AutoRetrieveCriteria getGroupAutoRetrieveCriteria()(Code)(Java Doc)
public String getGroupBy()(Code)(Java Doc)
public String getHaving()(Code)(Java Doc)
public int getJoinColumnCount(int joinNo)(Code)(Java Doc)
public int getJoinCount()(Code)(Java Doc)
public String getJoinLeftColumn(int joinNo, int colNo)(Code)(Java Doc)
public boolean getJoinOuter(int joinNo)(Code)(Java Doc)
public int getJoinRelationType(int joinNo)(Code)(Java Doc)
public String getJoinRightColumn(int joinNo, int colNo)(Code)(Java Doc)
public int getMaxRows()(Code)(Java Doc)
public String getOrderBy()(Code)(Java Doc)
public Properties getProperties()(Code)(Java Doc)
public String getSelectStatement(DBConnection conn, String criteria)(Code)(Java Doc)
public String getTable(int tableNo) throws DataStoreException(Code)(Java Doc)
public String[] getTableList(boolean updateable)(Code)(Java Doc)
public boolean getTrimStrings()(Code)(Java Doc)
public int getUpdateMethod()(Code)(Java Doc)
public int getUseBindColumn(int col) throws DataStoreException(Code)(Java Doc)
public int getUseBindColumn(String col) throws DataStoreException(Code)(Java Doc)
public boolean getUseBindForUpdate()(Code)(Java Doc)
public boolean isAutoIncrement(int col) throws DataStoreException(Code)(Java Doc)
public boolean isAutoIncrement(String col) throws DataStoreException(Code)(Java Doc)
public boolean isColumnPrimaryKey(int col) throws DataStoreException(Code)(Java Doc)
public boolean isPrimaryKey(int col) throws DataStoreException(Code)(Java Doc)
public boolean isPrimaryKey(String col) throws DataStoreException(Code)(Java Doc)
public boolean isUpdateable(int col) throws DataStoreException(Code)(Java Doc)
public boolean isUpdateable(String col) throws DataStoreException(Code)(Java Doc)
public void loadConnectionParms()(Code)(Java Doc)
public void loadConnectionParms(DBConnection conn)(Code)(Java Doc)
public static boolean parensMatch(String s)(Code)(Java Doc)
public boolean ping() throws Exception(Code)(Java Doc)
public void populateFromResultSet(ResultSet rs) throws Exception(Code)(Java Doc)
public synchronized void reloadRow() throws DataStoreException, SQLException(Code)(Java Doc)
public synchronized void reloadRow(int rowNo) throws DataStoreException, SQLException(Code)(Java Doc)
public synchronized void reloadRow(DBConnection conn, int rowNo) throws DataStoreException, SQLException(Code)(Java Doc)
public void removeColumn(String column)(Code)(Java Doc)
public void removeJoin(String left, String right)(Code)(Java Doc)
public void removeSQLPreviewListener(SQLPreviewListener p)(Code)(Java Doc)
public void removeTableAlias(String table)(Code)(Java Doc)
public synchronized void reset()(Code)(Java Doc)
public void retrieve() throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public void retrieve(DBConnection conn) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public void retrieve(DBConnection conn, String criteria) throws SQLException(Code)(Java Doc)
public void retrieve(DBConnection conn, String criteria, PreparedStatementParms psp) throws SQLException(Code)(Java Doc)
public void retrieve(DBConnection conn, QBEBuilder criteria) throws SQLException(Code)(Java Doc)
public void retrieve(QBEBuilder criteria) throws SQLException, DataStoreException(Code)(Java Doc)
public synchronized void retrieve(String criteria) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public synchronized void retrieve(String criteria, PreparedStatementParms psp) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public void run()(Code)(Java Doc)
public void setAppName(String appName)(Code)(Java Doc)
public void setAutoIncrement(int col, boolean auto) throws DataStoreException(Code)(Java Doc)
public void setAutoIncrement(String col, boolean auto) throws DataStoreException(Code)(Java Doc)
public void setAutoValidate(boolean autoValidate)(Code)(Java Doc)
public void setBatchInserts(boolean batchInserts)(Code)(Java Doc)
public void setCheckConcurrency(boolean truefalse)(Code)(Java Doc)
public void setConcurrencyCheckColumn(int col, boolean truefalse) throws DataStoreException(Code)(Java Doc)
public void setConcurrencyCheckColumn(String col, boolean truefalse) throws DataStoreException(Code)(Java Doc)
public void setConnection(DBConnection conn)(Code)(Java Doc)
public void setCriteria(String criteria)(Code)(Java Doc)
public void setDBProfile(String dbProfile)(Code)(Java Doc)
public void setDataSourceIn(DataSourceIn dsIn)(Code)(Java Doc)
public void setDataSourceOut(DataSourceOut dsOut)(Code)(Java Doc)
public void setDefaultTable(String table)(Code)(Java Doc)
public void setDistinct(boolean distinct)(Code)(Java Doc)
public void setEnableCancel(boolean truefalse)(Code)(Java Doc)
public void setEnableThreads(boolean truefalse)(Code)(Java Doc)
public void setGroupAutoRetrieveCriteria(AutoRetrieveCriteria crit)(Code)(Java Doc)
public void setGroupBy(String groupByColumns)(Code)(Java Doc)
public void setHaving(String havingCriteria)(Code)(Java Doc)
public void setMaxRows(int max)(Code)(Java Doc)
public void setOrderBy(String orderBy)(Code)(Java Doc)
public void setPrimaryKey(int col, boolean pkey) throws DataStoreException(Code)(Java Doc)
public void setPrimaryKey(String col, boolean pkey) throws DataStoreException(Code)(Java Doc)
public void setProperties(Properties p)(Code)(Java Doc)
public void setTrimStrings(boolean trim)(Code)(Java Doc)
public void setUpdateMethod(int updateMethod)(Code)(Java Doc)
public void setUpdateable(int col, boolean updateable) throws DataStoreException(Code)(Java Doc)
public void setUpdateable(String col, boolean updateable) throws DataStoreException(Code)(Java Doc)
public void setUseBindColumn(int col, int useBind) throws DataStoreException(Code)(Java Doc)
public void setUseBindColumn(String col, int useBind) throws DataStoreException(Code)(Java Doc)
public void setUseBindForUpdate(boolean truefalse)(Code)(Java Doc)
public int unDeleteRow(int row)(Code)(Java Doc)
public void union(DataStore dataStores) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public void union(DataStore dataStore) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public void union(DBConnection conn, DataStore dataStores) throws java.sql.SQLException(Code)(Java Doc)
public void union(DBConnection conn, DataStore dataStore) throws java.sql.SQLException, DataStoreException(Code)(Java Doc)
public void update() throws DataStoreException, java.sql.SQLException(Code)(Java Doc)
public void update(DBConnection conn) throws DataStoreException, java.sql.SQLException(Code)(Java Doc)
public void update(DBConnection conn, boolean handleTrans) throws DataStoreException, java.sql.SQLException(Code)(Java Doc)
|
| Methods inherited from com.salmonllc.sql.DataStoreBuffer | public void addBucket(String internalname, int type)(Code)(Java Doc)
public void addBucket(String internalname, int type, String format)(Code)(Java Doc)
public void addExpressionRule(String column, DataStoreExpression expression, String errorMessage, boolean executeOnServer) throws DataStoreException(Code)(Java Doc)
public void addExpressionRule(String column, String expression, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addExpressionRule(int column, DataStoreExpression expression, String errorMessage, boolean executeOnServer) throws DataStoreException(Code)(Java Doc)
public void addExpressionRule(int column, String expression, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addJavaScriptRule(String column, String javaScript, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addJavaScriptRule(int column, String javaScript, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addLookupRule(String column, String lookupTable, String searchExpression, String descriptionColumn, String descriptionBucket, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addLookupRule(int column, String lookupTable, String searchExpression, String descriptionColumn, String descriptionBucket, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addModelChangedListener(ModelChangedListener l)(Code)(Java Doc)
public void addRangeRule(int column, Object minValue, Object maxValue, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addRangeRule(String column, Object minValue, Object maxValue, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addRequiredRule(String column, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addRequiredRule(int column, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addReqularExpressionRule(String column, String regExp, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addReqularExpressionRule(int column, String regExp, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addTypeCheckRule(String column, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void addTypeCheckRule(int column, String errorMessage) throws DataStoreException(Code)(Java Doc)
public void appendRows(Vector rows)(Code)(Java Doc)
protected boolean areThereModelListeners()(Code)(Java Doc)
public void autoRetrieve() throws Exception(Code)(Java Doc)
public void clearAllValidationRules()(Code)(Java Doc)
public void clearSelectedRow()(Code)(Java Doc)
public void clearTempValues(int row) throws DataStoreException(Code)(Java Doc)
public void clearTempValues() throws DataStoreException(Code)(Java Doc)
public void clearValidationRules(int column) throws DataStoreException(Code)(Java Doc)
public void clearValidationRules(String column) throws DataStoreException(Code)(Java Doc)
public int compareRows(int row1, int row2, int[] cols)(Code)(Java Doc)
public int compareRows(int row1, int row2, String[] cols)(Code)(Java Doc)
public Object convertValue(String val, String columnName) throws DataStoreException(Code)(Java Doc)
public static Object convertValue(String val, int dataType) throws ParseException(Code)(Java Doc)
public boolean deleteRow()(Code)(Java Doc)
public boolean deleteRow(int row)(Code)(Java Doc)
public String export() throws com.salmonllc.sql.DataStoreException(Code)(Java Doc)
public void export(int format, boolean includeHeaders, PrintWriter p)(Code)(Java Doc)
public void export(PrintWriter p) throws com.salmonllc.sql.DataStoreException(Code)(Java Doc)
public void filter(String filter) throws DataStoreException(Code)(Java Doc)
public void filterQBE(QBEBuilder filter) throws DataStoreException(Code)(Java Doc)
public synchronized int find(int start, int end) throws DataStoreException(Code)(Java Doc)
public synchronized boolean findFirst() throws DataStoreException(Code)(Java Doc)
public synchronized boolean findLast() throws DataStoreException(Code)(Java Doc)
public synchronized boolean findNext() throws DataStoreException(Code)(Java Doc)
public synchronized boolean findPrior() throws DataStoreException(Code)(Java Doc)
public static String fixQuote(String data, int dataType)(Code)(Java Doc)
public static String fixQuote(String data, int dataType, String connectionType)(Code)(Java Doc)
protected String fixSpecialHTMLCharacters(String input)(Code)(Java Doc)
public boolean getAllowMasterRowDelete()(Code)(Java Doc)
public Object getAny(int column) throws DataStoreException(Code)(Java Doc)
public Object getAny(int row, int column) throws DataStoreException(Code)(Java Doc)
public Object getAny(int row, String column) throws DataStoreException(Code)(Java Doc)
public Object getAny(String column) throws DataStoreException(Code)(Java Doc)
public boolean getAutoBind()(Code)(Java Doc)
public int getAutoRetrieve()(Code)(Java Doc)
public AutoRetrieveCriteria getAutoRetrieveCriteria()(Code)(Java Doc)
public boolean getBucketsModified()(Code)(Java Doc)
public boolean getBucketsModified(int row)(Code)(Java Doc)
public byte[] getByteArray(int column) throws DataStoreException(Code)(Java Doc)
public byte[] getByteArray(int row, int column) throws DataStoreException(Code)(Java Doc)
public byte[] getByteArray(int row, String column) throws DataStoreException(Code)(Java Doc)
public byte[] getByteArray(String column) throws DataStoreException(Code)(Java Doc)
public int getColumnCount()(Code)(Java Doc)
public int getColumnDataType(int column) throws DataStoreException(Code)(Java Doc)
public int getColumnDataType(String column) throws DataStoreException(Code)(Java Doc)
public int getColumnIndex(String column)(Code)(Java Doc)
public String[] getColumnList()(Code)(Java Doc)
public String getColumnName(int col) throws DataStoreException(Code)(Java Doc)
public DataStoreRow getDataStoreRow(int rowNo, int buffer) throws DataStoreException(Code)(Java Doc)
public java.sql.Date getDate(int column) throws DataStoreException(Code)(Java Doc)
public java.sql.Date getDate(int row, int column) throws DataStoreException(Code)(Java Doc)
public java.sql.Date getDate(int row, String column) throws DataStoreException(Code)(Java Doc)
public java.sql.Date getDate(String column) throws DataStoreException(Code)(Java Doc)
public Timestamp getDateTime(int column) throws DataStoreException(Code)(Java Doc)
public Timestamp getDateTime(int row, int column) throws DataStoreException(Code)(Java Doc)
public Timestamp getDateTime(int row, String column) throws DataStoreException(Code)(Java Doc)
public java.sql.Timestamp getDateTime(String column) throws DataStoreException(Code)(Java Doc)
public int getDeletedCount()(Code)(Java Doc)
public double getDouble(int column) throws DataStoreException(Code)(Java Doc)
public double getDouble(int row, int column) throws DataStoreException(Code)(Java Doc)
public double getDouble(int row, String column) throws DataStoreException(Code)(Java Doc)
public double getDouble(String column) throws DataStoreException(Code)(Java Doc)
public int getFilteredCount()(Code)(Java Doc)
public float getFloat(int column) throws DataStoreException(Code)(Java Doc)
public float getFloat(int row, int column) throws DataStoreException(Code)(Java Doc)
public float getFloat(int row, String column) throws DataStoreException(Code)(Java Doc)
public float getFloat(String column) throws DataStoreException(Code)(Java Doc)
public String getFormat(int col) throws DataStoreException(Code)(Java Doc)
public String getFormat(String col) throws DataStoreException(Code)(Java Doc)
public String getFormattedString(int column) throws DataStoreException(Code)(Java Doc)
public String getFormattedString(int row, int column) throws DataStoreException(Code)(Java Doc)
public String getFormattedString(int row, String column) throws DataStoreException(Code)(Java Doc)
public String getFormattedString(String column) throws DataStoreException(Code)(Java Doc)
public int getInt(int column) throws DataStoreException(Code)(Java Doc)
public int getInt(int row, int column) throws DataStoreException(Code)(Java Doc)
public int getInt(int row, String column) throws DataStoreException(Code)(Java Doc)
public int getInt(String column) throws DataStoreException(Code)(Java Doc)
public LanguagePreferences getLang()(Code)(Java Doc)
public long getLong(int column) throws DataStoreException(Code)(Java Doc)
public long getLong(int row, int column) throws DataStoreException(Code)(Java Doc)
public long getLong(int row, String column) throws DataStoreException(Code)(Java Doc)
public long getLong(String column) throws DataStoreException(Code)(Java Doc)
protected Vector getModelListeners()(Code)(Java Doc)
public Object getNullDefault(int dataType)(Code)(Java Doc)
protected int getObjectType(Object obj)(Code)(Java Doc)
public Properties getProperties()(Code)(Java Doc)
public int getProxyRow(int rowNo)(Code)(Java Doc)
public String getRemoteID()(Code)(Java Doc)
public String getRemoteUpdateReturnValue()(Code)(Java Doc)
public int getRow()(Code)(Java Doc)
public int getRowCount()(Code)(Java Doc)
public int getRowStatus()(Code)(Java Doc)
public int getRowStatus(int row)(Code)(Java Doc)
public Vector getRows()(Code)(Java Doc)
public short getShort(int column) throws DataStoreException(Code)(Java Doc)
public short getShort(int row, int column) throws DataStoreException(Code)(Java Doc)
public short getShort(int row, String column) throws DataStoreException(Code)(Java Doc)
public short getShort(String column) throws DataStoreException(Code)(Java Doc)
public String getString(int column) throws DataStoreException(Code)(Java Doc)
public String getString(int row, int column) throws DataStoreException(Code)(Java Doc)
public String getString(int row, String column) throws DataStoreException(Code)(Java Doc)
public String getString(String column) throws DataStoreException(Code)(Java Doc)
public String[] getTableList(boolean updateable)(Code)(Java Doc)
public String getTempValue(int row, int column) throws DataStoreException(Code)(Java Doc)
public String getTempValue(int row, String column) throws DataStoreException(Code)(Java Doc)
public String getTempValue(String column) throws DataStoreException(Code)(Java Doc)
public String getTempValue(int column) throws DataStoreException(Code)(Java Doc)
public java.sql.Time getTime(int column) throws DataStoreException(Code)(Java Doc)
public java.sql.Time getTime(int row, int column) throws DataStoreException(Code)(Java Doc)
public java.sql.Time getTime(int row, String column) throws DataStoreException(Code)(Java Doc)
public java.sql.Time getTime(String column) throws DataStoreException(Code)(Java Doc)
public static String getTypeDescription(int type)(Code)(Java Doc)
public ValidationRule[] getValidationRulesForColumn(int colNo)(Code)(Java Doc)
public synchronized boolean gotoFirst()(Code)(Java Doc)
public synchronized boolean gotoLast()(Code)(Java Doc)
public synchronized boolean gotoNext()(Code)(Java Doc)
public synchronized boolean gotoPrior()(Code)(Java Doc)
public synchronized boolean gotoRow(int row)(Code)(Java Doc)
public boolean hasManyToOneRelationship()(Code)(Java Doc)
public boolean hasTempValues(int row) throws DataStoreException(Code)(Java Doc)
public void importRow(com.salmonllc.xml.Row row) throws DataStoreException(Code)(Java Doc)
public int insertRow()(Code)(Java Doc)
public int insertRow(int atPosition)(Code)(Java Doc)
protected synchronized void interruptWaitingCancelThreads()(Code)(Java Doc)
protected synchronized void interruptWaitingRetrieveThreads()(Code)(Java Doc)
public boolean isColumnInOneToManyRelationship(String sColumn)(Code)(Java Doc)
public boolean isColumnModified(int row, int column) throws DataStoreException(Code)(Java Doc)
public boolean isColumnModified(int row, String column) throws DataStoreException(Code)(Java Doc)
public boolean isFormattedStringValid(int column, String value) throws DataStoreException(Code)(Java Doc)
public boolean isFormattedStringValid(String column, String value) throws DataStoreException(Code)(Java Doc)
public void notifyListeners(ModelChangedEvent e)(Code)(Java Doc)
protected void notifyListeners(int type)(Code)(Java Doc)
public void removeModelChangedListener(ModelChangedListener l)(Code)(Java Doc)
public boolean removeRow()(Code)(Java Doc)
public boolean removeRow(int row)(Code)(Java Doc)
public synchronized void reset()(Code)(Java Doc)
public void resetStatus()(Code)(Java Doc)
public void setAllowMasterRowDelete(boolean bAllow)(Code)(Java Doc)
public void setAny(int row, int column, Object value) throws DataStoreException(Code)(Java Doc)
public void setAny(int column, Object value) throws DataStoreException(Code)(Java Doc)
public void setAny(int row, String column, Object value) throws DataStoreException(Code)(Java Doc)
public void setAny(String column, Object value) throws DataStoreException(Code)(Java Doc)
public void setAutoBind(boolean value)(Code)(Java Doc)
public void setAutoRetrieve(int value)(Code)(Java Doc)
public void setAutoRetrieveCriteria(AutoRetrieveCriteria crit)(Code)(Java Doc)
public void setBucketsModified(int row, boolean modified)(Code)(Java Doc)
public void setBucketsModified(boolean modified)(Code)(Java Doc)
public void setByteArray(int column, byte[] value) throws DataStoreException(Code)(Java Doc)
public void setByteArray(int row, int column, byte[] value) throws DataStoreException(Code)(Java Doc)
public void setByteArray(int row, String column, byte[] value) throws DataStoreException(Code)(Java Doc)
public void setByteArray(String column, byte[] value) throws DataStoreException(Code)(Java Doc)
protected void setCurrentRow(int currentRow)(Code)(Java Doc)
public void setDataStoreRow(int rowNo, int buffer, DataStoreRow row) throws DataStoreException(Code)(Java Doc)
public void setDate(int row, int column, java.sql.Date value) throws DataStoreException(Code)(Java Doc)
public void setDate(int row, String column, java.sql.Date value) throws DataStoreException(Code)(Java Doc)
public void setDate(int column, java.sql.Date value) throws DataStoreException(Code)(Java Doc)
public void setDate(String column, java.sql.Date value) throws DataStoreException(Code)(Java Doc)
public void setDateTime(int row, int column, java.sql.Timestamp value) throws DataStoreException(Code)(Java Doc)
public void setDateTime(int row, String column, java.sql.Timestamp value) throws DataStoreException(Code)(Java Doc)
public void setDateTime(int column, java.sql.Timestamp value) throws DataStoreException(Code)(Java Doc)
public void setDateTime(String column, java.sql.Timestamp value) throws DataStoreException(Code)(Java Doc)
public void setDistinct(boolean distinct)(Code)(Java Doc)
public void setDouble(int column, double value) throws DataStoreException(Code)(Java Doc)
public void setDouble(int row, int column, double value) throws DataStoreException(Code)(Java Doc)
public void setDouble(int row, String column, double value) throws DataStoreException(Code)(Java Doc)
public void setDouble(String column, double value) throws DataStoreException(Code)(Java Doc)
public void setFindExpression(String exp) throws DataStoreException(Code)(Java Doc)
public void setFloat(int column, float value) throws DataStoreException(Code)(Java Doc)
public void setFloat(int row, int column, float value) throws DataStoreException(Code)(Java Doc)
public void setFloat(int row, String column, float value) throws DataStoreException(Code)(Java Doc)
public void setFloat(String column, float value) throws DataStoreException(Code)(Java Doc)
public void setFormat(int col, String format) throws DataStoreException(Code)(Java Doc)
public void setFormat(String col, String format) throws DataStoreException(Code)(Java Doc)
public void setFormattedString(int row, int column, String value) throws DataStoreException(Code)(Java Doc)
public void setFormattedString(int column, String value) throws DataStoreException(Code)(Java Doc)
public void setFormattedString(int row, String column, String value) throws DataStoreException(Code)(Java Doc)
public void setFormattedString(String column, String value) throws DataStoreException(Code)(Java Doc)
public void setInt(int row, int column, int value) throws DataStoreException(Code)(Java Doc)
public void setInt(int row, String column, int value) throws DataStoreException(Code)(Java Doc)
public void setInt(String column, int value) throws DataStoreException(Code)(Java Doc)
public void setLang(LanguagePreferences preferences)(Code)(Java Doc)
public void setLong(int row, int column, long value) throws DataStoreException(Code)(Java Doc)
public void setLong(int column, long value) throws DataStoreException(Code)(Java Doc)
public void setLong(int row, String column, long value) throws DataStoreException(Code)(Java Doc)
public void setLong(String column, long value) throws DataStoreException(Code)(Java Doc)
public void setNullDefault(int dataType, Object defaultValue)(Code)(Java Doc)
public void setOrderBy(String orderBy)(Code)(Java Doc)
public void setPrimaryKey(int col, boolean pkey) throws DataStoreException(Code)(Java Doc)
public void setPrimaryKey(String col, boolean pkey) throws DataStoreException(Code)(Java Doc)
public void setProperties(Properties p)(Code)(Java Doc)
public void setRemoteID(String remoteID)(Code)(Java Doc)
public void setRemoteUpdateReturnValue(String update)(Code)(Java Doc)
public boolean setRowStatus(int status)(Code)(Java Doc)
public boolean setRowStatus(int row, int status)(Code)(Java Doc)
public void setRows(Vector rows)(Code)(Java Doc)
public void setShort(int row, int column, short value) throws DataStoreException(Code)(Java Doc)
public void setShort(int row, String column, short value) throws DataStoreException(Code)(Java Doc)
public void setShort(int column, short value) throws DataStoreException(Code)(Java Doc)
public void setShort(String column, short value) throws DataStoreException(Code)(Java Doc)
public void setString(int row, int column, String value) throws DataStoreException(Code)(Java Doc)
public void setString(int column, String value) throws DataStoreException(Code)(Java Doc)
public void setString(int row, String column, String value) throws DataStoreException(Code)(Java Doc)
public void setString(String column, String value) throws DataStoreException(Code)(Java Doc)
public void setTempValue(int row, int col, String value) throws DataStoreException(Code)(Java Doc)
public void setTempValue(int col, String value) throws DataStoreException(Code)(Java Doc)
public void setTempValue(String col, String value) throws DataStoreException(Code)(Java Doc)
public void setTime(int row, int column, java.sql.Time value) throws DataStoreException(Code)(Java Doc)
public void setTime(int row, String column, java.sql.Time value) throws DataStoreException(Code)(Java Doc)
public void setTime(int column, java.sql.Time value) throws DataStoreException(Code)(Java Doc)
public void setTime(String column, java.sql.Time value) throws DataStoreException(Code)(Java Doc)
public void sort(int[] col, int dir) throws DataStoreException(Code)(Java Doc)
public void sort(int[] col, int dir, boolean bUseQSAlgoritm) throws DataStoreException(Code)(Java Doc)
public void sort(Object[] obj, int dir) throws DataStoreException(Code)(Java Doc)
public void sort(String col, int dir) throws DataStoreException(Code)(Java Doc)
public void sort(int col, int dir) throws DataStoreException(Code)(Java Doc)
public void sort(DataStoreEvaluator eval, int dir) throws DataStoreException(Code)(Java Doc)
public void sort(String col, int dir) throws DataStoreException(Code)(Java Doc)
public int unDeleteRow(int row)(Code)(Java Doc)
public void undoChanges(int row)(Code)(Java Doc)
public DataStoreException[] validateColumn(int rowNo, String colName, DBConnection conn)(Code)(Java Doc)
public DataStoreException[] validateColumn(int rowNo, int colNo, DBConnection conn)(Code)(Java Doc)
protected void validateColumn(int rowNo, int colNo, Vector v, DBConnection conn)(Code)(Java Doc)
public DataStoreException[] validateRow(int rowNo, DBConnection conn)(Code)(Java Doc)
public DataStoreException[] validateRowsToUpdate(DBConnection conn, boolean stopAtFirstError)(Code)(Java Doc)
public boolean valueEqual(int row, int col, Object value) throws DataStoreException(Code)(Java Doc)
public boolean valueGreater(int row, int col, Object value) throws DataStoreException(Code)(Java Doc)
public boolean valueLess(int row, int col, Object value) throws DataStoreException(Code)(Java Doc)
public void waitForCancel()(Code)(Java Doc)
public void waitForRetrieve()(Code)(Java Doc)
public void waitForRetrieve(int iSeconds)(Code)(Java Doc)
protected void waitForRow(int row)(Code)(Java Doc)
|
|
|