Beispiel #1
0
  /**
   * Remove a rating by user for movie
   *
   * @param u
   * @param m
   * @return
   */
  public static boolean removeRating(User u, Movie m) {
    Logger.getInstance().log("Remove rating");

    // Check
    if (u == null || m == null) {
      Logger.getInstance().warn("User or Movie is null");
      return false;
    }
    Statement state;
    boolean result = false;
    try {
      state = ConnectSingleton.getInstance().createStatement();

      // Compute the request
      String request =
          MessageFormat.format(
              DELETE_RATING_OF_A_MOVIE_BY_USING_TABLE_USER_RATING,
              Integer.toString(u.getId()),
              Integer.toString(m.getId()));

      Logger.getInstance().debug("EXECUTE REQUEST", "REMOVE RATING", request);

      result = state.execute(request);
    } catch (SQLException e) {
      Logger.getInstance().warn("Error with database");
      e.printStackTrace();
    }
    return result;
  }
Beispiel #2
0
  public static int retrieveUserRating(User u, Movie m) {
    Logger.getInstance().log("Retrieve User Rating");

    int rate = -1;
    if (u != null) {
      try {
        Statement state = ConnectSingleton.getInstance().createStatement();

        String request =
            MessageFormat.format(
                RETRIEVE_USER_RATING_BY_USERID_AND_MOVIEID,
                Integer.toString(u.getId()),
                Integer.toString(m.getId()));

        Logger.getInstance().debug("RETRIEVE USER RATING", request);

        ResultSet rs = state.executeQuery(request);
        if (rs.next()) {
          rate = rs.getInt(1);
        }
      } catch (SQLException e) {
        Logger.getInstance().warn("Error with database");
        e.printStackTrace();
      }
    }

    return rate;
  }
Beispiel #3
0
  /**
   * Retrieve all ratings for a user
   *
   * @param u
   * @return
   */
  public static ArrayList<Rating> retrieveAllRatings(User u) {
    Logger.getInstance().log("Retrieve All Ratings");

    // Check
    if (u == null) {
      Logger.getInstance().warn("User is null");
      return null;
    }
    ArrayList<Rating> ratings = new ArrayList<Rating>();
    Statement state;

    try {
      state = ConnectSingleton.getInstance().createStatement();

      // Compute the request
      String request = MessageFormat.format(RETRIEVE_ALL_RATINGS, Integer.toString(u.getId()));

      Logger.getInstance().debug("EXECUTE REQUEST", "RETRIEVE RATINGS", request);

      ResultSet rs = state.executeQuery(request);

      Rating r;
      Movie m;

      while (rs.next()) {
        r = new Rating();
        m = new Movie();

        m.setTitle(rs.getString(6));
        m.setId(rs.getInt(2));
        m.setPicUrl(rs.getString("coverIMDB"));

        r.setUser(u);
        r.setMovie(m);
        r.setRate(rs.getInt(3));
        r.setTime(rs.getLong(4));

        ratings.add(r);
      }

    } catch (Exception e) {
      Logger.getInstance().warn("Error with database");
      e.printStackTrace();
    }

    return ratings;
  }
Beispiel #4
0
  /**
   * Change the rating of a movie
   *
   * @param u
   * @param m
   * @param newRate
   */
  public static boolean modifyRating(User u, Movie m, int newRate) {
    Logger.getInstance().log("Modify rating");

    // Check
    if (u == null || m == null) {
      Logger.getInstance().warn("User or Movie is null");
      return false;
    }
    Statement state;
    try {
      state = ConnectSingleton.getInstance().createStatement();
      String check =
          MessageFormat.format(
              RETRIEVE_USER_RATING_BY_USERID_AND_MOVIEID,
              Integer.toString(u.getId()),
              Integer.toString(m.getId()));
      ResultSet rs = state.executeQuery(check);
      if (!rs.next()) {
        return addRating(u, m, newRate);
      }

      // Compute the request
      String request =
          MessageFormat.format(
              MODIFY_RATING_OF_A_MOVIE_BY_USING_TABLE_USER_RATING,
              Integer.toString(u.getId()),
              Integer.toString(m.getId()),
              newRate,
              new Date().getTime() + "");

      Logger.getInstance().debug("EXECUTE REQUEST", "MODIFY RATING", request);

      int res = state.executeUpdate(request);

      return res != 0;
    } catch (SQLException e) {
      Logger.getInstance().warn("Error with database");
      e.printStackTrace();
    }

    return false;
  }