📄 jdbctextfeaturewriter.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><!--NewPage--><HTML><HEAD><!-- Generated by javadoc (build 1.4.2_13) on Tue Jun 05 11:36:32 GMT-05:00 2007 --><META http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"><TITLE>JDBCTextFeatureWriter (Geotools 2.3.x 2.3.2 API)</TITLE><META NAME="keywords" CONTENT="org.geotools.data.jdbc.JDBCTextFeatureWriter class"><META NAME="keywords" CONTENT="mapper"><META NAME="keywords" CONTENT="doInsert()"><META NAME="keywords" CONTENT="makeInsertSql()"><META NAME="keywords" CONTENT="addQuotes()"><META NAME="keywords" CONTENT="encodeName()"><META NAME="keywords" CONTENT="encodeColumnName()"><META NAME="keywords" CONTENT="getGeometryInsertText()"><META NAME="keywords" CONTENT="remove()"><META NAME="keywords" CONTENT="makeDeleteSql()"><META NAME="keywords" CONTENT="doUpdate()"><META NAME="keywords" CONTENT="makeSelectForUpdateSql()"><META NAME="keywords" CONTENT="makeUpdateSql()"><META NAME="keywords" CONTENT="useQueryDataForInsert()"><LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../stylesheet.css" TITLE="Style"><SCRIPT type="text/javascript">function windowTitle(){ parent.document.title="JDBCTextFeatureWriter (Geotools 2.3.x 2.3.2 API)";}</SCRIPT></HEAD><BODY BGCOLOR="white" onload="windowTitle();"><!-- ========= START OF TOP NAVBAR ======= --><A NAME="navbar_top"><!-- --></A><A HREF="#skip-navbar_top" 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_top_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> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/JDBCTextFeatureWriter.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> </TR></TABLE></TD><TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM></EM></TD></TR><TR><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../../org/geotools/data/jdbc/JDBCPSFeatureWriter.html" title="class in org.geotools.data.jdbc"><B>PREV CLASS</B></A> <A HREF="../../../../org/geotools/data/jdbc/JDBCTransactionState.html" title="class in org.geotools.data.jdbc"><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> <A HREF="JDBCTextFeatureWriter.html" target="_top"><B>NO FRAMES</B></A> <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: NESTED | <A HREF="#field_summary">FIELD</A> | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">DETAIL: <A HREF="#field_detail">FIELD</A> | <A HREF="#constructor_detail">CONSTR</A> | <A HREF="#method_detail">METHOD</A></FONT></TD></TR></TABLE><A NAME="skip-navbar_top"></A><!-- ========= END OF TOP NAVBAR ========= --><HR><!-- ======== START OF CLASS DATA ======== --><H2><FONT SIZE="-1">org.geotools.data.jdbc</FONT><BR>Class JDBCTextFeatureWriter</H2><PRE><A HREF="http://java.sun.com/j2se/1.4/docs/api/java/lang/Object.html" title="class or interface in java.lang">Object</A> <IMG SRC="../../../../resources/inherit.gif" ALT="extended by"><A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html" title="class in org.geotools.data.jdbc">JDBCFeatureWriter</A> <IMG SRC="../../../../resources/inherit.gif" ALT="extended by"><B>JDBCTextFeatureWriter</B></PRE><DL><DT><B>All Implemented Interfaces:</B> <DD><A HREF="../../../../org/geotools/data/FeatureWriter.html" title="interface in org.geotools.data">FeatureWriter</A></DD></DL><DL><DT><B>Direct Known Subclasses:</B> <DD><A HREF="../../../../org/geotools/data/db2/DB2FeatureWriter.html" title="class in org.geotools.data.db2">DB2FeatureWriter</A>, <A HREF="../../../../org/geotools/data/hsql/HsqlFeatureWriter.html" title="class in org.geotools.data.hsql">HsqlFeatureWriter</A>, <A HREF="../../../../org/geotools/data/mysql/MySQLFeatureWriter.html" title="class in org.geotools.data.mysql">MySQLFeatureWriter</A>, <A HREF="../../../../org/geotools/data/oracle/OracleFeatureWriter.html" title="class in org.geotools.data.oracle">OracleFeatureWriter</A>, <A HREF="../../../../org/geotools/data/postgis/PostgisFeatureWriter.html" title="class in org.geotools.data.postgis">PostgisFeatureWriter</A></DD></DL><HR><DL><DT>public abstract class <B>JDBCTextFeatureWriter</B><DT>extends <A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html" title="class in org.geotools.data.jdbc">JDBCFeatureWriter</A></DL><P>An abstract class that uses sql statements to insert, update and delete features from the database. Useful when the resultset got from the database is not updatable, for example.<P><P><DL><DT><B>Author:</B></DT> <DD>Andrea Aime, chorner</DD><DT><B>Module:</B></DT><DD><CODE><B>module/main</B></CODE> (<A HREF="http://maven.geotools.fr/repository/org/geotools/gt2-main/"><CODE>gt2-main.jar</CODE></A>) (<A HREF="http://maven.geotools.fr/reports/main/index.html">Maven report</A>) (<A HREF="http://svn.geotools.org/geotools/tags/2.3.2/module/main/src/org/geotools/data/jdbc/JDBCTextFeatureWriter.java">SVN head</A>)</DD><DT><B>'TODO:'</B></DT> <DD>TODO: Use prepared statements for inserts. Jody says that oracle at least will perform faster, and I imagine postgis will too. This will require a bit of rearchitecture, since the statement should just be made once, right now even if there were many features coming in they would all have to make a new prepared statement - should be able to do it before and then just fill it up for each feature. And for oracle Jody has some convenience methods in his SDO stuff that works with prepared statements and STRUCTS directly. See http://jira.codehaus.org/browse/GEOT-219 (close when done).</DD></DL><HR><P><!-- ======== NESTED CLASS SUMMARY ======== --><!-- =========== FIELD SUMMARY =========== --><A NAME="field_summary"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Field Summary</B></FONT></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>protected <A HREF="../../../../org/geotools/data/jdbc/fidmapper/FIDMapper.html" title="interface in org.geotools.data.jdbc.fidmapper">FIDMapper</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/JDBCTextFeatureWriter.html#mapper">mapper</A></B></CODE><BR> </TD></TR></TABLE> <A NAME="fields_inherited_from_class_JDBCFeatureWriter"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor"><TD><B>Fields 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#closed">closed</A>, <A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#current">current</A>, <A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#fidAttributes">fidAttributes</A>, <A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#listenerManager">listenerManager</A>, <A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#live">live</A>, <A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#queryData">queryData</A>, <A HREF="../../../../org/geotools/data/jdbc/JDBCFeatureWriter.html#reader">reader</A></CODE></TD></TR></TABLE> <!-- ======== CONSTRUCTOR SUMMARY ======== --><A NAME="constructor_summary"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Constructor Summary</B></FONT></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/JDBCTextFeatureWriter.html#JDBCTextFeatureWriter(org.geotools.data.FeatureReader, org.geotools.data.jdbc.QueryData)">JDBCTextFeatureWriter</A></B>(<A HREF="../../../../org/geotools/data/FeatureReader.html" title="interface in org.geotools.data">FeatureReader</A> fReader, <A HREF="../../../../org/geotools/data/jdbc/QueryData.html" title="class in org.geotools.data.jdbc">QueryData</A> queryData)</CODE><BR> Creates a new instance of JDBCFeatureWriter</TD></TR></TABLE> <!-- ========== METHOD SUMMARY =========== --><A NAME="method_summary"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Method Summary</B></FONT></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>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></CODE></FONT></TD><TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/JDBCTextFeatureWriter.html#addQuotes(java.lang.Object)">addQuotes</A></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> value)</CODE><BR> Adds quotes to an object for storage in postgis. </TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>protected void</CODE></FONT></TD><TD><CODE><B><A HREF="../../../../org/geotools/data/jdbc/JDBCTextFeatureWriter.html#doInsert(org.geotools.data.jdbc.MutableFIDFeature)">doInsert</A></B>(<A HREF="../../../../org/geotools/data/jdbc/MutableFIDFeature.html" title="class in org.geotools.data.jdbc">MutableFIDFeature</A> current)</CODE><BR> 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">⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -