数据库存储新闻_FMDB

项目介绍：

FMDB_news

数据库缓存，数据库保存新闻。新闻缓存至数据库。FMDB使用，开题报告，FMDB存储新闻

GitHub: https://github.com/Zws-China/FMDB_news

How To Use -(void)initDataBase{ // 获得Documents目录路径 NSString *documentsPath = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject]; // 文件路径 NSString *filePath = [documentsPath stringByAppendingPathComponent:@'newsSql.sqlite']; NSLog(@'%@',filePath); // 实例化FMDataBase对象 _db = [FMDatabase databaseWithPath:filePath]; [_db open]; // 初始化数据表 NSString *newsSql = @'CREATE TABLE IF NOT EXISTS 'news' ('cellTitle' VARCHAR(255),'source' VARCHAR(255),'imageUrl' VARCHAR(255),'newsUrl' VARCHAR(255),'newsID'VARCHAR(255)PRIMARY KEY) '; [_db executeUpdate:newsSql]; NSString *newsDetailSql = @'CREATE TABLE IF NOT EXISTS 'newsDetail' ('newsUrl' VARCHAR(255)PRIMARY KEY,'dataContent' VARCHAR(255)) '; [_db executeUpdate:newsDetailSql]; [_db close]; } #pragma mark - 接口 - (void)addNews:(DynamicModel *)dynamicModel { [_db open]; [_db executeUpdate:@'INSERT INTO news(cellTitle,source,imageUrl,newsUrl,newsID)VALUES(?,?,?,?,?)',dynamicModel.cellTitle,dynamicModel.source,dynamicModel.imageUrl,dynamicModel.newsUrl,dynamicModel.newsID]; [_db close]; } /* - (void)deleteNews:(DynamicModel *)dynamicModel { [_db open]; [_db executeUpdate:@'DELETE FROM news WHERE newsID = ?',dynamicModel.newsID]; [_db close]; } - (void)updateNews:(DynamicModel *)dynamicModel { [_db open]; [_db executeUpdate:@'UPDATE 'news' SET cellTitle = ? WHERE newsID = ? ',@'修改的名称',dynamicModel.newsID]; // [_db executeUpdate:@'UPDATE 'news' SET person_age = ? WHERE person_id = ? ',@(person.age),person.ID]; // [_db executeUpdate:@'UPDATE 'news' SET person_number = ? WHERE person_id = ? ',@(person.number + 1),person.ID]; [_db close]; } */ - (NSMutableArray *)getAllNews { [_db open]; NSMutableArray *dataArray = [[NSMutableArray alloc] init]; FMResultSet *res = [_db executeQuery:@'SELECT * FROM news']; while ([res next]) { DynamicModel *model = [[DynamicModel alloc] init]; model.cellTitle = [res stringForColumn:@'cellTitle']; model.source = [res stringForColumn:@'source']; model.imageUrl = [res stringForColumn:@'imageUrl']; model.newsUrl = [res stringForColumn:@'newsUrl']; model.newsID = [res stringForColumn:@'newsID']; [dataArray addObject:model]; } [_db close]; return dataArray; } #pragma mark - 新闻详情 - (void)addNewsDetail:(NewsDetailModel *)newsDetailModel { [_db open]; NSData *jsonData = [NSJSONSerialization dataWithJSONObject:newsDetailModel.dataContent options:NSJSONWritingPrettyPrinted error:nil]; NSString *jsonStr = [[NSString alloc] initWithData:jsonData encoding:NSUTF8StringEncoding]; [_db executeUpdate:@'INSERT INTO newsDetail(newsUrl,dataContent)VALUES(?,?)',newsDetailModel.newsUrl,jsonStr]; [_db close]; } - (NSDictionary *)getNewsDetailWithNewsUrl:(NSString *)newsUrl { [_db open]; FMResultSet *set = [_db executeQuery:@'SELECT * FROM newsDetail']; while ([set next]) { NSString *str = [set stringForColumn:@'newsUrl']; if ([newsUrl isEqualToString:str]) { NSString *jsonStr = [set stringForColumn:@'dataContent']; NSData *jsonData = [jsonStr dataUsingEncoding:NSUTF8StringEncoding]; NSError *err; NSDictionary *dic = [NSJSONSerialization JSONObjectWithData:jsonData options:NSJSONReadingMutableContainers error:&err]; if(err) { return nil; } return dic; } } [_db close]; return nil; }

，开题报告