前端之家收集整理的这篇文章主要介绍了
【學習筆記】sqlite 数据库读写图片,
前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
- 用 iPhone 的 sqlite 数据库读写图片,先把你的图片转换成 NSData 形式,然后在数据库添加一行 blob 数据,代码如下(data就是图片) :
-
- NSMutableString *insertsql = [[NSMutableString alloc] initWithString:@"INSERT INTO "];
- [insertsql appendString:BLOB];
- [insertsql appendString:@" ("];
- [insertsql appendString:BLOB_DATA];
- [insertsql appendString:@") VALUES(?1)"];
- sqlite3_stmt *insert_statement = nil;
- sqlite3 *database = 你的数据库;
- if (sqlite3_prepare_v2(database,[insertsql UTF8String],-1,&insert_statement,NULL) == sqlITE_OK) {
- sqlite3_bind_blob(insert_statement,1,[data bytes],[data length],NULL);
- if(sqlite3_step(insert_statement) != sqlITE_DONE) {
- NSLog(@"Db error %s",sqlite3_errmsg(database));
- }
- } else {
- NSLog(@"Db error %s",sqlite3_errmsg(database));
- }
- sqlite3_finalize(insert_statement);
- [insertsql release];
-
-
-
- //获取表格中所有的记录,放到数组fChannels中。
-
- - (void) getChannels:(NSMutableArray*)fChannels{
-
- char *sql = "SELECT * FROM channels where id = 2";
-
- sqlite3_stmt *statement;
-
- int success = (sqlite3_prepare_v2(database_,sql,&statement,NULL));
-
- if (success == sqlITE_OK) {
-
- if (sqlITE_ROW == sqlite3_step(statement)) {
-
- const unsigned char *cid = sqlite3_column_text(statement,1);//获取log的字符串,’1‘是第2列
-
- const unsigned char *dtitle = sqlite3_column_text(statement,2);
-
- Byte* imageData = (Byte*)sqlite3_column_blob(statement,3);
-
- int imageLen = sqlite3_column_int(statement,4);
-
- _titleLabel.text = [NSString stringWithUTF8String:(char *)dtitle];
-
- _iv.image = [UIImage imageWithData:[NSData dataWithBytes:imageData length:imageLen]];
-
- sqlite3_finalize(statement);
-
- }
-
- sqlite3_finalize(statement);
-
- }
-
- }