All pastes #448782 Raw Edit

Miscellany

public text v1 · immutable
·published 2007-04-19 21:36 UTC
rendered paste body
FinderBean.java
--------------------

private Collection collection = new ArrayList();

query = "SELECT * FROM music_recordings WHERE category = \"" + cat + "\" AND price <= " + mxp;
res = stmt.executeQuery(query);
while(res.next()) {
    MusicBean musicBean = new MusicBean(res.getString("title"), res.getString("artist_name"),
        res.getFloat("price"), res.getString("category"));
    collection.add(musicBean);
}

DataProcess.java
-----------------------

FinderBean finderBean = new FinderBean(cat, mxp);
request.setAttribute("results", finderBean);

RequestDispatcher dispatcher = getServletContext().getRequestDispatcher(address);
dispatcher.forward(request, response);

display.jsp
-----------------------

<jsp:useBean id="results" class="coreservlets.FinderBean" scope="request" />
<jsp:getProperty name="results" property="collection" />
<% ((Collection)request.getAttribute("collection")).size(); %>