select * from 表 where 1=1
${if(len(控件名)=0,"","and 字段 in ('"+控件名+"')")}
参数如果'1','2','3'格式
直接select * from 表 where 1=1
${if(len(控件名)=0,"","and 字段 in ("+控件名+")")}
如果是1,2,3格式
select * from 表 where 1=1
${if(len(控件名)=0,"","and 字段 in ('"+replace(控件名,",","','")+"')")}
snrtuemc 回复 遇见0817(提问者)参数如果\'1\',\'2\',\'3\'格式
直接select * from 表 where 1=1
${if(len(控件名)=0,\"\",\"and 字段 in (\"+控件名+\")\")}
如果是1,2,3格式
select * from 表 where 1=1
${if(len(控件名)=0,\"\",\"and 字段 in (\'\"+replace(控件名,\",\",\"\',\'\")+\"\')\")}