ios 通过第三方FMDB来读取db数据库的数据

第一步：在新建项目中把FMDB类库加进项目中，如图：

第二步：将做好的.db数据库放到以下目录中：

/Users/apple/Library/Application Support/iPhone Simulator/6.1/Applications/06A47F8B-23EA-48D5-80A5-54CF37D0D8B8/Documents/TCFexam.db

数据库如图：

第三步：输入以下代码：

//
//  TextOneViewController.m
//  TCFExamTextOne
//
//  Created by apple on 13-7-13.
//  Copyright (c) 2013年 apple. All rights reserved.
//

#import "TextOneViewController.h"
#import "FMDatabase.h"
#import "FMResultSet.h"

@interface TextOneViewController ()

@end

@implementation TextOneViewController

- (id)initWithNibName:(NSString *)nibNameOrNil bundle:(NSBundle *)nibBundleOrNil
{
    self = [super initWithNibName:nibNameOrNil bundle:nibBundleOrNil];
    if (self) {
        // Custom initialization
    }
    return self;
}

- (void)viewDidLoad
{
    [super viewDidLoad];
    // Do any additional setup after loading the view from its nib.
}

- (void)didReceiveMemoryWarning
{
    [super didReceiveMemoryWarning];
    // Dispose of any resources that can be recreated.
}

- (IBAction)DidSearch:(id)sender
{
    NSArray* paths = NSSearchPathForDirectoriesInDomains( NSDocumentDirectory ,  NSUserDomainMask ,  YES );
    NSString* documentPath = [ paths objectAtIndex: 0 ];

    NSString* dbPath = [ documentPath stringByAppendingPathComponent: @"TCFexam.db" ];

    FMDatabase* database = [ FMDatabase databaseWithPath: dbPath ];
    if ( ![ database open ] )
    {
        return;
    }
    
    // 查找表 AllTheQustions
    FMResultSet* resultSet = [ database executeQuery: @"select * from AllTheQustions" ];

    // 逐行读取数据
    while ( [ resultSet next ] )
    {
        // 对应字段来取数据
        NSString* history = [ resultSet stringForColumn: @"History" ];
        NSString* question = [ resultSet stringForColumn: @"Question" ];
        NSLog( @"history: %@ , question: %@" , history , question );
    }
    
    [ database close ];
    
    
}
@end

第四步：输出效果如下：