iphone - 保存查询值

如何从NSMutableArray中的查询保存值。

tempQuery=[@"select * from iapp_tbl_questions where id= " stringByAppendingString:[NSString stringWithFormat:@"%d",rowid1]];


const char *query2=[tempQuery UTF8String];
if (sqlite3_prepare_v2(database,query2,-1,&statement1,NULL)==SQLITE_OK) {
     NSLog(@"vt", vt);
    vt=[[[Question1 alloc]init]autorelease];
    while (sqlite3_step(statement1)==SQLITE_ROW) {

        vt.question=[NSString stringWithUTF8String:(char *)sqlite3_column_text(statement1,3)];

    }
}
return vt;

谢谢...

最佳答案

const char *query2=[tempQuery UTF8String];
 NSMutableArray *results = nil;
if (sqlite3_prepare_v2(database,query2,-1,&statement1,NULL)==SQLITE_OK) {
     NSLog(@"vt", vt);
    results= [[NSMutableArray alloc]init];
    while (sqlite3_step(statement1)==SQLITE_ROW) {
vt=[[[Question1 alloc]init]autorelease];
        vt.question=[NSString stringWithUTF8String:(char *)sqlite3_column_text(statement1,3)];
[results addObject:vt];

    }
}
return results;

关于iphone - 保存查询值，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/9820119/