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

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