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>