iOS 数据库保存图片，bool的例子

数据库保存图片，bool的例子，其实不应该保存图片，保存图影响速度，应该保存图片的路径，除非特殊需求。

#import "DataBase.h"
#import "ProjectModel.h"
static DataBase *_DBCtl = nil;

@interface DataBase()<NSCopying,NSMutableCopying>{
    FMDatabase  *_db;
}

@end

@implementation DataBase

+(instancetype)sharedDataBase{
    
    if (_DBCtl == nil) {
        
        _DBCtl = [[DataBase alloc] init];
        
        [_DBCtl initDataBase];
        
    }
    
    return _DBCtl;
    
}

+(instancetype)allocWithZone:(struct _NSZone *)zone{
    
    if (_DBCtl == nil) {
        
        _DBCtl = [super allocWithZone:zone];
        
    }
    
    return _DBCtl;
    
}

-(id)copy{
    
    return self;
    
}

-(id)mutableCopy{
    
    return self;
    
}

-(id)copyWithZone:(NSZone *)zone{
    
    return self;
    
}

-(id)mutableCopyWithZone:(NSZone *)zone{
    
    return self;
    
}


-(void)initDataBase{
    // 获得Documents目录路径
    
    NSString *documentsPath = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];
    
    // 文件路径
    
    NSString *filePath = [documentsPath stringByAppendingPathComponent:@"model.sqlite"];
    
    // 实例化FMDataBase对象
    
    _db = [FMDatabase databaseWithPath:filePath];
    
    [_db open];
    
    // 初始化数据表
    NSString *Sql = @"CREATE TABLE 'project' ('id' INTEGER PRIMARY KEY AUTOINCREMENT  NOT NULL ,'model_id' VARCHAR(255),'name' TEXT,'startImg' BLOB,'screenShot' BLOB,'endImg' BLOB,'createTime' TEXT,'endTime' TEXT,'infos' BLOB,'imgIsUpload' INTEGER,'ponitsIsUpload' INTEGER) ";
    [_db executeUpdate:Sql];
    [_db close];

}
#pragma mark - 接口

- (void)addProjectModel:(ProjectModel *)projectModel{
    [_db open];
    
    NSNumber *maxID = @(0);
    
    FMResultSet *res = [_db executeQuery:@"SELECT * FROM project "];
    //获取数据库中最大的ID
    while ([res next]) {
        if ([maxID integerValue] < [[res stringForColumn:@"model_id"] integerValue]) {
            maxID = @([[res stringForColumn:@"model_id"] integerValue] ) ;
        }
    }
    maxID = @([maxID integerValue] + 1);
    [_db executeUpdate:@"INSERT INTO project(model_id,name,startImg,screenShot,endImg,createTime,endTime,infos,imgIsUpload,ponitsIsUpload)VALUES(?,?,?,?,?,?,?,?,?,?)",maxID,projectModel.name, [NSKeyedArchiver archivedDataWithRootObject:projectModel.startImg], [NSKeyedArchiver archivedDataWithRootObject:projectModel.screenShot], [NSKeyedArchiver archivedDataWithRootObject:projectModel.endImg], projectModel.createTime, projectModel.endTime, [NSKeyedArchiver archivedDataWithRootObject:projectModel.infos], @(projectModel.imgIsUpload), @(projectModel.ponitsIsUpload)];
    
    [_db close];
    
}

- (void)deleteProjectModel:(ProjectModel *)projectModel{
    [_db open];
    [_db executeUpdate:@"DELETE FROM project WHERE model_id = ?",projectModel.Id];
    [_db close];
}

- (void)updateProjectModel:(ProjectModel *)projectModel{
    [_db open];
    
    [_db executeUpdate:@"UPDATE 'project' SET name = ?  WHERE model_id = ? ",projectModel.name,projectModel.Id];
    [_db executeUpdate:@"UPDATE 'project' SET startImg = ?  WHERE model_id = ? ",[NSKeyedArchiver archivedDataWithRootObject:projectModel.startImg],projectModel.Id];
    [_db executeUpdate:@"UPDATE 'project' SET screenShot = ?  WHERE model_id = ? ",[NSKeyedArchiver archivedDataWithRootObject:projectModel.screenShot],projectModel.Id];
    [_db executeUpdate:@"UPDATE 'project' SET endImg = ?  WHERE model_id = ? ",[NSKeyedArchiver archivedDataWithRootObject:projectModel.endImg],projectModel.Id];
    [_db executeUpdate:@"UPDATE 'project' SET createTime = ?  WHERE model_id = ? ",projectModel.createTime,projectModel.Id];
    [_db executeUpdate:@"UPDATE 'project' SET endTime = ?  WHERE model_id = ? ",projectModel.endTime,projectModel.Id];
    [_db executeUpdate:@"UPDATE 'project' SET infos = ?  WHERE model_id = ? ",[NSKeyedArchiver archivedDataWithRootObject:projectModel.infos],projectModel.Id];
    [_db executeUpdate:@"UPDATE 'project' SET imgIsUpload = ?  WHERE model_id = ? ",@(projectModel.imgIsUpload),projectModel.Id];
    [_db executeUpdate:@"UPDATE 'project' SET ponitsIsUpload = ?  WHERE model_id = ? ",@(projectModel.ponitsIsUpload),projectModel.Id];

    [_db close];
}

- (NSMutableArray *)getAllProjectModel{
    [_db open];
    
    NSMutableArray *dataArray = [[NSMutableArray alloc] init];
    //ORDER BY %@ DESC LIMIT 10
    FMResultSet *res = [_db executeQuery:@"SELECT * FROM project ORDER BY createTime DESC LIMIT 10"];
    
    while ([res next]) {
        ProjectModel *projectModel = [[ProjectModel alloc] init];
        projectModel.Id = @([[res stringForColumn:@"model_id"] integerValue]);
        projectModel.name = [res stringForColumn:@"name"];
        projectModel.startImg = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"startImg"]];
        projectModel.screenShot = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"screenShot"]];
        projectModel.endImg = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"endImg"]];
        projectModel.createTime = [res stringForColumn:@"createTime"];
        projectModel.endTime = [res stringForColumn:@"endTime"];
        projectModel.infos = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"infos"]];
        projectModel.imgIsUpload = [res boolForColumn:@"imgIsUpload"];
        projectModel.ponitsIsUpload = [res boolForColumn:@"ponitsIsUpload"];
        [dataArray addObject:projectModel];
        
    }
    [_db close];
    return dataArray;
}

- (NSMutableArray *)getFirstProjectModel{
    [_db open];
    
    NSMutableArray *dataArray = [[NSMutableArray alloc] init];
    //ORDER BY %@ DESC LIMIT 10
    FMResultSet *res = [_db executeQuery:@"SELECT * FROM project ORDER BY createTime DESC LIMIT 1"];
    
    while ([res next]) {
        ProjectModel *projectModel = [[ProjectModel alloc] init];
        projectModel.Id = @([[res stringForColumn:@"model_id"] integerValue]);
        projectModel.name = [res stringForColumn:@"name"];
        projectModel.startImg = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"startImg"]];
        projectModel.screenShot = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"screenShot"]];
        projectModel.endImg = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"endImg"]];
        projectModel.createTime = [res stringForColumn:@"createTime"];
        projectModel.endTime = [res stringForColumn:@"endTime"];
        projectModel.infos = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"infos"]];
        projectModel.imgIsUpload = [res boolForColumn:@"imgIsUpload"];
        projectModel.ponitsIsUpload = [res boolForColumn:@"ponitsIsUpload"];
        [dataArray addObject:projectModel];
        
    }
    [_db close];
    return dataArray;
}

- (NSMutableArray *)getPartProjectModel{
    [_db open];
    
    NSMutableArray *dataArray = [[NSMutableArray alloc] init];
    //ORDER BY %@ DESC LIMIT 10
    FMResultSet *res = [_db executeQuery:@"SELECT model_id,name,createTime,imgIsUpload,ponitsIsUpload FROM project ORDER BY createTime DESC LIMIT 10"];
    
    while ([res next]) {
        ProjectModel *projectModel = [[ProjectModel alloc] init];
        projectModel.Id = @([[res stringForColumn:@"model_id"] integerValue]);
        projectModel.name = [res stringForColumn:@"name"];
//        projectModel.startImg = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"startImg"]];
//        projectModel.screenShot = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"screenShot"]];
//        projectModel.endImg = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"endImg"]];
        projectModel.createTime = [res stringForColumn:@"createTime"];
//        projectModel.endTime = [res stringForColumn:@"endTime"];
//        projectModel.infos = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"infos"]];
        projectModel.imgIsUpload = [res boolForColumn:@"imgIsUpload"];
        projectModel.ponitsIsUpload = [res boolForColumn:@"ponitsIsUpload"];
        [dataArray addObject:projectModel];
        
    }
    [_db close];
    return dataArray;
}

- (NSMutableArray *)getImgProjectModelByName:(NSString *)name{
    [_db open];
    
    NSMutableArray *dataArray = [[NSMutableArray alloc] init];
    //ORDER BY %@ DESC LIMIT 10
    NSString *sql = [NSString stringWithFormat:@"SELECT model_id, startImg,screenShot,endImg FROM project WHERE name='%@'",name];
    FMResultSet *res = [_db executeQuery:sql];
    
    while ([res next]) {
        ProjectModel *projectModel = [[ProjectModel alloc] init];
        projectModel.Id = @([[res stringForColumn:@"model_id"] integerValue]);
//        projectModel.name = [res stringForColumn:@"name"];
        projectModel.startImg = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"startImg"]];
        projectModel.screenShot = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"screenShot"]];
        projectModel.endImg = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"endImg"]];
//        projectModel.createTime = [res stringForColumn:@"createTime"];
//        projectModel.endTime = [res stringForColumn:@"endTime"];
//        projectModel.infos = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"infos"]];
//        projectModel.imgIsUpload = [res boolForColumn:@"imgIsUpload"];
//        projectModel.ponitsIsUpload = [res boolForColumn:@"ponitsIsUpload"];
        [dataArray addObject:projectModel];
    }
    [_db close];
    return dataArray;
}

- (NSMutableArray *)getInfosProjectModelByName:(NSString *)name{
    [_db open];
    NSMutableArray *dataArray = [[NSMutableArray alloc] init];
    NSString *sql = [NSString stringWithFormat:@"SELECT model_id,name,createTime,endTime,infos,imgIsUpload,ponitsIsUpload FROM project WHERE name='%@'",name];
    FMResultSet *res = [_db executeQuery:sql];
    
    while ([res next]) {
        ProjectModel *projectModel = [[ProjectModel alloc] init];
                projectModel.Id = @([[res stringForColumn:@"model_id"] integerValue]);
                projectModel.name = [res stringForColumn:@"name"];
//        projectModel.startImg = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"startImg"]];
//        projectModel.screenShot = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"screenShot"]];
//        projectModel.endImg = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"endImg"]];
                projectModel.createTime = [res stringForColumn:@"createTime"];
                projectModel.endTime = [res stringForColumn:@"endTime"];
                projectModel.infos = [NSKeyedUnarchiver unarchiveObjectWithData:[res dataForColumn:@"infos"]];
                projectModel.imgIsUpload = [res boolForColumn:@"imgIsUpload"];
                projectModel.ponitsIsUpload = [res boolForColumn:@"ponitsIsUpload"];
        [dataArray addObject:projectModel];
    }
    [_db close];
    return dataArray;
}

@end

最后编辑于：2017.12.07 02:31:52

人面猴
序言：七十年代末，一起剥皮案震惊了整个滨河市，随后出现的几起案子，更是在滨河造成了极大的恐慌，老刑警刘岩，带你破解...
沈念sama阅读 195,898评论 5赞 462
死咒
序言：滨河连续发生了三起死亡事件，死亡现场离奇诡异，居然都是意外死亡，警方通过查阅死者的电脑和手机，发现死者居然都...
沈念sama阅读 82,401评论 2赞 373
救了他两次的神仙让他今天三更去死
文/潘晓璐我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
开封第一讲书人阅读 143,058评论 0赞 325
道士缉凶录：失踪的卖姜人
文/不坏的土叔我叫张陵，是天一观的道长。经常有香客问我，道长，这世上最难降的妖魔是什么？我笑而不...
开封第一讲书人阅读 52,539评论 1赞 267
港岛之恋（遗憾婚礼）
正文为了忘掉前任，我火速办了婚礼，结果婚礼上，老公的妹妹穿的比我还像新娘。我一直安慰自己，他们只是感情好，可当我...
茶点故事阅读 61,382评论 5赞 358
恶毒庶女顶嫁案：这布局不是一般人想出来的
文/花漫我一把揭开白布。她就那样静静地躺着，像睡着了一般。火红的嫁衣衬着肌肤如雪。梳的纹丝不乱的头发上，一...
开封第一讲书人阅读 46,319评论 1赞 273
城市分裂传说
那天，我揣着相机与录音，去河边找鬼。笑死，一个胖子当着我的面吹牛，可吹牛的内容都是我干的。我是一名探鬼主播，决...
沈念sama阅读 36,706评论 3赞 386
双鸳鸯连环套：你想象不到人心有多黑
文/苍兰香墨我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
开封第一讲书人阅读 35,370评论 0赞 254
万荣杀人案实录
序言：老挝万荣一对情侣失踪，失踪者是张志新（化名）和其女友刘颖，没想到半个月后，有当地人在树林里发现了一具尸体，经...
沈念sama阅读 39,664评论 1赞 294
护林员之死
正文独居荒郊野岭守林人离奇死亡，尸身上长有42处带血的脓包…… 初始之章·张勋以下内容为张勋视角年9月15日...
茶点故事阅读 34,715评论 2赞 312
白月光启示录
正文我和宋清朗相恋三年，在试婚纱的时候发现自己被绿了。大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
茶点故事阅读 36,476评论 1赞 326
活死人
序言：一个原本活蹦乱跳的男人离奇死亡，死状恐怖，灵堂内的尸体忽然破棺而出，到底是诈尸还是另有隐情，我是刑警宁泽，带...
沈念sama阅读 32,326评论 3赞 313
日本核电站爆炸内幕
正文年R本政府宣布，位于F岛的核电站，受9级特大地震影响，放射性物质发生泄漏。R本人自食恶果不足惜，却给世界环境...
茶点故事阅读 37,730评论 3赞 299
男人毒药：我在死后第九天来索命
文/蒙蒙一、第九天我趴在偏房一处隐蔽的房顶上张望。院中可真热闹，春花似锦、人声如沸。这庄子的主人今日做“春日...
开封第一讲书人阅读 29,003评论 0赞 19
一桩弑父案，背后竟有这般阴谋
文/苍兰香墨我抬头看了看天上的太阳。三九已至，却和暖如春，着一层夹袄步出监牢的瞬间，已是汗流浃背。一阵脚步声响...
开封第一讲书人阅读 30,275评论 1赞 251
情欲美人皮
我被黑心中介骗来泰国打工，没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留，地道东北人。一个月前我还...
沈念sama阅读 41,683评论 2赞 342
代替公主和亲
正文我出身青楼，却偏偏与公主长得像，于是被迫代替她去往敌国和亲。传闻我的和亲对象是个残疾皇子，可洞房花烛夜当晚...
茶点故事阅读 40,877评论 2赞 335

iOS 数据库保存图片，bool的例子

推荐阅读更多精彩内容