报错信息如下:
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping:
ParameterMapping{property='hgtime', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}.
Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #3 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 (3 > number of parameters, which is 2).
大概率 没人遇到的不同
处理方式为:
把xml select 中的 where 注释**- -** 删除,即可。
WHERE -- status=0
and age=18
修改如下
WHERE age=18
或者加上
and st.hgtime = #{hgtime}
and st.hgtime = #{hgtime,jdbcType=VARCHAR}