<if test="name != null"> AND p.product_name LIKE ‘%${name}%‘ </if>
<if test="productName != null and productName != ''">
and p.product_name like CONCAT('%',#{productName},'%')
</if>
u.username like "%"#{userName,jdbcType=VARCHAR}"%"
<if test="name != null"> AND p.product_name LIKE ‘%${name}%‘ </if>
<if test="productName != null and productName != ''">
and p.product_name like CONCAT('%',#{productName},'%')
</if>
u.username like "%"#{userName,jdbcType=VARCHAR}"%"