@Override public String deactivateRequirement(Requirement requirement) { SqlSession sqlSession = getSqlSessionFactory().openSession(); try { RequirementMapper requirementMapper = sqlSession.getMapper(RequirementMapper.class); if (requirementMapper.checkIfExistingRequirement(requirement) > 0) { requirementMapper.deactivateRequirement(requirement); sqlSession.commit(); System.out.println(requirement.getRequirementId()); return "success"; } return "failed-does-not-exist"; } catch (Exception e) { e.printStackTrace(); sqlSession.rollback(); } finally { sqlSession.close(); } return "failed-database"; }