select * from ads_week_day_dos where 1=1 and 分类 = '手机' and 仓库类别 is not null ${if(len(dt)==0,"","and 时间='"+dt+"'")} ${if(len(pp)==0,"","and 品牌 in ('"+pp+"')")} ${if(len(spu)==0,"","and spu in ('"+spu+"')")} ${if(len(lb)==0,"","and 仓库类别 in ('"+lb+"')")} 我这sql 已经把这些品牌过滤掉了 为甚么还显示啊 |