Retrieving data using iterate and eliminating duplicate values

[Steve Sutton]

I am executing 2 different sql queries in my action class, the first query retrieves values that are then used in the second query to retrieve related data. Here is my problem, the second query is retrieving from a comment table where there may be two or more rows of data. When this occurs, my jsp will show the same values for each row of comments found. I want to eliminate the duplicate displays and only display the comment. I am new to struts and am not sure how to do that. Here is my action class code looping through the results of the first query:

for(int i = 0; i <= index-1; i++)
{
//Query to retrieve the alert table information
ResultSet alrt;
ArrayList fleet = new ArrayList();
ArrayList ac_num = new ArrayList();
ArrayList ata_sect_cde = new ArrayList();
ArrayList ata_chap_cde = new ArrayList();
ArrayList defr_cde = new ArrayList();
ArrayList remarks = new ArrayList();
ArrayList name_working = new ArrayList();

try
{
alrt = stmt.executeQuery(
"SELECT *");
     while (alrt.next())
     {
dlb = new DisplayListBean();
dlb.setValue((String)alrt.getString(alrt.findColumn
("co_fleet_num")));
fleet.add(dlb);
 
dlb = new DisplayListBean();
dlb.setValue((String)alrt.getString(alrt.findColumn
("ac_num")));
        ac_num.add(dlb);

dlb = new DisplayListBean();
dlb.setValue((String)alrt.getString(alrt.findColumn
("ata_sect_cde")));
ata_sect_cde.add(dlb);

dlb = new DisplayListBean();
dlb.setValue((String)alrt.getString(alrt.findColumn
("ata_chap_cde")));
ata_chap_cde.add(dlb);

dlb = new DisplayListBean();
dlb.setValue((String)alrt.getString(alrt.findColumn
("defr_cde")));
        defr_cde.add(dlb);

                dlb = new DisplayListBean();
dlb.setValue((String)alrt.getString(alrt.findColumn
("alrt_rvw_sgrp_cde")));
name_working.add(dlb);

dlb = new DisplayListBean();
dlb.setValue((String)alrt.getString(alrt.findColumn
("cmt_txt")));
        remarks.add(dlb);
      }
ReportBean rb = new ReportBean();
rb.setDays_def((String) days_def.get(i));
rb.setLog_pg_num((String) log_pg_num.get(i));
rb.setScptr_dfclt_dte((String) scptr_dfclt_dte.get(i));
rb.setFleet(fleet);
rb.setAc_num(ac_num); 
rb.setAta_sect_cde(ata_sect_cde);
rb.setAta_chap_cde(ata_sect_cde);
rb.setDefr_cde(defr_cde);
rb.setName_working(name_working);
rb.setRemarks(remarks);
reportLine.add(rb);
} 

Here is the jsp code I am using to iterate:

<logic:iterate name='openMon1DayFormBean' id='reportLine' property='reportLine'>
    <tr>
      <td><logic:iterate name="reportLine" id="fleet" property='fleet'><bean:write name='fleet' property='value' /><br></logic:iterate>
     </td>
      <td><logic:iterate name="reportLine" id="ac_num" property='ac_num'><bean:write name='ac_num' property='value' /><br></logic:iterate>
      </td>
      <td><logic:iterate name="reportLine" id="ata_sect_cde" property='ata_sect_cde'><bean:write name='ata_sect_cde' property='value' /><br></logic:iterate>
      </td>
      <td><logic:iterate name="reportLine" id="ata_chap_cde" property='ata_chap_cde'><bean:write name='ata_chap_cde' property='value' /><br></logic:iterate>
      </td>
      <td><bean:write name="reportLine" property = 'log_pg_num' /></td>
      <td><bean:write name="reportLine" property = 'days_def' /></td>
      <td><logic:iterate name="reportLine" id="defr_cde" property='defr_cde'><bean:write name='defr_cde' property='value' /><br></logic:iterate>
      </td>
      <td><bean:write name="reportLine" property = 'scptr_dfclt_dte' /></td>
      <td></td>
      <td></td>
      <td><logic:iterate name="reportLine" id="name_working" property='name_working'><bean:write name='name_working' property='value' /><br></logic:iterate>
      </td>
      <td><logic:iterate name="reportLine" id="remarks" property='remarks'><bean:write name='remarks' property='value' /><br></logic:iterate>
      </td>
   </tr>

</logic:iterate>

The display is looks kind of like this:
a b c d e f g comment 1
a b c d e f g comment 2
a b c d e f g comment 3
I want it to look like this:
a b c d e f g comment 1
comment 2
comment 3
How do I get this result using the iterate?
[edit: moderator added code tags]
[ October 17, 2003: Message edited by: Junilu Lacar ]