try {
Connection conn = DataSourceHandler.getDataSource().getConnection();
GenericTransactionController controller = new GenericTransactionController(conn);
int result = controller.deleteRecord("role", "role_code='A'");
System.out.println("Number of records affected = " + result);
conn.commit();
DbUtils.close(conn);
} catch (ControllerException ce) {