多条件查询

-----数据库多查询------------
Declare @sql Varchar(1000)
Declare @List Varchar(500)
Set @List=@dept_code  //@List='1,2,3,4,5'
set @sql='Select * From Test where code In('+@List+')'
Exec(@sql)

 

ajax传数据

--------传数据----------

var select = document.getElementById("secretLevel");
var str = [];
for (i = 0; i < select.length; i++) {
if (select.options[i].selected) {
str.push(select[i].value);
}
}

var aa = '"' + str + '"';
aa = aa.replace(/\"/g, ""); 去掉双引号
var dept_code =aa;