|
||||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||||
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.
| 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 |
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 |
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 |
|---|
SimpleJdbcInsertOperations withTableName(String tableName)
tableName - the name of the stored table
SimpleJdbcInsertOperations withSchemaName(String schemaName)
schemaName - the name of the schema
SimpleJdbcInsertOperations withCatalogName(String catalogName)
catalogName - the name of the catalog
SimpleJdbcInsertOperations usingColumns(String... columnNames)
columnNames - one or more column names
SimpleJdbcInsertOperations usingGeneratedKeyColumns(String... columnNames)
columnNames - one or more column names
int execute(Map<String,Object> args)
args - Map containing column names and corresponding value
int execute(SqlParameterSource parameterSource)
parameterSource - SqlParameterSource containing values to use for insert
Number executeAndReturnKey(Map<String,Object> args)
args - Map containing column names and corresponding value
Number executeAndReturnKey(SqlParameterSource parameterSource)
parameterSource - SqlParameterSource containing values to use for insert
KeyHolder executeAndReturnKeyHolder(Map<String,Object> args)
args - Map containing column names and corresponding value
KeyHolder executeAndReturnKeyHolder(SqlParameterSource parameterSource)
parameterSource - SqlParameterSource containing values to use for insert
int[] executeBatch(Map<String,Object>[] batch)
batch - an array of Maps containing a batch of column names and corresponding value
int[] executeBatch(SqlParameterSource[] batch)
batch - 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 | |||||||||