往sqlite中写入图片二进制数据及读取源码 for iphone

概述入: NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);NSString *dataPath = [[paths objectAtIndex:0] stringByAppendingPathComponent:@”sqlite.sqlite”];

入: NSArray *paths = NSSearchPathForDirectorIEsInDomains(NSdocumentDirectory,NSUserDomainMask,YES);Nsstring *dataPath = [[paths objectAtIndex:0] stringByAppendingPathComponent:@”sqlite.sqlite”];NSData *image=UIImagePNGRepresentation([UIImage imagenamed:@"01_02.png"]);Nsstring *aaa=[[Nsstring alloc]initWithFormat:@”update cards set c_image=?where ID=1″];sqlite3 *database;if (sqlite3_open([dataPath UTF8String],&database) == sqlITE_OK){sqlite3_stmt * complIEdStatement;sqlite3_prepare(database,[aaa UTF8String],-1,&complIEdStatement,0);sqlite3_bind_blob(complIEdStatement,1,[image bytes],[image length],NulL);int result=sqlite3_step(complIEdStatement);if (result==sqlITE_DONE) {}sqlite3_finalize(complIEdStatement);}sqlite3_close(database);[aaa release];读取: NSArray *paths = NSSearchPathForDirectorIEsInDomains(NSdocumentDirectory,YES);Nsstring *dataPath = [[paths objectAtIndex:0] stringByAppendingPathComponent:@”sqlite.sqlite”];sqlite3 *database;if (sqlite3_open([dataPath UTF8String],&database) == sqlITE_OK){constchar*sqlStatement=”select c_image from cards where ID=1″;sqlite3_stmt *complIEdStatement;if(sqlite3_prepare(database,sqlStatement,NulL)==sqlITE_OK){while (sqlite3_step(complIEdStatement)==sqlITE_ROW) {int bytes = sqlite3_column_bytes(complIEdStatement,0);constvoID*value = sqlite3_column_blob(complIEdStatement,0);if( value != NulL && bytes !=0 ){NSData *data = [NSData dataWithBytes:value length:bytes];UIImage *image=[UIImage imageWithData:data];[imageVIEw setimage:image];}else{}}}sqlite3_finalize(complIEdStatement);}sqlite3_close(database);

总结

以上是内存溢出为你收集整理的往sqlite中写入图片二进制数据及读取源码 for iphone全部内容，希望文章能够帮你解决往sqlite中写入图片二进制数据及读取源码 for iphone所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。