public class SimpleSQLFormHandler extends GenericFormHandler
The bean itself is in the following states:
The bean supports the following submit methods:
The value property has sub-properties of its own that represent the values of columns in the current row being operated on by the form handler. For example, if you want to set or get the "firstName" column in a table, you'd reference this as "FormHandler.value.firstName" using the bean syntax.
The name of each sub-property of value should either be in the key or column lists. The list of keys is used in the lookup, update, and delete operations to define which row (or rows) should be operated on. The list of columns are used in lookup, update, and insert to specify which columns are arguments to that operation. For example, the lookup operation will retrieve the values of the column properties. The update operation will modify all columns in the table that are in the list.
The SimpleSQLFormHandler bean has the following properties:
The SimpleSQLFormHandler also has a set of properties that are used to control navigation after a form operation (lookup, update, delete, insert) has been completed. These properties specify the URLs to redirect on certain error and success conditions. If the value for a particular condition is not set, the form is left on the page defined as the action for that form (i.e. no redirect takes place). Each operation has its own SuccessURL and ErrorURL properties. Thus the following properties are available:
<input type=hidden bean="FormHandler.lookupErrorURL" value="/notFound.jhtml">
Modifier and Type | Class and Description |
---|---|
static class |
SimpleSQLFormHandler.FlexibleDoublePropertyEditor
This class implements a property editor which does normal double
parsing, but also check for 'true' treating it as 1.0 and 'false" as 0.0.
|
static class |
SimpleSQLFormHandler.FlexibleIntegerPropertyEditor
This class implements a property editor which does normal integer
parsing, but also check for 'true' treating it as 1 and 'false" as 0.
|
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
CLASS_VERSION
Class version string
|
static int |
STATE_CONFIG_ERROR |
static int |
STATE_DB_ERROR |
static int |
STATE_INVALID |
static int |
STATE_NOTSET
The constants that define the different states the form handler
can be in
|
static int |
STATE_VALID |
PARAM_DEFER_FORWARD_OR_REDIRECT, PARAM_USE_FORWARDS
SERVICE_INFO_KEY
DEFAULT_LOG_TRACE_STATUS
DEFAULT_LOG_DEBUG_STATUS, DEFAULT_LOG_ERROR_STATUS, DEFAULT_LOG_INFO_STATUS, DEFAULT_LOG_WARNING_STATUS
Constructor and Description |
---|
SimpleSQLFormHandler() |
Modifier and Type | Method and Description |
---|---|
void |
beforeGet(DynamoHttpServletRequest request,
DynamoHttpServletResponse response)
Before any form values are gotten, make sure we set any key
values.
|
boolean |
beforeSet(DynamoHttpServletRequest request,
DynamoHttpServletResponse response)
Before set process any form values, make sure our key columns
are set from the mapping specified.
|
java.lang.String[] |
getAllColumns() |
boolean |
getAutoLookup() |
java.lang.String[] |
getColumns() |
java.lang.String |
getConnectionURL() |
javax.sql.DataSource |
getDataSource() |
java.lang.String |
getDBErrorURL() |
java.lang.String |
getDeleteErrorURL() |
java.lang.String |
getDeleteSuccessURL() |
java.util.Properties |
getInitKeyColumnMap() |
java.lang.String |
getInsertErrorURL() |
java.lang.String |
getInsertSuccessURL() |
java.lang.String[] |
getKeyColumns()
Returns the list of columns used as keys to determine what row to edit.
|
java.lang.String |
getLookupErrorURL() |
java.lang.String |
getLookupSuccessURL() |
java.lang.String |
getMetaDataCatalogName()
Get the catalog name
|
java.lang.String |
getMetaDataSchemaPattern()
Get the schema name pattern.
|
protected java.lang.String |
getQualifiedTableName()
A convenience method to set and retrieve the qualified table name:
tablePrefix+tableName.
|
int |
getState() |
java.lang.String |
getTableName() |
java.lang.String |
getTablePrefix()
Returns property TablePrefix
|
javax.transaction.TransactionManager |
getTransactionManager() |
java.lang.String |
getUpdateErrorURL() |
java.lang.String |
getUpdateSuccessURL() |
boolean |
getUseDataSource() |
boolean |
getValid()
Returns the value of the read-only valid property.
|
java.util.Dictionary |
getValue()
Returns a dictionary of values that represent the state of the
current row in the database.
|
boolean |
handleDelete(DynamoHttpServletRequest pRequest,
DynamoHttpServletResponse pResponse) |
boolean |
handleInsert(DynamoHttpServletRequest pRequest,
DynamoHttpServletResponse pResponse) |
boolean |
handleLookup(DynamoHttpServletRequest pRequest,
DynamoHttpServletResponse pResponse) |
boolean |
handleReset(DynamoHttpServletRequest pRequest,
DynamoHttpServletResponse pResponse)
This resets the state of the form handler component, clearing out
the values of any properties and setting the state to STATE_NOTSET.
|
boolean |
handleUpdate(DynamoHttpServletRequest pRequest,
DynamoHttpServletResponse pResponse) |
void |
setAutoLookup(boolean pAutoLookup)
Sets the property AutoLookup.
|
void |
setColumns(java.lang.String[] pColumns)
Sets the value of the columns property.
|
void |
setConnectionURL(java.lang.String pConnectionURL)
Sets the property ConnectionURL.
|
void |
setDataSource(javax.sql.DataSource pDataSource)
Sets the DataSource
|
void |
setDBErrorURL(java.lang.String pDBErrorURL)
Sets the property DBErrorURL.
|
void |
setDeleteErrorURL(java.lang.String pDeleteErrorURL)
Sets the property DeleteErrorURL.
|
void |
setDeleteSuccessURL(java.lang.String pDeleteSuccessURL)
Sets the property DeleteSuccessURL.
|
void |
setInitKeyColumnMap(java.util.Properties pInitKeyColumnMap)
Sets the property InitKeyColumnMap.
|
void |
setInsertErrorURL(java.lang.String pInsertErrorURL)
Sets the property InsertErrorURL.
|
void |
setInsertSuccessURL(java.lang.String pInsertSuccessURL)
Sets the property InsertSuccessURL.
|
void |
setKeyColumns(java.lang.String[] pKeyColumns)
Sets the keyColumns property
|
void |
setLookupErrorURL(java.lang.String pLookupErrorURL)
Sets the property LookupErrorURL.
|
void |
setLookupSuccessURL(java.lang.String pLookupSuccessURL)
Sets the property LookupSuccessURL.
|
void |
setMetaDataCatalogName(java.lang.String pMetaDataCatalogName)
The name of a catalog, used internally only for a
DatabaseMetaData.getColumns() call.
|
void |
setMetaDataSchemaPattern(java.lang.String pMetaDataSchemaPattern)
Set a string representing a schema name pattern, used internally only
for a DatabaseMetaData.getColumns() call.
|
void |
setTableName(java.lang.String pTableName)
Sets the value of the tableName property.
|
void |
setTablePrefix(java.lang.String pTablePrefix)
Sets a String to be prepended as-is to the table name (tableName).
|
void |
setTransactionManager(javax.transaction.TransactionManager pTransactionManager)
Sets the TransactionManager
|
void |
setUpdateErrorURL(java.lang.String pUpdateErrorURL)
Sets the property UpdateErrorURL.
|
void |
setUpdateSuccessURL(java.lang.String pUpdateSuccessURL)
Sets the property UpdateSuccessURL.
|
void |
setUseDataSource(boolean pUseDataSource)
Sets the property UseDataSource
|
addFormException, addUncheckedFormException, afterSet, checkFormRedirect, createFormSubmissionMessage, getCancelURL, getCheckForValidSession, getFormError, getFormExceptions, getFormName, getMessagePort, getMessageSource, getMessageType, getPropertyExceptions, getSendMessages, getUncheckedFormExceptions, handleCancel, handleFormException, handleUncheckedFormException, hasUncheckedFormExceptions, isDeferForwardsAndRedirects, isRestorableForm, isUseForwards, isValidSession, redirectOrForward, resetFormExceptions, setCancelURL, setCheckForValidSession, setDeferForwardsAndRedirects, setFormName, setMessagePort, setMessageSource, setMessageType, setRestorableForm, setSendMessages, setUseForwards
afterGet
addLogListener, createAdminServlet, doStartService, doStopService, getAbsoluteName, getAdminServlet, getAdminServletOutputStreamEncoding, getLoggingForVlogging, getLogListenerCount, getLogListeners, getName, getNameContext, getNucleus, getRoot, getServiceConfiguration, getServiceInfo, isAdminServletUseServletOutputStream, isLoggingDebug, isLoggingError, isLoggingInfo, isLoggingTrace, isLoggingWarning, isRunning, logDebug, logDebug, logDebug, logError, logError, logError, logInfo, logInfo, logInfo, logTrace, logTrace, logTrace, logWarning, logWarning, logWarning, nameContextElementBound, nameContextElementUnbound, removeLogListener, reResolveThis, resolveName, resolveName, resolveName, resolveName, sendLogEvent, setAdminServletOutputStreamEncoding, setAdminServletUseServletOutputStream, setLoggingDebug, setLoggingError, setLoggingInfo, setLoggingTrace, setLoggingWarning, setNucleus, setServiceInfo, startService, stopService
vlogDebug, vlogDebug, vlogDebug, vlogDebug, vlogDebugTrace, vlogError, vlogError, vlogError, vlogError, vlogInfo, vlogInfo, vlogInfo, vlogInfo, vlogTrace, vlogTrace, vlogTrace, vlogTrace, vlogWarning, vlogWarning, vlogWarning, vlogWarning
public static java.lang.String CLASS_VERSION
public static final int STATE_NOTSET
public static final int STATE_INVALID
public static final int STATE_VALID
public static final int STATE_CONFIG_ERROR
public static final int STATE_DB_ERROR
public java.lang.String[] getKeyColumns()
public void setKeyColumns(java.lang.String[] pKeyColumns)
public void setConnectionURL(java.lang.String pConnectionURL)
public java.lang.String getConnectionURL()
public java.lang.String[] getColumns()
public void setColumns(java.lang.String[] pColumns)
public java.lang.String[] getAllColumns()
public java.lang.String getTableName()
public void setTableName(java.lang.String pTableName)
public java.util.Dictionary getValue()
public void setAutoLookup(boolean pAutoLookup)
value
.public boolean getAutoLookup()
public void setInitKeyColumnMap(java.util.Properties pInitKeyColumnMap)
myKeyName=/OriginatingRequest.myParamName
where myKeyName
is the name of an entry in your keyColumns
list and myParamName
is the name of a parameter in the
current request.
The key values are set in the beforeSet and/or beforeGet methods as called by the droplets system for form submission and form rendering respectively.
public java.util.Properties getInitKeyColumnMap()
public void setLookupSuccessURL(java.lang.String pLookupSuccessURL)
public java.lang.String getLookupSuccessURL()
public void setUpdateSuccessURL(java.lang.String pUpdateSuccessURL)
public java.lang.String getUpdateSuccessURL()
public void setDeleteSuccessURL(java.lang.String pDeleteSuccessURL)
public java.lang.String getDeleteSuccessURL()
public void setInsertSuccessURL(java.lang.String pInsertSuccessURL)
public java.lang.String getInsertSuccessURL()
public void setLookupErrorURL(java.lang.String pLookupErrorURL)
public java.lang.String getLookupErrorURL()
public void setUpdateErrorURL(java.lang.String pUpdateErrorURL)
public java.lang.String getUpdateErrorURL()
public void setDeleteErrorURL(java.lang.String pDeleteErrorURL)
public java.lang.String getDeleteErrorURL()
public void setInsertErrorURL(java.lang.String pInsertErrorURL)
public java.lang.String getInsertErrorURL()
public void setDBErrorURL(java.lang.String pDBErrorURL)
public java.lang.String getDBErrorURL()
public void setUseDataSource(boolean pUseDataSource)
public boolean getUseDataSource()
public void setDataSource(javax.sql.DataSource pDataSource)
public javax.sql.DataSource getDataSource()
public void setTransactionManager(javax.transaction.TransactionManager pTransactionManager)
public javax.transaction.TransactionManager getTransactionManager()
public void setMetaDataCatalogName(java.lang.String pMetaDataCatalogName)
String
- the name of a catalogDatabaseMetaData
public java.lang.String getMetaDataCatalogName()
public void setMetaDataSchemaPattern(java.lang.String pMetaDataSchemaPattern)
String
- the schema nameDatabaseMetaData
public java.lang.String getMetaDataSchemaPattern()
public void setTablePrefix(java.lang.String pTablePrefix)
metaDataSchemaPattern=adm
tablePrefix=adm.
String
- the prefix to be prepended to tableNamepublic java.lang.String getTablePrefix()
protected java.lang.String getQualifiedTableName()
public boolean beforeSet(DynamoHttpServletRequest request, DynamoHttpServletResponse response) throws DropletFormException
beforeSet
in interface DropletFormHandler
beforeSet
in class GenericFormHandler
DropletFormException
public void beforeGet(DynamoHttpServletRequest request, DynamoHttpServletResponse response)
beforeGet
in interface DropletFormHandler
beforeGet
in class EmptyFormHandler
public boolean handleLookup(DynamoHttpServletRequest pRequest, DynamoHttpServletResponse pResponse) throws javax.servlet.ServletException, java.io.IOException
javax.servlet.ServletException
java.io.IOException
public boolean handleDelete(DynamoHttpServletRequest pRequest, DynamoHttpServletResponse pResponse) throws javax.servlet.ServletException, java.io.IOException
javax.servlet.ServletException
java.io.IOException
public boolean handleUpdate(DynamoHttpServletRequest pRequest, DynamoHttpServletResponse pResponse) throws javax.servlet.ServletException, java.io.IOException
javax.servlet.ServletException
java.io.IOException
public boolean handleInsert(DynamoHttpServletRequest pRequest, DynamoHttpServletResponse pResponse) throws javax.servlet.ServletException, java.io.IOException
javax.servlet.ServletException
java.io.IOException
public boolean handleReset(DynamoHttpServletRequest pRequest, DynamoHttpServletResponse pResponse) throws javax.servlet.ServletException, java.io.IOException
javax.servlet.ServletException
java.io.IOException
public int getState()
public boolean getValid()