Examples of simon.entities.DVD

simon.entities.DVD
@author Simon StanfordAn object representing an individual DVD in the MySQL database. Used when a DVD is retrieved from the database to be viewed by the user.

        String price = rs.getString("PRICE");
        String genre = rs.getString("GENRE");
        String description = rs.getString("DESCRIPTION");
        String imageLink = rs.getString("IMAGELINK");
        Integer quantity = rs.getInt("QUANTITY");
        results.add(new DVD(id, name, genre, price, description, imageLink, quantity));
    }
      }
  }
  
  //if at least one result is found, return the first item in the list, else return null

View Full Code Here

        String price = rs.getString("PRICE");
        String genre = rs.getString("GENRE");
        String description = rs.getString("DESCRIPTION");
        String imageLink = rs.getString("IMAGELINK");
        Integer quantity = rs.getInt("QUANTITY");
        results.add(new DVD(id, name, genre, price, description, imageLink, quantity));
    }
      }
  }
  return results; //return the results
    }

View Full Code Here

        String price = rs.getString("PRICE");
        String genre = rs.getString("GENRE");
        String description = rs.getString("DESCRIPTION");
        String imageLink = rs.getString("IMAGELINK");
        Integer quantity = rs.getInt("QUANTITY");
        results.add(new DVD(id, name, genre, price, description, imageLink, quantity));
    }
      }
  }
  return results; //return the results
    }

View Full Code Here

            HttpServletResponse response)
            throws IOException, ServletException {


        RequestDispatcher view = null;
        ArrayList<DVD> randomDvds = null;
        DVD dvd = null;


        try {
            dvd = fetchEjb.GetSingleDvd(dbUrl, dbUsername, dbPassword, filmId);
            randomDvds = fetchEjb.GetFiveRandomFilms(dbUrl, dbUsername, dbPassword, dvd.getGenre());
        } catch (Exception ex) {
            throw new ServletException(ex);
        }
        request.setAttribute("name", request.getParameter("name"));
        request.setAttribute("dvd", dvd);

View Full Code Here

    
    //execute the query and parse the results into a list of OrderLine objects
    //add the object to the list
                ResultSet rs = ps.executeQuery();
                while (rs.next()) {
                    DVD dvd = fetchEjb.GetSingleDvd(dbUrl, dbUsername, dbPassword, rs.getInt("itemId"));
                    Integer quantity = rs.getInt("quantity");
                    dvdList.add(new OrderLine(dvd, quantity));
                }
            }
            return dvdList; //return the results

View Full Code Here

TOP

Related Classes of simon.entities.DVD

simon.GetDvds

simon.model.mysql.FetchEjb

simon.model.mysql.OrderEjb

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.