问题描述
- could not execute query是什么原因导致的啊？
-
There is no Action mapped for namespace / and action name LoginAction_login. - [unknown location]
at com.opensymphony.xwork2.DefaultActionProxy.prepare(DefaultActionProxy.java:177)
at org.apache.struts2.impl.StrutsActionProxy.prepare(StrutsActionProxy.java:61)
at org.apache.struts2.impl.StrutsActionProxyFactory.createActionProxy(StrutsActionProxyFactory.java:39)
at com.opensymphony.xwork2.DefaultActionProxyFactory.createActionProxy(DefaultActionProxyFactory.java:47)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:458)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
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.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
Hibernate:
select
administra0_.id as id0_,
administra0_.administrator_id as administ6_0_,
administra0_.email as email0_,
administra0_.name as name0_,
administra0_.password as password0_,
administra0_.realname as realname0_
from
Administrator administra0_
where
1=1
and (
lower(administra0_.name) like 'admin'
)
and administra0_.password='123456'
17:26:22,465 WARN org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 1054, SQLState: 42S22
17:26:22,466 ERROR org.hibernate.util.JDBCExceptionReporter:101 - Unknown column 'administra0_.administrator_id' in 'field list'
在控制台出现以下语句是什么意思
Hibernate:
select
administra0_.id as id0_,
administra0_.administrator_id as administ6_0_,
administra0_.email as email0_,
administra0_.name as name0_,
administra0_.password as password0_,
administra0_.realname as realname0_
from
Administrator administra0_
where
1=1
20:48:32,118 WARN org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 1054, SQLState: 42S22
20:48:32,126 ERROR org.hibernate.util.JDBCExceptionReporter:101 - Unknown column 'administra0_.administrator_id' in 'field list'
Hibernate:
select
administra0_.id as id0_,
administra0_.administrator_id as administ6_0_,
administra0_.email as email0_,
administra0_.name as name0_,
administra0_.password as password0_,
administra0_.realname as realname0_
from
Administrator administra0_
where
1=1
20:48:37,948 WARN org.hibernate.util.JDBCExceptionReporter:100 - SQL Error: 1054, SQLState: 42S22
20:48:37,949 ERROR org.hibernate.util.JDBCExceptionReporter:101 - Unknown column 'administra0_.administrator_id' in 'field list'
解决方案
here is no Action mapped for namespace / and action name LoginAction_login. - [unknown location]//未知的位置,是不是你路径写错了
like 'admin'//这个需不需要加%或者_
Unknown column 'administra0_.administrator_id' in 'field list'//未知的列
你根据打印的错误提示一个个找然后修改就可以了
如果回答对您有帮助,请采纳
解决方案二：
unknown的column，你的列名是不是用错了。
解决方案三：
mysql的代码执行有问题，可以贴出你的mysql部分的代码么？
时间： 2024-12-21 12:33:31