用mybatis的mapper代理模糊查询数据库,返回空集合

用mybatis的mapper代理模糊查询数据库,返回空集合怎么办

img

img

img

img

img



SELECT * FROM TNotific
<where>
    <if test="method != null">
        and Method like CONCAT('%', #{method ,jdbcType=VARCHAR}, '%')
    </if>
    <if test="statusOfread != null">
        and StatusOfread = #{statusOfread,jdbcType=VARCHAR}
    </if>
    <if test="bizCaseId != null">
        and BizCaseId = #{bizCaseId,jdbcType=VARCHAR}
    </if>


like 模糊查询是需要用%来做模糊的,没有% 就相当于=


company_name like  #{companyName}
改为
company_name like  concat('%',#{companyName},'%')

啥意思???