一行代码解决 sql语句 in传入数组变字符串

--数组

var arrs= ['test1','test2','test3'];

--变字符串

var instring = "'"+arrs.join("','")+"'";

--拼接

var sql = "select * from table where CreateUser in ("+instring+")";

--结果

select * from table where CreateUser in ('test1','test2','test3')

意外金喜的博客 : http://blog.csdn.net/zzwwjjdj1/