db2sqlbuilder.html

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

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Builds the SQL query to get the bounds (min-max coordinate values) of a
 geometry column for a given filter.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected &nbsp;boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/db2/DB2SQLBuilder.html#isTypeNumeric(int)">isTypeNumeric</A></B>(int&nbsp;columnType)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Checks if column type is SQL numeric type</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/DB2SQLBuilder.html#makeDeleteSql(org.geotools.feature.Feature)">makeDeleteSql</A></B>(<A HREF="../../../../org/geotools/feature/Feature.html" title="interface in org.geotools.feature">Feature</A>&nbsp;feature)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Generates the SQL delete statement</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected &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/DB2SQLBuilder.html#makeFIDWhere(org.geotools.feature.Feature)">makeFIDWhere</A></B>(<A HREF="../../../../org/geotools/feature/Feature.html" title="interface in org.geotools.feature">Feature</A>&nbsp;feature)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Build a DB2 WHERE clause based on the FID column values</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected &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/DB2SQLBuilder.html#makeInsertSql(org.geotools.feature.AttributeType[], org.geotools.feature.Feature)">makeInsertSql</A></B>(<A HREF="../../../../org/geotools/feature/AttributeType.html" title="interface in org.geotools.feature">AttributeType</A>[]&nbsp;attributes,
              <A HREF="../../../../org/geotools/feature/Feature.html" title="interface in org.geotools.feature">Feature</A>&nbsp;feature)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Creates a sql insert statement.  </TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected &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/DB2SQLBuilder.html#makeUpdateSql(org.geotools.feature.AttributeType[], org.geotools.feature.Feature, org.geotools.feature.Feature)">makeUpdateSql</A></B>(<A HREF="../../../../org/geotools/feature/AttributeType.html" title="interface in org.geotools.feature">AttributeType</A>[]&nbsp;attributes,
              <A HREF="../../../../org/geotools/feature/Feature.html" title="interface in org.geotools.feature">Feature</A>&nbsp;live,
              <A HREF="../../../../org/geotools/feature/Feature.html" title="interface in org.geotools.feature">Feature</A>&nbsp;current)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Generates the SQL UPDATE 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/data/db2/DB2SQLBuilder.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;Construct the FROM clause for a feature type.  </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/DB2SQLBuilder.html#sqlGeometryColumn(java.lang.StringBuffer, org.geotools.feature.AttributeType)">sqlGeometryColumn</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/feature/AttributeType.html" title="interface in org.geotools.feature">AttributeType</A>&nbsp;geomAttribute)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Generates the select column specification for a DB2 geometry column.
 
 </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#sqlColumns(java.lang.StringBuffer, org.geotools.data.jdbc.fidmapper.FIDMapper, org.geotools.feature.AttributeType[])">sqlColumns</A>, <A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#sqlOrderBy(java.lang.StringBuffer, org.opengis.filter.sort.SortBy[])">sqlOrderBy</A>, <A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#sqlWhere(java.lang.StringBuffer, org.geotools.filter.Filter)">sqlWhere</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 =========== -->


<!-- ========= 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="DB2SQLBuilder(org.geotools.filter.SQLEncoder, org.geotools.data.jdbc.fidmapper.FIDMapper, java.lang.String, java.lang.String)"><!-- --></A><H3>
DB2SQLBuilder</H3>
<PRE>
public <B>DB2SQLBuilder</B>(<A HREF="../../../../org/geotools/filter/SQLEncoder.html" title="class in org.geotools.filter">SQLEncoder</A>&nbsp;encoder,
                     <A HREF="../../../../org/geotools/data/jdbc/fidmapper/FIDMapper.html" title="interface in org.geotools.data.jdbc.fidmapper">FIDMapper</A>&nbsp;mapper,
                     <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;tableSchema,
                     <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)</PRE>
<DL>
<DD><B>Deprecated.</B>&nbsp;<I>please use DB2SQLBuilder(encoder, tableSchema, featureType)</I>
<P>
<DD>Creates a DB2SQLBuilder that will provide a table schema to qualify
 table names. The table schema is provided by the DB2DataStore which
 means that a given DataStore can only access tables within a single
 schema.
 
 <p>
 It would be better if the table schema was managed by FeatureTypeHandler
 or FeatureType.
 </p>
<P>
<DT><B>Parameters:</B><DD><CODE>encoder</CODE> - an SQLEncoder<DD><CODE>tableSchema</CODE> - table schema to qualify table names<DD><CODE>tableName</CODE> - the table name to be used by this SQL builder</DL>
<HR>

<A NAME="DB2SQLBuilder(org.geotools.filter.SQLEncoder, java.lang.String, org.geotools.feature.FeatureType)"><!-- --></A><H3>
DB2SQLBuilder</H3>
<PRE>
public <B>DB2SQLBuilder</B>(<A HREF="../../../../org/geotools/filter/SQLEncoder.html" title="class in org.geotools.filter">SQLEncoder</A>&nbsp;encoder,
                     <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;tableSchema,
                     <A HREF="../../../../org/geotools/feature/FeatureType.html" title="interface in org.geotools.feature">FeatureType</A>&nbsp;featureType)</PRE>
<DL>
<DD>Creates a DB2SQLBuilder that will provide a table schema to qualify
 table names. The table schema is provided by the DB2DataStore which
 means that a given DataStore can only access tables within a single
 schema.
 
 <p>
 It would be better if the table schema was managed by FeatureTypeHandler
 or FeatureType.
 </p>
<P>
<DT><B>Parameters:</B><DD><CODE>encoder</CODE> - an SQLEncoder<DD><CODE>tableSchema</CODE> - table schema to qualify table names</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="sqlGeometryColumn(java.lang.StringBuffer, org.geotools.feature.AttributeType)"><!-- --></A><H3>
sqlGeometryColumn</H3>
<PRE>
public void <B>sqlGeometryColumn</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/feature/AttributeType.html" title="interface in org.geotools.feature">AttributeType</A>&nbsp;geomAttribute)</PRE>
<DL>
<DD>Generates the select column specification for a DB2 geometry column.
 
 <p>
 Overrides sqlGeometryColumn in DefaultSQLBuilder
 </p>
<P>
<DD><DL>
<DT><B>Overrides:</B><DD><CODE><A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#sqlGeometryColumn(java.lang.StringBuffer, org.geotools.feature.AttributeType)">sqlGeometryColumn</A></CODE> in class <CODE><A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html" title="class in org.geotools.data.jdbc">DefaultSQLBuilder</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>sql</CODE> - A StringBuffer that the column specification can be appended
        to.<DD><CODE>geomAttribute</CODE> - An AttributeType for a geometry attribute</DL>
</DD>
</DL>
<HR>

<A NAME="sqlFrom(java.lang.StringBuffer, java.lang.String)"><!-- --></A><H3>
sqlFrom</H3>
<PRE>
public void <B>sqlFrom</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)</PRE>
<DL>
<DD>Construct the FROM clause for a feature type.  Prefixes the typeName
 with the table schema provided when this class was constructed.
 
 <p>
 This method could be promoted to DefaultSQLBuilder if the table schema