sqlencoder.html

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

<TD COLSPAN=1><FONT SIZE="+2">
<B>Method Detail</B></FONT></TD>
</TR>
</TABLE>

<A NAME="setFIDMapper(org.geotools.data.jdbc.fidmapper.FIDMapper)"><!-- --></A><H3>
setFIDMapper</H3>
<PRE>
public void <B>setFIDMapper</B>(<A HREF="../../../org/geotools/data/jdbc/fidmapper/FIDMapper.html" title="interface in org.geotools.data.jdbc.fidmapper">FIDMapper</A>&nbsp;mapper)</PRE>
<DL>
<DD>Sets the FIDMapper that will be used in subsequente visit calls. There
 must be a FIDMapper in order to invoke the FIDFilter encoder.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>mapper</CODE> - </DL>
</DD>
</DL>
<HR>

<A NAME="createFilterCapabilities()"><!-- --></A><H3>
createFilterCapabilities</H3>
<PRE>
protected <A HREF="../../../org/geotools/filter/FilterCapabilities.html" title="class in org.geotools.filter">FilterCapabilities</A> <B>createFilterCapabilities</B>()</PRE>
<DL>
<DD>Sets the capabilities of this filter.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>FilterCapabilities for this Filter</DL>
</DD>
</DL>
<HR>

<A NAME="encode(java.io.Writer, org.geotools.filter.Filter)"><!-- --></A><H3>
encode</H3>
<PRE>
public void <B>encode</B>(<A HREF="http://java.sun.com/j2se/1.4/docs/api/java/io/Writer.html" title="class or interface in java.io">Writer</A>&nbsp;out,
                   <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>Performs the encoding, sends the encoded sql to the writer passed in.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>out</CODE> - the writer to encode the SQL to.<DD><CODE>filter</CODE> - the Filter to be encoded.
<DT><B>Throws:</B>
<DD><CODE><A HREF="../../../org/geotools/filter/SQLEncoderException.html" title="class in org.geotools.filter">SQLEncoderException</A></CODE> - If filter type not supported, or if there
         were io problems.</DL>
</DD>
</DL>
<HR>

<A NAME="encode(org.geotools.filter.Filter)"><!-- --></A><H3>
encode</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>encode</B>(<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>Performs the encoding, returns a string of the encoded SQL.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>filter</CODE> - the Filter to be encoded.
<DT><B>Returns:</B><DD>the string of the SQL where statement.
<DT><B>Throws:</B>
<DD><CODE><A HREF="../../../org/geotools/filter/SQLEncoderException.html" title="class in org.geotools.filter">SQLEncoderException</A></CODE> - If filter type not supported, or if there
         were io problems.</DL>
</DD>
</DL>
<HR>

<A NAME="getCapabilities()"><!-- --></A><H3>
getCapabilities</H3>
<PRE>
public <A HREF="../../../org/geotools/filter/FilterCapabilities.html" title="class in org.geotools.filter">FilterCapabilities</A> <B>getCapabilities</B>()</PRE>
<DL>
<DD>Describes the capabilities of this encoder.
 
 <p>
 Performs lazy creation of capabilities.
 </p>
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD>The capabilities supported by this encoder.</DL>
</DD>
</DL>
<HR>

<A NAME="visit(org.geotools.filter.Filter)"><!-- --></A><H3>
visit</H3>
<PRE>
public void <B>visit</B>(<A HREF="../../../org/geotools/filter/Filter.html" title="interface in org.geotools.filter">Filter</A>&nbsp;filter)</PRE>
<DL>
<DD>This should never be called. This can only happen if a subclass of
 AbstractFilter failes to implement its own version of
 accept(FilterVisitor);
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.Filter)">visit</A></CODE> in interface <CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html" title="interface in org.geotools.filter">FilterVisitor</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>filter</CODE> - The filter to visit
<DT><B>Throws:</B>
<DD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></CODE> - for IO Encoding problems.<DT><B>'TODO:'</B></DT>
  <DD>REVISIT: I don't think Filter.NONE and Filter.ALL should be
       handled here.  They should have their own methods, but they don't
       have interfaces, so I don't know if that's possible.</DD>
</DL>
</DD>
</DL>
<HR>

<A NAME="visit(org.geotools.filter.BetweenFilter)"><!-- --></A><H3>
visit</H3>
<PRE>
public void <B>visit</B>(<A HREF="../../../org/geotools/filter/BetweenFilter.html" title="interface in org.geotools.filter">BetweenFilter</A>&nbsp;filter)
           throws <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></PRE>
<DL>
<DD>Writes the SQL for the Between Filter.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.BetweenFilter)">visit</A></CODE> in interface <CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html" title="interface in org.geotools.filter">FilterVisitor</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>filter</CODE> - the  Filter to be visited.
<DT><B>Throws:</B>
<DD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></CODE> - for io exception with writer</DL>
</DD>
</DL>
<HR>

<A NAME="visit(org.geotools.filter.LikeFilter)"><!-- --></A><H3>
visit</H3>
<PRE>
public void <B>visit</B>(<A HREF="../../../org/geotools/filter/LikeFilter.html" title="interface in org.geotools.filter">LikeFilter</A>&nbsp;filter)
           throws <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/UnsupportedOperationException.html" title="class or interface in java.lang">UnsupportedOperationException</A></PRE>
<DL>
<DD>Writes the SQL for the Like Filter.  Assumes the current java
 implemented wildcards for the Like Filter: . for multi and .? for
 single. And replaces them with the SQL % and _, respectively. Currently
 does nothing, and should not be called, not included in the
 capabilities.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.LikeFilter)">visit</A></CODE> in interface <CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html" title="interface in org.geotools.filter">FilterVisitor</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>filter</CODE> - the Like Filter to be visited.
<DT><B>Throws:</B>
<DD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/UnsupportedOperationException.html" title="class or interface in java.lang">UnsupportedOperationException</A></CODE> - always, as likes aren't
         implemented yet.<DT><B>'TODO:'</B></DT>
  <DD>REVISIT: Need to think through the escape char, so it works  right
       when Java uses one, and escapes correctly with an '_'.</DD>
</DL>
</DD>
</DL>
<HR>

<A NAME="visit(org.geotools.filter.LogicFilter)"><!-- --></A><H3>
visit</H3>
<PRE>
public void <B>visit</B>(<A HREF="../../../org/geotools/filter/LogicFilter.html" title="interface in org.geotools.filter">LogicFilter</A>&nbsp;filter)
           throws <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></PRE>
<DL>
<DD>Writes the SQL for the Logic Filter.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.LogicFilter)">visit</A></CODE> in interface <CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html" title="interface in org.geotools.filter">FilterVisitor</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>filter</CODE> - the logic statement to be turned into SQL.
<DT><B>Throws:</B>
<DD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></CODE> - for io exception with writer</DL>
</DD>
</DL>
<HR>

<A NAME="visit(org.geotools.filter.CompareFilter)"><!-- --></A><H3>
visit</H3>
<PRE>
public void <B>visit</B>(<A HREF="../../../org/geotools/filter/CompareFilter.html" title="interface in org.geotools.filter">CompareFilter</A>&nbsp;filter)
           throws <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></PRE>
<DL>
<DD>Writes the SQL for a Compare Filter.
  
  DJB: note, postgis overwrites this implementation because of the way
       null is handled.  This is for <PropertyIsNull> filters and <PropertyIsEqual> filters
       are handled.  They will come here with "property = null".  
       NOTE: 
        SELECT * FROM <table> WHERE <column> isnull;  -- postgresql
        SELECT * FROM <table> WHERE isnull(<column>); -- oracle???
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.CompareFilter)">visit</A></CODE> in interface <CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html" title="interface in org.geotools.filter">FilterVisitor</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>filter</CODE> - the comparison to be turned into SQL.
<DT><B>Throws:</B>
<DD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></CODE> - for io exception with writer</DL>
</DD>
</DL>
<HR>

<A NAME="visit(org.geotools.filter.NullFilter)"><!-- --></A><H3>
visit</H3>
<PRE>
public void <B>visit</B>(<A HREF="../../../org/geotools/filter/NullFilter.html" title="interface in org.geotools.filter">NullFilter</A>&nbsp;filter)
           throws <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></PRE>
<DL>
<DD>Writes the SQL for the Null Filter.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.NullFilter)">visit</A></CODE> in interface <CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html" title="interface in org.geotools.filter">FilterVisitor</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>filter</CODE> - the null filter to be written to SQL.
<DT><B>Throws:</B>
<DD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></CODE> - for io exception with writer</DL>
</DD>
</DL>
<HR>

<A NAME="visit(org.geotools.filter.FidFilter)"><!-- --></A><H3>
visit</H3>
<PRE>
public void <B>visit</B>(<A HREF="../../../org/geotools/filter/FidFilter.html" title="interface in org.geotools.filter">FidFilter</A>&nbsp;filter)</PRE>
<DL>
<DD>Encodes an FidFilter.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.FidFilter)">visit</A></CODE> in interface <CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html" title="interface in org.geotools.filter">FilterVisitor</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>filter</CODE> - 
<DT><B>Throws:</B>
<DD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></CODE> - DOCUMENT ME!<DT><B>See Also:</B><DD><A HREF="../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.FidFilter)"><CODE>visit(org.geotools.filter.FidFilter)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="visit(org.geotools.filter.AttributeExpression)"><!-- --></A><H3>
visit</H3>
<PRE>
public void <B>visit</B>(<A HREF="../../../org/geotools/filter/AttributeExpression.html" title="interface in org.geotools.filter">AttributeExpression</A>&nbsp;expression)
           throws <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></PRE>
<DL>
<DD>Writes the SQL for the attribute Expression.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.AttributeExpression)">visit</A></CODE> in interface <CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html" title="interface in org.geotools.filter">FilterVisitor</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>expression</CODE> - the attribute to turn to SQL.
<DT><B>Throws:</B>
<DD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></CODE> - for io exception with writer</DL>
</DD>
</DL>
<HR>