1.首先看一下我们的dao层
发现是这样写的
List<LifeIncinerateAcceptEntity> sumSangito( Map<String, Object> params);
2.再回到我们的xml文件中,这里是没有问题的
<select id="sumSangito">
select *
from XXX a
<if test="params.year != null and params.year !=''">
and a.accept_time like concat('%',#{params.year},'%')
</if>
</select>
3.最后发现,dao层里面少写了==@Param(“params”)==注解,在xml里面就用到了。。所以就出错
List<LifeIncinerateAcceptEntity> sumSangito(@Param("params") Map<String, Object> params);
4.如果不想写那个注解,那就在XML中这样写
5.就不要params传参了
<select id="sumSangito">
select *
from XXX a
<if test="year != null and year !=''">
and a.accept_time like concat('%',#{year},'%')
</if>
</select>