例如将一个数组['123','12345','3456','7896‘] 作为一个SQL语句的查询条件,正常这个语句应该是
select 字段名 from 表名 where userid in ('123','12345','3456','7896’)
当数组数据已知且固定我们可以手动将数据填入sql语句中,当不可知或数据多时可以通过循环写入
let arr = ['123','12345','3456','7896‘]
let query_sql = 'select 字段名 from 表名 where userid in ('
let str = ''
let endStr = ''
for ( let i=0; i<arr.length; i++) {
str = '"' + arr[i] + '"'
if (i<arr.length -1) {
str += ","
}
endStr += str
}
query_sql = query_sql + endStr + ')'
console.log('语句query_sql', query_sql)
// 输出语句就是
// 'select 字段名 from 表名 where userid in ('123','12345','3456','7896‘)'