注意：
1.使用该方法时注意要给项目中添加database.h和database.m文件以及PlausibleDatabase.framework框架。
2.在框架中导入libsqlite3.dylib框架。
@H_403_44@
5.正式开始--------------------------------------------------------------------------------
-(void)refreshArray{
PLsqliteDatabase *db = [DataBasesetup];
NSString *sql = [NSStringstringWithFormat:@"select * from %@",attribute];
id<PLResultSet>rs = [dbexecuteQuery:sql];
while ([rsnext]) {
NSMutableDictionary *myDict = [[NSMutableDictionaryalloc]init];
NSString *list = [rsstringForColumn:@"list"];
[myDict setObject:listforKey:@"list"];
// NSLog(@"list ---- %@",list);
NSString *words = [rsstringForColumn:@"words"];
[myDict setObject:wordsforKey:@"words"];
// NSLog(@"words ---- %@",words);
NSData *picData = [rsdataForColumn:@"picture"];
// NSLog(@"picData ---- %@",picData);
[myDict setObject:picDataforKey:@"picture"];
[myArrayaddObject:myDict];
[myDict release];
}
}
@H_403_44@
向sqlite数据库插入和读取二进制图片数据 (for ios)
假定数据库中存在表 test_table(name,image),下面代码将图片文件test.png的二进制数据写到sqlite数据库：@H_403_44@
UIImage *image = [UIImageimageNamed:@"tree.png"];
NSData *data = UIImagePNGRepresentation(image);
NSString *sql = [NSStringstringWithFormat:@"insert into test_tablevalues('%@')",data];
PLsqliteDatabase *db = [DataBasesetup];
[db executeUpdate:sql];
@H_403_44@
下面代码从数据库中读取图片二进制数据，然后转换成图片image格式：@H_403_44@
NSString *sql =@"select picture from test_table where mnumber=1";
PLsqliteDatabase *db = [DataBasesetup];
id<PLResultSet>rs = [dbexecuteQuery:sql];
while ([rsnext]) {
NSData *data = [rsdataForColumn:@"picture"];
UIImage *image = [UIImageimageWithData:data];//此即为读出的图片，然后按你自己的需求使用即可
}
@H_403_44@
【以下是不需要任何第三方类的方法】 @H_403_44@ 下面代码将图片文件test.png的二进制数据写到sqlite数据库： @H_403_44@ char *name = "test"; @H_403_44@ NSString * nameString = [NSString stringWithCString:name encoding:NSUTF8StringEncoding]; @H_403_44@ NSString * filePath = [[NSBundle mainBundle] pathForResource:nameString ofType:@"png"]; @H_403_44@ if ([[NSFileManager defaultManager] fileExistsAtPath:filePath]) @H_403_44@ { @H_403_44@ NSData * imgData = UIImagePNGRepresentation([UIImage imageWithContentsOfFile:filePath]); @H_403_44@ const char * sequel = "insert into test_table(name,image) values(?,?)"; @H_403_44@ sqlite3_stmt * update; @H_403_44@ if (sqlite3_prepare_v2(database,sequel,-1,&update,NULL) == sqlITE_OK) @H_403_44@ { @H_403_44@ sqlite3_bind_text(update,1,name,NULL); @H_403_44@ sqlite3_bind_blob(update,2,[imgData bytes],[imgData length],NULL); @H_403_44@ if( sqlite3_step(update) == sqlITE_DONE) @H_403_44@ { NSLog(@"已经写入数据"); } @H_403_44@ sqlite3_finalize(update); @H_403_44@ } @H_403_44@ } @H_403_44@ else @H_403_44@ { System Italic 27.0 NSLog(@"文件不存在"); } @H_403_44@ 下面代码从数据库中读取图片二进制数据，然后显示图片： @H_403_44@ const char * sequel = "select image from test_table where name=?"; @H_403_44@ sqlite3_stmt * getimg; @H_403_44@ if (sqlite3_prepare_v2(database,&getimg,NULL) == sqlITE_OK) @H_403_44@ { @H_403_44@ char *name = "test"; @H_403_44@ sqlite3_bind_text(update,NULL); @H_403_44@ if(sqlite3_step(getimg) == sqlITE_ROW) @H_403_44@ { @H_403_44@ int bytes = sqlite3_column_bytes(getimg,0); @H_403_44@ Byte * value = (Byte*)sqlite3_column_blob(getimg,1); @H_403_44@ if (bytes !=0 && value != NULL) @H_403_44@ { @H_403_44@ NSData * data = [NSData dataWithBytes:value length:bytes]; @H_403_44@ UIImage * img = [UIImage imageWithData:data]; @H_403_44@ UIImageView * aview =[[UIImageView alloc] initWithFrame:CGRectMake(0.0,0.0,IMAGE_WIDTH,IMAGE_HEIGHT)]; @H_403_44@ aview.image = img; @H_403_44@ [self.view addSubview:aview]; @H_403_44@ [aview release]; @H_403_44@ } @H_403_44@ } @H_403_44@sqlite3_finalize(getimg);
}
