public interface SimpleJdbcInsertOperations
SimpleJdbcInsert
.
This interface is not often used directly, but provides the option to enhance testability,
as it can easily be mocked or stubbed.Modifier and Type | Method and Description |
---|---|
int |
execute(java.util.Map<java.lang.String,?> args)
Execute the insert using the values passed in.
|
int |
execute(SqlParameterSource parameterSource)
Execute the insert using the values passed in.
|
java.lang.Number |
executeAndReturnKey(java.util.Map<java.lang.String,?> args)
Execute the insert using the values passed in and return the generated key.
|
java.lang.Number |
executeAndReturnKey(SqlParameterSource parameterSource)
Execute the insert using the values passed in and return the generated key.
|
KeyHolder |
executeAndReturnKeyHolder(java.util.Map<java.lang.String,?> 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(java.util.Map<java.lang.String,?>... 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(java.lang.String... columnNames)
Specify the column names that the insert statement should be limited to use.
|
SimpleJdbcInsertOperations |
usingGeneratedKeyColumns(java.lang.String... columnNames)
Specify the names of any columns that have auto generated keys.
|
SimpleJdbcInsertOperations |
withCatalogName(java.lang.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(java.lang.String schemaName)
Specify the schema name, if any, to be used for the insert.
|
SimpleJdbcInsertOperations |
withTableName(java.lang.String tableName)
Specify the table name to be used for the insert.
|
SimpleJdbcInsertOperations withTableName(java.lang.String tableName)
tableName
- the name of the stored tableSimpleJdbcInsertOperations withSchemaName(java.lang.String schemaName)
schemaName
- the name of the schemaSimpleJdbcInsertOperations withCatalogName(java.lang.String catalogName)
catalogName
- the name of the catalogSimpleJdbcInsertOperations usingColumns(java.lang.String... columnNames)
columnNames
- one or more column namesSimpleJdbcInsertOperations usingGeneratedKeyColumns(java.lang.String... columnNames)
columnNames
- one or more column namesSimpleJdbcInsertOperations withoutTableColumnMetaDataAccess()
SimpleJdbcInsertOperations includeSynonymsForTableColumnMetaData()
Note: This is only necessary to include for Oracle since other databases supporting synonyms seems to include the synonyms automatically.
SimpleJdbcInsertOperations useNativeJdbcExtractorForMetaData(NativeJdbcExtractor nativeJdbcExtractor)
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.
int execute(java.util.Map<java.lang.String,?> args)
args
- Map containing column names and corresponding valueint execute(SqlParameterSource parameterSource)
parameterSource
- SqlParameterSource containing values to use for insertjava.lang.Number executeAndReturnKey(java.util.Map<java.lang.String,?> args)
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.
args
- Map containing column names and corresponding valuejava.lang.Number executeAndReturnKey(SqlParameterSource parameterSource)
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.
parameterSource
- SqlParameterSource containing values to use for insertKeyHolder executeAndReturnKeyHolder(java.util.Map<java.lang.String,?> args)
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.
args
- Map containing column names and corresponding valueKeyHolder executeAndReturnKeyHolder(SqlParameterSource parameterSource)
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.
parameterSource
- SqlParameterSource containing values to use for insertint[] executeBatch(java.util.Map<java.lang.String,?>... batch)
batch
- an array of Maps containing a batch of column names and corresponding valueint[] executeBatch(SqlParameterSource... batch)
batch
- an array of SqlParameterSource containing values for the batch