fmdb数据库

 

+(DataBaseHandle*)sharedInstanc

{

    static id handle;

    static dispatch_once_t once;

    dispatch_once(&once,^(){

        handle = [[DataBaseHandle alloc]init];

    });

    return handle;

}

 

//创建数据库路径

+(NSString*)databaseFilePath

{

    NSString * docPath = NSSearchPathForDirectoriesInDomains(NSCachesDirectory, NSUserDomainMask, YES).lastObject;

    NSString * dbPath  = [docPath stringByAppendingString:@"dzm.sqlite"];

    

    NSLog(@"path ==== %@",dbPath);

    

    return dbPath;

}

static FMDatabase * _db = nil;

//创建数据库

+(void)creatDataBase

{

    _db = [FMDatabase databaseWithPath:[self databaseFilePath]];

}

 

//创建表

+(void)creatTable

{

    if (!_db) {

        [self creatDataBase];

    }

    //打开数据库,并判断数据库是否打开成功

    if (![_db open]) {

        NSLog(@"数据库打开失败");

        return;

    }

    //为数据库设置缓存，提高查询效率

    [_db setShouldCacheStatements:YES];

    

    //判断数据库中是否已经存在这个表，如果不存在则创建该表

    if(![_db tableExists:@"dzm"])

    {

        BOOL result = [_db executeUpdate:@"CREATE TABLE dzm(user_id TEXT PRIMARY KEY, data BLOB) "];

        if (result) {

            NSLog(@"创建成功");

        }

    }

    

//    [_db close];

}

//插入数据

+(void)insertDBWWithArra:(id)dataArray byID:(NSString*)model_id

{

    if (!_db) {

        [self creatDataBase];

    }

    if (![_db open]) {

        return;

    }

    [_db setShouldCacheStatements:YES];

    

    if (![_db tableExists:@"dzm"]) {

        [self creatTable];

    }

    //判断将要插入的数据是否存在

    //    NSString * model_id = [[modelDic allKeys] lastObject];

    NSMutableData * data = [NSMutableData data];

    NSKeyedArchiver * archiver = [[NSKeyedArchiver alloc]initForWritingWithMutableData:data];

    [archiver encodeObject:dataArray forKey:model_id];

    [archiver finishEncoding];

    FMResultSet * set = [_db executeQuery:@"select data from dzm where user_id = ?",model_id];

    if ([set next]) {

        BOOL result = [_db executeUpdate:@"update dzm set data = ? where user_id = ?",data,model_id];

        if (result) {

            NSLog(@"刷新成功");

        }

    }else{

        BOOL result = [_db executeUpdate:@"INSERT INTO dzm (user_id,data) VALUES (?,?)",model_id,data];

        NSLog(@"result === %d",result);

    }

    [_db close];

}

 

//通过ID获取数据

+(id)getDataArrayWithTitleid:(NSString*)titleID

{

    if (!_db) {

        [self creatDataBase];

    }

    if (![_db open]) {

        return nil;

    }

    if (![_db tableExists:@"dzm"]) {

        [_db close];

        return nil;

    }

    id array = nil;

    FMResultSet * set = [_db executeQuery:@"select data from dzm where user_id = ?",titleID];

    if ([set next]) {

        NSData * data = [set dataForColumn:@"data"];

        NSKeyedUnarchiver * unArchiver = [[NSKeyedUnarchiver alloc]initForReadingWithData:data];

        array = [unArchiver decodeObjectForKey:titleID];

        [unArchiver finishDecoding];

    }

    [_db close];

    return array;

}

 

//插入数据

+(void)insertDBWWithDictionary:(NSDictionary*)dataDic byID:(NSString*)model_id

{

    if (!_db) {

        [self creatDataBase];

    }

    if (![_db open]) {

        return;

    }

    

    [_db setShouldCacheStatements:YES];

    

    if (![_db tableExists:@"dzm"]) {

        [self creatTable];

    }

    

    //判断将要插入的数据是否存在

    //    NSString * model_id = [[modelDic allKeys] lastObject];

    NSMutableData * data = [NSMutableData data];

    NSKeyedArchiver * archiver = [[NSKeyedArchiver alloc]initForWritingWithMutableData:data];

    [archiver encodeObject:dataDic forKey:model_id];

    [archiver finishEncoding];

    

    FMResultSet * set = [_db executeQuery:@"select data from dzm where user_id = ?",model_id];

    if ([set next]) {

        BOOL result = [_db executeUpdate:@"update dzm set data = ? where user_id = ?",data,model_id];

        if (result) {

            NSLog(@"刷新成功");

        }

    }else{

        BOOL result = [_db executeUpdate:@"INSERT INTO dzm (user_id,data) VALUES (?,?)",model_id,data];

        NSLog(@"result === %d 插入成功!",result);

    }

    

    [_db close];

}

 

//通过ID获取数据

+(NSDictionary*)getDataDictionaryWithTitleid:(NSString*)titleID

{

    if (!_db) {

        [self creatDataBase];

    }

    if (![_db open]) {

        return nil;

    }

    if (![_db tableExists:@"dzm"]) {

        [_db close];

        return nil;

    }

    

    NSDictionary * dic = nil;

    FMResultSet * set = [_db executeQuery:@"select data from dzm where user_id = ?",titleID];

    if ([set next]) {

        NSData * data = [set dataForColumn:@"data"];

        NSKeyedUnarchiver * unArchiver = [[NSKeyedUnarchiver alloc]initForReadingWithData:data];

        dic = [unArchiver decodeObjectForKey:titleID];

        [unArchiver finishDecoding];

    }

    [_db close];

    return dic;

}

 

 

//更新数据库

+(void)updateDataBaseWithDictionary:(NSDictionary*)modelDic

{

    if (!_db) {

        [self creatDataBase];

    }

    if (![_db open]) {

        return;

    }

    

    [_db setShouldCacheStatements:YES];

    

    if (![_db tableExists:@"dzm"]) {

        [self creatTable];

    }

    

    //判断将要插入的数据是否存在

    NSString * model_id = [[modelDic allKeys] lastObject];

    NSMutableData * data = [NSMutableData data];

    NSKeyedArchiver * archiver = [[NSKeyedArchiver alloc]initForWritingWithMutableData:data];

    [archiver encodeObject:modelDic forKey:model_id];

    [archiver finishEncoding];

    

    FMResultSet * set = [_db executeQuery:@"select  * from dzm where user_id = ?",model_id];

    if ([set next]) {

        [_db executeUpdate:@"update dzm set data = ? where user_id = ?",data,model_id];

    }

    [_db close];

}

 

//通过ID删除数据

+(void)deleteDataByTitleID:(NSString*)titleID

{

    

    if (![_db open]) {

        return;

    }

    

    [_db setShouldCacheStatements:YES];

    

    if (![_db tableExists:@"dzm"]) {

        return;

    }

    

    [_db executeUpdate:@"delete from dzm where user_id = ?",titleID];

    

    [_db close];

}

 

//删除所有数据

+(void)deleteAllData

{

    if (![_db open]) {

        return;

    }

    

    [_db setShouldCacheStatements:YES];

    

    if (![_db tableExists:@"dzm"]) {

        return;

    }

    

    [_db executeUpdate:@"delete from dzm"];

    

    [_db close];

}