org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0

登陆页面显示HTTP Status 404 - /travel/failServelt

img


控制台显示
org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
at org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:71)
at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:812)
at dao.AdminUserDao.AdminLogin(AdminUserDao.java:18)
at web.servlet.AdminUserServlet.doGet(AdminUserServlet.java:26)
at web.servlet.AdminUserServlet.doPost(AdminUserServlet.java:46)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at web.filter.CharchaterFilter.doFilter(CharchaterFilter.java:32)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

img


求解惑!

错误的意思是“期望查询出一个对象然后封装,但是实际上由于数据库中没有匹配的条件,导致查询了零个对象”,因此报错。
可以检查查询条件是否正确,或者给代码加上try-catch语句。具体错误出现在

img

https://blog.csdn.net/weixin_47889104/article/details/125433905

404先检查自己地址什么的有没有问题,找不到路径就是404

建议你看下这篇博客【技术小常识之排查错误】org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected

已经解决了,不是try catch的问题,也不是地址的问题,是HTML传参没有传过去,改了下active就正常运行了