收藏功能主要对模型进行添加,查询和删除,我这里只给了部分代码, 能实现基本的功能, 也涉及到在数据库中对字典进行添加,我的另一篇博客也讲到这类功能,也可以参考我的林一篇博客.
数据库利用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;
}