com.ora.jsp.tags.sql
Class QueryTag

java.lang.Object
  |
  +--javax.servlet.jsp.tagext.TagSupport
        |
        +--javax.servlet.jsp.tagext.BodyTagSupport
              |
              +--com.ora.jsp.tags.sql.DBTag
                    |
                    +--com.ora.jsp.tags.sql.QueryTag
All Implemented Interfaces:
javax.servlet.jsp.tagext.BodyTag, java.io.Serializable, javax.servlet.jsp.tagext.Tag, ValueTagParent

public class QueryTag
extends DBTag

This class is a custom action for executing a SQL SELECT statement. The statement must be defined in the body of the action. It can contain ? place holders, replaced by the value of elements before execution. The number and order of place holders must match the number and order of elements in the body.

Version:
1.0
Author:
Hans Bergsten, Gefion software
See Also:
Serialized Form

Fields inherited from class com.ora.jsp.tags.sql.DBTag
dataSourceName, id, isExceptionThrown, isPartOfTransaction, scope, sqlCommandBean, sqlValue, values
 
Fields inherited from class javax.servlet.jsp.tagext.BodyTagSupport
bodyContent
 
Fields inherited from class javax.servlet.jsp.tagext.TagSupport
pageContext, parent
 
Fields inherited from interface javax.servlet.jsp.tagext.BodyTag
EVAL_BODY_TAG
 
Fields inherited from interface javax.servlet.jsp.tagext.Tag
EVAL_BODY_INCLUDE, EVAL_PAGE, SKIP_BODY, SKIP_PAGE
 
Constructor Summary
QueryTag()
           
 
Method Summary
 java.lang.Object execute(SQLCommandBean sqlCommandBean)
          Executes the SQL command as a query and returns a Vector with Row objects.
 
Methods inherited from class com.ora.jsp.tags.sql.DBTag
addValue, doAfterBody, doEndTag, doStartTag, getConnection, release, setDataSource, setId, setScope
 
Methods inherited from class javax.servlet.jsp.tagext.BodyTagSupport
doInitBody, getBodyContent, getPreviousOut, setBodyContent
 
Methods inherited from class javax.servlet.jsp.tagext.TagSupport
findAncestorWithClass, getId, getParent, getValue, getValues, removeValue, setPageContext, setParent, setValue
 
Methods inherited from class java.lang.Object
, clone, equals, finalize, getClass, hashCode, notify, notifyAll, registerNatives, toString, wait, wait, wait
 
Methods inherited from interface javax.servlet.jsp.tagext.Tag
getParent, setPageContext, setParent
 

Constructor Detail

QueryTag

public QueryTag()
Method Detail

execute

public java.lang.Object execute(SQLCommandBean sqlCommandBean)
                         throws java.sql.SQLException,
                                UnsupportedTypeException
Executes the SQL command as a query and returns a Vector with Row objects.
Overrides:
execute in class DBTag
Parameters:
sqlCommandBean - the SQL command to execute
Returns:
a Vector with Row objects