XML文件写入

  <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

三和mapper接口放