mybatis模糊查询

来源：互联网发布：阿里云 iaas paas 编辑：程序博客网时间：2024/06/05 16:33

1. 参数中直接加入%%

------param.setUsername("%CD%");------param.setPassword("%11%");<select id="selectPersons" resultType="person" parameterType="person">     select id,sex,age,username,password from person where true         <if test="username!=null">              AND username LIKE #{username}         </if>         <if test="password!=null">              AND password LIKE #{password}         </if></select>

2. bind标签

<select id="selectPersons" resultType="person" parameterType="person">     <bind name="pattern" value="'%' + _parameter.username + '%'" />           select id,sex,age,username,password           from person           where username LIKE #{pattern}</select>

3. CONCAT

where username LIKE concat(cancat('%',#{username}),'%')

4. sql中字符串拼接

SELECT * FROM tableName WHERE name LIKE CONCAT(CONCAT('%', #{text}), '%');

5. 使用 ${...} 代替 #{...}

SELECT * FROM tableName WHERE name LIKE '%${text}%';

6. 大小写匹配查询

SELECT * FROM TABLENAME WHERE UPPER(SUBSYSTEM) LIKE '%' || UPPER('jz') || '%'或者SELECT * FROM TABLENAME WHERE LOWER(SUBSYSTEM) LIKE '%' || LOWER('jz') || '%'

0 0