1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
//
// XFDB.m
// XFFruit
//
// Created by freecui on 15/8/24.
// Copyright (c) 2015年 Xummer. All rights reserved.
//
#import "XFDB.h"
#import "XFPhoto.h"
//FMDB
#define DATABASE_PATH [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)[0]stringByAppendingString:@"/.db"]
@implementation XFDB
+ (instancetype)sharedInstance {
static XFDB *_sharedinstance = nil;
static dispatch_once_t onceToken;
dispatch_once(&onceToken, ^{
_sharedinstance = [[self alloc]init];
});
return _sharedinstance;
}
+ (BOOL)checkTableCreatedInDb: (FMDatabase *)db {
NSString *createStr = @"CREATE TABLE IF NOT EXISTS 'xfphoto'(ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE, photoData VARCHAR)";//,position INTEGER
BOOL worked = [db executeUpdate:createStr];
return worked;
}
- (BOOL)savePhoto: (XFPhoto *)aphoto {
FMDatabase *db = [FMDatabase databaseWithPath:DATABASE_PATH];
if (![db open]) {
NSLog(@"数据库打开失败");
return NO;
}
[XFDB checkTableCreatedInDb:db];
NSString *insterStr = @"INSERT INTO 'xfphoto'('photoData') VALUES(?)";
BOOL worked = [db executeUpdate:insterStr,aphoto.photoData];//[NSString stringWithFormat:@"%@",aphoto.photoData]
[db close];
return worked;
}
- (BOOL)deletePhoto: (NSData *)photoData {
FMDatabase *db = [FMDatabase databaseWithPath:DATABASE_PATH];
if (![db open]) {
NSLog(@"数据库打开失败");
return NO;
}
[XFDB checkTableCreatedInDb:db];
NSString *delStr =[NSString stringWithFormat: @"DELETE FROM xfphoto where photoData = %@",photoData];
BOOL worked = [db executeUpdate:delStr];
[db close];
return worked;
}
- (NSMutableArray *)fetchAllPhotosFromLocal {
NSMutableArray *resultArr = [NSMutableArray array];
FMDatabase *db = [FMDatabase databaseWithPath:DATABASE_PATH];
if (![db open]) {
NSLog(@"数据库打开失败");
return resultArr;
}
[XFDB checkTableCreatedInDb:db];
FMResultSet *rs = [db executeQuery:@"select * from xfphoto"];
while ([rs next]) {
XFPhoto *xfPhoto = [[XFPhoto alloc]init];
xfPhoto.photoData = [rs dataForColumn:@"photoData"];
// xfPhoto.position = [rs intForColumn:@"position"];
[resultArr addObject:xfPhoto];
}
[rs close];
[db close];
return resultArr;
}
- (NSMutableArray *)fetchAllPhotosDataFromLocal {
NSMutableArray *resultArr = [NSMutableArray array];
FMDatabase *db = [FMDatabase databaseWithPath:DATABASE_PATH];
if (![db open]) {
NSLog(@"数据库打开失败");
return resultArr;
}
[XFDB checkTableCreatedInDb:db];
FMResultSet *rs = [db executeQuery:@"select * from xfphoto"];
while ([rs next]) {
NSData *photoData = [rs dataForColumn:@"photoData"];
[resultArr addObject:photoData];
}
[rs close];
[db close];
return resultArr;
}
@end