Example 11-14: Multiple QueryBeans in a page returning XML

<?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>