|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectorg.springframework.jdbc.core.simple.AbstractJdbcInsert
org.springframework.jdbc.core.simple.SimpleJdbcInsert
public class SimpleJdbcInsert
A SimpleJdbcInsert is a multi-threaded, reusable object providing easy insert capabilities for a table. It provides meta data processing to simplify the code needed to construct a basic insert statement. All you need to provide is the name of the table and a Map containing the column names and the column values.
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| Field Summary |
|---|
| Fields inherited from class org.springframework.jdbc.core.simple.AbstractJdbcInsert |
|---|
logger |
| Constructor Summary | |
|---|---|
SimpleJdbcInsert(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. |
|
| 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. |
SimpleJdbcInsert |
usingColumns(String... columnNames)
Specify the column names that the insert statement should be limited to use. |
SimpleJdbcInsert |
usingGeneratedKeyColumns(String... columnNames)
Specify the name sof any columns that have auto generated keys. |
SimpleJdbcInsert |
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. |
SimpleJdbcInsert |
withSchemaName(String schemaName)
Specify the shema name, if any, to be used for the insert. |
SimpleJdbcInsert |
withTableName(String tableName)
Specify the table name to be used for the insert. |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Constructor Detail |
|---|
public SimpleJdbcInsert(DataSource dataSource)
dataSource - the DataSource to useJdbcAccessor.setDataSource(javax.sql.DataSource)public SimpleJdbcInsert(JdbcTemplate jdbcTemplate)
jdbcTemplate - the JdbcTemplate to useJdbcAccessor.setDataSource(javax.sql.DataSource)| Method Detail |
|---|
public SimpleJdbcInsert withTableName(String tableName)
SimpleJdbcInsertOperations
withTableName in interface SimpleJdbcInsertOperationstableName - the name of the stored table
public SimpleJdbcInsert withSchemaName(String schemaName)
SimpleJdbcInsertOperations
withSchemaName in interface SimpleJdbcInsertOperationsschemaName - the name of the schema
public SimpleJdbcInsert withCatalogName(String catalogName)
SimpleJdbcInsertOperations
withCatalogName in interface SimpleJdbcInsertOperationscatalogName - the name of the catalog
public SimpleJdbcInsert usingColumns(String... columnNames)
SimpleJdbcInsertOperations
usingColumns in interface SimpleJdbcInsertOperationscolumnNames - one or more column names
public SimpleJdbcInsert usingGeneratedKeyColumns(String... columnNames)
SimpleJdbcInsertOperations
usingGeneratedKeyColumns in interface SimpleJdbcInsertOperationscolumnNames - one or more column names
public SimpleJdbcInsertOperations withoutTableColumnMetaDataAccess()
SimpleJdbcInsertOperations
withoutTableColumnMetaDataAccess in interface SimpleJdbcInsertOperationspublic SimpleJdbcInsertOperations includeSynonymsForTableColumnMetaData()
SimpleJdbcInsertOperations
includeSynonymsForTableColumnMetaData in interface SimpleJdbcInsertOperationspublic SimpleJdbcInsertOperations useNativeJdbcExtractorForMetaData(NativeJdbcExtractor nativeJdbcExtractor)
SimpleJdbcInsertOperations
useNativeJdbcExtractorForMetaData in interface SimpleJdbcInsertOperationspublic int execute(Map<String,Object> args)
SimpleJdbcInsertOperations
execute in interface SimpleJdbcInsertOperationsargs - Map containing column names and corresponding value
public int execute(SqlParameterSource parameterSource)
SimpleJdbcInsertOperations
execute in interface SimpleJdbcInsertOperationsparameterSource - SqlParameterSource containing values to use for insert
public Number executeAndReturnKey(Map<String,Object> args)
SimpleJdbcInsertOperations
executeAndReturnKey in interface SimpleJdbcInsertOperationsargs - Map containing column names and corresponding value
public Number executeAndReturnKey(SqlParameterSource parameterSource)
SimpleJdbcInsertOperations
executeAndReturnKey in interface SimpleJdbcInsertOperationsparameterSource - SqlParameterSource containing values to use for insert
public KeyHolder executeAndReturnKeyHolder(Map<String,Object> args)
SimpleJdbcInsertOperations
executeAndReturnKeyHolder in interface SimpleJdbcInsertOperationsargs - Map containing column names and corresponding value
public KeyHolder executeAndReturnKeyHolder(SqlParameterSource parameterSource)
SimpleJdbcInsertOperations
executeAndReturnKeyHolder in interface SimpleJdbcInsertOperationsparameterSource - SqlParameterSource containing values to use for insert
public int[] executeBatch(Map<String,Object>[] batch)
SimpleJdbcInsertOperations
executeBatch in interface SimpleJdbcInsertOperationsbatch - an array of Maps containing a batch of column names and corresponding value
public int[] executeBatch(SqlParameterSource[] batch)
SimpleJdbcInsertOperations
executeBatch in interface SimpleJdbcInsertOperationsbatch - an array of SqlParameterSource containing values for the batch
|
|||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||