jdbctextfeaturewriter.html

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

<CODE>protected &nbsp;void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/JDBCTextFeatureWriter.html#doUpdate(org.geotools.feature.Feature, org.geotools.feature.Feature)">doUpdate</A></B>(<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;Override that uses sql statements to perform the operation.</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/jdbc/JDBCTextFeatureWriter.html#encodeColumnName(java.lang.String)">encodeColumnName</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;colName)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Encodes the colName, default just calls <A HREF="../../../../org/geotools/data/jdbc/JDBCTextFeatureWriter.html#encodeName(java.lang.String)"><CODE>encodeName(String)</CODE></A>.</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/jdbc/JDBCTextFeatureWriter.html#encodeName(java.lang.String)">encodeName</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;Encodes the tableName, default is to do nothing, but postgis will
 override and put double quotes around the tablename.</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>protected abstract &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/jdbc/JDBCTextFeatureWriter.html#getGeometryInsertText(com.vividsolutions.jts.geom.Geometry, int)">getGeometryInsertText</A></B>(<A HREF="http://www.jump-project.org/docs/jts/1.7/api/com/vividsolutions/jts/geom/Geometry.html" title="class or interface in com.vividsolutions.jts.geom">Geometry</A>&nbsp;geom,
                      int&nbsp;srid)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Turns a geometry into the textual version needed for the sql 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/jdbc/JDBCTextFeatureWriter.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 query for 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/jdbc/JDBCTextFeatureWriter.html#makeInsertSql(org.geotools.feature.Feature)">makeInsertSql</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;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/jdbc/JDBCTextFeatureWriter.html#makeSelectForUpdateSql(org.geotools.feature.Feature)">makeSelectForUpdateSql</A></B>(<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;Generate the select for update statement, which will attempt to
 lock features for update.  </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/jdbc/JDBCTextFeatureWriter.html#makeUpdateSql(org.geotools.feature.Feature, org.geotools.feature.Feature)">makeUpdateSql</A></B>(<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;Generate the update sql 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/jdbc/JDBCTextFeatureWriter.html#remove()">remove</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Override that uses sql statements to perform the operation.</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/jdbc/JDBCTextFeatureWriter.html#useQueryDataForInsert()">useQueryDataForInsert</A></B>()</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;This version does not use QueryData udpate/insert/remove methods, but
 uses separate queries instead</TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_JDBCFeatureWriter"><!-- --></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/JDBCFeatureWriter.html" title="class in org.geotools.data.jdbc">JDBCFeatureWriter</A></B></TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE><A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#close()">close</A>, <A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#getFeatureType()">getFeatureType</A>, <A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#hasNext()">hasNext</A>, <A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#next()">next</A>, <A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#setFeatureListenerManager(org.geotools.data.FeatureListenerManager)">setFeatureListenerManager</A>, <A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#write()">write</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="mapper"><!-- --></A><H3>
mapper</H3>
<PRE>
protected <A HREF="../../../../org/geotools/data/jdbc/fidmapper/FIDMapper.html" title="interface in org.geotools.data.jdbc.fidmapper">FIDMapper</A> <B>mapper</B></PRE>
<DL>
<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="JDBCTextFeatureWriter(org.geotools.data.FeatureReader, org.geotools.data.jdbc.QueryData)"><!-- --></A><H3>
JDBCTextFeatureWriter</H3>
<PRE>
public <B>JDBCTextFeatureWriter</B>(<A HREF="../../../../org/geotools/data/FeatureReader.html" title="interface in org.geotools.data">FeatureReader</A>&nbsp;fReader,
                             <A HREF="../../../../org/geotools/data/jdbc/QueryData.html" title="class in org.geotools.data.jdbc">QueryData</A>&nbsp;queryData)
                      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 new instance of JDBCFeatureWriter
<P>
<DT><B>Parameters:</B><DD><CODE>fReader</CODE> - <DD><CODE>queryData</CODE> - 
<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>

<!-- ============ 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="doInsert(org.geotools.data.jdbc.MutableFIDFeature)"><!-- --></A><H3>
doInsert</H3>
<PRE>
protected void <B>doInsert</B>(<A HREF="../../../../org/geotools/data/jdbc/MutableFIDFeature.html" title="class in org.geotools.data.jdbc">MutableFIDFeature</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>,
                        <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/sql/SQLException.html" title="class or interface in java.sql">SQLException</A></PRE>
<DL>
<DD>Override that uses sql statements to perform the operation.
<P>
<DD><DL>
<DT><B>Overrides:</B><DD><CODE><A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#doInsert(org.geotools.data.jdbc.MutableFIDFeature)">doInsert</A></CODE> in class <CODE><A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html" title="class in org.geotools.data.jdbc">JDBCFeatureWriter</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>current</CODE> - 
<DT><B>Throws:</B>
<DD><CODE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/sql/SQLException.html" title="class or interface in java.sql">SQLException</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><DT><B>See Also:</B><DD><A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#doInsert(org.geotools.data.jdbc.MutableFIDFeature)"><CODE>JDBCFeatureWriter.doInsert(org.geotools.data.jdbc.MutableFIDFeature)</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="makeInsertSql(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/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="addQuotes(java.lang.Object)"><!-- --></A><H3>
addQuotes</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>addQuotes</B>(<A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html" title="class or interface in java.lang">Object</A>&nbsp;value)</PRE>
<DL>
<DD>Adds quotes to an object for storage in postgis.  The object should be a
 string or a number.  To perform an insert strings need quotes around
 them, and numbers work fine with quotes, so this method can be called
 on unknown objects.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>value</CODE> - The object to add quotes to.
<DT><B>Returns:</B><DD>a string representation of the object with quotes.</DL>
</DD>
</DL>
<HR>

<A NAME="encodeName(java.lang.String)"><!-- --></A><H3>
encodeName</H3>