+ (instancetype)sharedInstance { static dispatch_once_t once; static id __singleton__; dispatch_once( &once, ^{ __singleton__ = [[self alloc] init]; } ); return __singleton__; }
/**
- 打開數(shù)據(jù)庫 - Data
*/
- (void)opendb { if(db == nil){ NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES); NSString *documentDirectory = [paths objectAtIndex:0]; NSString *dbPath = [documentDirectory stringByAppendingPathComponent:@"MyDatabase.db"]; db = [FMDatabase databaseWithPath:dbPath] ; if ([db open]) { NSLog(@"db打開成功"); [db executeUpdate:@"CREATE TABLE DataList (title text primary key not null, dataBase blob)"]; NSLog(@"db創(chuàng)建表成功"); NSLog(@"%@",db); }else{ NSLog(@"Could not open db."); } } }