<?xml version="1.0"?> <Portfolio> <Date><%= new Date() %></Date> <jsp:useBean id="dbConn" class="ConnectionBean"/> <jsp:useBean id="client" class="QueryBean"/> <jsp:useBean id="quotes" class="QueryBean"/> <% client.setConnection(dbConn.getConnection()); quotes.setConnection(dbConn.getConnection()); client.setQuery("SELECT givenname, surname"+ " FROM client_table"+ " WHERE id = " + request.getParameter("id")); quotes.setQuery("SELECT q.symbol, q.price, q.change"+ " FROM quotes q, portfolio_stocks ps"+ " WHERE q.symbol = ps.symbol "+ " AND ps.owner = " + request.getParameter("id")); %> <% while (client.next()) { %> <Customer> <Name> <First><%= client.column(1) %></First> <Last><%= client.column(2) %></Last> </Name> </Customer> <% } client.close(); %> <Quotes> <% while (quotes.next()) { %> <Quote> <Symbol><%= quotes.column(1) %></Symbol> <Price><%= quotes.column(2) %></Price> <Change><%= quotes.column(3) %></Change> </Quote> <% } quotes.close(); dbConn.close(); %> </Quotes> </Portfolio> |