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

第四步：輸出效果如下：