我想在一个mysql数据库中插入很多数据,当然只有文本。
我目前正在通过帖子进行操作,例如 insertUser.php?user=asd&pass=asdas&email=asdasd 是否正常,它会给我一个回复,但现在我尝试 upload 大量数据,如 insertData.php?xml=string&userid=2 并且响应也很大,有时需要很长时间,因为它是用于手机的应用程序大多使用 3g (android & iOS),那么哪个会更高效,仍然使用 post connections 还是 direct mysql connection ?
谢谢。
Best Answer-推荐答案 strong>
检查下面的答案
xmlbody = (NSString *)CFURLCreateStringByAddingPercentEscapes(
NULL,
(CFStringRef)xmlbody,
NULL,
(CFStringRef)@"!*'\"();&=+$,/?%#[]% ",
kCFStringEncodingUTF8 );
NSMutableString *entirexmlbody=[[NSMutableString alloc]init ];
[entirexmlbody appendString"xml="];
[entirexmlbody appendString:xmlbody];
NSLog(@"posting XML Body after encoding--%@\n",xmlbody);
NSData *postData = [entirexmlbody dataUsingEncoding:NSASCIIStringEncoding allowLossyConversion:YES];
NSString *postLength = [NSString stringWithFormat"%d",[postData length]];
NSMutableURLRequest *request = [[[NSMutableURLRequest alloc] init] autorelease];
[request setURL:[NSURL URLWithString:posturl]];
[request setHTTPMethod"OST"];
[request setValue:postLength forHTTPHeaderField"Content-Length"];
[request setValue"application/x-www-form-urlencoded" forHTTPHeaderField"Content-Type"];
[request setHTTPBody:postData];
NSURLConnection *conn=[[[NSURLConnection alloc] initWithRequest:request delegate:self] autorelease];
关于android - 哪种方式更有效和更安全,后连接或直接连接到数据库?,我们在Stack Overflow上找到一个类似的问题:
https://stackoverflow.com/questions/15338645/
|