SYCacheManager使用FMDB必盖、LKDB進行二次封裝隧出，緩存數(shù)據(jù)。
FMDB使用效果圖
LKDBHelper使用效果圖
FMDB的基本使用
使用FMDatabase操作數(shù)據(jù)剔宪，使用時，必須保證如下三點：
（1）已創(chuàng)建數(shù)據(jù)庫
（2）操作前壹无，必須打開數(shù)據(jù)庫
（3）操作后葱绒，必須關閉數(shù)據(jù)庫
數(shù)據(jù)庫存儲路徑
- (NSString *)dataPath
{
if (_dataPath == nil)
{
NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
// NSArray *paths = NSSearchPathForDirectoriesInDomains(NSCachesDirectory, NSUserDomainMask, YES);
NSString *documentDirectory = [paths objectAtIndex:0];
_dataPath = [documentDirectory stringByAppendingPathComponent:@"cache.db"];
NSLog(@"_dataPath = %@", _dataPath);
}
return _dataPath;
}
FMDatabase實例化，并創(chuàng)建數(shù)據(jù)庫
- (FMDatabase *)dataBase
{
if (_dataBase == nil)
{
_dataBase = [FMDatabase databaseWithPath:self.dataPath];
}
return _dataBase;
}
- 創(chuàng)建表
if ([self.dataBase open])
{
NSString *createTabel = @"CREATE TABLE if not exists CompanyTable (departmentId text PRIMARY KEY,departmentName text,departmentStatus text)";
BOOL isResult = [self. dataBase executeUpdate:createTabel];
NSLog(@"createTabel = %@", (isResult ? @"success" : @"error"));
[self.dataBase close];
}
- 刪除表
if ([self.dataBase open])
{
NSString *deleteTabel = @"DROP TABLE CompanyTable";
BOOL isResult = [self. dataBase executeUpdate:deleteTabel];
NSLog(@"deleteTabel = %@", (isResult ? @"success" : @"error"));
[self.dataBase close];
}
- 保存數(shù)據(jù)
if ([self.dataBase open])
{
NSString *saveData = @"INSERT INTO CompanyTable (departmentId, departmentName, departmentStatus) VALUES (?,?,?)";
BOOL isResult = [self. dataBase executeUpdate:saveData, @"168", @"互聯(lián)網(wǎng)部門", @"禁用"];
NSLog(@"saveData = %@", (isResult ? @"success" : @"error"));
[self.dataBase close];
}
- 刪除數(shù)據(jù)
if ([self.dataBase open])
{
NSString *deleteData = @"DELETE FROM CompanyTable";
BOOL isResult = [self. dataBase executeUpdate:deleteData];
NSLog(@"deleteData = %@", (isResult ? @"success" : @"error"));
[self.dataBase close];
}
- 修改數(shù)據(jù)
if ([self.dataBase open])
{
NSString *modifyData = @"UPDATE CompanyTable set departmentStatus = ? where departmentName = ?";
BOOL isResult = [self. dataBase executeUpdate:modifyData, @"啟用", @"互聯(lián)網(wǎng)部門"];
NSLog(@"modifyData = %@", (isResult ? @"success" : @"error"));
[self.dataBase close];
}
- 讀取數(shù)據(jù)
if ([self.dataBase open])
{
NSString *readData = @"SELECT * FROM CompanyTable WHERE departmentName = ?";
FMResultSet *result = [self. dataBase executeQuery:readData, @"互聯(lián)網(wǎng)部門"];
// 讀取全部數(shù)據(jù)
while ([result next])
{
NSString *idStr = [result stringForColumn:@"departmentId"];
NSString *nameStr = [result stringForColumn:@"departmentName"];
NSString *statusStr = [result stringForColumn:@"departmentStatus"];
NSLog(@"查找數(shù)據(jù)成功斗锭。\nid = %@, name = %@, status = %@", idStr, nameStr, statusStr);
}
[self.dataBase close];
}
// 讀取單條數(shù)據(jù)
if ([result next])
{
NSString *idStr = [result stringForColumn:@"departmentId"];
NSString *nameStr = [result stringForColumn:@"departmentName"];
NSString *statusStr = [result stringForColumn:@"departmentStatus"];
NSLog(@"查找數(shù)據(jù)成功地淀。\nid = %@, name = %@, status = %@", idStr, nameStr, statusStr);
}
執(zhí)行語句使用的四種等價情況，使用更新語句示例
- 直接使用完整的SQL
NSString *sqlUpate = @"UPDATE CompanyTable(departmentStatus) values('啟用')";
[self.dataBase executeUpdate:sqlUpate];
- 使用不完整的SQL岖是，里面含有待定字符串"?"帮毁，需要后面的參數(shù)進行替代
NSString *sqlUpate = @"UPDATE CompanyTable set departmentStatus = ? where departmentName = ?";
[self.dataBase executeUpdate:sqlUpate, @"啟用", @"互聯(lián)網(wǎng)部門"];
- 使用不完整的SQL实苞，里面含有待定字符串"?"，需要數(shù)組參數(shù)里面的參數(shù)進行替代
NSString *sqlUpate = @"UPDATE CompanyTableUPDATE CompanyTable(departmentStatus) values(?)";
[self.dataBase executeUpdate:sqlUpate withArgumentsInArray:@[@"啟用"]];
- SQL語句字符串可以使用字符串格式化烈疚，這種我們應該比較熟悉
NSString *sqlUpate = @"UPDATE CompanyTable(departmentName) values(%@)";
[self.dataBase executeUpdateWithFormat:sqlUpate, @"啟用"];
LKDB的基本使用
通常使用時黔牵，采用單例設計模式進行使用。
數(shù)據(jù)庫存儲路徑：只需要設置數(shù)據(jù)庫名稱即可爷肝，實例化時已實現(xiàn)創(chuàng)建路徑方法猾浦。
實例化
- (instancetype)init
{
self = [super init];
if (self)
{
self.dataHelper = [[LKDBHelper alloc] initWithDBName:@"LKDB.db"];
}
return self;
}
單例
/// 單例
+ (SYCacheManager *)shareCache
{
static SYCacheManager *sharedManager;
static dispatch_once_t onceToken;
dispatch_once(&onceToken, ^{
sharedManager = [[self alloc] init];
assert(sharedManager != nil);
});
return sharedManager;
}
- 創(chuàng)建表
- (BOOL)newTableWithModel:(Class)class
{
BOOL isResult = NO;
if ([self.dataHelper isExistsWithTableName:NSStringFromClass(class) where:nil])
{
isResult = YES;
NSLog(@"newTableWithModel = 已存在");
}
else
{
isResult = [self.dataHelper createTableWithModelClass:class];
}
NSLog(@"newTableWithModel = %@", (isResult ? @"success" : @"error"));
return isResult;
}
- 刪除表
- 刪除所有表
- 刪除指定表
- (void)deleteAllTableModel
{
[self.dataHelper dropAllTable];
}
- (BOOL)deleteTableWithModel:(Class)class
{
BOOL isResult = [self.dataHelper dropTableWithClass:class];
NSLog(@"deleteTableWithModel = %@", (isResult ? @"success" : @"error"));
return isResult;
}
- 保存數(shù)據(jù)
- (BOOL)saveModel:(id)model
{
BOOL isResult = NO;
if ([self.dataHelper isExistsModel:model])
{
// 已存在時，先刪除灯抛，且刪除成功再保存
if ([self deleteModel:model])
{
isResult = [self.dataHelper insertWhenNotExists:model];
}
}
else
{
// 不存在時金赦，直接刪除
isResult = [self.dataHelper insertWhenNotExists:model];
}
NSLog(@"saveModel = %@", (isResult ? @"success" : @"error"));
return isResult;
}
- 刪除數(shù)據(jù)
- 刪除數(shù)據(jù)
- 刪除指定條件的數(shù)據(jù)
- (BOOL)deleteModel:(id)model
{
BOOL isResult = [self.dataHelper deleteToDB:model];
NSLog(@"isResult = %@", (isResult ? @"success" : @"error"));
return isResult;
}
- (BOOL)deleteModel:(Class)class where:(id)where
{
BOOL isResult = [self.dataHelper deleteWithClass:class where:where];
NSLog(@"isResult = %@", (isResult ? @"success" : @"error"));
return isResult;
}
- 修改數(shù)據(jù)
- 修改數(shù)據(jù)
- 修改指定條件的數(shù)據(jù)
- (BOOL)updateModel:(id)model
{
BOOL isResult = [self.dataHelper updateToDB:model where:nil];
NSLog(@"updateModel = %@", (isResult ? @"success" : @"error"));
return isResult;
}
- (BOOL)updateModel:(Class)class value:(NSString *)value where:(id)where
{
BOOL isResult = [self.dataHelper updateToDB:class set:value where:where];
NSLog(@"updateModel = %@", (isResult ? @"success" : @"error"));
return isResult;
}
- 查找數(shù)據(jù)
- (NSArray *)readModel:(Class)class where:(id)where
{
// 根據(jù) and 條件 查詢所有數(shù)據(jù) NSString *conditions = @"age = 23 and name = '張三1'";
// 根據(jù) 字典條件，查詢所有數(shù)據(jù) NSDictionary *conditions1 = @{@"age" : @23, @"name" : @"張三1"};
// 根據(jù) or 條件对嚼，查詢所有數(shù)據(jù) NSString *conditions2 = @"age = 23 or ID = 5";
// 根據(jù) in 條件夹抗，查詢所有數(shù)據(jù) NSString *conditions3 = @"age in (23, 24)";
// 根據(jù) 字典 in 條件，查詢所有數(shù)據(jù) NSDictionary *conditions4 = @{@"age" : @[@23, @24]};
// 查詢符合條件的數(shù)據(jù)有多少條 NSString *conditions5 = @"age = 23 and name = '張三1'";
NSArray *array = [self.dataHelper search:class column:nil where:where orderBy:nil offset:0 count:0];
return array;
}
