问题描述
我被困住了.有没有可以将CSV记录直接导入sqlite表的功能?任何帮助都将是可贵的.
I am stuck.Is there any function which can import CSV records directly to sqlite table ?Any help will be appreciable.
推荐答案
下面是执行此操作的粗略代码.请根据您的要求进行一些更改.
Here is a rough code to do that. Please do some changes as per your requirement.
-(void)loadCSVData{
NSStringEncoding encoding;
NSString *path1=[[NSString alloc] initWithContentsOfFile:[[NSBundle mainBundle] pathForResource:filename ofType:@"csv"] usedEncoding:&encoding error:nil];
//You will get the array of lines
NSArray *messArr=[path1 componentsSeparatedByString:@"\n"];
//Now start to process each single line. if(messArr) { for(int i=0;i<=[messArr count]-1;i++) { NSMutableDictionary *d=[[NSMutableDictionary alloc] init]; NSString *StrValue=[NSString stringWithFormat:@"%@",[messArr objectAtIndex:i]]; StrValue=[StrValue stringByReplacingOccurrencesOfString:@"\"" withString:@""]; StrValue=[StrValue stringByReplacingPercentEscapesUsingEncoding:NSUTF8StringEncoding]; NSArray *arr=[StrValue componentsSeparatedByString:@","];
//Now start to process each single line. if(messArr) { for(int i=0;i<=[messArr count]-1;i++) { NSMutableDictionary *d=[[NSMutableDictionary alloc] init]; NSString *StrValue=[NSString stringWithFormat:@"%@",[messArr objectAtIndex:i]]; StrValue=[StrValue stringByReplacingOccurrencesOfString:@"\"" withString:@""]; StrValue=[StrValue stringByReplacingPercentEscapesUsingEncoding:NSUTF8StringEncoding]; NSArray *arr=[StrValue componentsSeparatedByString:@","];
[d setValue:[arr objectAtIndex:0] forKey:@"columnName"]; //将此字典"d"添加到数据库中
[d版本]; //清理.
}
}
[path1版本];
}
请同时参考以下问题的答案.创建自己的自定义CSV解析器有一个很好的解释.
[d setValue:[arr objectAtIndex:0] forKey:@"columnName"]; //Add this dictionary "d" into database
[d release]; //Cleanup.
}
}
[path1 release];
}
Please also refer the following question's answers. There is a nice explanation of creating your own custom CSV parser.
从csv文件(iphone SDk)加载数据[如何导入CSV数据在iPhone应用程序中动态地进行sqlite操作
[2]:如何在iPhone应用程序中将CSV数据动态导入sqlite
我希望这会对您有所帮助.
I hope this will helps you.
这篇关于如何在iPhone应用程序中将CSV数据动态导入sqlite的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!