mybatis模糊查询错误

错误信息:Could not set parameters for mapping: ParameterMapping{property=‘value’, mod…

https://www.cnblogs.com/fan-yuan/p/9299831.html

 

select * from user where name like '%${name}%'-------解析成------------select * from smbms_role where roleName like '%name%' 
select * from user  where name like '%#{name}%'----------解析成--------select * from smbms_role where roleName like '%?%'     ----失败

select * from user  where name like concat('%',#{name},'%')   ---可以使用字符串拼接写法

posted @ 2019-09-19 10:10  似清风  阅读(434)  评论(0编辑  收藏  举报