Delete Operation

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:

<delete id="EMPLOYEE_DELETE_MYAPP" parameterClass ="java.util.HashMap">
DELETE EMPLOYEE WHERE EMP_ID = #EmployeeId#
</delete>

And the corresponding code would be like -

try { 
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.
}