分开写呢
SELECT * FROM TABLE
WHERE 1=1
${if(len(存货编码) == 0,"","and 字段 in ('" + 存货编码+ "')")}
${if(len(产品名称) == 0,"","and 字段1 in ('" + 产品名称 + "')")}
${if(len(存货分类) == 0,"","and 字段2 in ('" + 存货分类 + "')")}
${if(len(lot_ID) == 0,"","and 字段3 in ('" + lot_ID + "')")}
-------------------
MySQL数据库中文乱码-https://help.fanruan.com/finereport10.0/doc-view-1127.html