iphone - 通过 SQLIte 数据库访问对象

Question

我正在将一个对象传递给执行查询的方法。我的方法是:

-(BOOL)searchWordInDatabase:(NSString *)string
{
NSArray *paths=NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
NSString *documentsDirectory= [paths objectAtIndex:0];
NSString *path=[documentsDirectory stringByAppendingPathComponent:@"SymbolTalkLanguageElement.sqlite"];

//Open the database
//might have to make database as property
if(sqlite3_open([path UTF8String], &dataBase) ==SQLITE_OK)
{
    const char *sql="select ImageName from tblLanguageElement where Category= string";
    sqlite3_stmt *statement;

    if(sqlite3_prepare(dataBase, sql, -1, &statement, NULL) == SQLITE_OK)
    {
        while (sqlite3_step(statement) == SQLITE_ROW) 
        {
            NSLog(@"%@",[NSString stringWithUTF8String:(char *)sqlite3_column_text(statement, 0)]);
            //[list addObject:[NSString stringWithUTF8String:(char *)sqlite3_column_text(statement, 0)]];
            return YES;
        }

    }



}
return NO;

但我没有在查询中获取字符串的值。我该怎么做？

Answer 1

您的查询有误。你不能替换这样的字符串。按照以下方式进行。

NSString *sqlStr = [NSString stringWithFormat:@"select ImageName from tblLanguageElement where Category = '%@'", string];
char *sql = (char *)[sqlStr UTF8String];