sqlite3 api使用

gistfile1.txt

if (sqlite3_open([DATABASE UTF8String], &database) == SQLITE_OK)
  {
    NSString *sql = [NSString stringWithFormat:@"update lpb set %@ = '%@' where level='%@'", self.typeString, self.iconString, self.levelString];
    if (sqlite3_exec(database, [sql UTF8String], NULL, NULL, &error) != SQLITE_OK)
      NSLog(@"LPBERROR: %@ , %s",sql, error);

    sqlite3_close(database);
  }