问题描述
<%@ page language="java" contentType="text/html;charset=gb2312" %><jsp:directive.page import="com.xsminfo.struts.forms.*" /><%@ page import="java.util.List" %><%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean"%> <%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html"%><%@ taglib uri="http://jakarta.apache.org/struts/tags-logic" prefix="logic"%><%@ page import="java.util.LinkedList;" %><% String path = request.getContextPath(); String basePath = request.getScheme() + "://"+ request.getServerName() + ":" + request.getServerPort()+ path + "/";List list=(List)request.getAttribute("rsArray");out.println(list);%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html:html locale="true"> <head> <title>selectInfo.jsp</title> </head> <body><th><a href="<%=basePath %>/selectInfo.jsp"><b>查询</b></a></th><th><a href="" >修改</a></th><th><a href="<%=basePath %>/infoPc.jsp">添加</a></th><th><a href="">删除</a></th></br> <table border="1" > <html:form action="/selectInfo" > <tr> <td width="50%">部门 : <html:text property="departname"/><td/> <td width="50%">使用人 : <html:text property="owner"/><td/><td width="50%">品牌: <html:text property="brand" /><td/><br/></tr><tr><td width="50%">购机时间 : <html:text property="buytime"/><td/><td width="50%">计算机名 : <html:text property="pcname"/><td/><td width="50%">使用人 : <html:text property="username"/><td/></tr><tr><html:submit value="提交"/><html:cancel value="取消"/></tr></html:form></table> <table border="1"> <tr> <td>使用人 :</td><td>内存 : </td><td>电话 : </td><td>特殊软件 : </td><td>机器型号 : </td><td>硬盘 : </td><td>购机时间 : </td><td>计算机名 : </td><td>cpu : <td><td>备注 : <td><td>病毒名称 : <td><td>部门 : <td><td>品牌 : <td><td>使用情况 :<td><td>用户名 : <td><td>是否液晶 : <td><td>光驱 : <td><td>职务 : <td> </tr> <logic:present name="rsArray" scope="request" > <logic:iterate id="rsArray" name="rsArray" > <tr> <td><bean:write name="rsArray" property="owner"/></td> <td><bean:write name="rsArray" property="memory"/></td> <td><bean:write name="rsArray" property="tele"/></td> <td><bean:write name="rsArray" property="specsoft"/></td> <td><bean:write name="rsArray" property="type"/></td> <td><bean:write name="rsArray" property="disksum"/></td> <td><bean:write name="rsArray" property="buytime"/></td> <td><bean:write name="rsArray" property="pcname"/></td> <td><bean:write name="rsArray" property="cpu"/></td> <td><bean:write name="rsArray" property="remark"/></td> <td><bean:write name="rsArray" property="virus"/></td> <td><bean:write name="rsArray" property="departname"/></td> <td><bean:write name="rsArray" property="brand"/></td> <td><bean:write name="rsArray" property="usething"/></td> <td><bean:write name="rsArray" property="username"/></td> <td><bean:write name="rsArray" property="iscrystal"/></td> <td><bean:write name="rsArray" property="ram"/></td> <td><bean:write name="rsArray" property="post"/></td> </tr> </logic:iterate></logic:present> </table> </body></html:html>action public ActionForward execute(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response) {SelectInfoForm selectInfoForm = (SelectInfoForm) form;// TODO// Auto-generated// method stubString brand = (String)selectInfoForm.getBrand();String buyTime = (String)selectInfoForm.getBuytime();String departname = (String)selectInfoForm.getDepartname();String owner = (String)selectInfoForm.getOwner();String Pcname = (String)selectInfoForm.getPcname();String username = (String)selectInfoForm.getUsername();System.out.println(brand +"_____________"+buyTime+ "__________"+departname+"________" +owner +"_____"+Pcname+"______________"+username);StringBuffer clause = new StringBuffer("select * from infopc where 1=1 ");if(!brand.equals("")){clause.append("and brand='"+brand+"'");}if(!buyTime.equals("")){clause.append("and buytime='"+buyTime+"'");}if(!departname.equals("")){clause.append("and departname='"+departname+"'");}if(!owner.equals("")){clause.append("and owner='"+owner+"'");}if(!Pcname.equals("")){clause.append("and pcname='"+Pcname+"'");}if(!username.equals("")){clause.append("and username='"+username+"'");}System.out.println("_______sql____________:" + clause);DB db = null;try {db = new DB();db.connDb();ResultSet rs = db.executeQuery(clause.toString());List list= new ArrayList();while(rs.next()) {//System.out.println("____ResultSet have value!___________");//Integer.parseInt(arg0)list.add(rs.getInt(1));list.add(rs.getString(2));list.add(rs.getString(3));list.add(rs.getString(4));list.add(rs.getString(5));list.add(rs.getString(6));list.add(rs.getString(7));list.add(rs.getString(8));list.add(rs.getString(9));list.add(rs.getString(10));list.add(rs.getString(11));list.add(rs.getString(12));list.add(rs.getString(13));list.add(rs.getString(14));list.add(rs.getString(15));list.add(rs.getString(16));list.add(rs.getString(17));list.add(rs.getString(18));list.add(rs.getString(19));System.out.println("rs.getInt(1):"+rs.getInt(1));System.out.println("list.size() :"+list.size());System.out.println(rs.getInt(1)+rs.getString(2));}request.setAttribute("rsArray", list);System.out.println("session_______setAttribute得值是："+list);System.out.println("____can run here!!!____________");return mapping.findForward("success");} catch (Exception e) {} finally {if (db != null)db.closeDb();}return null;}解决了一个下午 有点迷糊了 问题补充：写了个类 com.xxx.struts.util.Pcinfo 得到新异常。。javax.servlet.ServletException: Cannot find bean Pcinfo in any scopewhile(rs.next()) {//System.out.println("____ResultSet have value!___________");//Integer.parseInt(arg0)list.add(rs.getInt(1));list.add(rs.getString(2));//departlist.add(rs.getString(3));//ownerlist.add(rs.getString(4));//pcnamelist.add(rs.getString(5));//usernamelist.add(rs.getString(6));//postlist.add(rs.getString(7));//brandlist.add(rs.getString(8));//typelist.add(rs.getString(9));//cpulist.add(rs.getString(10));//memlist.add(rs.getString(11));//disksumlist.add(rs.getString(12));//ramlist.add(rs.getString(13));//iscrtylist.add(rs.getString(14));//buytimelist.add(rs.getString(15));//telelist.add(rs.getString(16));//speclist.add(rs.getString(17));//usethinglist.add(rs.getString(18));//viruslist.add(rs.getString(19));//remarkPcinfo ipform= new Pcinfo();ipform.setBrand(rs.getString(7));ipform.setBuytime(rs.getString(14));ipform.setCpu(rs.getString(9));ipform.setDepartname(rs.getString(2));ipform.setDisksum(rs.getString(11));ipform.setIscrystal(rs.getString(13));ipform.setMemory(rs.getString(10));ipform.setOwner(rs.getString(3));ipform.setPcname(rs.getString(4));ipform.setPost(rs.getString(6));ipform.setRam(rs.getString(12));ipform.setRemark(rs.getString(19));ipform.setSpecsoft(rs.getString(16));ipform.setTele(rs.getString(15));ipform.setType(rs.getString(8));ipform.setUsername(rs.getString(5));ipform.setUsething(rs.getString(17));ipform.setVirus(rs.getString(18));list.add(ipform);界面 如下： <logic:present name="rsArray" scope="request" > <logic:iterate id="rsArray" name="Pcinfo" type="com.xsminfo.struts.util.Pcinfo" > <tr> <td><bean:write name="rsArray" property="owner"/></td> <td><bean:write name="rsArray" property="memory"/></td> <td><bean:write name="rsArray" property="tele"/></td> <td><bean:write name="rsArray" property="specsoft"/></td> <td><bean:write name="rsArray" property="type"/></td> <td><bean:write name="rsArray" property="disksum"/></td> <td><bean:write name="rsArray" property="buytime"/></td> <td><bean:write name="rsArray" property="pcname"/></td> <td><bean:write name="rsArray" property="cpu"/></td> <td><bean:write name="rsArray" property="remark"/></td> <td><bean:write name="rsArray" property="virus"/></td> <td><bean:write name="rsArray" property="departname"/></td> <td><bean:write name="rsArray" property="brand"/></td> <td><bean:write name="rsArray" property="usething"/></td> <td><bean:write name="rsArray" property="username"/></td> <td><bean:write name="rsArray" property="iscrystal"/></td> <td><bean:write name="rsArray" property="ram"/></td> <td><bean:write name="rsArray" property="post"/></td> </tr> </logic:iterate></logic:present>.写法不对？
解决方案
你在request中的"rsArray"存放的是一个list这个list里面有许多不同类型的值:getInt,getString.但是取数据的时候却是告诉程序rsArray是有一个JavaBeans的列表，<logic:iterate id="rsArray" name="rsArray" > 并且JavaBean有属性owner<bean:write name="rsArray" property="owner"/>这个是错误的，你需要建立一个RSObject类，将属性存进这个RSObject,并且保证RSObject有下列属性。 <td><bean:write name="rsArray" property="owner"/></td> <td><bean:write name="rsArray" property="memory"/></td> <td><bean:write name="rsArray" property="tele"/></td> <td><bean:write name="rsArray" property="specsoft"/></td> <td><bean:write name="rsArray" property="type"/></td> <td><bean:write name="rsArray" property="disksum"/></td> <td><bean:write name="rsArray" property="buytime"/></td> <td><bean:write name="rsArray" property="pcname"/></td> <td><bean:write name="rsArray" property="cpu"/></td> <td><bean:write name="rsArray" property="remark"/></td> <td><bean:write name="rsArray" property="virus"/></td> <td><bean:write name="rsArray" property="departname"/></td> <td><bean:write name="rsArray" property="brand"/></td> <td><bean:write name="rsArray" property="usething"/></td> <td><bean:write name="rsArray" property="username"/></td> <td><bean:write name="rsArray" property="iscrystal"/></td> <td><bean:write name="rsArray" property="ram"/></td> <td><bean:write name="rsArray" property="post"/></td>
解决方案二：
while(rs.next()) { //System.out.println("____ResultSet have value!___________"); //Integer.parseInt(arg0) list.add(rs.getInt(1)); list.add(rs.getString(2)); list.add(rs.getString(3)); list.add(rs.getString(4)); list.add(rs.getString(5)); list.add(rs.getString(6)); list.add(rs.getString(7)); list.add(rs.getString(8)); list.add(rs.getString(9)); list.add(rs.getString(10)); list.add(rs.getString(11)); list.add(rs.getString(12)); list.add(rs.getString(13)); list.add(rs.getString(14)); list.add(rs.getString(15)); list.add(rs.getString(16)); list.add(rs.getString(17)); list.add(rs.getString(18)); list.add(rs.getString(19)); System.out.println("rs.getInt(1):"+rs.getInt(1)); System.out.println("list.size() :"+list.size()); System.out.println(rs.getInt(1)+rs.getString(2)); } 你在这里给list添加值 就想楼上说的 你没有给他放到一个Bean里 就是一个对象了 所以你就不能用<bean:write >了 你直接用EL输出一下${rsArray} 就行了 如果想哪么写就定义个对象 while(rs.next()) { //System.out.println("____ResultSet have value!___________"); // 对象 Obj obj = new Obj(); // 给对象赋值 从数据库中取出来的值 obj.setName(rs.getInt(1)); // 添加到集合中 list.add(obj); } 现在就保存到对象中了 就可以用<bean:write> 了