public class SimpleJdbcInsert extends AbstractJdbcInsert implements SimpleJdbcInsertOperations
The meta data processing is based on the DatabaseMetaData provided by the JDBC driver. As long as the JBDC driver can provide the names of the columns for a specified table than we can rely on this auto-detection feature. If that is not the case, then the column names must be specified explicitly.
The actual insert is being handled using Spring's
JdbcTemplate
.
Many of the configuration methods return the current instance of the SimpleJdbcInsert to provide the ability to string multiple ones together in a "fluid" interface style.
DatabaseMetaData
,
JdbcTemplate
logger
Constructor and Description |
---|
SimpleJdbcInsert(javax.sql.DataSource dataSource)
Constructor that takes one parameter with the JDBC DataSource to use when creating the
JdbcTemplate.
|
SimpleJdbcInsert(JdbcTemplate jdbcTemplate)
Alternative Constructor that takes one parameter with the JdbcTemplate to be used.
|
Modifier and Type | Method and Description |
---|---|
int |
execute(java.util.Map<java.lang.String,java.lang.Object> 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,java.lang.Object> 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,java.lang.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(java.util.Map<java.lang.String,java.lang.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.
|
SimpleJdbcInsert |
usingColumns(java.lang.String... columnNames)
Specify the column names that the insert statement should be limited to use.
|
SimpleJdbcInsert |
usingGeneratedKeyColumns(java.lang.String... columnNames)
Specify the name sof any columns that have auto generated keys.
|
SimpleJdbcInsert |
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.
|
SimpleJdbcInsert |
withSchemaName(java.lang.String schemaName)
Specify the shema name, if any, to be used for the insert.
|
SimpleJdbcInsert |
withTableName(java.lang.String tableName)
Specify the table name to be used for the insert.
|
checkCompiled, checkIfConfigurationModificationIsAllowed, compile, compileInternal, doExecute, doExecute, doExecuteAndReturnKey, doExecuteAndReturnKey, doExecuteAndReturnKeyHolder, doExecuteAndReturnKeyHolder, doExecuteBatch, doExecuteBatch, getCatalogName, getColumnNames, getGeneratedKeyNames, getInsertString, getInsertTypes, getJdbcTemplate, getSchemaName, getTableName, isCompiled, matchInParameterValuesWithInsertColumns, matchInParameterValuesWithInsertColumns, onCompileInternal, setAccessTableColumnMetaData, setCatalogName, setColumnNames, setGeneratedKeyName, setGeneratedKeyNames, setNativeJdbcExtractor, setOverrideIncludeSynonymsDefault, setSchemaName, setTableName
public SimpleJdbcInsert(javax.sql.DataSource dataSource)
dataSource
- the DataSource
to useJdbcAccessor.setDataSource(javax.sql.DataSource)
public SimpleJdbcInsert(JdbcTemplate jdbcTemplate)
jdbcTemplate
- the JdbcTemplate
to useJdbcAccessor.setDataSource(javax.sql.DataSource)
public SimpleJdbcInsert withTableName(java.lang.String tableName)
SimpleJdbcInsertOperations
withTableName
in interface SimpleJdbcInsertOperations
tableName
- the name of the stored tablepublic SimpleJdbcInsert withSchemaName(java.lang.String schemaName)
SimpleJdbcInsertOperations
withSchemaName
in interface SimpleJdbcInsertOperations
schemaName
- the name of the schemapublic SimpleJdbcInsert withCatalogName(java.lang.String catalogName)
SimpleJdbcInsertOperations
withCatalogName
in interface SimpleJdbcInsertOperations
catalogName
- the name of the catalogpublic SimpleJdbcInsert usingColumns(java.lang.String... columnNames)
SimpleJdbcInsertOperations
usingColumns
in interface SimpleJdbcInsertOperations
columnNames
- one or more column namespublic SimpleJdbcInsert usingGeneratedKeyColumns(java.lang.String... columnNames)
SimpleJdbcInsertOperations
usingGeneratedKeyColumns
in interface SimpleJdbcInsertOperations
columnNames
- one or more column namespublic SimpleJdbcInsertOperations withoutTableColumnMetaDataAccess()
SimpleJdbcInsertOperations
withoutTableColumnMetaDataAccess
in interface SimpleJdbcInsertOperations
public SimpleJdbcInsertOperations includeSynonymsForTableColumnMetaData()
SimpleJdbcInsertOperations
includeSynonymsForTableColumnMetaData
in interface SimpleJdbcInsertOperations
public SimpleJdbcInsertOperations useNativeJdbcExtractorForMetaData(NativeJdbcExtractor nativeJdbcExtractor)
SimpleJdbcInsertOperations
useNativeJdbcExtractorForMetaData
in interface SimpleJdbcInsertOperations
public int execute(java.util.Map<java.lang.String,java.lang.Object> args)
SimpleJdbcInsertOperations
execute
in interface SimpleJdbcInsertOperations
args
- Map containing column names and corresponding valuepublic int execute(SqlParameterSource parameterSource)
SimpleJdbcInsertOperations
execute
in interface SimpleJdbcInsertOperations
parameterSource
- SqlParameterSource containing values to use for insertpublic java.lang.Number executeAndReturnKey(java.util.Map<java.lang.String,java.lang.Object> args)
SimpleJdbcInsertOperations
executeAndReturnKey
in interface SimpleJdbcInsertOperations
args
- Map containing column names and corresponding valuepublic java.lang.Number executeAndReturnKey(SqlParameterSource parameterSource)
SimpleJdbcInsertOperations
executeAndReturnKey
in interface SimpleJdbcInsertOperations
parameterSource
- SqlParameterSource containing values to use for insertpublic KeyHolder executeAndReturnKeyHolder(java.util.Map<java.lang.String,java.lang.Object> args)
SimpleJdbcInsertOperations
executeAndReturnKeyHolder
in interface SimpleJdbcInsertOperations
args
- Map containing column names and corresponding valuepublic KeyHolder executeAndReturnKeyHolder(SqlParameterSource parameterSource)
SimpleJdbcInsertOperations
executeAndReturnKeyHolder
in interface SimpleJdbcInsertOperations
parameterSource
- SqlParameterSource containing values to use for insertpublic int[] executeBatch(java.util.Map<java.lang.String,java.lang.Object>[] batch)
SimpleJdbcInsertOperations
executeBatch
in interface SimpleJdbcInsertOperations
batch
- an array of Maps containing a batch of column names and corresponding valuepublic int[] executeBatch(SqlParameterSource[] batch)
SimpleJdbcInsertOperations
executeBatch
in interface SimpleJdbcInsertOperations
batch
- an array of SqlParameterSource containing values for the batch