org.dbforms.taglib
Class QueryData

java.lang.Object
  javax.servlet.jsp.tagext.TagSupport
      javax.servlet.jsp.tagext.BodyTagSupport
          org.dbforms.taglib.TagSupportWithScriptHandler
              org.dbforms.taglib.DbBaseHandlerTag
                  org.dbforms.taglib.EmbeddedData
                      org.dbforms.taglib.QueryData

All Implemented Interfaces:

Serializable, javax.servlet.jsp.tagext.BodyTag, javax.servlet.jsp.tagext.IterationTag, javax.servlet.jsp.tagext.Tag, javax.servlet.jsp.tagext.TryCatchFinally, StaticDataAddInterface

public class QueryData
extends EmbeddedData
implements javax.servlet.jsp.tagext.TryCatchFinally

external data to be nested into radio, checkbox or select - tag! (useful only in conjunction with radio, checkbox or select - tag)

this tag provides data to radio, checkbox or select - tags. it may be used for cross-references to other tables.

this tag provides similar functionlaity to "TabData", but as it allows to formulate free querys including all SQL statements your RDBMS supports you have much more flexibility using this tag.

query building convention: first column is the "key" column for the radio/check/select elements, all other colums are just "data" columns visible to the user example: SELECT DISTINCT customer.id, customer.name, customer.adress, debitors.debit FROM customer INNER JOIN id ON (SELECT id FROM debitors WHERE debit>100000) ORDER BY debit DESC

- "id" will be threaten as key-value in select box, "name and address will be shown in select box

Author:

Joachim Peer

See Also:

Serialized Form

Field Summary

Fields inherited from class javax.servlet.jsp.tagext.BodyTagSupport

bodyContent

Fields inherited from class javax.servlet.jsp.tagext.TagSupport

id, pageContext

Fields inherited from interface javax.servlet.jsp.tagext.BodyTag

EVAL_BODY_BUFFERED, EVAL_BODY_TAG

Fields inherited from interface javax.servlet.jsp.tagext.IterationTag

EVAL_BODY_AGAIN

Fields inherited from interface javax.servlet.jsp.tagext.Tag

EVAL_BODY_INCLUDE, EVAL_PAGE, SKIP_BODY, SKIP_PAGE

Constructor Summary

QueryData()

Method Summary

void	doCatch(Throwable t)
void	doFinally() DOCUMENT ME!
protected List	fetchData(Connection con) returns Hashtable with data.
String	getQuery() DOCUMENT ME!
void	setQuery(String query) DOCUMENT ME!

Methods inherited from class org.dbforms.taglib.EmbeddedData

addElement, doStartTag, formatEmbeddedResultRows, getDbConnectionName, getDisableCache, getEscaper, getFormatClass, getName, setDbConnectionName, setDisableCache, setFormat, setFormatClass, setName, useCache

Methods inherited from class org.dbforms.taglib.DbBaseHandlerTag

customFormat, escapeHTML, getCustomFormatter, getDefaultValue, getEscaperClass, getField, getFieldObject, getFieldValue, getFormattedFieldValue, getFormatter, getFormFieldDefaultValue, getFormFieldName, getFormFieldValue, getLocale, getMaxlength, getOverrideFormFieldName, getParentForm, getPattern, getReadOnlyStyleClass, getStyleClass, hasOverrideFormFieldNameSet, hasReadOnlySet, renderOldValueHtmlInputField, renderPatternHtmlInputField, setCustomFormatter, setDefaultValue, setEscaperClass, setField, setFieldName, setMaxlength, setNullFieldValue, setOverrideFormFieldName, setParent, setPattern, setReadOnly, setReadOnlyStyleClass, typicalDefaultValue, writeOutSpecialValues

Methods inherited from class org.dbforms.taglib.TagSupportWithScriptHandler

getAccessKey, getConfig, getOnBlur, getOnChange, getOnClick, getOnDblClick, getOnFocus, getOnKeyDown, getOnKeyPress, getOnKeyUp, getOnMouseDown, getOnMouseMove, getOnMouseOut, getOnMouseOver, getOnMouseUp, getOnSelect, getStyle, getTabIndex, getTitle, prepareEventHandlers, prepareStyles, setAccessKey, setOnBlur, setOnChange, setOnClick, setOnDblClick, setOnFocus, setOnKeyDown, setOnKeyPress, setOnKeyUp, setOnMouseDown, setOnMouseMove, setOnMouseOut, setOnMouseOver, setOnMouseUp, setOnSelect, setStyle, setStyleClass, setTabIndex, setTitle

Methods inherited from class javax.servlet.jsp.tagext.BodyTagSupport

doAfterBody, doEndTag, doInitBody, getBodyContent, getPreviousOut, release, setBodyContent

Methods inherited from class javax.servlet.jsp.tagext.TagSupport

findAncestorWithClass, getId, getParent, getValue, getValues, removeValue, setId, setPageContext, setValue

Methods inherited from class java.lang.Object

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

Methods inherited from interface javax.servlet.jsp.tagext.Tag

getParent, setPageContext

Constructor Detail

QueryData

public QueryData()

Method Detail

setQuery

public void setQuery(String query)

DOCUMENT ME!

Parameters:

query - DOCUMENT ME!

getQuery

public String getQuery()

DOCUMENT ME!

Returns:

DOCUMENT ME!

doCatch

public void doCatch(Throwable t)
             throws Throwable

Specified by:

doCatch in interface javax.servlet.jsp.tagext.TryCatchFinally

Overrides:

doCatch in class EmbeddedData

Throws:

Throwable

See Also:

TryCatchFinally.doCatch(java.lang.Throwable)

doFinally

public void doFinally()

DOCUMENT ME!

Specified by:

doFinally in interface javax.servlet.jsp.tagext.TryCatchFinally

Overrides:

doFinally in class EmbeddedData

See Also:

TryCatchFinally.doFinally()

fetchData

protected List fetchData(Connection con)
                  throws SQLException

returns Hashtable with data. Its keys represent the "value"-fields for the DataContainer-Tag, its values represent the visible fields for the Multitags. (DataContainer are: select, radio, checkbox and a special flavour of Label).

Specified by:

fetchData in class EmbeddedData

Parameters:

con - DOCUMENT ME!

Returns:

DOCUMENT ME!

Throws:

SQLException