1、XML 中使用 #{},Java 代码中传入 "%参数值%"
Java:
list< User> users = mapper.select(Collections.singleMap("name", "%constxiong%"));
XML:
< select id=”select” resultMap="User" parameterType="String">
select * from user where name like #{name}
< /select>
2、XML 中使用 ${},Java 代码中传入
Java:
list< User> users = mapper.select(Collections.singleMap("name", "constxiong"));
XML:
< select id=”select” resultMap="User" parameterType="String">
select * from user where name like '%${name}%'
< /select>
【Java面试题与答案】整理推荐