第1种:在Java代码中添加sql通配符。
> string wildcardname = “%smi%”;
> list<name> names = mapper.selectlike(wildcardname);
> <select id=”selectlike”> select * from foo where bar like #{value}
> </select>
第2种:在sql语句中拼接通配符,会引起sql注入
> string wildcardname = “smi”;
> list<name> names = mapper.selectlike(wildcardname);
> <select id=”selectlike”> select * from foo where bar like "%"#{value}"%"
> </select>
了解更多java面试题欢迎关注小编面试专栏!