Class SQLQuery

java.lang.Object
net.sf.saxon.tree.NodeImpl
net.sf.saxon.tree.ParentNodeImpl
net.sf.saxon.tree.ElementImpl
net.sf.saxon.tree.ElementWithAttributes
net.sf.saxon.style.StyleElement
net.sf.saxon.style.ExtensionInstruction
net.sf.saxon.sql.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