I read recently that you can convert from a Javabean to an xml file using Digester with a dtd.I was wondering if there was a way to convert directly from a sql resultset into an xml file without going through an intermediary step of a javabean or custom formatting.
Thanks, Vijay -----Original Message----- From: David Graham [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 11:55 AM To: Struts Users Mailing List Subject: Re: [OT]RE: Iterating the resultset contents in the view (jsp) --- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
