第一步:在新建项目中把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
第四步:输出效果如下: