struts2,hibernate java.lang.NumberFormatException: For input string 错误

最新推荐文章于 2022-05-13 03:41:54 发布

转载最新推荐文章于 2022-05-13 03:41:54 发布 · 2.5k 阅读

java 专栏收录该内容

2 篇文章

订阅专栏

本文详细描述了在Java项目中遇到的NumberFormatException错误的原因及解决办法，主要涉及action方法中使用通用service执行SQL查询并返回object类型的问题，以及jsp页面中如何正确处理和展示查询结果，避免错误发生。

java.lang.NumberFormatException: For input string

最近做项目，出现一个错误，如下：

java.lang.NumberFormatException: For input string: "article"

at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)

at java.lang.Integer.parseInt(Integer.java:449)

at java.lang.Integer.parseInt(Integer.java:499)

at javax.el.ArrayELResolver.coerce(ArrayELResolver.java:161)

at javax.el.ArrayELResolver.getValue(ArrayELResolver.java:45)

at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)

at org.apache.el.parser.AstValue.getValue(AstValue.java:123)

at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)

at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:935)

at org.apache.jsp.personShow_jsp._jspx_meth_s_005fiterator_005f0(personShow_jsp.java:226)

at org.apache.jsp.personShow_jsp._jspService(personShow_jsp.java:178)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)

at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)

at org.apache.struts2.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:139)

at org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.java:178)

at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:348)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:253)

at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:221)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)

at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)

at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)

at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:150)

at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:48)

at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)

at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)

at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)

at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)

at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:123)

at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)

at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)

at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)

......

花费了我好长时间，不过最后还是发现了问题所在，分享一下，希望能帮到大家。

action中方法代码：(注:generalService为通用service)

public String personShow() throws Exception{

person = (Person) generalService.findByProperty(Person.class, "id", personId).get(0);

String allCountSql = "SELECT count(id) FROM Doc where personId ='"+personId+"'";

String hql = "select * FROM doc where person_id = '"+personId+"' ORDER BY 'insertTime' DESC";

int allCount = ((Long)(generalService.find(allCountSql)).get(0)).intValue();

// docList = generalService.find(hql,page.start*10,10);

docList = generalService.executeSQL(hql); //错误所在

page.setAllCount(allCount);

page.setStart(page.getStart());

return "personShow";

}

jsp中代码：

<s:iterator value="docList" id="m" status="index">

<tr>

<td colspan="4" align="left">${m.article}</td>

</tr>

<tr>

<td width="25%" align="center">${m.insertTime}</td>

<td width="25%" align="center"> <a href="">${m.origin }</a></td>

<td width="25%" align="center">  ${m.transmit}</td>

<td width="25%" align="center"> ${m.discuss}</td>

</tr>

</table>

</s:iterator>

此问题的主要是因为 generalService.executeSQL(hql)返回的list集合中的元素为object类型，没有转化为doc类对象，导致显示时找不到对应的article等。