Mybatis中的模糊查询

把’%#{name}%'改为”%”#{name}”%”

<select id="searchStudents" resultType="com.example.entity.StudentEntity"
 parameterType="com.example.entity.StudentEntity">
 SELECT * FROM test_student
 <where>
  <if test="age != null and age != '' and compare != null and compare != ''">
   age
   ${compare}
   #{age}
  </if>
  <if test="name != null and name != ''">
   AND name LIKE "%"#{name}"%"
  </if>
  <if test="address != null and address != ''">
   AND address LIKE "%"#{address}"%"
  </if>
 </where>
 ORDER BY id
</select>