Package net.sf.saxon.sql

Class SQLQuery

  • All Implemented Interfaces:
    javax.xml.transform.Source, javax.xml.transform.SourceLocator, LocationProvider, SaxonLocator, Container, FingerprintedNode, Item, NodeInfo, ValueRepresentation, InstructionInfo, org.xml.sax.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 Detail

      • column

        Expression column
        selected column(s) to query

      • where

        Expression where
        conditions of query (can be omitted)

      • rowTag

        java.lang.String rowTag

      • colTag

        java.lang.String colTag
        name of element to hold the rows

      • disable

        boolean disable
        name of element to hold the columns

    • Constructor Detail

      • SQLQuery

        public SQLQuery()

    • Method Detail

      • 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