// <?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="xml" indent="yes"/> 
  <xsl:param name="query" select= ""/>
  <xsl:param name="mynowtime" select= ""/> 
  <xsl:template match="/">
    <xsl:variable name="db" select="sql:new()"/>
    <!-- Connect to the database with minimal error detection -->
    <xsl:if test="not(sql:connect($db, 'mypbdspool'))" >
      <xsl:message>Error Connecting to the Database</xsl:message>
      <xsl:copy-of select="sql:getError($db)/ext-error" />
    </xsl:if>
    <xsl:value-of select="sql:disableStreamingMode($db)" />
    <realtime_data>
      <xsl:variable name="table" select='sql:query($db, $query)'/>      
      <!--Let's include Error Checking, the error is actually stored in the connection since $table will be either data or null-->        
      <xsl:if test="not($table)" >
        <xsl:message>Error in Query</xsl:message>
	<xsl:copy-of select="sql:getError($db)/ext-error" />
	<read>1</read>
      </xsl:if>
      <xsl:if test="($table)" >
	<read>0</read>
      </xsl:if>
      <updatetime><xsl:value-of select="$mynowtime"/></updatetime>   
      <xsl:apply-templates select="$table/sql/row-set/row"/>
    </realtime_data>
    <xsl:value-of select="sql:close($db)"/>
  </xsl:template>	
  <xsl:template match="row">
    <unit_data><xsl:apply-templates select="col"/></unit_data>
  </xsl:template>	
  <xsl:template match="col">
    <xsl:variable name="colname" select="@column-label"/>
    <xsl:element name="{$colname}"><xsl:value-of select="text()"/></xsl:element>
  </xsl:template>  
</xsl:stylesheet>在此输入java代码

// 在此输入java代码

// 在此输入java代码