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

写入:

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

NSData*image=UIImagePNGRepresentation([UIImageimageNamed:@"01_02.png"]);
NSString *aaa=[[NSString alloc]initWithFormat:@”update cards setc_image=? where id=1″];

sqlite3 *database;

if (sqlite3_open([dataPathUTF8String],&database) == SQLITE_OK){
sqlite3_stmt * compliedStatement;
sqlite3_prepare(database,[aaaUTF8String],-1,&compliedStatement,0);
sqlite3_bind_blob(compliedStatement,1,[image bytes],[imagelength],NULL);
int result=sqlite3_step(compliedStatement);
if (result==SQLITE_DONE) {
}
sqlite3_finalize(compliedStatement);

}
sqlite3_close(database);
[aaa release];

读取:

}
else{

} } } sqlite3_finalize(compliedStatement); } sqlite3_close(database);

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!