Zero丶zero(提问者) 回复 Coldman搞出来了,感谢大佬。我把控件字段都改成一样了
select * from campus_area where
1=1
${if(len(department)==0,\"\",\"and department =\'\" + department + \"\'\")}
${if(len(campus_name)==0,\"\",\"and campus_name =\'\" + campus_name + \"\'\")}
select campus_name from campus_area
where department =\'${department}\'