sqlite 添加图片
来源:互联网 发布:计算多个excel表格数据 编辑:程序博客网 时间:2024/05/21 10:38
假定数据库中存在表 test_table(name,image), 下面代码将图片文件test.png的二进制数据写到sqlite数据库:
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 CHAR * sequel = "insert into test_table(name,image) values(?,?)";
sqlite3_stmt * UPDATE;
IF (sqlite3_prepare_v2(DATABASE, sequel, -1, &UPDATE, NULL) == SQLITE_OK)
{
sqlite3_bind_text(UPDATE, 1, name, -1, NULL);
sqlite3_bind_blob(UPDATE, 2, [imgData bytes], [imgData LENGTH], NULL);
IF( sqlite3_step(UPDATE) == SQLITE_DONE)
{
NSLog(@"已经写入数据");
}
sqlite3_finalize(UPDATE);
}
}
ELSE
{
NSLog(@"文件不存在");
}
下面代码从数据库中读取图片二进制数据,然后显示图片:
const CHAR * sequel = "select image from test_table where name=?";
sqlite3_stmt * getimg;
IF (sqlite3_prepare_v2(DATABASE, sequel, -1, &getimg, NULL) == SQLITE_OK)
{
CHAR *name = "test";
sqlite3_bind_text(UPDATE, 1, name, -1, NULL);
IF(sqlite3_step(getimg) == SQLITE_ROW)
{
INT bytes = sqlite3_column_bytes(getimg, 1); //获取长度
Byte * VALUE = (Byte*)sqlite3_column_blob(getimg, 1); //获取数据
IF (bytes !=0 && VALUE != NULL)
{
NSData * DATA = [NSData dataWithBytes:VALUE LENGTH:bytes]; //二进制转化为data型
UIImage * img = [UIImage imageWithData:DATA]; //data型转化成image
UIImageView * aview =[[UIImageView alloc] initWithFrame:
CGRectMake(0.0, 0.0, IMAGE_WIDTH, IMAGE_HEIGHT)];
aview.image = img;
[SELF.VIEW addSubview:aview];
[aview release];
}
}
sqlite3_finalize(getimg);
}
例2:存储图片
/ 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, &statement, NULL) == SQLITE_OK )
{
sqlite3_bind_text(statement, 1, [mainUrl UTF8String], -1, SQLITE_TRANSIENT);
sqlite3_bind_blob(statement, 2, [imgData bytes], [imgData length], SQLITE_TRANSIENT);
sqlite3_step(statement);
}
else NSLog( @"SaveBody: Failed from sqlite3_prepare_v2. Error is: %s", sqlite3_errmsg(articlesDB) );
// Finalize and close database.
sqlite3_finalize(statement);
}
读取图片:
// Load images from data base with given image url
- (NSData*) LoadImagesFromSql: (NSString*) imageLink
{
NSData* data = nil;
NSString* sqliteQuery = [NSString stringWithFormat:@"SELECT IMAGE FROM IMAGES WHERE URL = '%@'", imageLink];
sqlite3_stmt* statement;
if( sqlite3_prepare_v2(articlesDB, [sqliteQuery UTF8String], -1, &statement, NULL) == SQLITE_OK )
{
if( sqlite3_step(statement) == SQLITE_ROW )
{
int length = sqlite3_column_bytes(statement, 0);
data = [NSData dataWithBytes:sqlite3_column_blob(statement, 0) length:length];
}
}
// Finalize and close database.
sqlite3_finalize(statement);
return data;
}
- sqlite 添加图片
- SQLite数据库储存图片信息,GridView显示,基本实现添加、删除图标操作 ... ...
- powerdesigner 添加sqlite支持
- Sqlite批量添加数据
- sqlite 添加字段
- sqlite添加列
- sqlite添加数据
- Sqlite添加自定义函数
- Sqlite 添加、查询
- 图片存入SQLite
- SQLite存取图片
- Sqlite数据库图片存取
- sqlite 存储、读取图片
- Sqlite存储图片文字
- sqlite 存储图片
- android sqlite 存储图片
- sqlite存储图片
- Android SQLite存取图片
- Voted Perceptron(投票感知器算法)
- Android dip,px,pt,sp 的区别
- 转帖:float型和double型数据的存储方式
- C语言18个经典小程序(一)
- 在 python 中,如果 x 是 list,为什么 x += "ha" 可以运行,而 x = x + "ha" 却抛出异常呢
- sqlite 添加图片
- C语言18个经典小程序(二)
- python 学习笔记一
- linux下的双显卡切换(linux mint LMDE测试有效)
- 针的魅力(来自CSDN博客)
- C语言18个经典小程序(三)
- Windows核心编程学习笔记--第15章
- ext.grid的配置属性和方法
- X Over SSH2 - A Tutorial