defaultsqlbuilder.html

Geotools是一个开源的Java GIS工具包,可利用它来开发符合标准的地理信息系统。Geotools提供了OGC(Open Geospatial Consortium)规范的一个实现来作为他们的

</DL>
<HR>

<A NAME="splitFilter(org.geotools.filter.Filter)"><!-- --></A><H3>
splitFilter</H3>
<PRE>
protected void <B>splitFilter</B>(<A HREF="../../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A>&nbsp;filter)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="sqlFrom(java.lang.StringBuffer, java.lang.String)"><!-- --></A><H3>
sqlFrom</H3>
<PRE>
public void <B>sqlFrom</B>(<A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/StringBuffer.html" title="class or interface in java.lang">StringBuffer</A>&nbsp;sql,
                    <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A>&nbsp;typeName)</PRE>
<DL>
<DD>Constructs the FROM clause for a featureType
 
 <p>
 sql: <code>FROM typeName</code>
 </p>
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html#sqlFrom(java.lang.StringBuffer, java.lang.String)">sqlFrom</A></CODE> in interface <CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html" title="interface in org.geotools.data.jdbc">SQLBuilder</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sql</CODE> - the StringBuffer that the WHERE clause should be appended to<DD><CODE>typeName</CODE> - the name of the table (feature type) to be queried</DL>
</DD>
</DL>
<HR>

<A NAME="sqlWhere(java.lang.StringBuffer, org.geotools.filter.Filter)"><!-- --></A><H3>
sqlWhere</H3>
<PRE>
public void <B>sqlWhere</B>(<A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/StringBuffer.html" title="class or interface in java.lang">StringBuffer</A>&nbsp;sql,
                     <A HREF="../../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A>&nbsp;preFilter)
              throws <A HREF="../../../../org/geotools/filter/SQLEncoderException.html" title="class in org.geotools.filter">SQLEncoderException</A></PRE>
<DL>
<DD>Constructs WHERE clause, if needed, for FILTER.
 
 <p>
 sql: <code>WHERE filter encoding</code>
 </p>
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html#sqlWhere(java.lang.StringBuffer, org.geotools.filter.Filter)">sqlWhere</A></CODE> in interface <CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html" title="interface in org.geotools.data.jdbc">SQLBuilder</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sql</CODE> - The StringBuffer that the WHERE clause should be appended to<DD><CODE>preFilter</CODE> - The filter to be used by the encoder class to generate
        the WHERE clause
<DT><B>Throws:</B>
<DD><CODE><A HREF="../../../../org/geotools/filter/SQLEncoderException.html" title="class in org.geotools.filter">SQLEncoderException</A></CODE> - Not thrown here but may be thrown by the
         encoder</DL>
</DD>
</DL>
<HR>

<A NAME="buildSQLQuery(java.lang.String, org.geotools.data.jdbc.fidmapper.FIDMapper, org.geotools.feature.AttributeType[], org.geotools.filter.Filter)"><!-- --></A><H3>
buildSQLQuery</H3>
<PRE>
public <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A> <B>buildSQLQuery</B>(<A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A>&nbsp;typeName,
                            <A HREF="../../../../org/geotools/data/jdbc/fidmapper/FIDMapper.html" title="interface in org.geotools.data.jdbc.fidmapper">FIDMapper</A>&nbsp;mapper,
                            <A HREF="../../../../org/geotools/feature/AttributeType.html" title="interface in org.geotools.feature">AttributeType</A>[]&nbsp;attrTypes,
                            <A HREF="../../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A>&nbsp;filter)
                     throws <A HREF="../../../../org/geotools/filter/SQLEncoderException.html" title="class in org.geotools.filter">SQLEncoderException</A></PRE>
<DL>
<DD>Constructs the full SQL SELECT statement for the supplied Filter.
 
 <p>
 The statement is constructed by concatenating the SELECT column list,
 FROM table specification and WHERE clause appropriate to the supplied
 Filter.
 </p>
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html#buildSQLQuery(java.lang.String, org.geotools.data.jdbc.fidmapper.FIDMapper, org.geotools.feature.AttributeType[], org.geotools.filter.Filter)">buildSQLQuery</A></CODE> in interface <CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html" title="interface in org.geotools.data.jdbc">SQLBuilder</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>typeName</CODE> - The name of the table (feature type) to be queried<DD><CODE>mapper</CODE> - FIDMapper to identify the FID columns in the table<DD><CODE>attrTypes</CODE> - The specific attribute columns to be selected<DD><CODE>filter</CODE> - The Filter that will be used by the encoder to construct
        the WHERE clause
<DT><B>Returns:</B><DD>The fully formed SQL SELECT statement
<DT><B>Throws:</B>
<DD><CODE><A HREF="../../../../org/geotools/filter/SQLEncoderException.html" title="class in org.geotools.filter">SQLEncoderException</A></CODE> - Not thrown by this method but may be thrown
         by the encoder class</DL>
</DD>
</DL>
<HR>

<A NAME="sqlColumns(java.lang.StringBuffer, org.geotools.data.jdbc.fidmapper.FIDMapper, org.geotools.feature.AttributeType[])"><!-- --></A><H3>
sqlColumns</H3>
<PRE>
public void <B>sqlColumns</B>(<A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/StringBuffer.html" title="class or interface in java.lang">StringBuffer</A>&nbsp;sql,
                       <A HREF="../../../../org/geotools/data/jdbc/fidmapper/FIDMapper.html" title="interface in org.geotools.data.jdbc.fidmapper">FIDMapper</A>&nbsp;mapper,
                       <A HREF="../../../../org/geotools/feature/AttributeType.html" title="interface in org.geotools.feature">AttributeType</A>[]&nbsp;attributes)</PRE>
<DL>
<DD>Appends the names of the columns to be selected.
 
 <p>
 sqlGeometryColumn is invoked for any special handling for geometry
 columns.
 </p>
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html#sqlColumns(java.lang.StringBuffer, org.geotools.data.jdbc.fidmapper.FIDMapper, org.geotools.feature.AttributeType[])">sqlColumns</A></CODE> in interface <CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html" title="interface in org.geotools.data.jdbc">SQLBuilder</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sql</CODE> - StringBuffer to be appended to<DD><CODE>mapper</CODE> - FIDMapper to provide the name(s) of the FID columns<DD><CODE>attributes</CODE> - Array of columns to be selected<DT><B>See Also:</B><DD><CODE>postgisDataStore.SQLBuilder#sqlColumns(java.lang.StringBuffer,
      postgisDataStore.FIDMapper.FIDMapper,
      org.geotools.feature.AttributeType[])</CODE></DL>
</DD>
</DL>
<HR>

<A NAME="sqlGeometryColumn(java.lang.StringBuffer, org.geotools.feature.AttributeType)"><!-- --></A><H3>
sqlGeometryColumn</H3>
<PRE>
public void <B>sqlGeometryColumn</B>(<A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/StringBuffer.html" title="class or interface in java.lang">StringBuffer</A>&nbsp;sql,
                              <A HREF="../../../../org/geotools/feature/AttributeType.html" title="interface in org.geotools.feature">AttributeType</A>&nbsp;geomAttribute)</PRE>
<DL>
<DD>Generates the select column specification for a geometry column.
 
 <p>
 This should typically be overridden in the subclass to return a
 meaningful value that the attribute i/o handler can process.
 </p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sql</CODE> - A StringBuffer that the column specification can be appended
        to<DD><CODE>geomAttribute</CODE> - An AttributeType for a geometry attribute</DL>
</DD>
</DL>
<HR>

<A NAME="sqlOrderBy(java.lang.StringBuffer, org.opengis.filter.sort.SortBy[])"><!-- --></A><H3>
sqlOrderBy</H3>
<PRE>
public void <B>sqlOrderBy</B>(<A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/StringBuffer.html" title="class or interface in java.lang">StringBuffer</A>&nbsp;sql,
                       SortBy[]&nbsp;sortBy)
                throws <A HREF="../../../../org/geotools/filter/SQLEncoderException.html" title="class in org.geotools.filter">SQLEncoderException</A></PRE>
<DL>
<DD>Generates the order by clause.
 <p>
 This uses the standard ASC,DESC sql keywords to denote ascending,descending
 sort respectivley.
 </p>
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html#sqlOrderBy(java.lang.StringBuffer, org.opengis.filter.sort.SortBy[])">sqlOrderBy</A></CODE> in interface <CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html" title="interface in org.geotools.data.jdbc">SQLBuilder</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Throws:</B>
<DD><CODE><A HREF="../../../../org/geotools/filter/SQLEncoderException.html" title="class in org.geotools.filter">SQLEncoderException</A></CODE></DL>
</DD>
</DL>
<!-- ========= END OF CLASS DATA ========= -->
<HR>


<!-- ======= START OF BOTTOM NAVBAR ====== -->
<A NAME="navbar_bottom"><!-- --></A>
<A HREF="#skip-navbar_bottom" title="Skip navigation links"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=3 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_bottom_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="class-use/DefaultSQLBuilder.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;<A HREF="../../../../org/geotools/data/jdbc/ConnectionPoolManager.html" title="class in org.geotools.data.jdbc"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../../../org/geotools/data/jdbc/FeatureTypeHandler.html" title="class in org.geotools.data.jdbc"><B>NEXT CLASS</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../index.html" target="_top"><B>FRAMES</B></A>  &nbsp;
&nbsp;<A HREF="DefaultSQLBuilder.html" target="_top"><B>NO FRAMES</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="../../../../allclasses-noframe.html"><B>All Classes</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="../../../../allclasses-noframe.html"><B>All Classes</B></A>
</NOSCRIPT>

</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
  SUMMARY:&nbsp;NESTED&nbsp;|&nbsp;<A HREF="#field_summary">FIELD</A>&nbsp;|&nbsp;<A HREF="#constructor_summary">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_summary">METHOD</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
DETAIL:&nbsp;<A HREF="#field_detail">FIELD</A>&nbsp;|&nbsp;<A HREF="#constructor_detail">CONSTR</A>&nbsp;|&nbsp;<A HREF="#method_detail">METHOD</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_bottom"></A>
<!-- ======== END OF BOTTOM NAVBAR ======= -->

<HR>
Copyright &copy; 1996-2007 <a href="http://www.geotools.org">Geotools</a>. All Rights Reserved.
</BODY>
</HTML>