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
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。