【學習筆記】sqlite 数据库读写图片

前端之家收集整理的这篇文章主要介绍了【學習筆記】sqlite 数据库读写图片前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
  1. iPhone sqlite 数据库读写图片,先把你的图片转换成 NSData 形式,然后在数据库添加一行 blob 数据,代码如下(data就是图片
  2.  
  3. NSMutableString *insertsql = [[NSMutableString alloc] initWithString:@"INSERT INTO "];
  4. [insertsql appendString:BLOB];
  5. [insertsql appendString:@" ("];
  6. [insertsql appendString:BLOB_DATA];
  7. [insertsql appendString:@") VALUES(?1)"];
  8. sqlite3_stmt *insert_statement = nil;
  9. sqlite3 *database = 你的数据库;
  10. if (sqlite3_prepare_v2(database,[insertsql UTF8String],-1,&insert_statement,NULL) == sqlITE_OK) {
  11. sqlite3_bind_blob(insert_statement,1,[data bytes],[data length],NULL);
  12. if(sqlite3_step(insert_statement) != sqlITE_DONE) {
  13. NSLog(@"Db error %s",sqlite3_errmsg(database));
  14. }
  15. } else {
  16. NSLog(@"Db error %s",sqlite3_errmsg(database));
  17. }
  18. sqlite3_finalize(insert_statement);
  19. [insertsql release];
  20.  
  21.  
  22.  
  23. //获取表格中所有的记录,放到数组fChannels中。
  24.  
  25. - (void) getChannels:(NSMutableArray*)fChannels{
  26.  
  27. char *sql = "SELECT * FROM channels where id = 2";
  28.  
  29. sqlite3_stmt *statement;
  30.  
  31. int success = (sqlite3_prepare_v2(database_,sql,&statement,NULL));
  32.  
  33. if (success == sqlITE_OK) {
  34.  
  35. if (sqlITE_ROW == sqlite3_step(statement)) {
  36.  
  37. const unsigned char *cid = sqlite3_column_text(statement,1);//获取log的字符串,’1‘是第2列
  38.  
  39. const unsigned char *dtitle = sqlite3_column_text(statement,2);
  40.  
  41. Byte* imageData = (Byte*)sqlite3_column_blob(statement,3);
  42.  
  43. int imageLen = sqlite3_column_int(statement,4);
  44.  
  45. _titleLabel.text = [NSString stringWithUTF8String:(char *)dtitle];
  46.  
  47. _iv.image = [UIImage imageWithData:[NSData dataWithBytes:imageData length:imageLen]];
  48.  
  49. sqlite3_finalize(statement);
  50.  
  51. }
  52.  
  53. sqlite3_finalize(statement);
  54.  
  55. }
  56.  
  57. }

猜你在找的Sqlite相关文章