用mybatis的mapper代理模糊查询数据库,返回空集合怎么办
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},'%')
啥意思???