分析思路:
发现问题----HTTP Status 500 - Incorrect result size: expected 1, actual 0异常
分析问题----找报错的根源
由于JdbcTemplate的queryForObject找到结果集长度为1实际上0,引起了daoImpl错误,引起BizImpl错误,引起Controller错误-----最终引起
HttpServlet.service服务器错误,得到状态码500
解决问题---排除法+剖析法
如果DaoImpl层没问题,就是你传的参数有问题
1.看一下Dao层
2.建测试类,测试DaoImpl如果传其他参数不报错
结果:
三月 19, 2017 12:27:31 上午 org.springframework.context.support.ClassPathXmlApplicationContext prepareRefresh 信息: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@533ddba: startup date [Sun Mar 19 00:27:31 CST 2017]; root of context hierarchy 三月 19, 2017 12:27:31 上午 org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions 信息: Loading XML bean definitions from class path resource [bean.xml] 三月 19, 2017 12:27:35 上午 com.mchange.v2.log.MLog <clinit> 信息: MLog clients using java 1.4+ standard logging. 三月 19, 2017 12:27:36 上午 com.mchange.v2.c3p0.C3P0Registry banner 信息: Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10] Employee[name='pdd', pwd='123']
3.再看Servlet外部传参,如果直接在Servlet里面直接getBean抛以下异常--------------------直接getBean但没传参
HTTP Status 500 - Incorrect result size: expected 1, actual 0
type Exception report
message Incorrect result size: expected 1, actual 0
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0 org.springframework.dao.support.DataAccessUtils.requiredSingleResult(DataAccessUtils.java:71) org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:801) com.lrq.dao.daoImpl.EmployeeDaoImpl.query(EmployeeDaoImpl.java:28) com.lrq.biz.bizImpl.EmployeeBizImpl.login(EmployeeBizImpl.java:31) com.lrq.controller.LoginServlet.doPost(LoginServlet.java:31) javax.servlet.http.HttpServlet.service(HttpServlet.java:648) javax.servlet.http.HttpServlet.service(HttpServlet.java:729) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) com.lrq.filter.LoginFilter.doFilter(LoginFilter.java:28) com.lrq.filter.EncodingFilter.doFilter(EncodingFilter.java:26)
4.解决方法:
set和get方法设定参数以后:
成功