Mybatis 的xml的Mapper文件中用到Like拼接模糊查询时出现如下错误提示:
Parameter index out of range (2 > number of parameters, which is 1)
原因是 PreparedStatement的sql中?是不能带有引号的;
select * from t_user where nake like '%?%' Mybatis解析xml文件就会跑出异常,可以用一个函数轻松解决
select * from t_user where nake like CONCAT('%','${name}','%')