![](https://iknow-base.cdn.bcebos.com/lxb/notice.png)
ssh框架用sql查询出来的一个list如何在页面显示?
查询出的数据:Stringsql="select*from(selectc.*,rownumrnfrom(selecta.ctmid,a.ctm011,a.ctm012,...
查询出的数据:
String sql=" select * from (select c.* ,rownum rn from (select a.ctmid,a.ctm011,a.ctm012,a.ctm013,a.ctm014,a.ctm015,a.ctm016,a.ctm017,nvl(b.ctm018,a.ctm018),nvl(b.ctm019,a.ctm019), " +
" nvl(b.ctm020,a.ctm020),nvl(b.ctm021,a.ctm021),a.ctm022, " +
" nvl(b.trk023,a.ctm023),nvl(b.trk024,a.ctm024),a.not016,b.trkid,b.trl011,b.trl012,rownum r " +
" from Customer a,(select * from track where trkid in(select max(t.trkid) from track t group by t.ctmid)) b " +
" where a.ctmid=b.ctmid(+) ) c where c.r >=1) d where d.rn<=3 ";
Action 的代码:
this.request.setAttribute("pagemodel",pageBean.getList()); 就是上面查询出的数据集合,求显示在页面上的代码。 展开
String sql=" select * from (select c.* ,rownum rn from (select a.ctmid,a.ctm011,a.ctm012,a.ctm013,a.ctm014,a.ctm015,a.ctm016,a.ctm017,nvl(b.ctm018,a.ctm018),nvl(b.ctm019,a.ctm019), " +
" nvl(b.ctm020,a.ctm020),nvl(b.ctm021,a.ctm021),a.ctm022, " +
" nvl(b.trk023,a.ctm023),nvl(b.trk024,a.ctm024),a.not016,b.trkid,b.trl011,b.trl012,rownum r " +
" from Customer a,(select * from track where trkid in(select max(t.trkid) from track t group by t.ctmid)) b " +
" where a.ctmid=b.ctmid(+) ) c where c.r >=1) d where d.rn<=3 ";
Action 的代码:
this.request.setAttribute("pagemodel",pageBean.getList()); 就是上面查询出的数据集合,求显示在页面上的代码。 展开
3个回答
展开全部
el表达式应该能搞定吧
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
struts1的话用c:forEach
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
展开全部
STRUTS2 GET SET
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询