db数据库利用第三方框架进行提取和解析数据

来源：互联网发布：linux 查看hba 编辑：程序博客网时间：2024/05/18 00:23

db的数据包用从github上下载的三方框架进行解析和数据提取，格式一般为数组和字典。db的查看工具是firefox上的解析db插件SQLite

三方框架为FMDB

#import "ViewController.h"//1. 引入头文件，需要引入libsqlite3的库#import "FMDB.h"#import "Word.h"@interface ViewController ()            @end@implementation ViewController            - (void)viewDidLoad {    [super viewDidLoad];        //2. 创建一个FMDatabase对象，并指定文件路径    FMDatabase *database = [FMDatabase databaseWithPath:@"/Users/apple/Desktop/japanese.db"];    //3. 打开文件    if (![database open]) {        NSLog(@"Can not open file");        return;    }        //4. 执行查询    FMResultSet *result = [database executeQuery:@"SELECT * FROM jp"];        NSMutableArray *array = [NSMutableArray array];    //5. 获取表格中的一行    while ([result next]) {//        NSMutableDictionary *dict = [NSMutableDictionary dictionary];                Word *word = [[Word alloc] init];                //根据名字（列名）获取数据        int rid = [result intForColumn:@"id"];        NSLog(@"rid: %d", rid);                word.rid = rid;        //        [dict setObject:[NSNumber numberWithInt:rid] forKey:@"id"];                //根据位置获取数据        int rid1 = [result intForColumnIndex:0];        NSLog(@"rid1: %d", rid1);                NSString *kana = [result stringForColumn:@"kana"];        NSLog(@"kana: %@", kana);        //        [dict setObject:kana forKey:@"kana"];                NSString *kana1 = [result stringForColumnIndex:5];        NSLog(@"kana1: %@", kana1);                word.kana = kana1;                [array addObject:word];    }        //6. 关闭文件    [database close];        NSLog(@"-----------");    NSLog(@"%@", array);}

这是word.h和word.m中的代码

#import <Foundation/Foundation.h>@interface Word : NSObject@property (nonatomic, assign) NSInteger rid;@property (nonatomic, copy) NSString *kana;@end

#import "Word.h"@implementation Word- (NSString *)description{    return [NSString stringWithFormat:@"%@: rid: %d---kana: %@", [super description], _rid, _kana];}@end

0 0