参数多,选择其中某个,或者多个,查询出对应的数据,不选的默认全部,
那个if判断的格式怎么写
https://help.fanruan.com/finereport10.0/doc-view-2394.html?source=4#
不选默认全部
select * from 表 where 1=1
${if(len(控件1)=0,""," and 字段1='"+控件1+"'")}
${if(len(控件2)=0,""," and 字段2='"+控件2+"'")}
${if(len(控件3)=0,""," and 字段3='"+控件3+"'")}