| java.lang.Object
 org.geotools.data.oracle.SqlStatementEncoder
| SqlStatementEncoder | | final class SqlStatementEncoder (Code) | | Provides SQL encoding functions for the Oracle Datasource
author:
Sean Geoghegan, Defence Science and Technology Organisation
author:
$Author: seangeo $
version:
$Id: SqlStatementEncoder.java 27862 2007-11-12 19:51:19Z desruisseaux $ Last Modified: $Date: 2003/11/05 00:53:37 $ |
| Inner Class :static class TypeMapping | |
| TYPE_MAPPINGS | | final protected static TypeMapping TYPE_MAPPINGS(Code) | | |
| SqlStatementEncoder | | SqlStatementEncoder(SQLEncoder whereEncoder, String tablename, String fidColumn)(Code) | | Creates a new SQL Statement encoder.
Parameters:
whereEncoder - This in the encoder used for where clauses.
Parameters:
tablename - This the table name to use in SQL statements.
Parameters:
fidColumn - The fid column for the table. |
| makeCreateTableSQL | | String makeCreateTableSQL(FeatureType schema)(Code) | | Creates a table for the provided schema.
CREATE TABLE tableName (fidColumn int, att1 type1, att2 type2, .... )
You should consider calling makeCreateIndexSQL to set up for fid based
indexing, and we should have something for spatial indexes.
Parameters:
schema - SQL used to create the table |
| makeInsertSQL | | String makeInsertSQL(FeatureType featureType)(Code) | | Constructs an Insert SQL statement template for this feature type.
Parameters:
featureType - The feature type to construct the statement for. The SQL insert template. The FID column will always be first, followed by eachfeature attribute. The VALUES section will contain ?'s for each attribute of thefeature type. |
| makeModifyTemplate | | String makeModifyTemplate(AttributeType[] attributeTypes)(Code) | | Makes a template SQL statement for use in an update prepared statement. The template will
have the form: UPDATE <tablename> SET <type> = ?
Parameters:
attributeTypes - The feature attributes that are being updated. An SQL template. |
| makeSelectSQL | | String makeSelectSQL(AttributeType[] attrTypes, Filter filter, int maxFeatures, boolean useMax) throws SQLEncoderException(Code) | | Makes an SQL statement for getFeatures. Constructs an SQL statement that will select the
features from the table based on the filter.
Parameters:
attrTypes - The Attribute types for the select statement
Parameters:
filter - The filter to convert to a where statement.
Parameters:
maxFeatures - The max amount of features to return.
Parameters:
useMax - True if we are to use the maxFeature as the max. An SQL statement.
throws:
SQLEncoderException - If an error occurs encoding the SQL |
| makeType | | String makeType(Class type)(Code) | | Map from Java type space to Oracle typespace - for use by createTableSQL
|
|
|