struts里的javabean取值问题
我写了一个从数据库中检索数据的程序,为什么在JSP页面里只能显示最后一个值啊。但是在用System.out.println(qxzmc)却能打印出所有的啊,
下面是程序,大家帮看看啊
qxzActipn:
try{
String sql = "select * from td_qxzdm order by qxzdm";
ConnectDB db=new ConnectDB();
ResultSet rs = db.executeQuery(sql);
//while(rs != null && rs.next())
while(rs.next())
{
//int qxzdm=rs.getInt(qxzdm);
String qxzmc=rs.getString("qxzmc");
String pyip=rs.getString("pyip");
String glip=rs.getString("glip");
request.setAttribute("qxzmc",qxzmc);
request.setAttribute("pyip",pyip);
request.setAttribute("glip",glip);
System.out.println(qxzmc);
QxzBean pb=new QxzBean();
//pb.setQxzdm(qxzdm);
pb.setQxzmc(qxzmc);
pb.setPyip(pyip);
pb.setGlip(glip);
request.setAttribute("qxzbean",pb);
//String ip = request.getRemoteAddr();
//System.out.println(ip);
//response.sendRedirect("sucess.jsp");
}
return mapping.findForward("success");
}
catch(Exception e)
{
request.setAttribute("error","3");
response.sendRedirect("error.jsp");
e.printStackTrace();
}
JSP:
<tr>
<th>权限组名称</th>
<th>评阅IP</th>
<th>管理IP</th><p>
</tr>
<tr>
<td><bean:write name="qxzbean" property="qxzmc"></bean:write></td>
<td><bean:write name="qxzbean" property="pyip"></bean:write></td>
<td><bean:write name="qxzbean" property="glip"></bean:write></td>
</tr>