-- 参数控件为空选择全部
SELECT * FROM table_name
WHERE 1 = 1
${if(len(参数1) == 0,"","and 字段1 = '" + 参数1 + "'")} -- 下拉框单选
${if(len(参数2) == 0,"","and 字段2 in ('" + replace(参数2,",","','") + "')")} -- 复选框多选
-- 联动从第一个参数往下结合
下拉多选框设置:
数据集里面正常的拼接就行
${if(len(参数名) == 0,"","and studentno in '(" + 参数名+ ")'")}