Spring MVC 如何显示自定义的sql语句的query.getResultList()的数据？
? <asp:Repeater id="rptList" runat="server">
??? <ItemTemplate>
????? <tr>
??????? <td width="30%"> <%# DataBinder.Eval(Container.DataItem,"userId") %></td>
??????? <td width="70%"> <%# DataBinder.Eval(Container.DataItem,"loginTimes") %> </td>
????? </tr>
??? </ItemTemplate>
? </asp:Repeater>
</table>
循环将统计的各位用户上网次数列表显示出来；
我的问题是，springMVC中，如果业务层从数据库列表返回的是一个类的对象列表，也可以用forEach循环显示；
如果返回的是一个sql语句写的统计列表，就像上面的sql语句那样，而系统中没有相应的类和它对应，如何将结果显示到页面上去？ package jpqlexample.servlets;...class LineItemSum { private Double price; private Integer quantity; private Double rslt; public LineItemSum (Double price, Integer quantity){ this.rslt = quantity*price; } public Double getRslt () { return this.rslt; } public void setRslt (Double rslt) { this.rslt = rslt; } }public class JpqlJoinsServlet extends HttpServlet { ... public void doGet( ... List<LineItemSum> arr = (List<LineItemSum>)em.createQuery ("SELECT NEW jpqlexample.servlets.LineItemSum(p.price, l.quantity) FROM PurchaseOrder o JOIN o.orderLineItems l JOIN l.product p JOIN p.supplier s WHERE s.sup_name = 'Tortuga Trading'") .getResultList(); Iterator i = arr.iterator(); LineItemSum lineItemSum; Double sum = 0.0; while (i.hasNext()) { lineItemSum = (LineItemSum) i.next(); sum = sum + lineItemSum.getRslt(); } out.println("The total cost of the ordered products supplied by Tortuga Trading: "+ sum + "<br/>"); }}?
