Package oracle.spatial.network.nfe.io.jdbc.dao

Class SpatialDAO

java.lang.Object

oracle.spatial.network.nfe.io.jdbc.dao.AbstractDAO

oracle.spatial.network.nfe.io.jdbc.dao.SpatialDAO

public class SpatialDAO
extends AbstractDAO

The SpatialDAO data access object provides methods to load, create and manage spatial related data. It is not recommended to use the data access objects methods, instead use the NFE services.

Field Summary

Fields inherited from class oracle.spatial.network.nfe.io.jdbc.dao.AbstractDAO

conn

Constructor Summary

Constructors

Constructor	Description
SpatialDAO(java.sql.Connection conn, NFEModel model)	Creates a SpatialDAO with the specified connection and model.

Method Summary

Modifier and Type	Method	Description
void	createNFEGeometryMetadata(java.lang.String tableName, java.lang.String geomColumn, NFEGeometryDescriptor geomDesc)	Creates a spatial geometry metadata.
void	createSpatialIndex(java.lang.String indexName, java.lang.String tableName, java.lang.String spatialColumn)	Creates the spatial index.
void	createStyle(oracle.sdovis.style.Style style, java.lang.String styleName)	Creates a style record in the view user_sdo_styles.
void	deleteStyle(NFEFeatureClass nfeFeatureClass)	Deletes the styles related to the specified feature class.
void	deleteStyles(NFEFeatureLayer nfeFeatureLayer)	Deletes the styles related to the specified feature layer.
JGeometry	fetchGeometryLayerMBR(java.lang.String tableName, java.lang.String geomColumnName)	Returns the minimum bounding rectangle (MBR) of the geometries in the specified table and column.
NFEGeometryDescriptor	fetchGeometryMetadata(java.lang.String tableName, java.lang.String columnName)	Returns the metadata information for the specified geometry column.
oracle.sdovis.SRS	fetchSRS(long srid)	Returns the spatial reference system (SRS) referred by the specified Spatial Reference System Identifier (SRID).
void	updateStyle(oracle.sdovis.style.Style style, java.lang.String styleName)	Updates the style record of the specified style in the view user_sdo_styles.

Methods inherited from class oracle.spatial.network.nfe.io.jdbc.dao.AbstractDAO

close, close, execute, execute, executeQuery, executeUpdate, getConnection, getModel, getSQLValidator

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SpatialDAO

public SpatialDAO(java.sql.Connection conn,
                  NFEModel model)

Creates a SpatialDAO with the specified connection and model.

Parameters:

conn - connection

model - model

Method Detail

fetchGeometryMetadata

public NFEGeometryDescriptor fetchGeometryMetadata(java.lang.String tableName,
                                                   java.lang.String columnName)
                                            throws NFEIOException

Returns the metadata information for the specified geometry column. The information is store in the view user_sdo_geom_metadata.

Parameters:

tableName - column's table

columnName - geometry column name

Returns:

the metadata information for the specified geometry column

Throws:

NFEIOException - if an NFE error occurs.

createNFEGeometryMetadata

public void createNFEGeometryMetadata(java.lang.String tableName,
                                      java.lang.String geomColumn,
                                      NFEGeometryDescriptor geomDesc)
                               throws NFEIOException

Creates a spatial geometry metadata.

Parameters:

tableName - column's table

geomColumn - the geometry column name

geomDesc - geometry descriptor used to access the SRID and the dimensions.

Throws:

NFEIOException - if an NFE error occurs.

createSpatialIndex

public void createSpatialIndex(java.lang.String indexName,
                               java.lang.String tableName,
                               java.lang.String spatialColumn)
                        throws NFEIOException

Creates the spatial index.

Parameters:

indexName - index name

tableName - index table name

spatialColumn - index geometry column

Throws:

NFEIOException - if an NFE error occurs.

createStyle

public void createStyle(oracle.sdovis.style.Style style,
                        java.lang.String styleName)
                 throws NFEIOException

Creates a style record in the view user_sdo_styles.

Parameters:

style - style

styleName - style name

Throws:

NFEIOException - if an NFE error occurs.

updateStyle

public void updateStyle(oracle.sdovis.style.Style style,
                        java.lang.String styleName)
                 throws NFEIOException

Updates the style record of the specified style in the view user_sdo_styles.

Parameters:

style - style

styleName - style name

Throws:

NFEIOException - if an NFE error occurs.

deleteStyles

public void deleteStyles(NFEFeatureLayer nfeFeatureLayer)
                  throws NFEIOException

Deletes the styles related to the specified feature layer. The styles with the name following the pattern [featureLayerId]_[featureClassId]_STYLE will be deleted.

Parameters:

nfeFeatureLayer - feature layer

Throws:

NFEIOException - if an NFE error occurs.

deleteStyle

public void deleteStyle(NFEFeatureClass nfeFeatureClass)
                 throws NFEIOException

Deletes the styles related to the specified feature class. The styles with the name following the pattern [featureLayerId]_[featureClassId]_STYLE will be deleted.

Parameters:

nfeFeatureClass - feature class

Throws:

NFEIOException - if an NFE error occurs.

fetchGeometryLayerMBR

public JGeometry fetchGeometryLayerMBR(java.lang.String tableName,
                                       java.lang.String geomColumnName)
                                throws NFEIOException

Returns the minimum bounding rectangle (MBR) of the geometries in the specified table and column.

Parameters:

tableName - table name

geomColumnName - geometry column name

Returns:

minimum bounding rectangle (MBR) geometry

Throws:

NFEIOException - if an NFE error occurs.

fetchSRS

public oracle.sdovis.SRS fetchSRS(long srid)
                           throws NFEIOException

Returns the spatial reference system (SRS) referred by the specified Spatial Reference System Identifier (SRID).

Parameters:

srid - SRID

Returns:

the spatial reference system (SRS) referred by the specified Spatial Reference System Identifier (SRID)

Throws:

NFEIOException - if an NFE error occurs.