Class SQLQuery

All Implemented Interfaces:
Source, SourceLocator, LocationProvider, SaxonLocator, Container, FingerprintedNode, Item, NodeInfo, ValueRepresentation, InstructionInfo, Locator

public class SQLQuery extends ExtensionInstruction
An sql:query element in the stylesheet.

For example:

   <sql:query column="{$column}" table="{$table}" where="{$where}"
                 xsl:extension-element-prefixes="sql"/ >
 

(result with HTML-table-output)
   <sql:query column="{$column}" table="{$table}" where="{$where}"
                 row-tag="TR" column-tag="TD"
                 separatorType="tag"
                 xsl:extension-element-prefixes="sql"/ >
 
Author:
claudio.thomas@unix-ag.org (based on Michael Kay's SQLInsert.java)
  • Field Details

    • connection

      Expression connection
    • column

      Expression column
      selected column(s) to query
    • table

      Expression table
      the table(s) to query in
    • where

      Expression where
      conditions of query (can be omitted)
    • rowTag

      String rowTag
    • colTag

      String colTag
      name of element to hold the rows
    • disable

      boolean disable
      name of element to hold the columns
  • Constructor Details

    • SQLQuery

      public SQLQuery()
  • Method Details

    • prepareAttributes

      public void prepareAttributes() throws XPathException
      Description copied from class: StyleElement
      Set the attribute list for the element. This is called to process the attributes (note the distinction from processAttributes in the superclass). Must be supplied in a subclass
      Specified by:
      prepareAttributes in class StyleElement
      Throws:
      XPathException
    • validate

      public void validate() throws XPathException
      Description copied from class: StyleElement
      Check that the stylesheet element is valid. This is called once for each element, after the entire tree has been built. As well as validation, it can perform first-time initialisation. The default implementation does nothing; it is normally overriden in subclasses.
      Overrides:
      validate in class ExtensionInstruction
      Throws:
      XPathException
    • compile

      public Expression compile(Executable exec) throws XPathException
      Description copied from class: StyleElement
      Compile the instruction on the stylesheet tree into an executable instruction for use at run-time.
      Specified by:
      compile in class StyleElement
      Returns:
      either a ComputedExpression, or null. The value null is returned when compiling an instruction that returns a no-op, or when compiling a top-level object such as an xsl:template that compiles into something other than an instruction.
      Throws:
      XPathException