sqlencoderpostgis.html

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

<A NAME="isLooseBbox()"><!-- --></A><H3>
isLooseBbox</H3>
<PRE>
public boolean <B>isLooseBbox</B>()</PRE>
<DL>
<DD>Gets whether the Filter.BBOX query will be strict and use an intersects
 or 'loose' and just operate against the geometry envelopes.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD><tt>true</tt> if this encoder is going to do loose filtering.</DL>
</DD>
</DL>
<HR>

<A NAME="setSRID(int)"><!-- --></A><H3>
setSRID</H3>
<PRE>
public void <B>setSRID</B>(int&nbsp;srid)</PRE>
<DL>
<DD>Sets a spatial reference system ESPG number, so that the geometry can be
 properly encoded for postgis.  If geotools starts actually creating
 geometries with valid srids then this method will no longer be needed.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>srid</CODE> - the integer code for the EPSG spatial reference system.</DL>
</DD>
</DL>
<HR>

<A NAME="setDefaultGeometry(java.lang.String)"><!-- --></A><H3>
setDefaultGeometry</H3>
<PRE>
public void <B>setDefaultGeometry</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)</PRE>
<DL>
<DD>Sets the default geometry, so that filters with null for one of their
 expressions can assume that the default geometry is intended.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>name</CODE> - the name of the default geometry Attribute.<DT><B>'TODO:'</B></DT>
  <DD>REVISIT: pass in a featureType so that geometries can figure out
       their own default geometry?</DD>
</DL>
</DD>
</DL>
<HR>

<A NAME="setSupportsGEOS(boolean)"><!-- --></A><H3>
setSupportsGEOS</H3>
<PRE>
public void <B>setSupportsGEOS</B>(boolean&nbsp;supports)</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getSupportsGEOS()"><!-- --></A><H3>
getSupportsGEOS</H3>
<PRE>
public boolean <B>getSupportsGEOS</B>()</PRE>
<DL>
<DD><DL>
</DL>
</DD>
<DD><DL>
</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>Turns a geometry filter into the postgis sql bbox statement.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.GeometryFilter)">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.GeometryFilter)">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 geometry filter to be encoded.
<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 (need a better error)<DT><B>See Also:</B><DD><A HREF="../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.GeometryFilter)"><CODE>FilterVisitor.visit(org.geotools.filter.GeometryFilter)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="visitLiteralGeometry(org.geotools.filter.LiteralExpression)"><!-- --></A><H3>
visitLiteralGeometry</H3>
<PRE>
public void <B>visitLiteralGeometry</B>(<A HREF="../../../org/geotools/filter/LiteralExpression.html" title="interface in org.geotools.filter">LiteralExpression</A>&nbsp;expression)
                          throws <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/io/IOException.html" title="class or interface in java.io">IOException</A></PRE>
<DL>
<DD>Checks to see if the literal is a geometry, and encodes it if it is, if
 not just sends to the parent class.
<P>
<DD><DL>
<DT><B>Overrides:</B><DD><CODE><A HREF="../../../org/geotools/filter/SQLEncoder.html#visitLiteralGeometry(org.geotools.filter.LiteralExpression)">visitLiteralGeometry</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>expression</CODE> - the expression to visit and encode.
<DT><B>Throws:</B>
<DD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/io/IOException.html" title="class or interface in java.io">IOException</A></CODE> - for IO exception (need a better error)</DL>
</DD>
</DL>
<HR>

<A NAME="visit(org.geotools.filter.LiteralExpression)"><!-- --></A><H3>
visit</H3>
<PRE>
public void <B>visit</B>(<A HREF="../../../org/geotools/filter/LiteralExpression.html" title="interface in org.geotools.filter">LiteralExpression</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>Checks to see if the literal is a geometry, and encodes it if it  is, if
 not just sends to the parent class.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../org/geotools/filter/FilterVisitor.html#visit(org.geotools.filter.LiteralExpression)">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.LiteralExpression)">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>expression</CODE> - the expression to visit and encode.
<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 (need a better error)</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><DT><B>Overrides:</B><DD><CODE><A HREF="../../../org/geotools/filter/SQLEncoder.html#visit(org.geotools.filter.CompareFilter)">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 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>
<!-- ========= 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/SQLEncoderPostgis.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/filter/SQLEncoderOracle.html" title="class in org.geotools.filter"><B>PREV CLASS</B></A>&nbsp;
&nbsp;<A HREF="../../../org/geotools/filter/SQLEncoderPostgisGeos.html" title="class in org.geotools.filter"><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="SQLEncoderPostgis.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>