db2sqlbuilder.html

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

 was propagated up.
 </p>
 
 <p>
 Overrides sqlFrom in DefaultSQLBuilder
 </p>
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html#sqlFrom(java.lang.StringBuffer, java.lang.String)">sqlFrom</A></CODE> in interface <CODE><A HREF="../../../../org/geotools/data/jdbc/SQLBuilder.html" title="interface in org.geotools.data.jdbc">SQLBuilder</A></CODE><DT><B>Overrides:</B><DD><CODE><A HREF="../../../../org/geotools/data/jdbc/DefaultSQLBuilder.html#sqlFrom(java.lang.StringBuffer, java.lang.String)">sqlFrom</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> - StringBuffer to be appended to<DD><CODE>typeName</CODE> - Name of the type (table)</DL>
</DD>
</DL>
<HR>

<A NAME="buildSQLBoundsQuery(java.lang.String, org.geotools.feature.AttributeType, org.geotools.filter.Filter)"><!-- --></A><H3>
buildSQLBoundsQuery</H3>
<PRE>
public <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A> <B>buildSQLBoundsQuery</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;typeName,
                                  <A HREF="../../../../org/geotools/feature/AttributeType.html" title="interface in org.geotools.feature">AttributeType</A>&nbsp;geomAttr,
                                  <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>Builds the SQL query to get the bounds (min-max coordinate values) of a
 geometry column for a given filter.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>typeName</CODE> - the feature type name.<DD><CODE>geomAttr</CODE> - the geometry attribute.<DD><CODE>filter</CODE> - the filter expression.
<DT><B>Returns:</B><DD>the string to perform the SQL query.
<DT><B>Throws:</B>
<DD><CODE><A HREF="../../../../org/geotools/filter/SQLEncoderException.html" title="class in org.geotools.filter">SQLEncoderException</A></CODE></DL>
</DD>
</DL>
<HR>

<A NAME="makeInsertSql(org.geotools.feature.AttributeType[], org.geotools.feature.Feature)"><!-- --></A><H3>
makeInsertSql</H3>
<PRE>
protected <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A> <B>makeInsertSql</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)
                        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>Creates a sql insert statement.  Uses each feature's schema, which makes
 it possible to insert out of order, as well as inserting less than all
 features.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>feature</CODE> - the feature to add.
<DT><B>Returns:</B><DD>an insert sql statement.
<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></DL>
</DD>
</DL>
<HR>

<A NAME="makeUpdateSql(org.geotools.feature.AttributeType[], org.geotools.feature.Feature, org.geotools.feature.Feature)"><!-- --></A><H3>
makeUpdateSql</H3>
<PRE>
protected <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A> <B>makeUpdateSql</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)
                        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>Generates the SQL UPDATE statement
<P>
<DD><DL>

<DT><B>Returns:</B><DD>DB2 UPDATE statement
<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>
<DD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/UnsupportedOperationException.html" title="class or interface in java.lang">UnsupportedOperationException</A></CODE></DL>
</DD>
</DL>
<HR>

<A NAME="makeDeleteSql(org.geotools.feature.Feature)"><!-- --></A><H3>
makeDeleteSql</H3>
<PRE>
public <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A> <B>makeDeleteSql</B>(<A HREF="../../../../org/geotools/feature/Feature.html" title="interface in org.geotools.feature">Feature</A>&nbsp;feature)
                     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>Generates the SQL delete statement
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>feature</CODE> - 
<DT><B>Returns:</B><DD>DB2 DELETE statement
<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>
<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>
<DD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/UnsupportedOperationException.html" title="class or interface in java.lang">UnsupportedOperationException</A></CODE></DL>
</DD>
</DL>
<HR>

<A NAME="makeFIDWhere(org.geotools.feature.Feature)"><!-- --></A><H3>
makeFIDWhere</H3>
<PRE>
protected <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A> <B>makeFIDWhere</B>(<A HREF="../../../../org/geotools/feature/Feature.html" title="interface in org.geotools.feature">Feature</A>&nbsp;feature)
                       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>Build a DB2 WHERE clause based on the FID column values
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>feature</CODE> - 
<DT><B>Returns:</B><DD>A DB2 WHERE clause based on the FID column values.
<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></DL>
</DD>
</DL>
<HR>

<A NAME="isTypeNumeric(int)"><!-- --></A><H3>
isTypeNumeric</H3>
<PRE>
protected boolean <B>isTypeNumeric</B>(int&nbsp;columnType)</PRE>
<DL>
<DD>Checks if column type is SQL numeric type
<P>
<DD><DL>

<DT><B>Returns:</B><DD>true if the column is an SQL numeric type</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/DB2SQLBuilder.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/data/db2/DB2SpatialCatalog.html" title="class in org.geotools.data.db2"><B>PREV CLASS</B></A>&nbsp;
&nbsp;NEXT CLASS</FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../index.html" target="_top"><B>FRAMES</B></A>  &nbsp;
&nbsp;<A HREF="DB2SQLBuilder.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="#fields_inherited_from_class_DefaultSQLBuilder">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;FIELD&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>