/*
   wyświetlenie zawartości lodówki w formie listy
  */
  public List<Fridge> getAllProducts(int userid) {
    List<Fridge> products = new ArrayList<Fridge>();

    try {
      PreparedStatement preparedStatement =
          connection.prepareStatement("select * from fridge where userid=?");
      preparedStatement.setInt(1, userid);
      ResultSet rs = preparedStatement.executeQuery();
      // ResultSet rs = preparedStatement.executeQuery();
      // Statement statement = connection.createStatement();
      // ResultSet rs = statement.executeQuery("select * from fridge where userid=?");
      while (rs.next()) {
        // wypełnianie listy
        Fridge product = new Fridge();
        product.setProductID(rs.getInt("ProductID"));
        product.setName(rs.getString("ProductName"));
        product.setAmount(rs.getInt("ProductAmount"));
        product.setUserID(rs.getInt("UserID"));
        products.add(product);
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }

    return products;
  }
  /*
  wyświetlenie jednego produktu na podstawie ID
  */
  public Fridge getProductById(int ProductID) {
    Fridge product = new Fridge();

    try {
      PreparedStatement preparedStatement =
          connection.prepareStatement("select * from fridge where ProductID=?");
      preparedStatement.setInt(1, ProductID);
      ResultSet rs = preparedStatement.executeQuery();

      if (rs.next()) {
        product.setProductID(rs.getInt("ProductID"));
        product.setName(rs.getString("ProductName"));
        product.setAmount(rs.getInt("ProductAmount"));
        product.setUserID(rs.getInt("UserID"));
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }

    return product;
  }