参数为空查询全部:固定值
WHERE 1=1 ${if(len(参数) == 0,"","and 字段 = '" + 参数 + "'")}
参数为空查询全部:模糊查询
WHERE 1=1 ${if(len(参数) == 0,""," and 字段like '%" + 参数 + "%'")}
参数为空查询全部:下拉复选框
注意下拉复选框,返回值是 ‘,’
WHERE 1=1 ${if(len(参数) == 0,"","and 字段 in ('" + 参数+ "')")}