例如下拉框中设置三个选项,实际值分别为1、2、3
数据源中${if}如何设置能实现选择1时 sql中添加条件 and **=1 选择2 时sql条件为 and **=2 选择3 时sql条件为 and **=3
${if(canshu = '1',"and ** = '1'",if(canshu = '2',"and ** = '2'",if(canshu = '3',"and ** = '3'","")))}
where 1=1
${if(a='1','and **=1',if(a=2,'and **=2','and **=3'))}
SELECT * FROM TABLE WHERE 1=1 ${SWITCH(下拉,"1"," and **=1","2"," and **=2",下拉," and **=3")}
-------------
如果你的**是同一个字段可以简化为
SELECT * FROM TABLE WHERE **='${下拉}'