iOS-FMDB事務【批次更新資料庫】，ios-fmdb交易資料庫

iOS-FMDB事務【批次更新資料庫】，ios-fmdb交易資料庫

開啟資料庫（sqlite）

///開啟資料庫+ (BOOL)openDataBase{       _TYDatabase = [[FMDatabase alloc]initWithPath:[self databasePath]];    if ([_TYDatabase open]) {        return YES;    }    return NO;}///資料庫路徑+ (NSString *)databasePath{    NSString *documentPath = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];    NSString *dataPath = [documentPath stringByAppendingPathComponent:@"TY.SQLite"];    NSFileManager *fileM = [NSFileManager defaultManager];    if (![fileM fileExistsAtPath:dataPath]) {        NSString *filePath = [[NSBundle mainBundle] pathForResource:@"TY" ofType:@"SQLite"];        [fileM copyItemAtPath:filePath toPath:dataPath error:nil];    }    NSLog(@"%@",dataPath);    return dataPath;    }

 

事務

/** 事務 arraySql：SQL語句數組 */- (void)beginTransaction:(NSArray *)arraySql;{    ////  static FMDatabase *_TYDatabase = nil;    BOOL isOpen=[_TYDatabase open];    if (!isOpen) {        NSLog(@"開啟資料庫失敗！");        return;    }    ///開始事物    [_TYDatabase beginTransaction];    BOOL isRollBack = NO;    @try {        for (int i = 0; i<arraySql.count; i++) {            BOOL result = [_TYDatabase executeUpdate:arraySql[i]];            if (!result) {                NSLog(@"操作失敗【%d】== SQL：%@",i,arraySql[i]);            }        }    }    @catch (NSException *exception) {        isRollBack = YES;        ///復原        [_TYDatabase rollback];    }    @finally {        if (!isRollBack) {            ///提交            [_TYDatabase commit];        }    }    [_TYDatabase close];}

 

多線程事務

/** 多線程事務 arraySql：SQL語句數組 */+ (void)beginTransactionT:(NSArray *)arraySql{    FMDatabaseQueue *databaseQueue = [FMDatabaseQueue databaseQueueWithPath:[self databasePath]];    [databaseQueue inTransaction:^(FMDatabase *db, BOOL *rollback) {        BOOL result = NO;        for (int i = 0; i < arraySql.count; i++) {            result = [_TYDatabase executeUpdate:arraySql[i]];        }        if (result) {            NSLog(@"成功");        }    }];}