iOS中FMDB数据库之增删改查使用实例

multithread:

- (void)multithread {
  NSLog(@"%s", __func__);

  FMDatabaseQueue *queue = [FMDatabaseQueue databaseQueueWithPath:self.dbPath];
  dispatch_queue_t q1 = dispatch_queue_create("queue1", NULL);
  dispatch_queue_t q2 = dispatch_queue_create("queue2", NULL);

  dispatch_async(q1, ^{
    for (int i = 0; i < 100; ++i) {
      [queue inDatabase:^(FMDatabase *db) {
        NSString *sql = @"insert into user (name, password) values(?, ?) ";
        NSString *name = [NSString stringWithFormat:@"queue111 %d", i];
        BOOL res = [db executeUpdate:sql, name, @"boy"];
        if (!res) {
          NSLog(@"error to add db data: %@", name);
        } else {
          NSLog(@"success to add db data: %@", name);
        }
      }];
    }
  });

  dispatch_async(q2, ^{
    for (int i = 0; i < 100; ++i) {
      [queue inDatabase:^(FMDatabase *db) {
        NSString *sql = @"insert into user (name, password) values(?, ?) ";
        NSString *name = [NSString stringWithFormat:@"queue222 %d", i];
        BOOL res = [db executeUpdate:sql, name, @"boy"];
        if (!res) {
          NSLog(@"error to add db data: %@", name);
        } else {
          NSLog(@"success to add db data: %@", name);
        }
      }];
    }
  });
}