| 
 | ||||||||||
| 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 | |||||||||