--- Vijay Balakrishnan <[EMAIL PROTECTED]> wrote: > Hi, > > Is there a way to return this resultset from a SQL Query as an xml file > using a beanutils class or Digester ?
I don't know of any class that does that. Every application will require its own XML format anyways. David > > Thanks, > Vijay > > -----Original Message----- > From: Craig R. McClanahan [mailto:[EMAIL PROTECTED] > Sent: Monday, July 14, 2003 7:25 PM > To: Struts Users Mailing List > Subject: Re: Iterating the resultset contents in the view (jsp) > > > > > On Mon, 14 Jul 2003, Richard Hill wrote: > > > Date: Mon, 14 Jul 2003 16:36:17 -0700 > > From: Richard Hill <[EMAIL PROTECTED]> > > Reply-To: Struts Users Mailing List <[EMAIL PROTECTED]> > > To: "'[EMAIL PROTECTED]'" > > <[EMAIL PROTECTED]> > > Subject: Iterating the resultset contents in the view (jsp) > > > > Hi, > > I'm working on an action that gets a resultset from a database table > > containing 4 columns. I need to pass that information back to the view > > > (jsp) which will iterate over results. My question is what is the best > > > way to do this. Do I create an array for each row in the resultset and > > > insert each array in a collection, passing that back to the view? > > > > That is certainly one approach. Indeed, commons-beanutils has a useful > little class (org.apache.commons.beanutils.RowSetDynaClass) that is > ideally > suited to this use case. It creates a List of DynaBeans representing > the > data content returned by the SELECT. Because it makes a copy, you can > close > the result set (and return the connection back to the connection pool) > before forwarding to the page. > > > If so, how would you iterate over each array in the collection with > > the logic:iterate taglib? All of the examples only show iterations > > over single column lists. > > > > Let's assume you have done this in your Action: > > ResultSet rs = ...; > RowSetDynaClass rsdc = new RowSetDynaClass(rs); > rs.close(); > request.setAttribute("customers", rsdc.getList()); > > so you now have a request attribute containing the list. Now, in your > page, > you can say things like: > > <logic:iterate id="customer" name="customers"> > Name is <bean:write name="customer" property="name"/> > Status is <bean:write name="customer" property="status"/> > </logic:iterate> > > and so on. Details of RowSetDynaClass are in the javadocs for > BeanUtils: > > http://jakarta.apache.org/commons/beanutils/ > > > Any help would be appreciated. > > > > Thanks, > > Richard > > > > Craig > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
