Type Exception Report
Message Request processing failed; nested exception is org.springframework.dao.TransientDataAccessResourceException:
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.TransientDataAccessResourceException: ### Error updating database. Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). ### The error may involve com.company.mapper.PayMapperDAO.addInfo-Inline ### The error occurred while setting parameters ### SQL: insert into payinfo values('2','?','?','?','?','?','?','?','?','?') ### Cause: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). ; SQL []; Parameter index out of range (1 > number of parameters, which is 0).; nested exception is java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:948) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827) javax.servlet.http.HttpServlet.service(HttpServlet.java:634) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812) javax.servlet.http.HttpServlet.service(HttpServlet.java:741) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
错误示例:
<insert id="addInfo" parameterType="payInfoEntity">
insert into payinfo values('#{pnum}','#{sumprice}','#{paydate}','#{pname}','#{yunprice}','#{shoupeople}','#{status}')
</insert>
问题解决:
把以上单引号去掉即可。
如:
<insert id="addInfo" parameterType="payInfoEntity">
insert into payinfo values(#{pnum},#{sumprice},#{paydate},#{pname},#{yunprice},#{shoupeople},#{status})
</insert>