解决java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).等类似问题

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>