java.sql.SQLException: Parameter index out of range (5 ＞ number of parameters, which is 4)

2020-12-16 09:30:12.493 ERROR 10560 — [nio-5050-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet] :
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping:

ParameterMapping{property='id', mode=IN, javaType=int, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. 		Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #5 with JdbcType null . 
Try setting a different JdbcType for this parameter 	or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range 
(5 > number of parameters, which is 4).] with root cause

java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4).

解析：第一种可能mapper.xml中sql语句里有注释，删除注释，便可成功
第二种可能sql语句，字段没写完。