How To show data groupwise?

Question

I am trying to load order data from different table.

I have displayed data also from tables using JOIN query.

This Is my o/p : enter image description here

I want something like this :

enter image description here

The Order ID i.e. No. here should be displayed once, if it repeats.

My JSP Code :

<table class="table table-condensed">
                        <%
                            List<String> oIdList = (List<String>)request.getAttribute("oIdList");
                            List<String> pNameList = (List<String>)request.getAttribute("pNameList");
                            List<String> pQtyList = (List<String>)request.getAttribute("pQtyList");
                            List<String> pTimeList = (List<String>)request.getAttribute("pTimeList");
                            List<Boolean> pStatusList = (List<Boolean>)request.getAttribute("statusList");
                        %>
                              <thead>
                                  <tr>
                                      <th width="8%">No.</th>
                                      <th width="23%">Product Name</th>
                                      <th width="20%">Product Qty</th>
                                      <th width="18%">Order Time</th>
                                      <th width="22%"><div align="center">Order Status</div></th>                                          
                                  </tr>
                              </thead>   
                              <tbody>

                              <%
                                    for(int i = 0; i<pNameList.size(); i++)
                                    {
                                        %>
                                            <tr>
                                                <td><%= oIdList.get(i) %></td>
                                                <td class="center"><%= pNameList.get(i) %></td>
                                                <td class="center"><%= pQtyList.get(i) %></td>
                                                <td class="center"><%= pTimeList.get(i) %></td>                                             
                                                <%
                                                    if(pStatusList.get(i))
                                                    {

                                                        %>                                                  
                                                            <td class="center"><div align="center"><span class="label label-success">Delivered</span></div></td>
                                                        <% 

                                                    }
                                                    else
                                                    {
                                                        %>
                                                            <td style="text-align: center;" width="9%"><span class="label">Pending</span></td>
                                                        <% 

                                                    }
                                                %>

                                            </tr>   
                                        <%
                                    }
                              %>


                              </tbody>
                         </table>

So Any Suggestion Please..

You can add one Jquery code to change value to empty if more than one row for that No. column come same . — Sujith PS, Dec 20 '13 at 13:22

score 1 · Accepted Answer · edited Dec 20 '13 at 13:53

1

Hello. buddy. try this

 for(int j =0,i = 0; i<pNameList.size(); i++) {
     %> <tr> <% 
    if(i==0){      
    j++;    
       %> <td><%= j %></td> <%
    }else if(oIdList.get(i) != oIdList.get(i-1)){
    j++;

         %> <td><%= j %></td> <%
    }else{
         %> <td></td> <%

    }    
   %>                                      

  <td class="center"><%= pNameList.get(i) %></td>
  <td class="center"><%= pQtyList.get(i) %></td>
  <td class="center"><%= pTimeList.get(i) %></td>

edited Dec 20 '13 at 13:53

answered Dec 20 '13 at 13:33

Karthikeyan Sukkoor

968
2
6
24

Sir, Can I print i value ? i.e on place of 11 it's 1 then on place of 9 it's2 and on place of 7 it's 3. – Dec 20 '13 at 13:42
Sure. to print i value : <%=i %> – Karthikeyan Sukkoor Dec 20 '13 at 13:45
But sir when I am using `<%=i %>` in both condition it gives me like `0,1,..,4,.` , I want like `1,2,..,3.` – Dec 20 '13 at 13:47
i have modified this line for(int j =0, i = 0; i – Karthikeyan Sukkoor Dec 20 '13 at 13:51

score 0 · Answer 2 · answered Dec 20 '13 at 13:22

0

Set a variable lastIdDisplayed to the id each time around the loop (initialize it to -1 or something else invalid). If lastIdDisplayed == id then don't display id.

answered Dec 20 '13 at 13:22

Tim B

40,716
16
83
128

score 0 · Answer 3 · answered Dec 20 '13 at 13:28

Your example is not very object-oriented. You should convert all these lists of string arrays into Order objects.

Then iterate over the Orders (sort them first by using a Comparable interface and comparing on the order id value).

Then use some basic logic to check if the last order id value is the same as the last.

How To show data groupwise?

3 Answers3