@Override public void saveOrUpdateResult(Result result) throws DatabaseException { Connection connection = null; PreparedStatement statement = null; try { connection = DBUtility.getConnection(); // If result id = 0, then we are trying to save a new record, else update if (result.getResultId() == 0) { statement = connection.prepareStatement(INSERT_STMT); statement.setInt(1, result.getExamination().getExaminationId()); statement.setInt(2, result.getUser().getUserId()); statement.setInt(3, result.getNumberCorrect()); statement.setInt(4, result.getNumberIncorrect()); statement.setInt(5, result.getMarksObtained()); statement.setInt(6, result.getIsPass()); statement.executeUpdate(); } } catch (ClassNotFoundException ex) { LOG.log(Level.SEVERE, null, ex); throw new DatabaseException(ex); } catch (SQLException ex) { LOG.log(Level.SEVERE, null, ex); throw new DatabaseException(ex); } finally { DBUtility.close(statement); DBUtility.close(connection); } }
@Override public void deleteResult(Result result) throws DatabaseException { Connection connection = null; PreparedStatement statement = null; try { connection = DBUtility.getConnection(); statement = connection.prepareStatement(DELETE_STMT); statement.setInt(1, result.getResultId()); statement.execute(); } catch (ClassNotFoundException ex) { LOG.log(Level.SEVERE, null, ex); throw new DatabaseException(ex); } catch (SQLException ex) { LOG.log(Level.SEVERE, null, ex); throw new DatabaseException(ex); } finally { DBUtility.close(statement); DBUtility.close(connection); } }