模糊查询

<select id="findByPage" resultType="com.huarui.mapping.entity.ZdzEntity" parameterType="com.huarui.common.entity.web.Req">
   SELECT a.id,a.project_id,  a.project_name,  a.start_time,  a.end_time,  d.user_name,  b.customer_name,  a.status,  a.create_time
   FROM OA_PM_PROJECT a
   left join OA_PM_CUSTOMER b on a.customer_id = b.customer_id
   left join OA_COMPANY_USER d on a.user_id = d.user_id
   <where>
           a.status!='2'
      <if test="parameterMap.project_id != null">
         AND a.project_id LIKE CONCAT(CONCAT('%', #{parameterMap.project_id}), '%')
      </if>
      <if test="parameterMap.project_name != null">
         AND a.project_name LIKE CONCAT(CONCAT('%', #{parameterMap.project_name}), '%')
      </if>
      <if test="parameterMap.user_name != null">
         AND d.user_name LIKE CONCAT(CONCAT('%', #{parameterMap.user_name}), '%')
      </if>
      <if test="parameterMap.status != null">
         AND a.status LIKE CONCAT(CONCAT('%', #{parameterMap.status}), '%')
      </if>
   </where>
</select>