mysql 别名找不到_mysql - 带有别名的MySQL select语句失败，找不到列 - 堆栈内存溢出...

java.sql.SQLException：找不到列“深度”。 在com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)在com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)在com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) )com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1167)com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java：com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1167)处com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920) 5733)在EntityAssessmentEntityActions.EntityAssessmentEntityListAction.detailedEntityList(EntityAssessmentEntityListAction.java:184)在EntityAssessmentEntityActions.EntityAssessmentEntityListAction.execute(EntityAssessmentEntityListAction.java:69)在sun.reflect.NativeMethodAccessorImpl.inoke.NativeMethodAccessorImpl.in .java：57)位于sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)位于com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActi)上java.lang.reflect.Method.invoke(Method.java:606)处 com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289)上的onInvocation.java:450)org.apache.struts2.interceptor.debugging处com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252)上的onInvocation.java com处com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)处的com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)处的.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)。在com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)处的opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)在com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java 265)，位于com.opensymphony.xwork2.interceptor的org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)处。 在com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)处的MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)在com.opensymphony的com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)处com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98处的.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)在com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:249) )com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:249)com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept( com.opensymphony.xwork2.DefaultActionInvocation.invoke上的MethodFilterInterceptor.java:98)(com.opensymphony.xwork2.int上的DefaultActionInvocation.java:246) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)的erceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191)在org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73)处org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91)上的.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)，com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) )在org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252)在com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)在com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept com.opensymphony.xwork2.DefaultActionInvocation.invoke的ModelDrivenInterceptor.java:100).com.opensymphony.xwork2.interceptor.ScopedModelDrivenInte(DefaultActionInvocation.java:246) com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)的com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)的rceptor.intercept(ScopedModelDrivenInterceptor.java:141) com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)处的.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)在com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) )在com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)在com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)在com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation。 org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)上的com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvoc)上的java：246) ation.java:246)com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193)com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)com.opensymphony.xwork2.interceptor org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)上的com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246)上的.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)。 org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)处的apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:546)在org.apache.struts2.dispatcher.ng.filter处。 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243 :)的StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)在org.org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) .apache.catalina。 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)org.apache.catalina.authenticator.Authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)的core.StandardContextValve.invoke(StandardContextValve.java:123)在org.apache.catalina.valv.ErrorReportValve.invoke(ErrorReportValve.java:99)在org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)在org.apache.catalina.valves.AccessLogValve.invoke (AccessLogValve.java:947)，位于org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)，位于org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)，位于org.apache。位于org.apache.coyote.AbstractProtocol $ AbstractConnectionHandler.process(AbstractProtocol.java:589)的coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1009)在org.apache.tomcat.util.net.JIoEndpoint $ SocketProcessor.run( JIoEndpoint.java:312)，位于java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:11 45)在java.util.concurrent.ThreadPoolExecutor $ Worker.run(ThreadPoolExecutor.java:615)在java.lang.Thread.run(Thread.java:724)