sqlencoderpostgis.html

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

<TD><CODE><B><A HREF="../../../org/geotools/filter/SQLEncoderPostgis.html#isLooseBbox()">isLooseBbox</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Gets whether the Filter.BBOX query will be strict and use an intersects
 or 'loose' and just operate against the geometry envelopes.</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/filter/SQLEncoderPostgis.html#setDefaultGeometry(java.lang.String)">setDefaultGeometry</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;name)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sets the default geometry, so that filters with null for one of their
 expressions can assume that the default geometry is intended.</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/filter/SQLEncoderPostgis.html#setLooseBbox(boolean)">setLooseBbox</A></B>(boolean&nbsp;isLooseBbox)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sets whether the Filter.BBOX query should be 'loose', meaning that it
 should just doing a bounding box against the envelope.  </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/filter/SQLEncoderPostgis.html#setSRID(int)">setSRID</A></B>(int&nbsp;srid)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sets a spatial reference system ESPG number, so that the geometry can be
 properly encoded for postgis.  </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/filter/SQLEncoderPostgis.html#setSupportsGEOS(boolean)">setSupportsGEOS</A></B>(boolean&nbsp;supports)</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/filter/SQLEncoderPostgis.html#visit(org.geotools.filter.CompareFilter)">visit</A></B>(<A HREF="../../../org/geotools/filter/CompareFilter.html" title="interface in org.geotools.filter">CompareFilter</A>&nbsp;filter)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Writes the SQL for a Compare 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/filter/SQLEncoderPostgis.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;Turns a geometry filter into the postgis sql bbox statement.</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/filter/SQLEncoderPostgis.html#visit(org.geotools.filter.LiteralExpression)">visit</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;Checks to see if the literal is a geometry, and encodes it if it  is, if
 not just sends to the parent class.</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/filter/SQLEncoderPostgis.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;Checks to see if the literal is a geometry, and encodes it if it is, if
 not just sends to the parent class.</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.Expression)">visit</A>, <A HREF="../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.FidFilter)">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.LikeFilter)">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.Expression)">visit</A>, <A HREF="../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.FidFilter)">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.LikeFilter)">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 =========== -->

<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="looseBbox"><!-- --></A><H3>
looseBbox</H3>
<PRE>
protected boolean <B>looseBbox</B></PRE>
<DL>
<DD>Whether the BBOX filter should be strict (using the exact geom), or 
  loose (using the envelopes)
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="supportsGEOS"><!-- --></A><H3>
supportsGEOS</H3>
<PRE>
protected boolean <B>supportsGEOS</B></PRE>
<DL>
<DD>Whether the installed PostGIS has GEOS support. Default is false for
 backwards compatibility.
<P>
<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="SQLEncoderPostgis()"><!-- --></A><H3>
SQLEncoderPostgis</H3>
<PRE>
public <B>SQLEncoderPostgis</B>()</PRE>
<DL>
<DD>Empty constructor TODO: rethink empty constructor, as BBOXes _need_ an
 SRID, must make client set it somehow.  Maybe detect when encode is
 called?
<P>
</DL>
<HR>

<A NAME="SQLEncoderPostgis(boolean)"><!-- --></A><H3>
SQLEncoderPostgis</H3>
<PRE>
public <B>SQLEncoderPostgis</B>(boolean&nbsp;looseBbox)</PRE>
<DL>
</DL>
<HR>

<A NAME="SQLEncoderPostgis(int)"><!-- --></A><H3>
SQLEncoderPostgis</H3>
<PRE>
public <B>SQLEncoderPostgis</B>(int&nbsp;srid)</PRE>
<DL>
<DD>Constructor with srid.
<P>
<DT><B>Parameters:</B><DD><CODE>srid</CODE> - spatial reference id to encode geometries with.</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="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><B>Description copied from class: <CODE><A HREF="../../../org/geotools/filter/SQLEncoder.html" title="class in org.geotools.filter">SQLEncoder</A></CODE></B></DD>
<DD>Sets the capabilities of this filter.
<P>
<DD><DL>
<DT><B>Overrides:</B><DD><CODE><A HREF="../../../org/geotools/filter/SQLEncoder.html#createFilterCapabilities()">createFilterCapabilities</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>Returns:</B><DD>FilterCapabilities for this Filter<DT><B>See Also:</B><DD><A HREF="../../../org/geotools/filter/SQLEncoder.html#createFilterCapabilities()"><CODE>SQLEncoder.createFilterCapabilities()</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="setLooseBbox(boolean)"><!-- --></A><H3>
setLooseBbox</H3>
<PRE>
public void <B>setLooseBbox</B>(boolean&nbsp;isLooseBbox)</PRE>
<DL>
<DD>Sets whether the Filter.BBOX query should be 'loose', meaning that it
 should just doing a bounding box against the envelope.  If set to
 <tt>false</tt> then the BBOX query will perform a full intersects 
 against the geometry, ensuring that it is exactly correct.  If 
 <tt>true</tt> then the query will likely perform faster, but may not
 be exactly correct.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>isLooseBbox</CODE> - whether the bbox should be loose or strict.</DL>
</DD>
</DL>
<HR>