how to use logic:iterate for ArrayLists withing Collection

[Ashimashi Kabashi]

Howdy Ranchers.

I am having a little trouble with this.
I am trying to use the logic:iterate tag to iterate through a Collection. But the Collection does not have the values itself. The Collection is a collection of ArrayLists and the ArrayLists have the Strings which I want to display.

What do I need to do on the jsp page?
Do I need a nested logic:iterate?

Your help is always appreciated!!

[Martijn Verburg]

Hi there!

Have you tried the nested logic:iterate tag? What happened?

[Ashimashi Kabashi]

I am struggling with that actually..
I know how to do this if the Collection had the actual string values etc.
But the Collection has arraylists and the arraylists have the string values..

my code is

    public Collection retrieveSQL() throws SQLException {
        Collection coll = new java.util.Vector();
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * FROM test");
        while (rs.next()) {
            java.util.ArrayList arr = new java.util.ArrayList();
            arr.add(rs.getString(1));
            arr.add(rs.getString(2));
            arr.add(rs.getString(3));
            
            coll.add(arr);
        }
        return coll;
    }

[Jeanne Boyarsky]

Ashimashi,
You would use nested logic:iterate tags. The outer one would use the java.util.ArrayList type. The inner one would use String.

[Ashimashi Kabashi]

If I do something like this (while populating the Collection)

        Collection coll = new java.util.Vector();
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * FROM test");
        while (rs.next()) {
            PlatformVO platformVO = new PlatformVO();
            platformVO.setEmail(rs.getString(1));
            platformVO.setName(rs.getString(2));
            platformVO.setStory(rs.getString(3));
            coll.add(platformVO);
        }
        return coll;    

where PlatformVO is a bean that I am using
and represent it like this (on the jsp):

            <%
            java.util.Vector vector = (java.util.Vector) session.getAttribute("PlatformList");
        %>
        
        <table border="1">
            <thead>
                <tr>
                    <th>Col1</th>
                    <th>Col2</th>
                    <th>Col3</th>
                </tr>
            </thead> 
            <tbody>
                <logic:iterate id="myCollectionElement" collection="<%= vector %>">
                
                   
                    <tr>
                        <td><bean:write name="myCollectionElement" property="name"/></td>
                        <td><bean:write name="myCollectionElement" property="email"/></td>
                        <td><bean:write name="myCollectionElement" property="story"/></td>
                    </tr>
                    
                    
                    
                </logic:iterate>
            </tbody>
        </table>

Then everything is fine....

But I dont want to fill the Collection with Beans..I want to fill it with ArrayLists, the reason is the that when you use a bean you have to use the property attribute and are bound to use only the attributes defined in the bean. But I dont want to be bound to the bean as my arraylist contains other columns.

Thanks

[Jeanne Boyarsky]

That is close. I was thinking more like:

<logic:iterate id="nestedArray" name="yourBean" type="java.util.ArrayList">
  <tr>
    <logic:iterate id="cellValue" name="nestedArray" type="String">          
      <td><bean:write name="cellValue"/></td>
    </logic:iterate> 
  </tr>
 </logic:iterate>

[edited to fix typo in name]
[ October 12, 2008: Message edited by: Jeanne Boyarsky ]