在Sqlite数据库插入和读取图片数据

在iOS下用sqlite数据库存储图片，先把你的图片转换成 NSData 形式，然后在数据库添加一行 blob 数据

假定数据库中存在表 test_table(name,image),下面代码将图片文件test.png的二进制数据写到sqlite数据库：

例1

 
  
   
     
     
      CHAR 
      *name 
      = 
      "test"; 
      
 NSString 
      *nameString 
      = 
      [NSString stringWithCString:name encoding:NSUTF8StringEncoding 
      ]; 
      
 NSString 
      *filePath 
      [ 
      [NSBundle mainBundle 
      ]pathForResource:nameString ofType:@ 
      "png" 
      ]; 
      
 
      IF 
      ( 
      [NSFileManager defaultManager 
      ]fileExistsAtPath:filePath 
      ] 
      ) 
      
 
      { 
      
   NSData 
      *imgData 
      =UIImagePNGRepresentation 
      [UIImage imageWithContentsOfFile:filePath 
      ); 
      
   const  
      *sequel 
      "insert into test_table(name,image) values(?,?)"; 
      
  
      
   sqlite3_stmt 
      * 
      UPDATE; 
      
   
      (sqlite3_prepare_v2 
      ( 
      DATABASE 
      ,sequel 
      - 
      1 
      UPDATE 
      NULL 
      ) 
      ==sqlITE_OK 
      ) 
      
   
      { 
      
     sqlite3_bind_text 
      name 
      ); 
      
     sqlite3_bind_blob 
      2 
      [imgData bytes 
      [imgData 
      LENGTH 
      ); 
      
     
      (sqlite3_step 
      ==sqlITE_DONE 
      ) 
      
     
      { 
      
      NSLog 
      (@ 
      "已经写入数据" 
      ); 
      
     
      } 
      
     sqlite3_finalize 
      ); 
      
   
      } 
      
 
      } 
      
 
      ELSE 
      
 
      { 
      
   NSLog 
      "文件不存在" 
      ); 
      
 
      } 
      
 
      
 下面代码从数据库中读取图片二进制数据，然后显示图片： 
      
 const 
      "select image from test_table where name=?"; 
      
 sqlite3_stmt 
      *getimg; 
      
 
      { 
      
   
      "test"; 
      
   sqlite3_bind_text 
      ); 
      
   
      (getimg 
      ==sqlITE_ROW 
      { 
      
     
      INTbytes 
      =sqlite3_column_bytes 
      0 
      ); 
      
     Byte 
      VALUE 
      (Byte 
      * 
      )sqlite3_column_blob 
      (bytes ! 
      = 
      0&& 
      VALUE! 
      = 
      { 
      
       NSData 
      DATA 
      [NSData dataWithBytes: 
      VALUE 
      LENGTH:bytes 
      ]; 
      
       UIImage 
      *img 
      [UIImage imageWithData: 
      ]; 
      
       UIImageView 
      *aview 
      [UIImageView alloc 
      ]initWithFrame: 
      
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CGRectMake 
      ( 
      0.0 
      IMAGE_HEIGHT 
      ]; 
      
       aview 
      .image 
      =img; 
      
       
      [ 
      SELF 
      . 
      VIEWaddSubview:aview 
      ]; 
      
       
      [aview release 
      ]; 
      
      
      } 
      
    
      } 
      
   sqlite3_finalize 
      } 
     
 
   
 
  

例2:存储图片

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

@H_901_403@@H_130_404@// Save Small Image Data by given main url
- ( void )SaveImagesTosql : ( NSData * )imgData NSString )mainUrl
{
NSLog ( @ "\n*****Save image to sqlite*****\n" );

const char *sqliteQuery = "INSERT INTO IMAGES (URL,IMAGE) VALUES (?,?)";
sqlite3_stmt *statement;

if (sqlite3_prepare_v2 (articlesDB,sqliteQuery,- 1,0)">&statement,NULL ) ==sqlITE_OK )
{
sqlite3_bind_text (statement,[mainUrl UTF8String ],sqlITE_TRANSIENT );
sqlite3_bind_blob 2,0)">[imgData bytes [imgData length );
sqlite3_step (statement );
}
elseNSLog "SaveBody: Failed from sqlite3_prepare_v2. Error is: %s",sqlite3_errmsg (articlesDB );

@H_130_404@// Finalize and close database.
sqlite3_finalize );
}

读取图片:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

@H_130_404@// Load images from data base with given image url
)LoadImagesFromsql )imageLink
{
*data = nil;
= [ NSStringstringWithFormat : "SELECT IMAGE FROM IMAGES WHERE URL = '%@'",imageLink ];
sqlite3_stmt [sqliteQuery UTF8String {
(sqlite3_step ==sqlITE_ROW )
{
intlength =sqlite3_column_bytes 0 );
data NSDatadataWithBytes :sqlite3_column_blob )length :length ];
}

原文链接：https://www.f2er.com/sqlite/201171.html

在Sqlite数据库插入和读取图片数据

例1

例2:存储图片

猜你在找的Sqlite相关文章