org.springframework.jdbc.core.simple
Interface SimpleJdbcInsertOperations

All Known Implementing Classes:
SimpleJdbcInsert

public interface SimpleJdbcInsertOperations

Interface specifying the API for a Simple JDBC Insert implemented by SimpleJdbcInsert. This interface is not often used directly, but provides the option to enhance testability, as it can easily be mocked or stubbed.

Since:
2.5
Author:
Thomas Risberg

Method Summary
 int execute(Map<String,Object> args)
          Execute the insert using the values passed in.
 int execute(SqlParameterSource parameterSource)
          Execute the insert using the values passed in.
 Number executeAndReturnKey(Map<String,Object> args)
          Execute the insert using the values passed in and return the generated key.
 Number executeAndReturnKey(SqlParameterSource parameterSource)
          Execute the insert using the values passed in and return the generated key.
 KeyHolder executeAndReturnKeyHolder(Map<String,Object> args)
          Execute the insert using the values passed in and return the generated keys.
 KeyHolder executeAndReturnKeyHolder(SqlParameterSource parameterSource)
          Execute the insert using the values passed in and return the generated keys.
 int[] executeBatch(Map<String,Object>[] batch)
          Execute a batch insert using the batch of values passed in.
 int[] executeBatch(SqlParameterSource[] batch)
          Execute a batch insert using the batch of values passed in.
 SimpleJdbcInsertOperations includeSynonymsForTableColumnMetaData()
          Include synonyms for the column meta data lookups via JDBC.
 SimpleJdbcInsertOperations useNativeJdbcExtractorForMetaData(NativeJdbcExtractor nativeJdbcExtractor)
          Use a the provided NativeJdbcExtractor during the column meta data lookups via JDBC.
 SimpleJdbcInsertOperations usingColumns(String... columnNames)
          Specify the column names that the insert statement should be limited to use.
 SimpleJdbcInsertOperations usingGeneratedKeyColumns(String... columnNames)
          Specify the name sof any columns that have auto generated keys.
 SimpleJdbcInsertOperations withCatalogName(String catalogName)
          Specify the catalog name, if any, to be used for the insert.
 SimpleJdbcInsertOperations withoutTableColumnMetaDataAccess()
          Turn off any processing of column meta data information obtained via JDBC.
 SimpleJdbcInsertOperations withSchemaName(String schemaName)
          Specify the shema name, if any, to be used for the insert.
 SimpleJdbcInsertOperations withTableName(String tableName)
          Specify the table name to be used for the insert.
 

Method Detail

withTableName

SimpleJdbcInsertOperations withTableName(String tableName)
Specify the table name to be used for the insert.

Parameters:
tableName - the name of the stored table
Returns:
the instance of this SimpleJdbcInsert

withSchemaName

SimpleJdbcInsertOperations withSchemaName(String schemaName)
Specify the shema name, if any, to be used for the insert.

Parameters:
schemaName - the name of the schema
Returns:
the instance of this SimpleJdbcInsert

withCatalogName

SimpleJdbcInsertOperations withCatalogName(String catalogName)
Specify the catalog name, if any, to be used for the insert.

Parameters:
catalogName - the name of the catalog
Returns:
the instance of this SimpleJdbcInsert

usingColumns

SimpleJdbcInsertOperations usingColumns(String... columnNames)
Specify the column names that the insert statement should be limited to use.

Parameters:
columnNames - one or more column names
Returns:
the instance of this SimpleJdbcInsert

usingGeneratedKeyColumns

SimpleJdbcInsertOperations usingGeneratedKeyColumns(String... columnNames)
Specify the name sof any columns that have auto generated keys.

Parameters:
columnNames - one or more column names
Returns:
the instance of this SimpleJdbcInsert

withoutTableColumnMetaDataAccess

SimpleJdbcInsertOperations withoutTableColumnMetaDataAccess()
Turn off any processing of column meta data information obtained via JDBC.

Returns:
the instance of this SimpleJdbcInsert

includeSynonymsForTableColumnMetaData

SimpleJdbcInsertOperations includeSynonymsForTableColumnMetaData()
Include synonyms for the column meta data lookups via JDBC. Note: this is only necessary to include for Oracle since other databases supporting synonyms seems to include the synonyms automatically.

Returns:
the instance of this SimpleJdbcInsert

useNativeJdbcExtractorForMetaData

SimpleJdbcInsertOperations useNativeJdbcExtractorForMetaData(NativeJdbcExtractor nativeJdbcExtractor)
Use a the provided NativeJdbcExtractor during the column meta data lookups via JDBC. Note: this is only necessary to include when running with a connection pool that wraps the meta data connection and when using a database like Oracle where it is necessary to access the native connection to include synonyms.

Returns:
the instance of this SimpleJdbcInsert

execute

int execute(Map<String,Object> args)
Execute the insert using the values passed in.

Parameters:
args - Map containing column names and corresponding value
Returns:
the number of rows affected as returned by the JDBC driver

execute

int execute(SqlParameterSource parameterSource)
Execute the insert using the values passed in.

Parameters:
parameterSource - SqlParameterSource containing values to use for insert
Returns:
the number of rows affected as returned by the JDBC driver

executeAndReturnKey

Number executeAndReturnKey(Map<String,Object> args)
Execute the insert using the values passed in and return the generated key. This requires that the name of the columns with auto generated keys have been specified. This method will always return a key or throw an exception if a key was not returned.

Parameters:
args - Map containing column names and corresponding value
Returns:
the generated key value

executeAndReturnKey

Number executeAndReturnKey(SqlParameterSource parameterSource)
Execute the insert using the values passed in and return the generated key. This requires that the name of the columns with auto generated keys have been specified. This method will always return a key or throw an exception if a key was not returned.

Parameters:
parameterSource - SqlParameterSource containing values to use for insert
Returns:
the generated key value.

executeAndReturnKeyHolder

KeyHolder executeAndReturnKeyHolder(Map<String,Object> args)
Execute the insert using the values passed in and return the generated keys. This requires that the name of the columns with auto generated keys have been specified. This method will always return a KeyHolder but the caller must verify that it actually contains the generated keys.

Parameters:
args - Map containing column names and corresponding value
Returns:
the KeyHolder containing all generated keys

executeAndReturnKeyHolder

KeyHolder executeAndReturnKeyHolder(SqlParameterSource parameterSource)
Execute the insert using the values passed in and return the generated keys. This requires that the name of the columns with auto generated keys have been specified. This method will always return a KeyHolder but the caller must verify that it actually contains the generated keys.

Parameters:
parameterSource - SqlParameterSource containing values to use for insert
Returns:
the KeyHolder containing all generated keys

executeBatch

int[] executeBatch(Map<String,Object>[] batch)
Execute a batch insert using the batch of values passed in.

Parameters:
batch - an array of Maps containing a batch of column names and corresponding value
Returns:
the array of number of rows affected as returned by the JDBC driver

executeBatch

int[] executeBatch(SqlParameterSource[] batch)
Execute a batch insert using the batch of values passed in.

Parameters:
batch - an array of SqlParameterSource containing values for the batch
Returns:
the array of number of rows affected as returned by the JDBC driver