iphone开发-SQLite数据库使用

核心提示：这里获取表格中所有的记录，放到数组fChannels中，iphone开发-SQLite数据库使用(3)，- (void) getChannels:(NSMutableArray*)fChannels{sqlite3_stmt *statement = nil;char *sql = "SELECT * FRO

这里获取表格中所有的记录，放到数组fChannels中。

- (void) getChannels:(NSMutableArray*)fChannels{

sqlite3_stmt *statement = nil;

char *sql = "SELECT * FROM channels";

if (sqlite3_prepare_v2(database_, sql, -1, &statement, NULL) != SQLITE_OK) {

NSLog(@"Error: failed to prepare statement with message:get channels.");

}

//查询结果集中一条一条的遍历所有的记录，这里的数字对应的是列值。

while (sqlite3_step(statement) == SQLITE_ROW) {

char* cid = (char*)sqlite3_column_text(statement, 1);

char* title = (char*)sqlite3_column_text(statement, 2);

Byte* imageData = (Byte*)sqlite3_column_blob(statement, 3);

int imageLen = sqlite3_column_int(statement, 4);

Channel* channel = [[Channel alloc] init];

if(cid)

channel.id_ = [NSString stringWithUTF8String:cid];

if(title)

channel.title_ = [NSString stringWithUTF8String:title];

if(imageData){

UIImage* image = [UIImage imageWithData:[NSData dataWithBytes:imageData length:imageLen]];

channel.image_ = image;

}

[fChannels addObject:channel];

[channel release];

}

sqlite3_finalize(statement);

}

就简单说这些吧。

原文http://yuxiang13115204.blog.163.com/blog/static/26802022200921410845642/