ios FMDB WHERE IN array

短命女 2022-07-16 17:20 181阅读 0赞

1、表

CREATE TABLE map\_group\_ac (  
  gp\_id integer,  
  ac\_id varchar,  
  PRIMARY KEY(gp\_id, ac\_id)  
);

2. 正确的SQL是

NSMutableString \*fieldString = \[NSMutableStringnew\];

\[fieldStringappendString:@"SELECT ac\_id FROM  map\_group\_ac where gp\_id  IN ("\];

for (NSNumber \*gpNoin groups) \{

\[fieldStringappendString:@"?,"\];

\[fieldString replaceCharactersInRange:NSMakeRange(\[fieldStringlength\] -1,1)withString:@")"\];

NSString \*normalString = \[NSStringstringWithString:fieldString\];

FMResultSet \*ps = \[shareDataBaseexecuteQuery:normalStringwithArgumentsInArray:groups\];   //groups is Number Array

3、（3.1-3.3）下面这几种方法试了都不起作用。3.4还未尝试

3.1

NSArray \*mergeIds; // An array of NSNumber Objects    
NSString \*mergeIdString = \[mergeIds componentsJoinedByString:@","\];     
NSString \*query = @"SELECT \* FROM items WHERE last\_merge\_id IN (?)";     
FMResultSet \*res = \[self.database executeQueryWithFormat:query, mergeIdString\];  
  
  
3.2

FMResultSet \*ps = \[shareDataBase executeQuery: @"SELECT ac\_id FROM  map\_group\_ac  where gp\_id in ?", groups\];

3.3   
NSArray \*array = \[NSArray arrayWithObjects:@"1",@"2",@"3",nil\];  
NSString \*components = \[array componentsJoinedByString:@", "\];  
NSMutableString \*valueString = \[NSMutableString new\];  
NSMutableString \*fieldString = \[NSMutableString new\];  
\[fieldString appendString:@"SELECT id FROM FriendList WHERE id NOT IN ("\];  
for (NSString \*fielValue in array) \{  
    \[fieldString appendString:@"?,"\];  
    \[valueString appendString:fielValue\];  
\}  
\[fieldString replaceCharactersInRange:NSMakeRange(\[fieldString length\] - 1, 1) withString:@")"\];  
NSString \*normalString = \[NSString stringWithString:fieldString\];  
FMResultSet \* rs = \[self.db executeQuery:@"%@", normalString, components\];

3.4

[https://github.com/mehlkelm/FMDB-InOperator][https_github.com_mehlkelm_FMDB-InOperator]

[https_github.com_mehlkelm_FMDB-InOperator]: https://github.com/mehlkelm/FMDB-InOperator