如何往sqlite中寫入圖片位元據及讀取

寫入資料庫的實現代碼:

NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);<br />NSString *dataPath = [[paths objectAtIndex:0] stringByAppendingPathComponent:@”sqlite.sqlite”];<br />NSData *image=UIImagePNGRepresentation([UIImage imageNamed:@"01_02.png"]);<br />NSString *aaa=[[NSString alloc]initWithFormat:@”update cards set c_image=? where id=1″];<br />sqlite3 *database;<br />if (sqlite3_open([dataPath UTF8String], &database) == SQLITE_OK){<br />sqlite3_stmt * compliedStatement;<br />sqlite3_prepare(database,[aaa UTF8String],-1,&compliedStatement,0);<br />sqlite3_bind_blob(compliedStatement, 1, [image bytes], [image length], NULL);<br />int result=sqlite3_step(compliedStatement);<br />if (result==SQLITE_DONE) {<br />}<br />sqlite3_finalize(compliedStatement);<br />}<br />sqlite3_close(database);<br />[aaa release];

 

讀取的實現代碼：

NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);<br />NSString *dataPath = [[paths objectAtIndex:0] stringByAppendingPathComponent:@”sqlite.sqlite”];<br />sqlite3 *database;<br />if (sqlite3_open([dataPath UTF8String], &database) == SQLITE_OK){<br />const char *sqlStatement=”select c_image from cards where id=1″;<br />sqlite3_stmt *compliedStatement;<br />if(sqlite3_prepare(database, sqlStatement, -1, &compliedStatement, NULL)==SQLITE_OK)<br />{<br />while (sqlite3_step(compliedStatement)==SQLITE_ROW) {<br />int bytes = sqlite3_column_bytes(compliedStatement, 0);<br />const void *value = sqlite3_column_blob(compliedStatement, 0);<br />if( value != NULL && bytes != 0 ){<br />NSData *data = [NSData dataWithBytes:value length:bytes];<br />UIImage *image=[UIImage imageWithData:data];<br />[imageView setImage:image];<br />}<br />else{<br />}<br />}<br />}<br />sqlite3_finalize(compliedStatement);<br />}<br />sqlite3_close(database);<br />