Android Sqlite IN, NOT IN syntax --- not int (?)

处理where column_name not in (?)：如果后面是一串字符或数字组合时，不可以直接用(?)来处理，而应该将这些字符组合直接作为条件字符串的一部分。

1. where column_name not in ('name1','name2')

2. db.query(TABLE, new String[] { "id", ""}, String.format(" type NOT IN (%s)", argsArrayToString(arrays)), null, null, null, null);

 

You cannot place just one '?' instead of a list of values. As such, there is little to gain from trying to parametrize lists. One can, of course, create 2,4,16-value prepared statements ..." type NOT IN (?,?)", new String[]{ "connect","answer" },... but even on a server with remote RDBMS it has questionable value. Istead, do

db.query(TABLE, new String[] { "id", ""}, " type NOT IN ('connect','answer')", null, null, null, null);

if the list is dynamic, you will have to escape the strings and put them into single quoted list.

 

Via: http://stackoverflow.com/questions/4707367/android-sqlite-in-not-in-syntax

转载于:https://www.cnblogs.com/veins/p/4050341.html