Example #1
0
  @Override
  public List<Result> getResult(Examination examination, User user) throws DatabaseException {
    List<Result> resultList = null;
    Connection connection = null;
    PreparedStatement statement = null;
    ResultSet rs = null;

    try {
      connection = DBUtility.getConnection();
      statement = connection.prepareStatement(SELECT_BY_EXAM_USER);
      statement.setInt(1, examination.getExaminationId());
      statement.setInt(2, user.getUserId());
      rs = statement.executeQuery();

      resultList = createResultObject(rs);

    } 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(rs);
      DBUtility.close(statement);
      DBUtility.close(connection);
    }

    return resultList;
  }
Example #2
0
  @Override
  public Result getResult(int resultId) throws DatabaseException {
    List<Result> resultList = null;
    Result result = null;
    Connection connection = null;
    PreparedStatement statement = null;
    ResultSet rs = null;

    try {
      connection = DBUtility.getConnection();
      statement = connection.prepareStatement(SELECT_BY_ID);
      statement.setInt(1, resultId);
      rs = statement.executeQuery();

      resultList = createResultObject(rs);

      if (resultList != null && !resultList.isEmpty()) {
        result = resultList.get(0);
      }

    } 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(rs);
      DBUtility.close(statement);
      DBUtility.close(connection);
    }

    return result;
  }
Example #3
0
  @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);
    }
  }
Example #4
0
  @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);
    }
  }