nl.gx.webmanager.handler.forms.handling
Class QueryToSessionHandler

java.lang.Object
  nl.gx.webmanager.handler.forms.foundation.FormHandlerBase
      nl.gx.webmanager.handler.forms.handling.QueryToSessionHandler

All Implemented Interfaces:

FormComponent, Handler

public class QueryToSessionHandler
extends FormHandlerBase
implements Handler

This handler executes a query and stores the resultset as XML in the session.

Variable	Type	Mode	Default	Description
query	Parameter	Required	-	The query that should be executed.
formpartcode	Multiple Parameter	Optional	-	The formpart codes for which the form values should be set as arguments for the query. May contain XSLT.
sessionkey	Parameter	Optional	-	The key in the session for storing the resulting XML.
key	Parameter	Optional	-	The key in the global values for storing the resulting XML.
tupletag	Parameter	Optional	-	The tag that will be added for each record in the resultset.
sqlexceptionmessage	Parameter	Optional	""	This exception message will be shown in the session together with the code 'sql_exception'.
connectionname	Parameter	Required	-	The name of the data source that will be used for executing the query.

Example usage:

• Fields of interest.

Field Summary

Fields inherited from class nl.gx.webmanager.handler.forms.foundation.FormHandlerBase

DEFAULT_STATEMENT_TIMEOUT, log, staticlog

Constructor Summary

QueryToSessionHandler()

Method Summary

void	doHandle(FormDefinition form, State formState, javax.servlet.http.HttpServletRequest req, javax.servlet.http.HttpServletResponse res) Processes the form.
void	init(FormComponentConfig c) Passes the initialization parameters to the component.

Methods inherited from class nl.gx.webmanager.handler.forms.foundation.FormHandlerBase

close, close, close, executeInsertWithIdentityMSSQLMYSQL, executeInsertWithIdentityOracle, executeIntegerQuery, executeIntegerQuery, executeIntegersQuery, executeIntegersQuery, executeQuery, executeStringQuery, executeUpdate, fillValues, getDataSource, setArguments, setArguments

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

QueryToSessionHandler

public QueryToSessionHandler()

Method Detail

init

public void init(FormComponentConfig c)
          throws InitializationException

Description copied from interface: FormComponent

Passes the initialization parameters to the component.

Specified by:

init in interface FormComponent

Parameters:

c - The FormComponentConfig object that contains configutation information for this component.

Throws:

InitializationException - If initialization failed

doHandle

public void doHandle(FormDefinition form,
                     State formState,
                     javax.servlet.http.HttpServletRequest req,
                     javax.servlet.http.HttpServletResponse res)
              throws HandleException

Description copied from interface: Handler

Processes the form.

Specified by:

doHandle in interface Handler

Parameters:

form - The definition of the form for which the submitted values should be handled.

formState - The session values for the form

req - The http request

res - The http response

Throws:

HandleException - If the form values could not be handled correctly