Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #15 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 (15 > number of parameters, which is 14).
at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:71)
at com.baomidou.mybatisplus.core.MybatisDefaultParameterHandler.setParameters(MybatisDefaultParameterHandler.java:227)
... 88 more
Caused by: java.sql.SQLException: Parameter index out of range (15 > number of parameters, which is 14).
如果代碼SQL中存在注釋 SQL片段,注釋的SQL片段 中不能使用#{} 參數。如下:
on t1.dealer_code = t4.dealer_code
-- left join (
-- select
-- ads_code
-- ,sum(case when car like '%MM%' or model = 'MM' then ss_num else 0 end) as ws_MM_num
-- from abc_assss_ss
-- where seq = 1 and count_date between '2021-04-01' and '2021-06-30'
-- group by
-- dealer_code
-- )t2
-- on t1.asd_code = t2.ads_code
)
select
~~~
如果把between and 之間也用參數代替 寫成between #{start_time} and #{end_time},會報這樣的錯誤,希望能解決各位問題