XML document structures must start and end within the same entity.
<if test="price2 != null"> <![CDATA[and
f.ticketPrice <= #{price2}]]></if>
你的那种转义符也是可以的就是看着乱点,
<![CDATA[ <=]]> #{killTime}
and start_time <![CDATA[<=]]#{killTime}
还少了一个结束的“>”在#号前面
我果然开启了自问自答。。亲们换成这个吧
原符号 < <= > >= & ' "
替换符号 < <= > >= & ' "
update
seckill
set
number=number-1
where seckill_id=#{sechillId}
and start_time <![CDATA[<=]]#{killTime}
and end_time >=#{killTime}
and number > 0;