Mybatis的几种模糊查询

模糊查询在项目的检索中经常用到，我就说一下我知道的这几种

---

1. sql中字符串拼接

   select * from table where column like concat(concat(‘%’,#{value}),’%’);

2. 在java中拼接再传
   String NewValue = new StringBuilder(“%”).append(value).append(“%”).toString();
   parameterMap.put(“value”, NewValue);
   其实有种简单的：
   String NewValue = “%” + value + “%”;

3. 使用bind标签

<select id="selectUser" resultType="entity.User" parameterType="entity.User">
  <bind name="pattern" value="'%' + _parameter.username + '%'" />
  select id,username from user
  where username LIKE #{pattern}
</select>