往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];

读取:

NSArray *paths =NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask, YES);
NSString *dataPath = [[paths objectAtIndex:0]stringByAppendingPathComponent:@”sqlite.sqlite”];
sqlite3 *database;
if (sqlite3_open([dataPath UTF8String], &database)== SQLITE_OK){
const char *sqlStatement=”select c_image from cards whereid=1″;
sqlite3_stmt *compliedStatement;
if(sqlite3_prepare(database, sqlStatement, -1,&compliedStatement, NULL)==SQLITE_OK)
{
while (sqlite3_step(compliedStatement)==SQLITE_ROW) {
int bytes = sqlite3_column_bytes(compliedStatement, 0);
const void *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);