mysqlgeomcolumn.html

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

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Creates the schema, a FeatureType of the attributes.</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/mysql/MysqlGeomColumn.html#populateData(int, java.lang.String)">populateData</A></B>(int&nbsp;geomID,
             <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;wellKnownText)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Stores the geometry information by geometry ID, so that it can be
 queried later.  </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/mysql/MysqlGeomColumn.html#removeData(int)">removeData</A></B>(int&nbsp;geomID)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Takes out a geometry according to its ID.</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/mysql/MysqlGeomColumn.html#setFeaTableCat(java.lang.String)">setFeaTableCat</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;catalog)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Setter method for feature catalog.</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/mysql/MysqlGeomColumn.html#setFeaTableName(java.lang.String)">setFeaTableName</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;name)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Setter method for feature table name.</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/mysql/MysqlGeomColumn.html#setFeaTableSchema(java.lang.String)">setFeaTableSchema</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;schema)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Setter method for feature schema.</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/mysql/MysqlGeomColumn.html#setGeomColName(java.lang.String)">setGeomColName</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;name)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Setter method for geometry column.</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/mysql/MysqlGeomColumn.html#setGeomTableCat(java.lang.String)">setGeomTableCat</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;catalog)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Setter method for geometry catalog.</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/mysql/MysqlGeomColumn.html#setGeomTableName(java.lang.String)">setGeomTableName</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;name)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Setter method for geometry table name.</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/mysql/MysqlGeomColumn.html#setGeomTableSchema(java.lang.String)">setGeomTableSchema</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;schema)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Setter method for geometry schema.</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/mysql/MysqlGeomColumn.html#setGeomType(int)">setGeomType</A></B>(int&nbsp;gType)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sets the Geometry type of the geometry column.</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/mysql/MysqlGeomColumn.html#setSchema(org.geotools.feature.FeatureType)">setSchema</A></B>(<A HREF="../../../../org/geotools/feature/FeatureType.html" title="interface in org.geotools.feature">FeatureType</A>&nbsp;schema)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sets the schema for this geometry column.</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/mysql/MysqlGeomColumn.html#setStorageType(int)">setStorageType</A></B>(int&nbsp;sType)</CODE>

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sets the type used for storage in the geometry column.</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="NORMALIZED_STORAGE_TYPE"><!-- --></A><H3>
NORMALIZED_STORAGE_TYPE</H3>
<PRE>
public static final int <B>NORMALIZED_STORAGE_TYPE</B></PRE>
<DL>
<DD>For get and set Storage type, see SFS for SQL spec
<P>
<DL>
<DT><B>See Also:</B><DD><A HREF="../../../../constant-values.html#org.geotools.data.mysql.MysqlGeomColumn.NORMALIZED_STORAGE_TYPE">Constant Field Values</A></DL>
</DL>
<HR>

<A NAME="WKB_STORAGE_TYPE"><!-- --></A><H3>
WKB_STORAGE_TYPE</H3>
<PRE>
public static final int <B>WKB_STORAGE_TYPE</B></PRE>
<DL>
<DD>For get and set Storage type, see SFS for SQL spec, the Well Known
 Binary
<P>
<DL>
<DT><B>See Also:</B><DD><A HREF="../../../../constant-values.html#org.geotools.data.mysql.MysqlGeomColumn.WKB_STORAGE_TYPE">Constant Field Values</A></DL>
</DL>
<HR>

<A NAME="GEOMETRY_META_NAME"><!-- --></A><H3>
GEOMETRY_META_NAME</H3>
<PRE>
public static final <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>GEOMETRY_META_NAME</B></PRE>
<DL>
<DD>From the SFS for SQL spec, always has the meta data
<P>
<DL>
<DT><B>See Also:</B><DD><A HREF="../../../../constant-values.html#org.geotools.data.mysql.MysqlGeomColumn.GEOMETRY_META_NAME">Constant Field Values</A></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="MysqlGeomColumn()"><!-- --></A><H3>
MysqlGeomColumn</H3>
<PRE>
public <B>MysqlGeomColumn</B>()</PRE>
<DL>
<DD>Default constructor
<P>
</DL>
<HR>

<A NAME="MysqlGeomColumn(java.lang.String, java.lang.String, java.lang.String)"><!-- --></A><H3>
MysqlGeomColumn</H3>
<PRE>
public <B>MysqlGeomColumn</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;feaTabName,
                       <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;feaGeomColumn,
                       <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;geomTabName)</PRE>
<DL>
<DD>Convenience constructor with the minimum meta information needed to do
 anything useful.
<P>
<DT><B>Parameters:</B><DD><CODE>feaTabName</CODE> - The name of the feature table for this geometry.<DD><CODE>feaGeomColumn</CODE> - The name of the column in the feature table that
        refers to the MysqlGeomColumn.<DD><CODE>geomTabName</CODE> - The name of the table holding the geometry data.</DL>
<HR>

<A NAME="MysqlGeomColumn(java.sql.Connection, java.lang.String)"><!-- --></A><H3>
MysqlGeomColumn</H3>
<PRE>
public <B>MysqlGeomColumn</B>(<A HREF="http://java.sun.com/j2se/1.4/docs/api/java/sql/Connection.html" title="class or interface in java.sql">Connection</A>&nbsp;dbConnection,
                       <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;feaTableName)
                throws <A HREF="http://java.sun.com/j2se/1.4/docs/api/java/sql/SQLException.html" title="class or interface in java.sql">SQLException</A>,
                       <A HREF="../../../../org/geotools/feature/SchemaException.html" title="class in org.geotools.feature">SchemaException</A></PRE>
<DL>
<DD>A convenience constructor, when you there is an open connection, and
 only using  flat features.  This constructor will not work with feature
 tables that contain multiple geometries as the query on the feature
 table will return multiple rows, which will be discarded.  For multiple
 geometries an array of MysqlGeomColumns must be created, each
 initialized with the default constructor, filling in the values through
 the accesssor functions.
<P>
<DT><B>Parameters:</B><DD><CODE>dbConnection</CODE> - An open connection to the database.<DD><CODE>feaTableName</CODE> - The feature table that references this Geometry Col.
<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> - if there were problems accessing the database.
<DD><CODE><A HREF="../../../../org/geotools/feature/SchemaException.html" title="class in org.geotools.feature">SchemaException</A></CODE> - if there were problems creating the schema.<DT><B>'TODO:'</B></DT>
  <DD>TODO: Get rid of this constructor, move the functionality outside.</DD>
</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="populateData(int, java.lang.String)"><!-- --></A><H3>
populateData</H3>
<PRE>
public void <B>populateData</B>(int&nbsp;geomID,
                         <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;wellKnownText)</PRE>
<DL>
<DD>Stores the geometry information by geometry ID, so that it can be
 queried later.  Currently only takes Well Known Text.  This should
 eventually change to Well Known Binary, possible stored as a bit
 stream?  And in time an overloaded populateData that allows for
 normalized SQL 92 storage.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>geomID</CODE> - the primary key for a row in the Geometry Table;<DD><CODE>wellKnownText</CODE> - the WKT representation of the geometry; tasks:
        TODO: Well Known Binary, and normalized SQL 92 (see SFS for for
        SQL spec 2.2.5)</DL>
</DD>
</DL>
<HR>

<A NAME="removeData(int)"><!-- --></A><H3>
removeData</H3>
<PRE>
public void <B>removeData</B>(int&nbsp;geomID)</PRE>
<DL>
<DD>Takes out a geometry according to its ID.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>geomID</CODE> - the primary key for a rwo in the Geometry Table</DL>
</DD>
</DL>
<HR>

<A NAME="getGeometry(int)"><!-- --></A><H3>
getGeometry</H3>
<PRE>
public <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> <B>getGeometry</B>(int&nbsp;geomID)
                     throws <A HREF="../../../../org/geotools/data/DataSourceException.html" title="class in org.geotools.data">DataSourceException</A></PRE>
<DL>
<DD>Returns a jts Geometry when queried with a geometry ID.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>geomID</CODE> - the ID of the feature geometry.
<DT><B>Returns:</B><DD>a jts geometry represention of the stored data, returns null is
         it is not found.
<DT><B>Throws:</B>
<DD><CODE><A HREF="../../../../org/geotools/data/DataSourceException.html" title="class in org.geotools.data">DataSourceException</A></CODE> - if there is trouble with the Database.</DL>
</DD>
</DL>
<HR>

<A NAME="setFeaTableCat(java.lang.String)"><!-- --></A><H3>
setFeaTableCat</H3>
<PRE>
public void <B>setFeaTableCat</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;catalog)</PRE>
<DL>
<DD>Setter method for feature catalog.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>catalog</CODE> - the name of the catalog.</DL>
</DD>
</DL>
<HR>

<A NAME="getFeaTableCat()"><!-- --></A><H3>
getFeaTableCat</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>getFeaTableCat</B>()</PRE>
<DL>
<DD>Getter method for Feature Catalog.
<P>
<DD><DL>

<DT><B>Returns:</B><DD>the name of the catalog.</DL>
</DD>
</DL>
<HR>

<A NAME="setFeaTableSchema(java.lang.String)"><!-- --></A><H3>
setFeaTableSchema</H3>
<PRE>
public void <B>setFeaTableSchema</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;schema)</PRE>
<DL>
<DD>Setter method for feature schema.
<P>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>schema</CODE> - the name of the schema.</DL>
</DD>
</DL>
<HR>