那位大侠能帮忙给看看关于两表联查的问题(能远程帮忙调试一下急急)

[xuanzishu]

Hibernate:
select
capture0_.Id as Id2_0_,
student1_.Id as Id0_1_,
capture0_.StudentID as StudentID2_0_,
capture0_.Schoolyear as Schoolyear2_0_,
capture0_.Amountone as Amountone2_0_,
capture0_.Amounttwo as Amounttwo2_0_,
capture0_.Signatureone as Signatur6_2_0_,
capture0_.Signaturetwo as Signatur7_2_0_,
capture0_.Note as Note2_0_,
student1_.Name as Name0_1_,
student1_.Sex as Sex0_1_,
student1_.National as National0_1_,
student1_.Political as Political0_1_,
student1_.Pinid as Pinid0_1_,
student1_.Learning as Learning0_1_,
student1_.Levels as Levels0_1_,
student1_.Stood as Stood0_1_,
student1_.Address as Address0_1_,
student1_.Mailj as Mailj0_1_,
student1_.Mobile as Mobile0_1_,
student1_.Student_Class as Student13_0_1_,
student1_.Professional as Profess14_0_1_,
student1_.EnterTime as EnterTime0_1_,
student1_.Resume as Resume0_1_,
student1_.Family as Family0_1_,
student1_.Workunit as Workunit0_1_,
student1_.Changes as Changes0_1_,
student1_.Disobeys as Disobeys0_1_,
student1_.Telj as Telj0_1_,
student1_.Maild as Maild0_1_,
student1_.Teld as Teld0_1_,
student1_.Eductional as Eductional0_1_,
student1_.Wastime as Wastime0_1_,
student1_.Secco as Secco0_1_,
student1_.Account as Account0_1_,
student1_.Category as Category0_1_,
student1_.Departments as Departm29_0_1_,
student1_.Student_ID as Student30_0_1_,
student1_.Student_telx as Student31_0_1_,
student1_.Birthday as Birthday0_1_,
student1_.Graduation as Graduation0_1_,
student1_.Diploma as Diploma0_1_,
student1_.Degree as Degree0_1_,
student1_.Certificat as Certificat0_1_,
student1_.Subordinate as Subordi37_0_1_,
student1_.Cultural as Cultural0_1_,
student1_.Admission as Admission0_1_,
student1_.Student_describ as Student40_0_1_,
student1_.Booktime as Booktime0_1_,
student1_.BookNote as BookNote0_1_
from
studentdb.capture capture0_,
studentdb.student student1_
where
student1_.Id=capture0_.StudentID
and student1_.Name='法国队的'
2011-6-8 10:00:01 org.apache.catalina.core.ApplicationDispatcher invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.NumberFormatException: For input string: "id"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:447)
at java.lang.Integer.parseInt(Integer.java:497)
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.captureManager.dunning_jsp._jspx_meth_s_005fiterator_005f0(dunning_jsp.java:406)
at org.apache.jsp.captureManager.dunning_jsp._jspService(dunning_jsp.java:195)
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.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:88)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:154)
at org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.java:186)
at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:362)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:266)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)

[howsun_zh]

这不是查询出的问题吧。可能是前台一个表单接受数字的控件却被输入了非数字的字符串。

[xuanzishu]

<td height="30" align="center">请输入姓名：
<s:textfield name="name" cssStyle="width:100px" cssClass="text_2000" maxlength="10"></s:textfield>
请输入身份证号：
<s:textfield name="pinid" cssStyle="width:180px" cssClass="text_2000" maxlength="18"></s:textfield>  
<input type="button" class="Submit" value="查询" style="width:100px" onclick="sumbilt();"/>
</td>
只输入这两个啊！怎么有非法字符呢？

[kevinPai2011]

你qq多少？ 这个好像是输入的时候的错误！ 我QQ303579750

[xuanzishu]

我QQ：81657263[Quote=引用 3 楼 kevinpai2011 的回复:]
你qq多少？ 这个好像是输入的时候的错误！ 我QQ303579750
[/Quote]