public class MemberSearchAction extends Action {
public ActionForward execute(ActionMapping actionMapping,
ActionForm actionForm, HttpServletRequest request,
HttpServletResponse response) {
MemberForm memberForm = (MemberForm) actionForm;
String mobilephone = memberForm.getInMobilephone();
DataSource ds = getDataSource(request);
DBManager dbm = new DBManager(ds);
DBSqlManager dbsm = new DBSqlManager();
HttpSession session = request.getSession();
ActionMessages errors = new ActionMessages(); List<MemberForm> list = new ArrayList<MemberForm>();
String sql = null;
if (mobilephone == null || mobilephone.equals("")) {
//查询全部会员信息
sql = SQL.SQL_MEM_QUE;
} else if (IsNumber.isNumber(mobilephone)) {
sql = SQL.SQL_MEM_QUE + " where mobile_phone like '%" + mobilephone
+ "%';";
System.out.print(sql); } else {
errors.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage(
"errors.member.mobilephone"));
if (!errors.isEmpty()) {
saveErrors(request, errors);
System.out.println("============================");
}
}
ResultSet rs = dbsm.display(sql, dbm); try {
while(rs.next()) {
MemberForm form = new MemberForm();
form.setMember_id(rs.getLong("member_id"));
form.setOutMobilephone(rs.getString("mobile_phone"));
form.setProduct_name_cn(rs.getString("product_name_cn"));
form.setClinet_code(rs.getString("clinet_code"));
form.setLast_login_date(rs.getString("last_login_date"));
form.setLogin_count(rs.getInt("login_count"));
form.setLocation_name(rs.getString("location_name"));
list.add(form);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
dbm.close();
} request.setAttribute("list", list); // 页面跳转
return actionMapping.findForward("toMemList");
}
}JSP:
<logic:iterate id="list" name="list">
<tr onClick="selectThis(this,'datalist');" onDblClick="">
<td nowrap class="listno">
<input type="checkbox">
</td>
<td nowrap>
<bean:write name="list" property="mobile_phone" />
</td>
<td nowrap>
<bean:write name="list" property="product_name_cn" />
</td>
<td nowrap>
<bean:write name="list" property="location_name" />
</td>
<td nowrap>
<bean:write name="list" property="clinet_code" />
</td>
<td nowrap>
<bean:write name="list" property="login_count" />
</td>
<td nowrap>
<bean:write name="list" property="last_login_date" />
</td>
</tr>
</logic:iterate>struts: <action name="MemberForm" path="/memberSearch" type="com.cn.business.mem.actions.MemberSearchAction">
<forward name="toMemList" path="/WEB-INF/jsp/mem/memberinfo.jsp" />
</action>日志:
2011-7-24 15:42:09 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet action threw exception
javax.servlet.jsp.JspException: Cannot find bean: "list" in any scope
at org.apache.struts.taglib.TagUtils.lookup(TagUtils.java:935)
at org.apache.struts.taglib.logic.IterateTag.doStartTag(IterateTag.java:232)
at org.apache.jsp.WEB_002dINF.jsp.mem.memberinfo_jsp._jspService(memberinfo_jsp.java:240)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
public ActionForward execute(ActionMapping actionMapping,
ActionForm actionForm, HttpServletRequest request,
HttpServletResponse response) {
MemberForm memberForm = (MemberForm) actionForm;
String mobilephone = memberForm.getInMobilephone();
DataSource ds = getDataSource(request);
DBManager dbm = new DBManager(ds);
DBSqlManager dbsm = new DBSqlManager();
HttpSession session = request.getSession();
ActionMessages errors = new ActionMessages(); List<MemberForm> list = new ArrayList<MemberForm>();
String sql = null;
if (mobilephone == null || mobilephone.equals("")) {
//查询全部会员信息
sql = SQL.SQL_MEM_QUE;
} else if (IsNumber.isNumber(mobilephone)) {
sql = SQL.SQL_MEM_QUE + " where mobile_phone like '%" + mobilephone
+ "%';";
System.out.print(sql); } else {
errors.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage(
"errors.member.mobilephone"));
if (!errors.isEmpty()) {
saveErrors(request, errors);
System.out.println("============================");
}
}
ResultSet rs = dbsm.display(sql, dbm); try {
while(rs.next()) {
MemberForm form = new MemberForm();
form.setMember_id(rs.getLong("member_id"));
form.setOutMobilephone(rs.getString("mobile_phone"));
form.setProduct_name_cn(rs.getString("product_name_cn"));
form.setClinet_code(rs.getString("clinet_code"));
form.setLast_login_date(rs.getString("last_login_date"));
form.setLogin_count(rs.getInt("login_count"));
form.setLocation_name(rs.getString("location_name"));
list.add(form);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
dbm.close();
} request.setAttribute("list", list); // 页面跳转
return actionMapping.findForward("toMemList");
}
}JSP:
<logic:iterate id="list" name="list">
<tr onClick="selectThis(this,'datalist');" onDblClick="">
<td nowrap class="listno">
<input type="checkbox">
</td>
<td nowrap>
<bean:write name="list" property="mobile_phone" />
</td>
<td nowrap>
<bean:write name="list" property="product_name_cn" />
</td>
<td nowrap>
<bean:write name="list" property="location_name" />
</td>
<td nowrap>
<bean:write name="list" property="clinet_code" />
</td>
<td nowrap>
<bean:write name="list" property="login_count" />
</td>
<td nowrap>
<bean:write name="list" property="last_login_date" />
</td>
</tr>
</logic:iterate>struts: <action name="MemberForm" path="/memberSearch" type="com.cn.business.mem.actions.MemberSearchAction">
<forward name="toMemList" path="/WEB-INF/jsp/mem/memberinfo.jsp" />
</action>日志:
2011-7-24 15:42:09 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet action threw exception
javax.servlet.jsp.JspException: Cannot find bean: "list" in any scope
at org.apache.struts.taglib.TagUtils.lookup(TagUtils.java:935)
at org.apache.struts.taglib.logic.IterateTag.doStartTag(IterateTag.java:232)
at org.apache.jsp.WEB_002dINF.jsp.mem.memberinfo_jsp._jspService(memberinfo_jsp.java:240)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货