在xcode中新建一個(gè)空項(xiàng)目紧显，新建一個(gè)類(lèi)，命名為DataBaseHelper, .h文件申明一個(gè)單例和幾個(gè)口函數(shù)，代碼如下：

#import <Foundation/Foundation.h>
#import "FMDatabase.h"

@interface DataBaseHelper : NSObject

@property (nonatomic, strong) FMDatabase *db;

//單例
+ (DataBaseHelper *)sharedDataBaseHelper;
//插入數(shù)據(jù)
- (void)insertNoticeDictionary:(NSDictionary *)dict;
//查詢(xún)數(shù)據(jù)
- (NSArray *)queryNoticeData;
//修改數(shù)據(jù)
- (void)updateNoticeDataWithNewDictionary:(NSDictionary *)newDictionary messageId:(NSString *)messageId;

@end

.m文件代碼如下：

#import "DataBaseHelper.h"

static DataBaseHelper *helper = nil;

@implementation DataBaseHelper

#pragma mark - 創(chuàng)建單例
+ (DataBaseHelper *)sharedDataBaseHelper{
   static dispatch_once_t onceToken;
   dispatch_once(&onceToken, ^{
       helper = [[DataBaseHelper alloc] init];
       [helper createDataBase];
       [helper createTable];
   });
   return helper;
}


#pragma mark - 創(chuàng)建數(shù)據(jù)庫(kù)
- (void)createDataBase{
   NSString *document = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask,YES) firstObject];
   NSString *filePath = [document stringByAppendingPathComponent:@"notices.sqlite"];
   self.db = [FMDatabase databaseWithPath:filePath];
}


#pragma mark - 創(chuàng)建表
- (void)createTable{
   if ([self.db open]) {
       BOOL result = [self.db executeUpdate:@"CREATE TABLE IF NOT EXISTS t_notice (id integer PRIMARY KEY AUTOINCREMENT, dict BLOB NOT NULL, timeStamp datetime NOT NULL, messageId text NOT NULL);"];
       if (result) {
           NSLog(@"創(chuàng)建表成功");
       }else{
           NSLog(@"創(chuàng)建表失敗");
       }
       [self.db close];
   }else{
       NSLog(@"數(shù)據(jù)庫(kù)打開(kāi)失敗");
   }
}


#pragma mark - 插入數(shù)據(jù)
- (void)insertNoticeDictionary:(NSDictionary *)dict {
   if ([self.db open]) {
       NSNumber *startFromDate = [self getCurrentTimestamp];
       NSDictionary *noticeDict = @{@"messageId":dict[@"messageId"],
                                    @"fromId":dict[@"from"][@"fromId"],
                                    @"fromName":dict[@"from"][@"name"],
                                    @"fromAvatar":dict[@"from"][@"avatar"],
                                    @"toId":dict[@"to"][@"toId"],
                                    @"toName":dict[@"to"][@"name"],
                                    @"toAvatar":dict[@"to"][@"avatar"],
                                    @"title":dict[@"content"][@"title"],
                                    @"payload":dict[@"payload"],
                                    @"startFromDate":startFromDate
                                    };
       NSData *jsonData = [NSJSONSerialization dataWithJSONObject:noticeDict options:NSJSONWritingPrettyPrinted error:nil];
       NSString *messageId = dict[@"messageId"];
       NSString *dateStr = [self getCurrentTimeStr];
       BOOL result = [self.db executeUpdate:@"INSERT INTO t_notice (dict, timeStamp, messageId) VALUES (?,?,?);", jsonData, dateStr, messageId];
       if (result) {
           NSLog(@"插入成功");
       }else{
           NSLog(@"插入失敗");
       }
       [self.db close];
   }else{
       NSLog(@"數(shù)據(jù)庫(kù)打開(kāi)失敗");
   }
}

#pragma mark - 根據(jù)時(shí)間先后查詢(xún)數(shù)據(jù)
- (NSArray *)queryNoticeData {
   NSError *error;
   NSMutableArray *arr = [NSMutableArray array];
   if ([self.db open]) {
       FMResultSet *resultSet = [self.db executeQuery:@"SELECT * FROM t_notice order by timeStamp desc"];
       while ([resultSet next]) {
           NSData *resultData = [resultSet objectForColumnName:@"dict"];
           NSDictionary *dict = [NSJSONSerialization JSONObjectWithData:resultData options:kNilOptions error:&error];
           [arr addObject:dict];
       }
   }
   return arr;
}

#pragma mark - 根據(jù)messageId修改數(shù)據(jù)
- (void)updateNoticeDataWithNewDictionary:(NSDictionary *)newDictionary messageId:(NSString *)messageId {
   NSData *jsonData = [NSJSONSerialization dataWithJSONObject:newDictionary options:NSJSONWritingPrettyPrinted error:nil];
   if ([self.db open]) {
       BOOL result = [self.db executeUpdate:@"UPDATE t_notice SET dict = ? WHERE messageId = ?", jsonData, messageId];
       if (result) {
           NSLog(@"修改數(shù)據(jù)成功");
       } else {
           NSLog(@"修改數(shù)據(jù)失敗");
       } [self.db close];
   } else {
       NSLog(@"數(shù)據(jù)庫(kù)打開(kāi)失敗");
   }
}


#pragma mark - 獲取當(dāng)前時(shí)間
- (NSString *)getCurrentTimeStr {
   NSDate *currentDate = [NSDate date];
   NSDateFormatter *dateFormatter = [[NSDateFormatter alloc] init];
   [dateFormatter setDateFormat:@"yyyy-MM-dd HH:mm:ss"];
   NSString *dateString = [dateFormatter stringFromDate:currentDate];
   return dateString;
}


#pragma mark - 獲取當(dāng)前時(shí)間戳
- (NSNumber *)getCurrentTimestamp {
   NSTimeInterval interval = [[NSDate date] timeIntervalSince1970];
   NSNumber *startFromDate = [NSNumber numberWithDouble:interval];
   return startFromDate;
}