sqlencoderdb2.html

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

<TD COLSPAN=2><FONT SIZE="+2">
<B>Method Summary</B></FONT></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected &nbsp;<A HREF="../../../../../org/geotools/filter/FilterCapabilities.html" title="class in org.geotools.filter">FilterCapabilities</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/geotools/data/db2/filter/SQLEncoderDB2.html#createFilterCapabilities()">createFilterCapabilities</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sets the DB2 filter capabilities.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;<A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../org/geotools/data/db2/filter/SQLEncoderDB2.html#db2Geom(com.vividsolutions.jts.geom.Geometry)">db2Geom</A></B>(<A HREF="http://www.jump-project.org/docs/jts/1.7/api/com/vividsolutions/jts/geom/Geometry.html" title="class or interface in com.vividsolutions.jts.geom">Geometry</A>&nbsp;geom)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Construct a geometry from the WKT representation of a geometry</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/db2/filter/SQLEncoderDB2.html#setSelectivityClause(java.lang.String)">setSelectivityClause</A></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;string)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sets a SELECTIVITY clause that can be included with the spatial
 predicate to influence the query optimizer to exploit a spatial index
 if it exists.
 
 </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/db2/filter/SQLEncoderDB2.html#setSRID(int)">setSRID</A></B>(int&nbsp;srid)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Set the value of the srid value to be used if a DB2 Spatial Extender
 geometry needs to be constructed.
 
 </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/db2/filter/SQLEncoderDB2.html#visit(org.geotools.filter.FidFilter)">visit</A></B>(<A HREF="../../../../../org/geotools/filter/FidFilter.html" title="interface in org.geotools.filter">FidFilter</A>&nbsp;filter)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Encodes an FidFilter.</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/db2/filter/SQLEncoderDB2.html#visit(org.geotools.filter.GeometryFilter)">visit</A></B>(<A HREF="../../../../../org/geotools/filter/GeometryFilter.html" title="interface in org.geotools.filter">GeometryFilter</A>&nbsp;filter)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Generate a WHERE clause for the input GeometryFilter.
 
 </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/db2/filter/SQLEncoderDB2.html#visit(org.geotools.filter.LikeFilter)">visit</A></B>(<A HREF="../../../../../org/geotools/filter/LikeFilter.html" title="interface in org.geotools.filter">LikeFilter</A>&nbsp;filter)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Writes the SQL for the Like Filter.  </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/db2/filter/SQLEncoderDB2.html#visitLiteralGeometry(org.geotools.filter.LiteralExpression)">visitLiteralGeometry</A></B>(<A HREF="../../../../../org/geotools/filter/LiteralExpression.html" title="interface in org.geotools.filter">LiteralExpression</A>&nbsp;expression)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Construct the appropriate geometry type from the WKT representation of a literal
 expression</TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_SQLEncoder"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD><B>Methods inherited from class <A HREF="../../../../../org/geotools/filter/SQLEncoder.html" title="class in org.geotools.filter">SQLEncoder</A></B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../../org/geotools/filter/SQLEncoder.html#encode(org.geotools.filter.Filter)">encode</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#encode(java.io.Writer, org.geotools.filter.Filter)">encode</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#escapeName(java.lang.String)">escapeName</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#getCapabilities()">getCapabilities</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#getColnameEscape()">getColnameEscape</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#setColnameEscape(java.lang.String)">setColnameEscape</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#setFIDMapper(org.geotools.data.jdbc.fidmapper.FIDMapper)">setFIDMapper</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#setSqlNameEscape(java.lang.String)">setSqlNameEscape</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.AttributeExpression)">visit</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.BetweenFilter)">visit</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.CompareFilter)">visit</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.Expression)">visit</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.Filter)">visit</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.FunctionExpression)">visit</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.LiteralExpression)">visit</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.LogicFilter)">visit</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.MathExpression)">visit</A>, <A HREF="../../../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.NullFilter)">visit</A></CODE></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;<A NAME="methods_inherited_from_class_FilterVisitor"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TD><B>Methods inherited from interface <A HREF="../../../../../org/geotools/filter/FilterVisitor.html" title="interface in org.geotools.filter">FilterVisitor</A></B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.AttributeExpression)">visit</A>, <A HREF="../../../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.BetweenFilter)">visit</A>, <A HREF="../../../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.CompareFilter)">visit</A>, <A HREF="../../../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.Expression)">visit</A>, <A HREF="../../../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.Filter)">visit</A>, <A HREF="../../../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.FunctionExpression)">visit</A>, <A HREF="../../../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.LiteralExpression)">visit</A>, <A HREF="../../../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.LogicFilter)">visit</A>, <A HREF="../../../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.MathExpression)">visit</A>, <A HREF="../../../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.NullFilter)">visit</A></CODE></TD>
</TR>
</TABLE>
&nbsp;
<P>

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


<!-- ========= 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="SQLEncoderDB2()"><!-- --></A><H3>
SQLEncoderDB2</H3>
<PRE>
public <B>SQLEncoderDB2</B>()</PRE>
<DL>
<DD>Construct an SQLEncoderDB2
<P>
</DL>
<HR>

<A NAME="SQLEncoderDB2(java.io.Writer, org.geotools.filter.Filter)"><!-- --></A><H3>
SQLEncoderDB2</H3>
<PRE>
public <B>SQLEncoderDB2</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>Construct an SQLEncoderDB2 that does the encoding (through superclass)
 directly based on the filter parameter.
<P>
<DT><B>Parameters:</B><DD><CODE>out</CODE> - a writer object<DD><CODE>filter</CODE> - query 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></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="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/RuntimeException.html" title="class or interface in java.lang">RuntimeException</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.
<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><DT><B>Overrides:</B><DD><CODE><A HREF="../../../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.LikeFilter)">visit</A></CODE> in class <CODE><A HREF="../../../../../org/geotools/filter/SQLEncoder.html" title="class in org.geotools.filter">SQLEncoder</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/RuntimeException.html" title="class or interface in java.lang">RuntimeException</A></CODE> - if writing the expression fails.</DL>
</DD>
</DL>
<HR>

<A NAME="visit(org.geotools.filter.GeometryFilter)"><!-- --></A><H3>
visit</H3>
<PRE>
public void <B>visit</B>(<A HREF="../../../../../org/geotools/filter/GeometryFilter.html" title="interface in org.geotools.filter">GeometryFilter</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>Generate a WHERE clause for the input GeometryFilter.
 
 <p>
 The following spatial filter operations are supported:
 
 <ul>
 <li>
 GEOMETRY_BBOX
 </li>
 <li>
 GEOMETRY_CONTAINS
 </li>
 <li>
 GEOMETRY_CROSSES
 </li>
 <li>
 GEOMETRY_DISJOINT
 </li>
 <li>
 GEOMETRY_EQUALS
 </li>
 <li>
 GEOMETRY_INTERSECTS
 </li>
 <li>
 GEOMETRY_OVERLAPS
 </li>