一次性报的异常主要有以下几个:
java.lang.RuntimeException: org.mybatis.spring.MyBatisSystemException: nested
exception is org.apache.ibatis.type.TypeException:

Could not set parameters for mapping: ParameterMapping{time=’time’, mode=IN,
javaType=class java.lang.Object, jdbcType=null, numericScale=null,
resultMapId=’null’, jdbcTypeName=’null’, expression=’null’}.

Cause: org.apache.ibatis.type.TypeException: Error setting non null for
parameter #4 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 (4 > number of
parameters, which is 3).

最后发现原来是。。。

mapper.xml映射文件里有注释!!!!!

把注释删掉,一切OK!