数据库查询中，sql语句实现下拉复选框

${if(len(company)=0,"","and sc.SUPPLY_CENTER_NAME IN ('"+company+"')")}  ,模板参数company  设为下拉复选 框，筛选查询不起作用

len(company)==0 试一试

直接报错

${if(len(company)=0,"","and sc.SUPPLY_CENTER_NAME IN ('"+replace(company," ","','")+"')")}

下拉复选传多个值，中间用英文逗号分隔，传字符串前后均有引号，需替换转化下

返回值类型怎么设置的

你这sc.SUPPLY_CENTER_NAME字段是什么类型。字符串这么写IN不行哦。如果是INT类型你就不要单引号。

${if(len(company)==0,"","and sc.SUPPLY_CENTER_NAME IN ('"+replace(company,",","','")+"')")}
复选框中的文本是用逗号分隔的如  复选框内容一,复选框内容二  用replace替换掉逗号
变成 复选框内容一','复选框内容二
完整的就变成了   SUPPLY_CENTER_NAME IN ('复选框内容一','复选框内容二')

${if(len(company) == 0,""," and sc.SUPPLY_CENTER_NAME in ('" + company + "')")}  

1、${if(len(company) == 0,""," and sc.SUPPLY_CENTER_NAME in ('" + company + "')")}  
2、筛选项的分隔符设置为','