Package org.gvsig.fmap.dal.store.mdb

Class MDBSQLBuilder

java.lang.Object
org.gvsig.fmap.dal.feature.spi.SQLBuilderBase
org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase
org.gvsig.fmap.dal.store.mdb.MDBSQLBuilder
All Implemented Interfaces:
org.gvsig.expressionevaluator.ExpressionBuilder.Visitable, org.gvsig.fmap.dal.SQLBuilder
public class MDBSQLBuilder extends org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

  • Nested Class Summary

    Nested Classes
    Modifier and Type
    Class
    Description
    class 
    MDBSQLBuilder.DisposableClobs
     
    protected class 
    MDBSQLBuilder.MDBAlterTableBuilderBase
     
    class 
    MDBSQLBuilder.MDBCreateIndexBuilder
     
    protected class 
    MDBSQLBuilder.MDBCreateTableBuilder
     
    class 
    MDBSQLBuilder.MDBInsertBuilderBase
     
    class 
    MDBSQLBuilder.MDBInsertColumnBuilderBase
     
    class 
    MDBSQLBuilder.MDBSelectBuilderBase
     
    class 
    MDBSQLBuilder.MDBSelectColumnBuilderBase
     
    class 
    MDBSQLBuilder.MDBTableNameBuilderBase
     

    Nested classes/interfaces inherited from class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatement, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AbstractStatementPart, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.AlterTableBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.ColumnBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.ColumnDescriptorBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.CountBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.CreateIndexBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.CreateTableBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.DeleteBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.DropIndexBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.DropTableBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.FromBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.GrantBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.GrantRoleBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.InsertBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.InsertColumnBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.JoinBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.MergeBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.OrderByBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.SelectBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.SelectColumnBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.TableNameBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.UpdateBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.UpdateColumnBuilderBase, org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.UpdateTableStatisticsBuilderBase

    Nested classes/interfaces inherited from interface org.gvsig.fmap.dal.SQLBuilder

    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder, org.gvsig.fmap.dal.SQLBuilder.Column, org.gvsig.fmap.dal.SQLBuilder.ColumnDescriptor, org.gvsig.fmap.dal.SQLBuilder.CountBuilder, org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder, org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder, org.gvsig.fmap.dal.SQLBuilder.DeleteBuilder, org.gvsig.fmap.dal.SQLBuilder.DropIndexBuilder, org.gvsig.fmap.dal.SQLBuilder.DropTableBuilder, org.gvsig.fmap.dal.SQLBuilder.FromBuilder, org.gvsig.fmap.dal.SQLBuilder.GrantBuilder, org.gvsig.fmap.dal.SQLBuilder.GrantRoleBuilder, org.gvsig.fmap.dal.SQLBuilder.InsertBuilder, org.gvsig.fmap.dal.SQLBuilder.InsertColumnBuilder, org.gvsig.fmap.dal.SQLBuilder.JoinBuilder, org.gvsig.fmap.dal.SQLBuilder.MergeBuilder, org.gvsig.fmap.dal.SQLBuilder.OrderByBuilder, org.gvsig.fmap.dal.SQLBuilder.Privilege, org.gvsig.fmap.dal.SQLBuilder.SelectBuilder, org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder, org.gvsig.fmap.dal.SQLBuilder.Statement, org.gvsig.fmap.dal.SQLBuilder.StatementPart, org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder, org.gvsig.fmap.dal.SQLBuilder.UpdateBuilder, org.gvsig.fmap.dal.SQLBuilder.UpdateColumnBuilder, org.gvsig.fmap.dal.SQLBuilder.UpdateTableStatisticsBuilder

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    protected org.gvsig.expressionevaluator.Formatter
    formatter
     

    Fields inherited from class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

    helper

    Fields inherited from class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    aggregateFunctionNames, allowAutomaticValues, alter_table, constant_false, constant_true, create_index, create_table, defaultSchema, delete, drop_index, drop_table, expressionBuilder, geometrySupportType, grant, hasSpatialFunctions, insert, LOGGER, merge, select, STMT_DELETE_FROM_table, STMT_DELETE_FROM_table_WHERE_expresion, STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_schema_table, STMT_DELETE_GEOMETRY_COLUMN_FROM_TABLE_table, STMT_DROP_TABLE_table, STMT_GRANT_privileges_ON_table_TO_role, STMT_INSERT_INTO_table_columns_VALUES_values, STMT_MERGE_INTO_table_KEY_column_columns_VALUES_values, STMT_UPDATE_table_SET_columnsAndValues, STMT_UPDATE_table_SET_columnsAndValues_WHERE_expresion, STMT_UPDATE_TABLE_STATISTICS_table, supportSchemas, table_name, type_boolean, type_byte, type_bytearray, type_char, type_date, type_decimal_p, type_decimal_ps, type_double, type_FILE, type_float, type_FOLDER, type_geometry, type_int, type_long, type_string, type_string_0, type_string_p, type_time, type_timestamp, type_URI, type_URL, type_version, update, update_table_statistics

    Fields inherited from interface org.gvsig.fmap.dal.SQLBuilder

    DEFAULT_RECOMENDED_SQL_LENGTH, FEATURE_ATTRIBUTE_DESCRIPTOR, PROP_ADD_TABLE_NAME_TO_COLUMNS, PROP_FEATURE_TYPE, PROP_JDBCHELPER, PROP_QUERY, PROP_SQLBUILDER, PROP_SYMBOLTABLE, PROP_TABLE, PROP_TABLENAME

  • Constructor Summary

    Constructors
    Constructor
    Description
    MDBSQLBuilder(MDBHelper helper)
     

  • Method Summary

    Modifier and Type
    Method
    Description
    String
    as_identifier(String id)
     
    org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder
    createAlterTableBuilder()
     
    org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder
    createCreateIndexBuilder()
     
    protected org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder
    createCreateTableBuilder()
     
    org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.InsertBuilderBase
    createInsertBuilder()
     
    org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.InsertColumnBuilderBase
    createInsertColumnBuilder()
     
    org.gvsig.fmap.dal.SQLBuilder.SelectBuilder
    createSelectBuilder()
     
    protected org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder
    createSelectColumnBuilder()
     
    org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder
    createTableNameBuilder()
     
    org.gvsig.expressionevaluator.Formatter
    formatter()
     
    MDBHelper
    getHelper()
     
    List<Object>
    getParameters(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)
     
    List<org.gvsig.expressionevaluator.ExpressionBuilder.Parameter>
    parametersWithoutSRS()
     
    org.gvsig.tools.dispose.Disposable
    setParameters(PreparedStatement st, org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)
     
    org.gvsig.tools.dispose.Disposable
    setStatementParameters(PreparedStatement st, List values, org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType)
     
    Object
    sqlgeometrydimension(int type, int subtype)
     
    Object
    sqlgeometrynumdimension(int type, int subtype)
     
    Object
    sqlgeometrytype(int geomtype, int geomsubtype)
     
    String
    sqltype(int type, int size, int precision, int scale, int geomtype, int geomSubtype)
     

    Methods inherited from class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

    debug_setStatementParameters, forceGeometryType, getGeometryManager, getNativeBytes, getParameters, setParameters, setParameters, setStatementParameters, setStatementValue, srs_id

    Methods inherited from class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    accept, alter_table, as_clob, as_string, as_string, as_string, as_string, as_string, column, column, column, column_from, column_from, count, create_index, create_table, createDeleteBuilder, createDropIndexBuilder, createDropTableBuilder, createExpressionBuilder, createFromBuilder, createGrantBuilder, createGrantRoleBuilder, createJoin, createMergeBuilder, createOrderByBuilder, createUpdateBuilder, createUpdateColumnBuilder, createUpdateTableStatisticsBuilder, default_schema, delete, drop_index, drop_table, expression, geometry_support_type, getConstrainName, getMaxRecomendedSQLLength, grant, has_spatial_functions, insert, isAggregateFunction, merge, parameters, parameters_names, quote_for_identifiers, quote_for_strings, select, setProperties, setProperties, support_schemas, table_name, toString, toString, update, update_table_statistics, variables, variables_names

    Methods inherited from class java.lang.Object

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

  • Field Details

    • formatter

      protected org.gvsig.expressionevaluator.Formatter formatter

  • Constructor Details

    • MDBSQLBuilder

      public MDBSQLBuilder(MDBHelper helper)

  • Method Details

    • formatter

      public org.gvsig.expressionevaluator.Formatter formatter()
      Specified by:
      formatter in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      formatter in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • sqlgeometrydimension

      public Object sqlgeometrydimension(int type, int subtype)
      Specified by:
      sqlgeometrydimension in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      sqlgeometrydimension in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • sqltype

      public String sqltype(int type, int size, int precision, int scale, int geomtype, int geomSubtype)
      Specified by:
      sqltype in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      sqltype in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • sqlgeometrytype

      public Object sqlgeometrytype(int geomtype, int geomsubtype)
      Specified by:
      sqlgeometrytype in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      sqlgeometrytype in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • sqlgeometrynumdimension

      public Object sqlgeometrynumdimension(int type, int subtype)

    • getHelper

      public MDBHelper getHelper()
      Overrides:
      getHelper in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

    • setParameters

      public org.gvsig.tools.dispose.Disposable setParameters(PreparedStatement st, org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)
      Overrides:
      setParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase

    • parametersWithoutSRS

      public List<org.gvsig.expressionevaluator.ExpressionBuilder.Parameter> parametersWithoutSRS()

    • createInsertColumnBuilder

      public org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.InsertColumnBuilderBase createInsertColumnBuilder()
      Overrides:
      createInsertColumnBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createInsertBuilder

      public org.gvsig.fmap.dal.feature.spi.SQLBuilderBase.InsertBuilderBase createInsertBuilder()
      Overrides:
      createInsertBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createAlterTableBuilder

      public org.gvsig.fmap.dal.SQLBuilder.AlterTableBuilder createAlterTableBuilder()
      Overrides:
      createAlterTableBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createTableNameBuilder

      public org.gvsig.fmap.dal.SQLBuilder.TableNameBuilder createTableNameBuilder()
      Specified by:
      createTableNameBuilder in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      createTableNameBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createCreateTableBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.CreateTableBuilder createCreateTableBuilder()
      Overrides:
      createCreateTableBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createSelectBuilder

      public org.gvsig.fmap.dal.SQLBuilder.SelectBuilder createSelectBuilder()
      Specified by:
      createSelectBuilder in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      createSelectBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createSelectColumnBuilder

      protected org.gvsig.fmap.dal.SQLBuilder.SelectColumnBuilder createSelectColumnBuilder()
      Overrides:
      createSelectColumnBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • createCreateIndexBuilder

      public org.gvsig.fmap.dal.SQLBuilder.CreateIndexBuilder createCreateIndexBuilder()
      Overrides:
      createCreateIndexBuilder in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • as_identifier

      public String as_identifier(String id)
      Specified by:
      as_identifier in interface org.gvsig.fmap.dal.SQLBuilder
      Overrides:
      as_identifier in class org.gvsig.fmap.dal.feature.spi.SQLBuilderBase

    • setStatementParameters

      public org.gvsig.tools.dispose.Disposable setStatementParameters(PreparedStatement st, List values, org.gvsig.expressionevaluator.GeometryExpressionBuilderHelper.GeometrySupportType geometrySupportType) throws SQLException
      Overrides:
      setStatementParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase
      Throws:
      SQLException

    • getParameters

      public List<Object> getParameters(org.gvsig.fmap.dal.feature.spi.FeatureProvider feature)
      Overrides:
      getParameters in class org.gvsig.fmap.dal.store.jdbc2.spi.JDBCSQLBuilderBase