Edit Question - KnowledgeHub

Title Body

I am developing an application in struts 2 and hibernate 3. I have 3 tables Inspection InspectionMission Timeline Inspection is associated with InspectionMission and InspectionMission is associated with Timeline . Now I have following problem. I have written following query in HQL public List getQuartewiseInspectionList(){ Session session = HibernateUtil.getSessionFactory().getCurrentSession(); Query q = session.createQuery( "select count(i.inspectionId) as tot_inspections,t.year,t.quarter" + " From Inspection as i " + " inner join i.inspectionMission as im inner join im.timeline as t" + " GROUP by t.year,t.quarter"); return q.list(); } I want to fetch result as following result[0][tot_inspections] = "6" result[0][year] = "2009"; result[0][quarter] = "Q2"; result[1][tot_inspections] = "3" result[1][year] = "2009"; result[1][quarter] = "Q3"; and so on so that I can display it in jsp struts as follows: In JSP I have written following code <table border="1"> <s:iterator value="result" status="status"> <tr class="<s:if test="#status.even">even</s:if><s:else>odd</s:else>"> <td class="nowrap"><s:property value="tot_inspections" /></td> <td class="nowrap"><s:property value="year" /></td> <td class="nowrap"><s:property value="quarter" /></td> </tr> </s:iterator> </table> Can anyone here help me?

Tags (comma-separated) Cancel