利用本地数据库给项目添加收藏功能

收藏功能主要对模型进行添加,查询和删除,我这里只给了部分代码, 能实现基本的功能, 也涉及到在数据库中对字典进行添加,我的另一篇博客也讲到这类功能,也可以参考我的林一篇博客.
数据库利用bold类型存储与读取字典
1. 建立Model 我的Model是List
List.h的代码

@interface List : NSObject

@property (nonatomic, copy)NSString *Id;
@property (nonatomic, copy)NSString *title;
@property (nonatomic, copy)NSString *actual_count;
@property (nonatomic, retain)NSObject *collectors_count;
@property (nonatomic, copy)NSString *market_price;
@property (nonatomic, copy)NSString *is_published;
@property (nonatomic, copy)NSString *show_price;
@property (nonatomic, retain)NSDictionary *cover_image;
@property (nonatomic, copy)NSString *show_num;
@property (nonatomic, assign)BOOL is_old;
@property (nonatomic, copy)NSString *shop_img;
@property (nonatomic, copy)NSString *weight;



- (instancetype)initWithName:(NSString *)Id title:(NSString *)title actual_count:(NSString *)actual_count collectors_count:(NSObject *)collectors_count header_img:(NSDictionary *)header_img;


+ (instancetype)ListWithName:(NSString *)Id title:(NSString *)title actual_count:(NSString *)actual_count collectors_count:(NSObject *)collectors_count header_img:(NSDictionary *)header_img;

+ (NSDictionary *)initWithList:(List *)list;

List.m的代码

-(void)setValue:(id)value forUndefinedKey:(NSString *)key
{
    if ([key isEqualToString:@"id"]) {
        self.Id = value;
    }
}

- (instancetype)initWithName:(NSString *)Id title:(NSString *)title actual_count:(NSString *)actual_count collectors_count:(NSObject *)collectors_count header_img:(NSDictionary *)header_img
{
    self = [super init];
    if (self) {
        self.Id = Id;
        self.title = title;
        self.actual_count = actual_count;
        self.collectors_count = collectors_count;
        self.cover_image = [NSDictionary dictionaryWithDictionary:header_img];
    }
    return self;
}

+ (instancetype)ListWithName:(NSString *)Id title:(NSString *)title actual_count:(NSString *)actual_count collectors_count:(NSObject *)collectors_count header_img:(NSDictionary *)header_img
{
    List *list = [[List alloc]initWithName:Id title:title actual_count:actual_count collectors_count:collectors_count header_img:header_img];
    return [list autorelease];
}

+ (NSMutableDictionary *)initWithList:(List *)list
{
    NSMutableDictionary *dic = [NSMutableDictionary dictionary];
    [dic setValue:list.title forKey:@"title"];
    [dic setValue:list.Id forKey:@"id"];
    [dic setValue:list.actual_count forKey:@"actual_count"];
    [dic setValue:list.collectors_count forKey:@"collectors_count"];    
    [dic setValue:list.market_price forKey:@"market_price"];
    [dic setValue:list.is_published forKey:@"is_published"];
    [dic setValue:list.cover_image forKey:@"cover_image"];
    [dic setValue:list.show_num forKey:@"show_num"];
    [dic setValue:list.shop_img forKey:@"show_img"];
    [dic setValue:list.weight forKey:@"weight"];
    return dic;
}

2. 打开关闭数据库 DB
DB.m

@interface DB : NSObject

+ (sqlite3 *)openDataBase;
+ (void)closeDataBase;

@end

DB.h

#import <sqlite3.h>
static sqlite3 *dbpointer = nil;
@implementation DB
- (instancetype)init
{
    self = [super init];
    if (self) {

    }
    return self;
}
+ (sqlite3 *)openDataBase
{
    if (dbpointer) {
        return dbpointer;
    }
    NSString *sourse = [[NSBundle mainBundle]pathForResource:@"HLJ" ofType:@"rdb"];
    NSString *path = [NSSearchPathForDirectoriesInDomains(NSLibraryDirectory, NSUserDomainMask, YES) firstObject];
    path = [NSString stringWithFormat:@"%@/%@", path, @"db.rdb"];
    NSLog(@"%@",path);
    NSFileManager *manager = [NSFileManager defaultManager];
    if (![manager fileExistsAtPath:path]) {
        [manager copyItemAtPath:sourse toPath:path error:nil];
    }
    sqlite3_open([path UTF8String], &dbpointer);
    NSLog(@"%@", path);
    return dbpointer;
}
+ (void)closeDataBase
{
    sqlite3_close(dbpointer);
}

3. 对数据库进行操作 ListDatabase
ListDatabase.m

+ (BOOL)insertWithModel:(List *)list;
+ (BOOL)deleteWithModel:(List *)list;
+ (List *)selectWithId:(NSString *)Id;
+ (BOOL)selectWithIdofBool:(NSString *)Id;
+ (NSArray *)selectAll;
+ (List *)selectWithId:(NSString *)pid;

ListDatabase.h

+ (BOOL)insertWithModel:(List *)list
{
    sqlite3 *db = [DB openDataBase];//[list.cover_image objectForKey:@"img"]

    //  NSDictionary 转  NSData
    NSData *data = [NSJSONSerialization dataWithJSONObject:[[List initWithList:list] objectForKey:@"cover_image"] options:NSJSONWritingPrettyPrinted  error:nil];
    // 这里 NSData 数据不能使用 sql 语句插入，因为要向数据库中写入blob类型的二进制数据，还要写入数据的长度bytes, 所以在写sql语句时不要插入blob类型的数据
    NSString *sqlstr = [NSString stringWithFormat:@"insert into hjl_list(Id, title, actual_count, collectors_count) values('%@', '%@', '%@', '%@')", list.Id, list.title, list.actual_count, list.collectors_count];

    // 这里写了一个sql的update语句，为了写入 blob类型的数据，注意更新的值还未知，要用问号 ？ 代替
    NSString *sqlstr_data = [NSString stringWithFormat:@"update hjl_list set cover_img=? where Id='%@'", list.Id];

    // 定义数据库替身
    sqlite3_stmt *stmt = nil;
    int result = sqlite3_exec(db, [sqlstr UTF8String], nil, nil, nil);

    // 执行 update 语句使用 sqlite3_prepare
    int result2 = sqlite3_prepare(db, [sqlstr_data UTF8String], -1, &stmt, nil);

    if (result == SQLITE_OK && result2 == SQLITE_OK) {

        // 使用 sqlite3_bind_blob64 语句用绑定的方式插入数据，查询的时候 bytes 才正确
        sqlite3_bind_blob64(stmt, 1, [data bytes], [data length], nil);

        if (sqlite3_step(stmt) == SQLITE_DONE) {
            NSLog(@"添加成功");
        }

        return YES;
    }
    NSLog(@"%@ 失败",sqlstr);
    return  NO;

}

+ (BOOL)deleteWithModel:(List *)list
{
    sqlite3 *db = [DB openDataBase];
    NSString *sqlstr = [NSString stringWithFormat:@"delete from hjl_list where Id = '%@'", list.Id];
    int result = sqlite3_exec(db, [sqlstr UTF8String], nil, nil, nil);
    if (result == SQLITE_OK) {
        NSLog(@"删除成功");
        return YES;
    }
    return  NO;
}

+ (NSArray *)selectAll
{
    sqlite3 *db = [DB openDataBase];
    sqlite3_stmt *stmt = nil;
    NSString *sqlstr = [NSString stringWithFormat:@"select * from hjl_list"];
    int result = sqlite3_prepare(db, [sqlstr UTF8String], -1, &stmt, nil);

    NSMutableArray *arr = [NSMutableArray array];
    if (result == SQLITE_OK) {
//        NSLog(@"查询成功");
        while (sqlite3_step(stmt) == SQLITE_ROW) {
            const unsigned char *aid = sqlite3_column_text(stmt, 0);
            const unsigned char *atitle = sqlite3_column_text(stmt, 1);
            const unsigned char *aactual_p = sqlite3_column_text(stmt, 2);
            const unsigned char *acollector_p = sqlite3_column_text(stmt, 3);            
            NSString *Id = [NSString stringWithUTF8String:(const char *)aid];
            NSString *title = [NSString stringWithUTF8String:(const char *)atitle];
            NSString *actual_p = [NSString stringWithUTF8String:(const char *)aactual_p];
            NSString *collector_p = [NSString stringWithUTF8String:(const char *)acollector_p];
            // 查询
            const void *op = sqlite3_column_blob(stmt, 4);
            int size = sqlite3_column_bytes(stmt, 4);
            NSData *data = [NSData dataWithBytes:op length:size];
            NSDictionary *dic = [NSJSONSerialization JSONObjectWithData:data options:NSJSONReadingMutableContainers error:nil];
            List *list = [List ListWithName:Id title:title actual_count:actual_p collectors_count:collector_p header_img:dic];
            NSLog(@"list = %@",[List initWithList:list]);
            [arr addObject:list];
        }        
    }
    sqlite3_finalize(stmt);
    return  arr;
}
+ (BOOL)selectWithIdofBool:(NSString *)Id
{
    sqlite3 *db = [DB openDataBase];
    sqlite3_stmt *stmt= nil;
    NSString *sqlstr = [NSString stringWithFormat:@"select * from hjl_list where Id = '%@'", Id];
    int result = sqlite3_prepare_v2(db, [sqlstr UTF8String], -1, &stmt, nil);
    if (result == SQLITE_OK) {
        if (sqlite3_step(stmt) == SQLITE_ROW){
            NSLog(@"查询成功");
            return YES;
        }
    }
    NSLog(@"查询失败");
    return  NO;
}