- (IBAction)insertData:(id)sender

{

static int idx = 1;

FMDatabase *db = [FMDatabase databaseWithPath:self.dbPath];

if ([db open]) {

NSString *sql = @"insert into User(name,password,beizhu,image) values(?,?,?,?)";

NSString *name = [NSString stringWithFormat:@"Karen %d",idx++];

UIImage *image = [UIImage imageNamed:@"01.png"];

NSData *data = UIImagePNGRepresentation(image); // data:52987

NSString *imgStr = [NSString stringWithFormat:@"%@",data];

BOOL res = [db executeUpdate:sql,name,@"boy",@"www",imgStr];

if (!res) {

debugLog(@"Error: 插入数据 失败 ");

}

else

debugLog(@"插入数据 成功");

[db close];

}

}

- (IBAction)queryData:(id)sender

{

debugMethod();

FMDatabase *db = [FMDatabase databaseWithPath:self.dbPath];

if ([db open]) {

NSString *sql = @"select * from User";

FMResultSet *rs = [db executeQuery:sql];

while([rs next]) {

int userId = [rs intForColumn:@"id"];

NSString *name = [rs stringForColumn:@"name"];

NSString *password = [rs stringForColumn:@"password"];

NSString *beizhu = [rs stringForColumn:@"beizhu"];

NSData *data = [rs dataForColumn:@"image"]; /// data:119222 为什么两次的data不相同

self.imageView.image = [UIImage imageWithData:data]; //self.imageView.image 是空呢

NSLog(@"self.imageView.image = %@",self.imageView.image);

debugLog(@"id = %d, name = %@,password = %@,beizhu = %@ \n",userId,name,password,beizhu);

}

[rs close];

[db close];

}

}