struts-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chad Johnson" <ch...@netnet.net>
Subject Re: CachedRowset with logic:iterate tag
Date Thu, 18 Jul 2002 16:38:18 GMT
You could use the "forEach" tag from JSTL
(http://jakarta.apache.org/taglibs/doc/standard-doc/intro.html).  "forEach"
can iterate over ResultSet's (and RowSet's via inheritance) with the
assistance from the helper class: javax.servlet.jsp.jstl.sql.ResultSupport .
ResultSupport can convert ResultSet's to the JSTL friendly Result class.

-Chad Johnson

----- Original Message -----
From: "aps olute" <aps8882002@yahoo.com>
To: <struts-user@jakarta.apache.org>
Sent: Wednesday, July 17, 2002 6:19 PM
Subject: CachedRowset with logic:iterate tag


> How to iterate over a CachedRowSet using
> <logic:iterate > tags? I have filled the CachedRowset
> with a select
> statement and am able to iterate using the
> crs.getString(1) or the crs.getString(colname)
> methods,
> but no am ready to use Struts tags but dont know how.
> Do I need to convert it a Collection type? but that
> will eat up more memory as two copies CRS and the
> Collection with same contents?
> Is it necessary to use the Struts tags to work with
> the rest of the Struts features?
>
> <?xml version="1.0"?>
> <%@ page language="java" %>
> <%@ page contentType="text/html" %>
> <%@ page
> import="sun.jdbc.rowset.CachedRowSet,javax.naming.InitialContext"%>
> <jsp:useBean id="Contacts"
> class="sun.jdbc.rowset.CachedRowSet" scope="session">
> <% InitialContext ctx = new InitialContext();
>   javax.sql.DataSource ds =
> (javax.sql.DataSource)ctx.lookup("java:/DefaultDS");
>   java.sql.Connection con = ds.getConnection();
>   Contacts.setCommand("SELECT name,
> owner,species,sex,birth,death from pet");
>   Contacts.execute(con);
>   Contacts.first(); %> </jsp:useBean>
> <logic:present name="Contacts" property="name">
> <logic:iterate id="subs" name="Contacts"
>  type="sun.jdbc.rowset.CachedRowSet">
>     <bean:write name="subs" property="name"/>
> </logic:iterate>
> </logic:present>
>
>
> But nothing is ever printed. if i take out the
> logic:present and logic:iterate and replaced with a
> while (Contacts.next()  Contacts.getString(1)  at
> least
> i gets some output.
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Autos - Get free new car price quotes
> http://autos.yahoo.com
>
> --
> To unsubscribe, e-mail:
<mailto:struts-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail:
<mailto:struts-user-help@jakarta.apache.org>
>
>



--
To unsubscribe, e-mail:   <mailto:struts-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:struts-user-help@jakarta.apache.org>


Mime
View raw message