sqlite练习总结

1.NSDocumentDirectory NSDocumentationDirectory的区别
NSArray *paths=NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
NSString *documents=[paths objectAtIndex:0];
NSString *databasePath=[documents stringByAppendingPathComponent:DBNAME];//DBNAME为person.sqlite
NSLog(@”%@”,databasePath);
//NSDocumentDirectory输出:Users/wt/Library/Developer/CoreSimulator/Devices/11CFC7B5-382F-4573-90EB-CD0E8A1ADC7F/data/Containers/Data/Application/535A650E-E498-41C4-99AE-3CC4AA902372/Documents/person.sqlite
//NSdocumentationDirectory输出:Users/wt/Library/Developer/CoreSimulator/Devices/11CFC7B5-382F-4573-90EB-CD0E8A1ADC7F/data/Containers/Data/Application/D8A63D16-CC1E-4CB5-BD78-6453F8657DF9/Library/Documentation/person.sqlite;
即NSDocumentDirectory输出documents路径；NSdocumentationDirectory输出library/documentation路径。这个路径是没有读写权限的，所以看不到文件生成。

iOS中NSSearchPathForDirectoriesInDomains函数
默认情况下，每个沙盒含有3个文件夹：Documents, Library 和 tmp。因为应用的沙盒机制，应用只能在几个目录下读写文件
（1）Documents：应用中用户数据可以放在这里，iTunes备份和恢复的时候会包括此目录
（2）tmp：存放临时文件，iTunes不会备份和恢复此目录，此目录下文件可能会在应用退出后删除
（3）Library/Caches：存放缓存文件，iTunes不会备份此目录，此目录下文件不会在应用退出删除
对于文件操作，NSSearchPathForDirectoriesInDomains是核心函数。

2.stringByAppendingPathComponent与 stringByAppendingString区别
NSString *databasePath=[documents stringByAppendingPathComponent:DBNAME];
/Users/wt/Library/Developer/CoreSimulator/Devices/11CFC7B5-382F-4573-90EB-CD0E8A1ADC7F/data/Containers/Data/Application/4E73549E-128D-493B-A18F-F1689DC53E66/Documents/person.sqlite
NSString *databasePath1=[documents stringByAppendingString:DBNAME];
/Users/wt/Library/Developer/CoreSimulator/Devices/11CFC7B5-382F-4573-90EB-CD0E8A1ADC7F/data/Containers/Data/Application/4E73549E-128D-493B-A18F-F1689DC53E66/Documentsperson.sqlite
3.数据库的名必须以.sqlite为后缀。＊＊＊
NSString *databasePath=[documents stringByAppendingPathComponent:@“person.sqlite”];//后缀必须为person.sqlite
4.
NSArray *paths=NSSearchPathForDirectoriesInDomains(NSDocumentationDirectory, NSUserDomainMask, YES);
NSString *documents=[paths objectAtIndex:0];
NSString *databasePath=[documents stringByAppendingString:@”DB”];
NSLog(@”%@”,databasePath);
路径是：/Users/wt/Library/Developer/CoreSimulator/Devices/11CFC7B5-382F-4573-90EB-CD0E8A1ADC7F/data/Containers/Data/Application/80B39D7F-F084-4BDA-96AD-08AF6CF6B04B/Library/DocumentationDB