使用Druid后,模糊查询抛出异常
- xml文件如下:
<if test="type != null">
`type` like '%' #{
type,jdbcType=VARCHAR} '%'
</if>
- 异常如下:
### Error querying database. Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :'ype` like '%' ? '%'', expect QUES, actual QUES pos 201, line 7, column 28, token QUES : select
id, `type`, creatTime, expirationTime,