<if test="name != null and name !='' ">
and f.file_title like concat('%',#{name},'%')
</if>
一 所有模糊查询写在一起的XML
<if test="query != null and query != ''">
and
( info.gateway_sn like concat('%',#{query}, '%')
or info.gateway_name like concat('%',#{query}, '%')
or version.type like concat('%', #{query}, '%')
or area.name like concat('%', #{query}, '%'))
</if>
二 :放在resource下任意目录
mybatis:
mapper-locations: classpath:/mapper/*.xml