| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
|
| <!--NewPage-->
|
| <HTML>
|
| <HEAD>
|
| <!-- Generated by javadoc on Thu Nov 22 17:12:52 EST 2007 -->
|
| <TITLE>
|
| Xalan-Java 2.7.1: Package org.apache.xalan.lib.sql
|
| </TITLE>
|
| <LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../../stylesheet.css" TITLE="Style">
|
| </HEAD>
|
| <BODY BGCOLOR="white">
|
|
|
| <!-- ========== START OF NAVBAR ========== -->
|
| <A NAME="navbar_top"><!-- --></A> |
| <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0">
|
| <TR>
|
| <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
|
| <A NAME="navbar_top_firstrow"><!-- --></A> |
| <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3">
|
| <TR ALIGN="center" VALIGN="top">
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD>
|
| <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Package</B></FONT> </TD>
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <FONT CLASS="NavBarFont1">Class</FONT> </TD>
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-use.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD>
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD>
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD>
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD>
|
| </TR>
|
| </TABLE>
|
| </TD>
|
| <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
|
| </EM>
|
| </TD>
|
| </TR>
|
|
|
| <TR>
|
| <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
|
| <A HREF="../../../../../org/apache/xalan/lib/package-summary.html"><B>PREV PACKAGE</B></A>
|
| <A HREF="../../../../../org/apache/xalan/processor/package-summary.html"><B>NEXT PACKAGE</B></A></FONT></TD>
|
| <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
|
| <A HREF="../../../../../index.html" TARGET="_top"><B>FRAMES</B></A>
|
| <A HREF="package-summary.html" TARGET="_top"><B>NO FRAMES</B></A></FONT></TD>
|
| </TR>
|
| </TABLE>
|
| <!-- =========== END OF NAVBAR =========== -->
|
|
|
| <HR>
|
| <H2>
|
| Package org.apache.xalan.lib.sql
|
| </H2>
|
| Provides extension functions for connecting to a JDBC data source, executing a query,
|
| and working incrementally through a "streamable" result set.
|
| <P>
|
| <B>See: </B>
|
| <BR>
|
| <A HREF="#package_description"><B>Description</B></A>
|
| <P>
|
| |
| <TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%">
|
| <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
|
| <TD COLSPAN=2><FONT SIZE="+2">
|
| <B>Interface Summary</B></FONT></TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="ConnectionPool.html"><I>ConnectionPool</I></A></B></TD>
|
| <TD>An interface used to build wrapper classes around existing |
| Connection Pool libraries.</TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="DTMDocument.CharacterNodeHandler.html"><I>DTMDocument.CharacterNodeHandler</I></A></B></TD>
|
| <TD> </TD>
|
| </TR>
|
| </TABLE>
|
|
|
|
|
| <P>
|
| |
| <TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%">
|
| <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
|
| <TD COLSPAN=2><FONT SIZE="+2">
|
| <B>Class Summary</B></FONT></TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="ConnectionPoolManager.html">ConnectionPoolManager</A></B></TD>
|
| <TD> </TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="DefaultConnectionPool.html">DefaultConnectionPool</A></B></TD>
|
| <TD>For internal connectiones, i.e.</TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="DTMDocument.html">DTMDocument</A></B></TD>
|
| <TD>The SQL Document is the main controlling class the executesa SQL Query</TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="JNDIConnectionPool.html">JNDIConnectionPool</A></B></TD>
|
| <TD>A Connection Pool that wraps a JDBC datasource to provide connections.</TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="ObjectArray.html">ObjectArray</A></B></TD>
|
| <TD>Provide a simple Array storage mechinsim where native Arrays will be use as |
| the basic storage mechinism but the Arrays will be stored as blocks.</TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="PooledConnection.html">PooledConnection</A></B></TD>
|
| <TD> </TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="QueryParameter.html">QueryParameter</A></B></TD>
|
| <TD> </TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="SQLDocument.html">SQLDocument</A></B></TD>
|
| <TD>The SQL Document is the main controlling class the executesa SQL Query</TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="SQLErrorDocument.html">SQLErrorDocument</A></B></TD>
|
| <TD>The SQL Document is the main controlling class the executesa SQL Query</TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="SQLQueryParser.html">SQLQueryParser</A></B></TD>
|
| <TD> </TD>
|
| </TR>
|
| <TR BGCOLOR="white" CLASS="TableRowColor">
|
| <TD WIDTH="15%"><B><A HREF="XConnection.html">XConnection</A></B></TD>
|
| <TD>An XSLT extension that allows a stylesheet to |
| access JDBC data.</TD>
|
| </TR>
|
| </TABLE>
|
|
|
|
|
| <P>
|
| <A NAME="package_description"><!-- --></A><H2>
|
| Package org.apache.xalan.lib.sql Description
|
| </H2>
|
|
|
| <P>
|
| <p>Provides extension functions for connecting to a JDBC data source, executing a query,
|
| and working incrementally through a "streamable" result set. Streaming (reuse of a single row node to traverse the result set) is the default mode of operation. If you want unlimited access to the entire result set, you can cache the query result set (1 row node for each row in the result set).</p>
|
| <p><em>If you use streaming mode (the default), you can only access row elements one at a time moving forward through the result set. The use of XPath expressions in your stylesheet, for example, that attempt to return nodes from the result set in any other manner may produce unpredictable results.</em></p>
|
| <p>XConnection provides three extension functions that you can use in your stylesheet.</p>
|
| <ol>
|
| <li><p>new() -- Use one of the XConnection constructors to connect to a data source, and return an XConnection
|
| object.</p></li>
|
| <li><p>query() -- Use the XConnection object query() method to return a "streamable" result set in the form of a row-set
|
| node. Work your way through the row-set one row at a time. The same row element is used over and over again, so you can
|
| begin "transforming" the row-set before the entire result set has been returned.</p></li>
|
| <li>close() -- Use the XConnection object close() method to terminate the connection.</li>
|
| </ol>
|
| <p>The query() extension function returns a Document node that contains (as needed) an array of column-header elements,
|
| a single row element that is used repeatedly, and an array of col elements. Each column-header element (one per column in the
|
| row-set) contains an attribute (ColumnAttribute) for each of the column descriptors in the ResultSetMetaData object.
|
| Each col element contains a text node with a textual representation of the value for that column in the current row.</p>
|
| <h2>Example</h2>
|
| <p>This example displays the result set from a table in a sample InstantDB database.</p>
|
| <pre><?xml version="1.0"?>
|
| <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
|
| version="1.0"
|
| xmlns:sql="org.apache.xalan.lib.sql.XConnection"
|
| extension-element-prefixes="sql">
|
| <xsl:output method="html" indent="yes"/>
|
| <xsl:param name="query" select="'SELECT * FROM import1'"/>
|
|
|
| <xsl:template match="/">
|
| <!-- 1. Make the connection -->
|
| <xsl:variable name="products"
|
| select="sql:new('org.enhydra.instantdb.jdbc.idbDriver',
|
| 'jdbc:idb:D:\instantdb\Examples\sample.prp')"/>
|
| <HTML>
|
| <HEAD>
|
| </HEAD>
|
| <BODY>
|
| <TABLE border="1">
|
| <!--2. Execute the query -->
|
| <xsl:variable name="table" select='sql:query($products, $query)'/>
|
| <TR>
|
| <!-- Get column-label attribute from each column-header-->
|
| <xsl:for-each select="$table/sql/metadata/column-header">
|
| <TH><xsl:value-of select="@column-label"/></TH>
|
| </xsl:for-each>
|
| </TR>
|
| <xsl:apply-templates select="$table/sql/row-set/row"/>
|
| <xsl:text>&#10;</xsl:text>
|
| </TABLE>
|
| </BODY>
|
| </HTML>
|
| <!-- 3. Close the connection -->
|
| <xsl:value-of select="sql:close($products)"/>
|
| </xsl:template>
|
|
|
| <xsl:template match="row">
|
| <TR>
|
| <xsl:apply-templates select="col"/>
|
| </TR>
|
| </xsl:template>
|
|
|
| <xsl:template match="col">
|
| <TD>
|
| <!-- Here is the column data -->
|
| <xsl:value-of select="text()"/>
|
| </TD>
|
| </xsl:template>
|
|
|
| </xsl:stylesheet>
|
| </pre>
|
| <P>
|
| <HR>
|
|
|
| <!-- ========== START OF NAVBAR ========== -->
|
| <A NAME="navbar_bottom"><!-- --></A> |
| <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0">
|
| <TR>
|
| <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
|
| <A NAME="navbar_bottom_firstrow"><!-- --></A> |
| <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3">
|
| <TR ALIGN="center" VALIGN="top">
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD>
|
| <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Package</B></FONT> </TD>
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <FONT CLASS="NavBarFont1">Class</FONT> </TD>
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-use.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD>
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD>
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD>
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD>
|
| <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD>
|
| </TR>
|
| </TABLE>
|
| </TD>
|
| <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
|
| </EM>
|
| </TD>
|
| </TR>
|
|
|
| <TR>
|
| <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
|
| <A HREF="../../../../../org/apache/xalan/lib/package-summary.html"><B>PREV PACKAGE</B></A>
|
| <A HREF="../../../../../org/apache/xalan/processor/package-summary.html"><B>NEXT PACKAGE</B></A></FONT></TD>
|
| <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
|
| <A HREF="../../../../../index.html" TARGET="_top"><B>FRAMES</B></A>
|
| <A HREF="package-summary.html" TARGET="_top"><B>NO FRAMES</B></A></FONT></TD>
|
| </TR>
|
| </TABLE>
|
| <!-- =========== END OF NAVBAR =========== -->
|
|
|
| <HR>
|
| Copyright © 2006 Apache XML Project. All Rights Reserved.
|
| </BODY>
|
| </HTML>
|
