本文介绍了一段用于从SQLite数据库中获取数据并转换为Objective-C字典的代码实现。该方法通过遍历每一列来获取列名及对应的数据类型，并将这些信息存储到字典中以便进一步处理。
FMResult 中管理数据库值得学习的代码
- (NSDictionary *)resultDict {
int num_cols = sqlite3_data_count(statement.statement);
if (num_cols > 0) {
NSMutableDictionary *dict = [NSMutableDictionary dictionaryWithCapacity:num_cols];
int i;
for (i = 0; i < num_cols; i++) {
const char *col_name = sqlite3_column_name(statement.statement, i);
if (col_name) {
NSString *colName = [NSString stringWithUTF8String:col_name];
id value = nil;
// fetch according to type
switch (sqlite3_column_type(statement.statement, i)) {
case SQLITE_INTEGER: {
value = [NSNumber numberWithLongLong:[self longLongIntForColumnIndex:i]];
break;
}
case SQLITE_FLOAT: {
value = [NSNumber numberWithDouble:[self doubleForColumnIndex:i]];
break;
}
case SQLITE_TEXT: {
value = [self stringForColumnIndex:i];
break;
}
case SQLITE_BLOB: {
value = [self dataForColumnIndex:i];
break;
}
}
// save to dict
if (value) {
[dict setObject:value forKey:colName];
}
}
}
return [[dict copy] autorelease];
}
else {
NSLog(@"Warning: There seem to be no columns in this set.");
}
return nil;
}
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
