en]) {
BOOL flag = [self.database executeUpdate:@"delete from t_testOfFMDB"];
if (flag) {
NSLog(@"删除成功");
}else{
NSLog(@"删除失败");
}
}
[self.database close];
}
- (IBAction)update:(id)sender {
if ([self.database open]) {
NSData * data = UIImageJPEGRepresentation([UIImage imageNamed:@"CX.jpg"], 1);
BOOL flag = [self.database executeUpdate:@"update t_testOfFMDB set image = ?",data];
if (flag) {
NSLog(@"修改成功");
}else{
NSLog(@"修改失败");
}
}
[self.database close];
}
- (IBAction)select:(id)sender {
if ([self.database open]) {
//返回查询数据的结果集
FMResultSet * resultSet = [self.database executeQuery:@"select * from t_testOfFMDB"];
//查询表中的每一个记录
while ([resultSet next]) {
NSData * data = [resultSet dataForColumn:@"image"];
UIImage * image = [UIImage imageWithData:data];
self.imageView.image = image;
}
}
[self.database close];
}
@end
测试结果
图片(插入后查询)
图片(修改后查询)
图片(删除后查询 由于显示无法证实 这里查看数据库)
|