postgissqlbuilder.html

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

</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/postgis/PostgisSQLBuilder.html#encodeTableName(java.lang.String)">encodeTableName</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;tableName)</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;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/postgis/PostgisSQLBuilder.html#isByteaEnabled()">isByteaEnabled</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Enables the use of the bytea function to transfer faster WKB geometries</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>&nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/postgis/PostgisSQLBuilder.html#isSchemaEnabled()">isSchemaEnabled</A></B>()</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;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/postgis/PostgisSQLBuilder.html#isWKBEnabled()">isWKBEnabled</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Returns true if the WKB format is used to transfer geometries, false
 otherwise</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/postgis/PostgisSQLBuilder.html#setByteaEnabled(boolean)">setByteaEnabled</A></B>(boolean&nbsp;byteaEnable)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Enables/disables the use of the bytea function</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/postgis/PostgisSQLBuilder.html#setSchemaEnabled(boolean)">setSchemaEnabled</A></B>(boolean&nbsp;schemaEnabled)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Enables/disables schema name qualification.</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/postgis/PostgisSQLBuilder.html#setWKBEnabled(boolean)">setWKBEnabled</A></B>(boolean&nbsp;enabled)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If turned on, WKB will be used to transfer geometry data instead of  WKT</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/postgis/PostgisSQLBuilder.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;Produces the select information required.
 
 </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/postgis/PostgisSQLBuilder.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;Consutrcts FROM clause for 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/postgis/PostgisSQLBuilder.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_DefaultSQLBuilder"><!-- --></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/data/jdbc/DefaultSQLBuilder.html" title="class in org.geotools.data.jdbc">DefaultSQLBuilder</A></B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#buildSQLQuery(java.lang.String, org.geotools.data.jdbc.fidmapper.FIDMapper, org.geotools.feature.AttributeType[], org.geotools.filter.Filter)">buildSQLQuery</A>, <A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#getPostQueryFilter(org.geotools.filter.Filter)">getPostQueryFilter</A>, <A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#getPreQueryFilter(org.geotools.filter.Filter)">getPreQueryFilter</A>, <A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#splitFilter(org.geotools.filter.Filter)">splitFilter</A>, <A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#sqlGeometryColumn(java.lang.StringBuffer, org.geotools.feature.AttributeType)">sqlGeometryColumn</A>, <A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#sqlOrderBy(java.lang.StringBuffer, org.opengis.filter.sort.SortBy[])">sqlOrderBy</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;
<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="WKBEnabled"><!-- --></A><H3>
WKBEnabled</H3>
<PRE>
protected boolean <B>WKBEnabled</B></PRE>
<DL>
<DD>If true, WKB format is used instead of WKT
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="byteaEnabled"><!-- --></A><H3>
byteaEnabled</H3>
<PRE>
protected boolean <B>byteaEnabled</B></PRE>
<DL>
<DD>If true, ByteA function is used to transfer WKB data
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="schemaEnabled"><!-- --></A><H3>
schemaEnabled</H3>
<PRE>
protected boolean <B>schemaEnabled</B></PRE>
<DL>
<DD>If true, tables are qualified with a schema
<P>
<DL>
</DL>
</DL>
<HR>

<A NAME="config"><!-- --></A><H3>
config</H3>
<PRE>
protected <A HREF="../../../../org/geotools/data/jdbc/JDBCDataStoreConfig.html" title="class in org.geotools.data.jdbc">JDBCDataStoreConfig</A> <B>config</B></PRE>
<DL>
<DD>the datastore
<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="PostgisSQLBuilder(int, org.geotools.data.jdbc.JDBCDataStoreConfig)"><!-- --></A><H3>
PostgisSQLBuilder</H3>
<PRE>
public <B>PostgisSQLBuilder</B>(int&nbsp;srid,
                         <A HREF="../../../../org/geotools/data/jdbc/JDBCDataStoreConfig.html" title="class in org.geotools.data.jdbc">JDBCDataStoreConfig</A>&nbsp;config)</PRE>
<DL>
</DL>
<HR>

<A NAME="PostgisSQLBuilder(org.geotools.filter.SQLEncoder, org.geotools.data.jdbc.JDBCDataStoreConfig)"><!-- --></A><H3>
PostgisSQLBuilder</H3>
<PRE>
public <B>PostgisSQLBuilder</B>(<A HREF="../../../../org/geotools/filter/SQLEncoder.html" title="class in org.geotools.filter">SQLEncoder</A>&nbsp;encoder,
                         <A HREF="../../../../org/geotools/data/jdbc/JDBCDataStoreConfig.html" title="class in org.geotools.data.jdbc">JDBCDataStoreConfig</A>&nbsp;config)</PRE>
<DL>
<DD>Constructor with encoder.  Use PostgisSQLBuilder(encoder, config, ft) if possible.
<P>
<DT><B>Parameters:</B><DD><CODE>encoder</CODE> - </DL>
<HR>

<A NAME="PostgisSQLBuilder(org.geotools.filter.SQLEncoder, org.geotools.data.jdbc.JDBCDataStoreConfig, org.geotools.feature.FeatureType)"><!-- --></A><H3>
PostgisSQLBuilder</H3>
<PRE>
public <B>PostgisSQLBuilder</B>(<A HREF="../../../../org/geotools/filter/SQLEncoder.html" title="class in org.geotools.filter">SQLEncoder</A>&nbsp;encoder,
                         <A HREF="../../../../org/geotools/data/jdbc/JDBCDataStoreConfig.html" title="class in org.geotools.data.jdbc">JDBCDataStoreConfig</A>&nbsp;config,
                         <A HREF="../../../../org/geotools/feature/FeatureType.html" title="interface in org.geotools.feature">FeatureType</A>&nbsp;ft)</PRE>
<DL>
</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="sqlColumns(java.lang.StringBuffer, org.geotools.data.jdbc.fidmapper.FIDMapper, org.geotools.feature.AttributeType[])"><!-- --></A><H3>
sqlColumns</H3>
<PRE>
public void <B>sqlColumns</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)</PRE>
<DL>
<DD>Produces the select information required.