defaultsqlbuilder.html

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

 
 </TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#getPostQueryFilter(org.geotools.filter.Filter)">getPostQueryFilter</A></B>(<A HREF="../../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A>&nbsp;filter)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Return the postQueryFilter that must be applied to the database query
 result set.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="../../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#getPreQueryFilter(org.geotools.filter.Filter)">getPreQueryFilter</A></B>(<A HREF="../../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A>&nbsp;filter)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Return the preQueryFilter that can be used to generate the WHERE clause.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected &nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#splitFilter(org.geotools.filter.Filter)">splitFilter</A></B>(<A HREF="../../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A>&nbsp;filter)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#sqlColumns(java.lang.StringBuffer, org.geotools.data.jdbc.fidmapper.FIDMapper, org.geotools.feature.AttributeType[])">sqlColumns</A></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)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Appends the names of the columns to be selected.
 
 </TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#sqlFrom(java.lang.StringBuffer, java.lang.String)">sqlFrom</A></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)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Constructs the FROM clause for a featureType
 
 
 sql: <code>FROM typeName</code>
 </TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#sqlGeometryColumn(java.lang.StringBuffer, org.geotools.feature.AttributeType)">sqlGeometryColumn</A></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)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Generates the select column specification for a geometry column.
 
 </TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#sqlOrderBy(java.lang.StringBuffer, org.opengis.filter.sort.SortBy[])">sqlOrderBy</A></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)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Generates the order by clause.
 </TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#sqlWhere(java.lang.StringBuffer, org.geotools.filter.Filter)">sqlWhere</A></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)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Constructs WHERE clause, if needed, for FILTER.
 
 </TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_Object"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD><B>Methods inherited from class <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html" title="class or interface in java.lang">Object</A></B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html#clone()" title="class or interface in java.lang">clone</A>, <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html#equals(java.lang.Object)" title="class or interface in java.lang">equals</A>, <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html#finalize()" title="class or interface in java.lang">finalize</A>, <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html#getClass()" title="class or interface in java.lang">getClass</A>, <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html#hashCode()" title="class or interface in java.lang">hashCode</A>, <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html#notify()" title="class or interface in java.lang">notify</A>, <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html#notifyAll()" title="class or interface in java.lang">notifyAll</A>, <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html#toString()" title="class or interface in java.lang">toString</A>, <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html#wait()" title="class or interface in java.lang">wait</A>, <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html#wait(long)" title="class or interface in java.lang">wait</A>, <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html#wait(long, int)" title="class or interface in java.lang">wait</A></CODE></TD>
</TR>
</TABLE>
&nbsp;
<P>

<!-- ============ FIELD DETAIL =========== -->

<A NAME="field_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Field Detail</B></FONT></TD>
</TR>
</TABLE>

<A NAME="encoder"><!-- --></A><H3>
encoder</H3>
<PRE>
protected <A HREF="../../../../org/geotools/filter/SQLEncoder.html" title="class in org.geotools.filter">SQLEncoder</A> <B>encoder</B></PRE>
<DL>
<DL>
</DL>
</DL>
<HR>

<A NAME="ft"><!-- --></A><H3>
ft</H3>
<PRE>
protected <A HREF="../../../../org/geotools/feature/FeatureType.html" title="interface in org.geotools.feature">FeatureType</A> <B>ft</B></PRE>
<DL>
<DL>
</DL>
</DL>
<HR>

<A NAME="accessor"><!-- --></A><H3>
accessor</H3>
<PRE>
protected <A HREF="../../../../org/geotools/filter/visitor/ClientTransactionAccessor.html" title="interface in org.geotools.filter.visitor">ClientTransactionAccessor</A> <B>accessor</B></PRE>
<DL>
<DL>
</DL>
</DL>

<!-- ========= CONSTRUCTOR DETAIL ======== -->

<A NAME="constructor_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Constructor Detail</B></FONT></TD>
</TR>
</TABLE>

<A NAME="DefaultSQLBuilder()"><!-- --></A><H3>
DefaultSQLBuilder</H3>
<PRE>
public <B>DefaultSQLBuilder</B>()</PRE>
<DL>
<DD>Constructs an instance of this class with a default SQLEncoder
<P>
</DL>
<HR>

<A NAME="DefaultSQLBuilder(org.geotools.filter.SQLEncoder)"><!-- --></A><H3>
DefaultSQLBuilder</H3>
<PRE>
public <B>DefaultSQLBuilder</B>(<A HREF="../../../../org/geotools/filter/SQLEncoder.html" title="class in org.geotools.filter">SQLEncoder</A>&nbsp;encoder)</PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I></I>&nbsp;
<P>
<DD>Constructs an instance of this class using the encoder class specified.
 This will typically be from the getSqlBuilder method of a JDBCDataStore
 subclass.
 <p>
 This constructor should not be used to obtain Pre/Post filters, as these
 methods require a FeatureType to function properly.
<P>
<DT><B>Parameters:</B><DD><CODE>encoder</CODE> - the specific encoder to be used.</DL>
<HR>

<A NAME="DefaultSQLBuilder(org.geotools.filter.SQLEncoder, org.geotools.feature.FeatureType, org.geotools.filter.visitor.ClientTransactionAccessor)"><!-- --></A><H3>
DefaultSQLBuilder</H3>
<PRE>
public <B>DefaultSQLBuilder</B>(<A HREF="../../../../org/geotools/filter/SQLEncoder.html" title="class in org.geotools.filter">SQLEncoder</A>&nbsp;encoder,
                         <A HREF="../../../../org/geotools/feature/FeatureType.html" title="interface in org.geotools.feature">FeatureType</A>&nbsp;featureType,
                         <A HREF="../../../../org/geotools/filter/visitor/ClientTransactionAccessor.html" title="interface in org.geotools.filter.visitor">ClientTransactionAccessor</A>&nbsp;accessor)</PRE>
<DL>
<DD>Constructs an instance of this class using the encoder class specified.
 This will typically be from the getSqlBuilder method of a JDBCDataStore
 subclass.
<P>
<DT><B>Parameters:</B><DD><CODE>encoder</CODE> - the specific encoder to be used.<DD><CODE>featureType</CODE> - <DD><CODE>accessor</CODE> - client-side transaction handler; may be null.</DL>

<!-- ============ METHOD DETAIL ========== -->

<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Method Detail</B></FONT></TD>
</TR>
</TABLE>

<A NAME="getPostQueryFilter(org.geotools.filter.Filter)"><!-- --></A><H3>
getPostQueryFilter</H3>
<PRE>
public <A HREF="../../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A> <B>getPostQueryFilter</B>(<A HREF="../../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A>&nbsp;filter)</PRE>
<DL>
<DD>Return the postQueryFilter that must be applied to the database query
 result set.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html#getPostQueryFilter(org.geotools.filter.Filter)">getPostQueryFilter</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>filter</CODE> - the application filter which must be applied
<DT><B>Returns:</B><DD>the filter representing the functionality that must be performed
         on the result set.</DL>
</DD>
</DL>
<HR>

<A NAME="getPreQueryFilter(org.geotools.filter.Filter)"><!-- --></A><H3>
getPreQueryFilter</H3>
<PRE>
public <A HREF="../../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A> <B>getPreQueryFilter</B>(<A HREF="../../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A>&nbsp;filter)</PRE>
<DL>
<DD>Return the preQueryFilter that can be used to generate the WHERE clause.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html#getPreQueryFilter(org.geotools.filter.Filter)">getPreQueryFilter</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>filter</CODE> - the application filter which must be applied
<DT><B>Returns:</B><DD>the filter representing the functionality that can be performed
         by the database.</DL>
</DD>