Assume that the scenario is to delete a record from the Employee table based on the Employee ID. A SQL map of the following format –is suitable for the delete operation:
| Code Block |
|---|
|
<delete id="EMPLOYEE_DELETE_MYAPP" parameterClass ="java.util.HashMap"> |
...
DELETE EMPLOYEE WHERE EMP_ID = #EmployeeId# |
...
And the corresponding code would be like -
...
DatabaseRequest dbRequest = new DatabaseRequest(); |
...
dbRequest.setDataAccessMapKey("EMPLOYEE"); |
...
dbRequest.setOperation(DatabaseConstants.DELETE) |
...
dbRequest.setOperationExtension("MYAPP"); |
...
dbRequest.addFilter(empIdToDelete); //Add the Emp Id to delete as filter |
...
DatabaseResult dbResult = dbRequest.execute(); //Execute the select. |
...
Logger.debug(" # rows deleted = " + dbResult.getNumberOfRowsAffected(); //Get the count of affected rows |
...
} catch (DatabaseException dbException) { |
...
//Handle the exception appropriately. |
...