Question

ios sqlite3建的表为什么隔一段时间就不存在了

Answer 1

-(void)viewDidLoad{[superviewDidLoad];NSString*fileName=[selfdataFile];NSLog(@"%@",fileName);if(sqlite3_open([fileNameUTF8String],&db)!=SQLITE_OK){sqlite3_close(db);NSAssert(NO,@"OPENSQLITEDATABASEERROR！");}else{char*error;NSString*createSQL=[NSStringstringWithFormat:@"CREATETABLEIFNOTEXISTS%@(%@TEXTPRIMARYKEY,%@TEXT,%@%TEXT);",TABLE_NAME,FIELDS_NAME_SID,FIELDS_NAME_SNAME,FIELDS_NAME_SCLASS];if(sqlite3_exec(db,[createSQLUTF8String],NULL,NULL,&error)){sqlite3_close(db);NSAssert1(NO,@"CREATETABLEERROR",error);}else{sqlite3_close(db);}}}