FMDB基于FMDatabaseQueue封裝

創(chuàng)建數(shù)據(jù)庫和數(shù)據(jù)表的工具類

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ff4647}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #de38a6}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ffffff}p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #00b1ff}p.p5 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #08fa95}span.s1 {font-variant-ligatures: no-common-ligatures; color: #eb905a}span.s2 {font-variant-ligatures: no-common-ligatures}span.s3 {font-variant-ligatures: no-common-ligatures; color: #ffffff}span.s4 {font-variant-ligatures: no-common-ligatures; color: #de38a6}span.s5 {font-variant-ligatures: no-common-ligatures; color: #08fa95}span.s6 {font-variant-ligatures: no-common-ligatures; color: #00b1ff}span.s7 {font-variant-ligatures: no-common-ligatures; color: #5231f4}span.s8 {font-variant-ligatures: no-common-ligatures; color: #ff4647}span.s9 {font-variant-ligatures: no-common-ligatures; color: #4bd157}span.s10 {font: 15.0px 'Heiti SC Light'; font-variant-ligatures: no-common-ligatures; color: #4bd157}span.s11 {font: 15.0px 'Heiti SC Light'; font-variant-ligatures: no-common-ligatures; color: #ff4647}

#import "GLSQLManger.h"
#import <FMDB/FMDB.h>
@implementation GLSQLManger
+(instancetype)shareManager{
    static GLSQLManger *instance;
    static dispatch_once_t Token;
    dispatch_once(&Token, ^{
        instance=[[self alloc]init];
        NSString *path=[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)[0] stringByAppendingPathComponent:@"status.db"];
        NSLog(@"%@",path);
        //創(chuàng)建數(shù)據(jù)庫
        instance.queue=[FMDatabaseQueue databaseQueueWithPath:path];
        NSString *path1=[[NSBundle mainBundle]pathForResource:@"db.sql" ofType:nil];
        NSError *error;
        NSString *string=[NSString stringWithContentsOfFile:path1 encoding:NSUTF8StringEncoding error:&error];
        //創(chuàng)表
        [instance.queue inDatabase:^(FMDatabase *db) {
            BOOL success=[db executeStatements:string];
            if (success) {
                NSLog(@"創(chuàng)表成功");
            }else{
                NSLog(@"創(chuàng)表失敗");
            }
        }];
    });
    return instance;
}
@end

插入數(shù)據(jù)

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ff4647}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #08fa95}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #4bd157}p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ffffff}span.s1 {font-variant-ligatures: no-common-ligatures; color: #ffffff}span.s2 {font-variant-ligatures: no-common-ligatures; color: #00b1ff}span.s3 {font-variant-ligatures: no-common-ligatures}span.s4 {font-variant-ligatures: no-common-ligatures; color: #de38a6}span.s5 {font-variant-ligatures: no-common-ligatures; color: #08fa95}span.s6 {font-variant-ligatures: no-common-ligatures; color: #5231f4}span.s7 {font-variant-ligatures: no-common-ligatures; color: #ff4647}span.s8 {font: 15.0px 'Heiti SC Light'; font-variant-ligatures: no-common-ligatures; color: #ff4647}

    NSString *string=@"INSERT INTO T_Person (name, age, height) VALUES (?, ?, ?);";
    [[GLSQLManger shareManager].queue inDatabase:^(FMDatabase *db) {
//       BOOL success=[db executeUpdate:string];
        BOOL success=[db executeUpdate:string values:@[@"zhang", @23, @1.9] error:nil];
        if (success) {
            NSLog(@"%lld",db.lastInsertRowId);
        }else{
            NSLog(@"插入失敗");
        }
    }];

更新數(shù)據(jù)

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ff4647}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #08fa95}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ffffff}p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #4bd157}span.s1 {font-variant-ligatures: no-common-ligatures; color: #ffffff}span.s2 {font-variant-ligatures: no-common-ligatures; color: #00b1ff}span.s3 {font-variant-ligatures: no-common-ligatures}span.s4 {font-variant-ligatures: no-common-ligatures; color: #de38a6}span.s5 {font-variant-ligatures: no-common-ligatures; color: #08fa95}span.s6 {font-variant-ligatures: no-common-ligatures; color: #5231f4}span.s7 {font-variant-ligatures: no-common-ligatures; color: #ff4647}span.s8 {font: 15.0px 'Heiti SC Light'; font-variant-ligatures: no-common-ligatures; color: #ff4647}

    NSString *string=@"UPDATE T_Person set name = ?, age = ?, height = ? WHERE id = ?;";
    [[GLSQLManger shareManager].queue inDatabase:^(FMDatabase *db) {
        BOOL result=[db executeUpdate:string values:@[@"lisi",@1,@1.5,@3] error:nil];
        if (result) {
            //NSLog(@"%lld",db.lastInsertRowId);
            NSLog(@"更新第3條數(shù)據(jù)成功");
        }else{
            NSLog(@"插入失敗");
        }
    }];

刪除 、更新 都需要指定查詢條件即：WHERE id = ?

查詢

1.簡單查詢
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ff4647}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #08fa95}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ffffff}p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ffffff; min-height: 17.0px}span.s1 {font-variant-ligatures: no-common-ligatures; color: #ffffff}span.s2 {font-variant-ligatures: no-common-ligatures; color: #00b1ff}span.s3 {font-variant-ligatures: no-common-ligatures}span.s4 {font-variant-ligatures: no-common-ligatures; color: #08fa95}span.s5 {font-variant-ligatures: no-common-ligatures; color: #de38a6}span.s6 {font-variant-ligatures: no-common-ligatures; color: #ff4647}

    NSString *string=@"SELECT id, name, age, height FROM T_Person;";
    [[GLSQLManger shareManager].queue inDatabase:^(FMDatabase *db) {
        FMResultSet *set=[db executeQuery:string];
        while ([set next]) {
            NSString *dd=set[@"id"];
            NSString *name=set[@"name"];
            NSLog(@"%@---%@",dd,name);
        }
        
        
    }];
2.簡單查詢
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ff4647}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #08fa95}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ffffff}p.p4 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #00b1ff}p.p5 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ffffff; min-height: 17.0px}span.s1 {font-variant-ligatures: no-common-ligatures; color: #ffffff}span.s2 {font-variant-ligatures: no-common-ligatures; color: #00b1ff}span.s3 {font-variant-ligatures: no-common-ligatures}span.s4 {font-variant-ligatures: no-common-ligatures; color: #08fa95}span.s5 {font-variant-ligatures: no-common-ligatures; color: #5231f4}span.s6 {font-variant-ligatures: no-common-ligatures; color: #de38a6}span.s7 {font-variant-ligatures: no-common-ligatures; color: #ff4647}

    NSString *string=@"SELECT id, name, age, height FROM T_Person;";
    [[GLSQLManger shareManager].queue inDatabase:^(FMDatabase *db) {
        FMResultSet *set=[db executeQuery:string];
        NSMutableArray *arrayMu=[NSMutableArray arrayWithCapacity:4];
        while ([set next]) {
            NSMutableDictionary *row=[NSMutableDictionary dictionaryWithCapacity:4];
            row[@"id"]=set[@"id"];
            row[@"name"]=set[@"name"];
            row[@"age"]=set[@"age"];
            row[@"height"]=set[@"height"];
            [arrayMu addObject:row];
         }
        NSLog(@"%@",arrayMu);
        
    }];
3.常用查詢
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #ffffff}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #08fa95}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 15.0px 'Andale Mono'; color: #00b1ff}span.s1 {font-variant-ligatures: no-common-ligatures}span.s2 {font-variant-ligatures: no-common-ligatures; color: #de38a6}span.s3 {font-variant-ligatures: no-common-ligatures; color: #00b1ff}span.s4 {font-variant-ligatures: no-common-ligatures; color: #ffffff}span.s5 {font-variant-ligatures: no-common-ligatures; color: #08fa95}span.s6 {font-variant-ligatures: no-common-ligatures; color: #5231f4}span.s7 {font-variant-ligatures: no-common-ligatures; color: #4bd157}span.s8 {font: 15.0px 'Heiti SC Light'; font-variant-ligatures: no-common-ligatures; color: #4bd157}span.s9 {font-variant-ligatures: no-common-ligatures; color: #ff4647}

-(void)demo5:(NSString *)string {
    [[GLSQLManger shareManager].queue inDatabase:^(FMDatabase *db) {
        FMResultSet *set=[db executeQuery:string];
        NSMutableArray *arrayMu=[NSMutableArray arrayWithCapacity:4];
        while ([set next]) {
            NSMutableDictionary *row=[NSMutableDictionary dictionaryWithCapacity:4];
            //列數(shù)
            int colCount=[set columnCount];
            for (int i=0; i<colCount; i++) {
                //列名
                NSString *name=[set columnNameForIndex:i];
                //值
                NSString *value=[set objectForColumnIndex:i];
                row[name]=value;
            }
            NSLog(@"--%@",row);
            [arrayMu addObject:row];
        }
        NSLog(@"++%@",arrayMu);
    }];
}
最后編輯于 ：
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者
【社區(qū)內(nèi)容提示】社區(qū)部分內(nèi)容疑似由AI輔助生成，瀏覽時請結(jié)合常識與多方信息審慎甄別。
平臺聲明：文章內(nèi)容（如有圖片或視頻亦包括在內(nèi)）由作者上傳并發(fā)布，文章內(nèi)容僅代表作者本人觀點，簡書系信息發(fā)布平臺，僅提供信息存儲服務(wù)。

相關(guān)閱讀更多精彩內(nèi)容

友情鏈接更多精彩內(nèi)容