<s:iterator ... >使用的例子,STRUTS2.新手,求指教!

Question

ACTION:
........
public String execute() throws Exception { Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rst = null;
@SuppressWarnings({ "unchecked", "rawtypes" })
Map<String, String> request = (Map) ActionContext.getContext().get(
"request"); String rets = "";
int i = 0; conn = (Connection) ConnDemo.getConnections();
String sqls = "select * from domaininfo where state='0'";// 0,有效，1，无效
pstmt = (PreparedStatement) conn.prepareStatement(sqls);
rst = pstmt.executeQuery(); while (rst.next()) {
i++;
setDomain(rst.getString("domain"));
setBuyby(rst.getString("buyby"));
setMagurl(rst.getString("magurl"));
setPrice(rst.getString("price"));
setBelongs(rst.getString("belong"));
setContest(rst.getString("contest"));
setRegdate(rst.getString("regdate"));
setEnddate(rst.getString("enddate")); resultList.add(domain);
resultList.add(buyby);
resultList.add(magurl);
resultList.add(price);
resultList.add(belongs);
resultList.add(contest);
resultList.add(regdate);
resultList.add(enddate);
//System.out.print(i);
} if (i == 0) {
request.put("errorstr", "nodates");
rets = ERROR;
} else {
rets = SUCCESS;
}
//System.out.print(i);//test
//System.out.print(resultList);//test

return rets;
}
List<String> resultList = new ArrayList<String>();
public List<String> getResultList() {
return resultList;
}
public void setResultList(List<String> resultList) {
this.resultList = resultList;
}
..........
============== jsp ===============
</s:else>
      <td width="" height=""><s:property value="#L.index+1"/></td>
      <td width="" height=""><s:property value="domain"/></td>
  <td width="" height=""><s:property value="buyby"/></td>
  <td width="" height=""><s:property value="magurl"/></td>   
  <td width="" height=""><s:property value="price"/></td>
  <td width="" height=""><s:property value="belongs"/></td>
  <td width="" height=""><s:property value="contest"/></td>
  <td width="" height=""><s:property value="regdate"/></td>
  <td width="" height="">"<s:property value="enddatec"/></td>
  <td width="" height="">操作</td>
    </tr>
    </s:iterator> 
=========结果===========
结果就是循环显示了最后一条记录,而且循环了96次(共12条记录)

Answer 1

<s:iterator value="#request.postedjobList" var="job" >
                                                <tr style="font-size: 11px;" id="job_post_tr_<s:property value="#job.jobid"  />" class="appendrow">
                                                    <td width="5%" style="position: relative;" valign="middle" align="center" style="" id="<s:property value="#job.jobid" />" class="job_post_tr left_table1 pointer">
                                                        <img  width="19" height="14" src="images3/format_icon1.jpg">
                                                    </td>
                                                    
                                                </tr>
                                            </s:iterator>

Answer 2

上面的没复制全,JSP是这样的.
==========JSP=================<s:iterator value="resultList" id="domain" status="L">
<s:if test="#L.odd == true">
<tr>
</s:if>
<s:else >
<tr bgcolor="#CCCCFF">
</s:else>
      <td width="" height=""><s:property value="#L.index+1"/></td>
      <td width="" height=""><s:property value="domain"/></td>
  <td width="" height=""><s:property value="buyby"/></td>
  <td width="" height=""><s:property value="magurl"/></td>   
  <td width="" height=""><s:property value="price"/></td>
  <td width="" height=""><s:property value="belongs"/></td>
  <td width="" height=""><s:property value="contest"/></td>
  <td width="" height=""><s:property value="regdate"/></td>
  <td width="" height="">&quot;<s:property value="enddatec"/></td>
  <td width="" height="">操作</td>
    </tr>
    </s:iterator> 

Answer 3

>>结果就是循环显示了最后一条记录,而且循环了96次(共12条记录)光看代码好像没什么问题。resultList的size是多少呢，你是不是后台往request里设的时候就只放进去一条记录啊。而且的设置的不对，你有12条记录，list的size就应该是12，前台才好迭代赋值的。代码类似这样 List<xxxxBean> resultList = new ArrayList<xxxxBean>();
while (rst.next()) {
i++;
xxxxBean.setDomain(rst.getString("domain"));
xxxxBean.setBuyby(rst.getString("buyby"));
xxxxBean.setMagurl(rst.getString("magurl"));
xxxxBean.setPrice(rst.getString("price"));
xxxxBean.setBelongs(rst.getString("belong"));
xxxxBean.setContest(rst.getString("contest"));
xxxxBean.setRegdate(rst.getString("regdate"));
xxxxBean.setEnddate(rst.getString("enddate")); resultList.add(xxxxBean);
}
request.put("resultList", resultList);

Answer 4

回楼上,如果我ACTION不变,在JSP里使用以下显示:
${resultList},就显示出来了12条记录,但显示不分行不分列.我就猜想,这应该说明ACTION是没问题的.

Answer 5

还有,我注意到,我的ACTION与你的不同在于,你在ADD时,只有一句,我是一个字段一个字段地ADD的,是不是这里错了.我看了看,12*8(字段)=96.