FMDataBaseQueue ?是線程安全的闪金,可以在多線程中放心使用
FMDatabaseQueue *queue = [FMDatabaseQueue databaseQueueWithPath:dbPath]
[queue inDatabase:^(FMDatabase *adb) {
[adb executeUpdate:@"create table qfoo (foo text)"];
[adb executeUpdate:@"insert into qfoo values ('hello')"];
FMResultSet *rsl = [adb executeQuery:@"select * from qfoo where foo like 'h%'"]
}
//處理事務(wù) 大量數(shù)據(jù)庫存取操作效率高 失敗一次性回滾
[queue inTransaction:^(FMDatabase *adb, BOOL *rollback) {
NSLog(@"Starting update %ld", nby);
[adb executeUpdate:@"insert into qfoo values ('1')"];
[adb executeUpdate:@"insert into qfoo values ('2')"];
[adb executeUpdate:@"insert into qfoo values ('3')"];
NSLog(@"Ending update? %ld", nby);
}];
*當(dāng)數(shù)據(jù)庫文件存儲到 Docments 需設(shè)置不上傳icloud