[iOS]列表已读/文章收藏

2024-08-20 23:32
文章标签 文章 列表 ios 收藏 已读

本文主要是介绍[iOS]列表已读/文章收藏,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

[iOS]列表已读/文章收藏


Demo:http://download.csdn.net/detail/u012881779/9476772

收藏


#import "FavManager.h"
#import "BaseDB.h"
#import "SBJson.h"@implementation FavManager- (void)addToFavarite:(NSDictionary *)dic FavType:(FAVTYPE)favType{NSDictionary *_dic=[NSDictionary dictionaryWithDictionary:dic];BaseDB *baseDB=[[BaseDB alloc] init];[baseDB openDB];//favtimestamp[baseDB createTable:@"Favarites" columns:@"aid INTEGER PRIMARY KEY,json text,favType integer,dateTime text"];NSMutableArray *arr=[NSMutableArray arrayWithObjects:[_dic objectForKey:@"id"]==NULL?[_dic objectForKey:@"gid"]:[_dic objectForKey:@"id"],[_dic JSONRepresentation],[NSNumber numberWithInt:favType],[NSString stringWithFormat:@"%.f",[[NSDate date] timeIntervalSince1970]], nil];[baseDB insertTableValues:@"Favarites" values:arr];[baseDB closeDB];[baseDB release];
}- (BOOL)hasFavarited:(NSString *)aid{BaseDB *baseDB=[[BaseDB alloc] init];[baseDB openDB];NSInteger i = [[baseDB selectForColumn:@"aid" value:aid tableName:@"Favarites"] count];[baseDB closeDB];[baseDB release];return i>0?YES:NO;
}- (NSArray *)fetchFavariteList:(FAVTYPE)favType{BaseDB *baseDB=[[BaseDB alloc] init];[baseDB openDB];NSMutableArray *listArray=[NSMutableArray array];NSArray *temp=[NSArray array];temp=[baseDB selectSequence:[NSString stringWithFormat:@"SELECT * FROM Favarites WHERE favType=%d order by dateTime desc",favType]];for (int i = 0 ; i<[temp count]; i++) {NSDictionary *dic = [[[temp objectAtIndex:i] objectForKey:@"json"] JSONValue];NSMutableDictionary *mDict = [dic mutableCopy];[mDict setObject:[NSString stringWithFormat:@"%d",favType] forKey:@"favtype"];[mDict setObject:[[temp objectAtIndex:i] objectForKey:@"dateTime"] forKey:@"dateTime"];[listArray addObject:mDict];[mDict release];}[baseDB closeDB];[baseDB release];return listArray;
}- (void)deleteFromFavarite:(NSString *)aid{BaseDB *baseDB=[[BaseDB alloc] init];[baseDB openDB];[baseDB deleteForColumn:@"aid" value:aid tableName:@"Favarites"];[baseDB closeDB];[baseDB release]; 
}- (void)clearFavarites{BaseDB *baseDB=[[BaseDB alloc] init];[baseDB openDB];[baseDB deleteAll:@"Favarites"];[baseDB closeDB];[baseDB release];
}//收藏已读、未读
+ (void)setRead:(NSString *)aid{BaseDB *baseDB=[[BaseDB alloc] init];[baseDB openDB];if (![baseDB tableExists:@"ListStatus"]) {[baseDB createTable:@"ListStatus" columns:@"aid INTEGER PRIMARY KEY"];}[baseDB executeSQL:[NSString stringWithFormat:@"INSERT INTO ListStatus VALUES(%@)",aid]];[baseDB closeDB];[baseDB release];
}+ (BOOL)hasRead:(NSString *)aid{BaseDB *baseDB=[[BaseDB alloc] init];[baseDB openDB];NSInteger i=[[baseDB selectForColumn:@"aid" value:aid tableName:@"ListStatus"] count];[baseDB closeDB];[baseDB release];return i > 0?YES:NO;
}@end

数据库


#import "BaseDB.h"
#import <Foundation/Foundation.h>
#import "FMDatabase.h"
#import "FMDatabaseAdditions.h"
#import "FMResultSet.h"
@interface BaseDB : NSObject{
FMDatabase *fmdb;
}
@implementation BaseDB
@synthesize fmdb;- (void)dealloc{self.fmdb   = nil;[super dealloc];
}-(void)openDB{NSString *documentsDirectory =NSHomeDirectory();NSString *path = [documentsDirectory stringByAppendingPathComponent:@"/Library/Caches/Caches.db"];NSFileManager *fileManager=[[NSFileManager alloc] init];if ([fileManager fileExistsAtPath:path]) {fmdb=[[FMDatabase alloc] initWithPath:path];if ([fmdb open]) {}}else{fmdb=[[FMDatabase alloc] initWithPath:path];if ([fmdb open]) {NSLog(@"创建了数据库并打开数据库成功!");}}[fileManager release];
}-(void)openDBMS{NSString *documentsDirectory =NSHomeDirectory();NSString *path = [documentsDirectory stringByAppendingPathComponent:@"/Library/Dbms"];NSFileManager *fileManager=[[NSFileManager alloc] init];if(![fileManager fileExistsAtPath:path]){[fileManager createDirectoryAtPath:path withIntermediateDirectories:YES attributes:nil error:nil];}NSString *filePath = [path stringByAppendingFormat:@"/Dbms.db"];if ([fileManager fileExistsAtPath:filePath]) {fmdb=[[FMDatabase alloc] initWithPath:filePath];if ([fmdb open]) {}}else{fmdb=[[FMDatabase alloc] initWithPath:filePath];if ([fmdb open]) {NSLog(@"创建了数据库并打开数据库成功!");}}[fileManager release];
}-(BOOL) tableExists:(NSString *)tableName{return [fmdb tableExists:tableName];
}-(void)deleteAll:(NSString *)tableName{NSString *sql=[NSString stringWithFormat:@"DELETE FROM %@",tableName];[fmdb executeUpdate:sql];
}-(void) deleteForColumn:(NSString *)columnName value:(NSString *)v tableName:(NSString *)name{NSString *sql=[NSString stringWithFormat:@"DELETE FROM %@ WHERE %@='%@'",name,columnName,v];NSLog(@"%@",sql);[fmdb executeUpdate:sql];
}- (void)deleteSQLString:(NSString *)condition tableName:(NSString *)name{NSString *sql=[NSString stringWithFormat:@"DELETE FROM %@ WHERE %@",name,condition];[fmdb executeUpdate:sql];
}-(void)createTable:(NSString *)tableName columns:(NSString *)columnsName{NSString *sql=[NSString stringWithFormat:@"CREATE TABLE %@ (%@)",tableName,columnsName];[fmdb executeUpdate:sql];
}-(void)insertTableValues:(NSString *)tableName values:(NSMutableArray *)Values{NSMutableString *sql=[[NSMutableString alloc] init];NSMutableArray *tempArray=[[NSMutableArray alloc] initWithArray:Values];[sql appendFormat:@"INSERT INTO %@ VALUES(",tableName];for (int i=0; i<[Values count]; i++) {if (i==[Values count]-1) {[sql appendFormat:@"?)"];}else{[sql appendFormat:@"?,"];}}[fmdb executeUpdate:sql withArgumentsInArray:tempArray];[sql release];[tempArray release];
}- (void)executeSQL:(NSString *)sql{[fmdb executeUpdate:sql];
}-(NSMutableArray *)selectAll:(NSString *)tableName{NSString *sql=[NSString stringWithFormat:@"SELECT * FROM %@",tableName];FMResultSet *rs=[fmdb executeQuery:sql];NSMutableArray *list=[[NSMutableArray alloc] init];while ([rs next]) {NSMutableDictionary *temp=[[NSMutableDictionary alloc] init];for (int i=0; i<[rs columnCount]; i++) {[temp addEntriesFromDictionary:[NSDictionary dictionaryWithObject:[rs stringForColumn:[rs columnNameForIndex:i]] forKey:[rs columnNameForIndex:i]]];}[list addObject:temp];[temp release];}return [list autorelease];
}-(NSMutableArray *)selectForColumn:(NSString *)columnName value:(NSString *)v tableName:(NSString *)name{NSString *sql=[NSString stringWithFormat:@"SELECT * FROM %@ WHERE %@='%@'",name,columnName,v];FMResultSet *rs=[fmdb executeQuery:sql];NSMutableArray *list=[[NSMutableArray alloc] init];while ([rs next]) {NSMutableDictionary *temp=[[NSMutableDictionary alloc] init];for (int i=0; i<[rs columnCount]; i++) {[temp addEntriesFromDictionary:[NSDictionary dictionaryWithObject:[rs stringForColumn:[rs columnNameForIndex:i]] forKey:[rs columnNameForIndex:i]]];}[list addObject:temp];[temp release];}return [list autorelease];
}-(NSMutableArray *) selectForNotColumn:(NSString *)columnName value:(NSString *)v tableName:(NSString *)name{NSString *sql=[NSString stringWithFormat:@"SELECT * FROM %@ WHERE %@!='%@'",name,columnName,v];FMResultSet *rs=[fmdb executeQuery:sql];NSMutableArray *list=[[NSMutableArray alloc] init];while ([rs next]) {NSMutableDictionary *temp=[[NSMutableDictionary alloc] init];for (int i=0; i<[rs columnCount]; i++) {[temp addEntriesFromDictionary:[NSDictionary dictionaryWithObject:[rs stringForColumn:[rs columnNameForIndex:i]] forKey:[rs columnNameForIndex:i]]];}[list addObject:temp];[temp release];}return [list autorelease] ;
}-(void)updateForColumn:(NSString *)columnName value:(NSString *)v tableName:(NSString *)name whereColumn:(NSString *)where whereValue:(NSString *)whereV{NSString *sql=[NSString stringWithFormat:@"UPDATE %@ SET %@='%@' WHERE %@='%@'",name,columnName,v,where,whereV];[fmdb executeUpdate:sql];
}-(NSMutableArray *)selectSequence:(NSString *)sql{NSLog(@"SQL:%@",sql);FMResultSet *rs=[fmdb executeQuery:sql];NSMutableArray *list=[[NSMutableArray alloc] init];while ([rs next]) {NSMutableDictionary *temp=[[NSMutableDictionary alloc] init];for (int i=0; i<[rs columnCount]; i++) {[temp addEntriesFromDictionary:[NSDictionary dictionaryWithObject:[rs stringForColumn:[rs columnNameForIndex:i]] forKey:[rs columnNameForIndex:i]]];}[list addObject:temp];[temp release];}return [list autorelease];    
}@end


示意图


这篇关于[iOS]列表已读/文章收藏的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/1091483

相关文章

微信公众号脚本-获取热搜自动新建草稿并发布文章

《微信公众号脚本-获取热搜自动新建草稿并发布文章》本来想写一个自动化发布微信公众号的小绿书的脚本,但是微信公众号官网没有小绿书的接口,那就写一个获取热搜微信普通文章的脚本吧,:本文主要介绍微信公众... 目录介绍思路前期准备环境要求获取接口token获取热搜获取热搜数据下载热搜图片给图片加上标题文字上传图片

Python中DataFrame转列表的最全指南

《Python中DataFrame转列表的最全指南》在Python数据分析中,Pandas的DataFrame是最常用的数据结构之一,本文将为你详解5种主流DataFrame转换为列表的方法,大家可以... 目录引言一、基础转换方法解析1. tolist()直接转换法2. values.tolist()矩阵

Android App安装列表获取方法(实践方案)

《AndroidApp安装列表获取方法(实践方案)》文章介绍了Android11及以上版本获取应用列表的方案调整,包括权限配置、白名单配置和action配置三种方式,并提供了相应的Java和Kotl... 目录前言实现方案         方案概述一、 androidManifest 三种配置方式

python展开嵌套列表的多种方法

《python展开嵌套列表的多种方法》本文主要介绍了python展开嵌套列表的多种方法,包括for循环、列表推导式和sum函数三种方法,具有一定的参考价值,感兴趣的可以了解一下... 目录一、嵌套列表格式二、嵌套列表展开方法(一)for循环(1)for循环+append()(2)for循环+pyPhWiFd

Python容器类型之列表/字典/元组/集合方式

《Python容器类型之列表/字典/元组/集合方式》:本文主要介绍Python容器类型之列表/字典/元组/集合方式,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录1. 列表(List) - 有序可变序列1.1 基本特性1.2 核心操作1.3 应用场景2. 字典(D

Java中数组转换为列表的两种实现方式(超简单)

《Java中数组转换为列表的两种实现方式(超简单)》本文介绍了在Java中将数组转换为列表的两种常见方法使用Arrays.asList和Java8的StreamAPI,Arrays.asList方法简... 目录1. 使用Java Collections框架(Arrays.asList)1.1 示例代码1.

python中列表list切分的实现

《python中列表list切分的实现》列表是Python中最常用的数据结构之一,经常需要对列表进行切分操作,本文主要介绍了python中列表list切分的实现,文中通过示例代码介绍的非常详细,对大家... 目录一、列表切片的基本用法1.1 基本切片操作1.2 切片的负索引1.3 切片的省略二、列表切分的高

Python如何计算两个不同类型列表的相似度

《Python如何计算两个不同类型列表的相似度》在编程中,经常需要比较两个列表的相似度,尤其是当这两个列表包含不同类型的元素时,下面小编就来讲讲如何使用Python计算两个不同类型列表的相似度吧... 目录摘要引言数字类型相似度欧几里得距离曼哈顿距离字符串类型相似度Levenshtein距离Jaccard相

Redis存储的列表分页和检索的实现方法

《Redis存储的列表分页和检索的实现方法》在Redis中,列表(List)是一种有序的数据结构,通常用于存储一系列元素,由于列表是有序的,可以通过索引来访问元素,因此可以很方便地实现分页和检索功能,... 目录一、Redis 列表的基本操作二、分页实现三、检索实现3.1 方法 1:客户端过滤3.2 方法

Python实现将实体类列表数据导出到Excel文件

《Python实现将实体类列表数据导出到Excel文件》在数据处理和报告生成中,将实体类的列表数据导出到Excel文件是一项常见任务,Python提供了多种库来实现这一目标,下面就来跟随小编一起学习一... 目录一、环境准备二、定义实体类三、创建实体类列表四、将实体类列表转换为DataFrame五、导出Da