where
<if test="goodsKey != null and goodsKey != ''">
AND GOODS_KEY LIKE concat('%',#{goodsKey},'%') ------------------ mysql:模糊查询:
AND GOODS_CODE LIKE CONCAT(CONCAT('%',#{goods_code}),'%') --------------- --- ORACLE:模糊查询:
</if>