前言
使用FMDB更新数据库直接执行sql语句即可,这边文章重点在查询,升降序查询,分页查询数据库。(SELECT FROM ‘%@’ where dateline <= 2016-01-13 11:11 order by dateline DESC limit 0,10)降序查询,在时间参数dateline 在 2016-01-13 11:11 之后的数据,每次读取十条;(SELECT * FROM ‘%@’ order by dateline ASC ) 时间升序查询*
#define PATH [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) firstObject]
一、创建数据库和表格
#pragma mark 创建数据库
+(FMDatabase *)createSqlite:(NSString *)sqliteName{
NSString *dataBase_path=[PATH stringByAppendingPathComponent:[NSString stringWithFormat:@"%@.sqlite",sqliteName]];
FMDatabase*fm=[[FMDatabase alloc]initWithPath:dataBase_path];
return fm;
}
#pragma mark 创建表格
+(void)CreateInsqlite:(FMDatabase *)sqlite createTable:(NSString *)tableName ValueArray:(NSArray *)array{
if (!sqlite) {
return;
}
NSString*infoName=tableName;
NSString*sql;
sql=[NSString stringWithFormat:@"CREATE TABLE '%@' (dateline,title,type,typeId)",infoName];
if ([sqlite open]) {
BOOL res=[sqlite executeUpdate:sql];
if (res) {
NSLog(@"创建%@表格成功",infoName);
}else{
NSLog(@"创建%&