在例子一中同时有 # $ 正常运行,但在例子二中,却报错显示 # $ 不能同时存在,改成 '${变量}'正常运行,这是什么原因?
例子一:
UPDATE A SET ${khcode}=#{khcode}
例子二:
update ${x.tablename}
set ${x.a} = null,${x.reason} = null
where
<if test="x.endpdate == null and x.pdate != null">
TO_CHAR(pdate,'YYYY-MM-DD') = '${x.pdate}'
</if>
<if test="x.endpdate!=null and x.pdate != null">
TO_CHAR(pdate,'YYYY-MM-DD') between '${x.pdate}' and '${x.endpdate}'
</if>
and khcode = ${x.khcode} and plantid = ${x.plantid} and ${x.ismk} = 1