FMDB数据库的第三方应用

哦吼吼，又研究了几天，把FMDB这个封装好的数据库搞定了，写了个简单的例子，基于FMDB的添删改查操作，界面很一般了，代码可能比较乱，希望不要伤了各位的眼睛。依旧是纯代码实现的，没有用到任何IB，其中添加删除更改的操作都非常简单，不需要做太多操作，只需要用到FMDB封装好的executeUpdate方法就行了。搜索功能用到了UISearchDisplayController这个控件，因为以前没有用过，研究了一天才搞定。下面对界面做简单的说明：


　　整个界面使用一个UITabBarController实现的，一共有三个TabBarItem，第一个是通讯录，我重写了cell，在每一行可以显示姓名，电话和ID。我要说明一下ID，ID最好每个人的都不要写成一样的，如果两个人的姓名一样，ID也一样的话，在删除一个人的时候会把两个人的信息都删掉。右上角是更新button，先选择某一项，再点那个button就可以进入更新界面。下面来看更新界面：


进入更新界面，可以更新姓名和电话，ID是不可更改的，为什么呢，因为在操作数据库的时候必须要有一个主键（PRIMARY KEY），作为区分每条数据的标识。注意右上角是save。下面来看添加信息的页面，也就是第二个TabBarItem：


可以添加姓名，电话和ID，注意ID不要和其他的相同！再来看第三个TabBarItem，搜索功能，这是我新学的一个知识，用UISearchDisplayController和UISearchBar来实现的搜索，因为用这两个可以达到最好的图像效果


搜索出来的数据点击某一行可以进入详情：


这个页面就简单了，没什么可说的了，一目了然。

下面为大家呈上代码，首先要在AppDelegate.m文件里做修改，要放入一个UITabBar

- (BOOL)application:(UIApplication *)application didFinishLaunchingWithOptions:(NSDictionary *)launchOptions{   

 self.window = [[[UIWindow alloc] initWithFrame:[[UIScreen mainScreen] bounds]] autorelease];    

// Override point for customization after application launch.    self.viewController = [[[ViewController alloc] initWithNibName:@"ViewController" bundle:nil] autorelease];    

//因为有三个tabBarItem，我把系统默认的viewController放在了第一个，然后再新建两个继承自UIViewController的类AddUserInfo和SearchInfo    UINavigationController *viewController = [[UINavigationController alloc]initWithRootViewController:self.viewController];    viewController.tabBarItem = [[UITabBarItem alloc]initWithTabBarSystemItem:UITabBarSystemItemContacts tag:101];    //将viewController初始化为第一个tabBarItem    AddUserInfo *adduserViewController = [[AddUserInfo alloc]init];    adduserViewController.title = @"添加用户信息";    adduserViewController.tabBarItem = [[UITabBarItem alloc]initWithTabBarSystemItem:UITabBarSystemItemTopRated tag:102];//将adduserViewController初始化为第二个tabBarItem    SearchInfo *searchViewController = [[SearchInfo alloc]init];    searchViewController.tabBarItem = [[UITabBarItem alloc]initWithTabBarSystemItem:UITabBarSystemItemSearch tag:103];    searchViewController.title = @"搜索信息";    //将searchViewController初始化为第三个tabBarItem，现在已经准备了UITabBarController上的三个tabBarItem了，但是每一个tabBarItem都需要放到UINavigationController上来控制视图，在初始化两个UINavigationController，还有一个在上面。    UINavigationController *nav1= [[UINavigationController alloc]initWithRootViewController:adduserViewController];        UINavigationController *nav2 = [[UINavigationController alloc]initWithRootViewController:searchViewController];        NSArray *ViewControllerArray = [[NSArray alloc]initWithObjects:viewController,nav1,nav2, nil];//    将三个UINavigationController添加到一个数组里，tabBarItem已经搞定了，但是主要的UITabBarController我们现在来初始化。    UITabBarController *tabBarController = [[UITabBarController alloc]init];//注意这里的用法，tabBarController.viewControllers是tabBarController的一个数组类型的属性，它存放的是UINavigationController    tabBarController.viewControllers = ViewControllerArray;    tabBarController.selectedIndex = 0;//初始显示第一个tabBarItem    tabBarController.delegate = self;//别忘了设置代理，在头文件里要加上这两个        self.window.rootViewController = tabBarController;    [self.window makeKeyAndVisible];        [nav1 release];    [nav2 release];    [tabBarController release];    [ViewControllerArray release];    [searchViewController release];    [adduserViewController release];    [viewController release];    return YES;}复制代码接下来去下载FMDB工程项目https://github.com/ccgus/fmdb.git下载下来的是一个demo，大家可以把src文件夹拖出来再改名为FMDB，拖进自己的项目及就行了在项目里添加libsqlite3.dylib，SenTestingKit.framework两个库，还有头文件#import "FMDatabase.h"和#import "FMDatabaseQueue.h"来看看通讯录页面ViewController.h复制代码#import#import "FMDatabase.h"#import "FMDatabaseQueue.h"@class dataFromDataBase;@interface ViewController : UIViewController{    }@property (nonatomic, retain) NSString * dbPath;@property (nonatomic, retain) NSMutableArray *nameArray;@property (nonatomic, retain) NSMutableArray *phoneArray;@property (nonatomic, retain) NSMutableArray *IDArray;@property (nonatomic, retain) UITableView *table;- (void)createTable;@end@interface dataFromDataBase : NSObject {//新建一个类，专门用于保存数据@private    NSString *nameFromClass;    NSString *phoneFromClass;    NSString *IDFromClass;    NSMutableArray *nameArrayFromClass;}+(dataFromDataBase*)shareFromDataBase;//神奇的单例@property(retain,nonatomic) NSString *nameFromClass;@property(retain,nonatomic)NSString *phoneFromClass;@property(retain,nonatomic)NSString *IDFromClass;@property(retain,nonatomic)NSMutableArray *nameArrayFromClass;@end复制代码ViewController.m复制代码////  ViewController.m//  tabbartest////  Created by changjian on 12-12-8.//  Copyright (c) 2012年 __MyCompanyName__. All rights reserved.//#import "ViewController.h"#import "AddUserInfo.h"@implementation ViewController@synthesize dbPath;@synthesize nameArray,phoneArray,IDArray;@synthesize table;- (void)didReceiveMemoryWarning{    [super didReceiveMemoryWarning];    // Release any cached data, images, etc that aren't in use.}#pragma mark - View lifecycle- (void)viewDidLoad{    [super viewDidLoad];    self.title = @"通讯录";    UITableView *tableView = [[UITableView alloc]initWithFrame:CGRectMake(0, 0, 320, 369) style:UITableViewStylePlain];    tableView.delegate = self;    tableView.dataSource = self;    self.table = tableView;    [self.view addSubview:tableView];        UIBarButtonItem *refreshBtn = [[UIBarButtonItem  alloc]initWithBarButtonSystemItem:UIBarButtonSystemItemRefresh target:self action:@selector(modifyDatabase)];    self.navigationItem.rightBarButtonItem = refreshBtn;    [refreshBtn release];        }#pragma mark -tableview-- (UITableViewCell*)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath{//    NSString *CustomIdentifier =  [NSString stringWithFormat:@"cell%d",indexPath.row];        static NSString *CustomIdentifier = @"cell";//    UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:CustomIdentifier];    UITableViewCell *cell = nil;    if (cell == nil) {        cell = [[UITableViewCell alloc]initWithStyle:UITableViewCellStyleDefault reuseIdentifier:CustomIdentifier];    }//    while ([cell.contentView.subviews lastObject] != nil){        [(UIView*)[cell.contentView.subviews lastObject]removeFromSuperview];//当再次刷新的时候会自动添加新的cell，出现叠加情况，用这种方法可以去掉上一次添加的cell.contentView.subviews    if (indexPath.row == 0)//这里注意，因为第一行不显示数据，所以做个判断        cell.selectionStyle = UITableViewCellSelectionStyleNone;    if (indexPath.row > 0) {//从第二行开始显示数据//        cell.textLabel.text = [dataArray objectAtIndex:(indexPath.row - 1)];//注意这里是从indexPath.row - 1行开始        UILabel *nameLabel = [[UILabel alloc]initWithFrame:CGRectMake(0+40, 10, 70, 30)];        UILabel *phoneLabel = [[UILabel alloc]initWithFrame:CGRectMake(90+40, 10, 70, 30)];        UILabel *IDLabel = [[UILabel alloc]initWithFrame:CGRectMake(180+40, 10, 70, 30)];        nameLabel.text = [self.nameArray objectAtIndex:(indexPath.row-1)];        IDLabel.text = [self.IDArray objectAtIndex:(indexPath.row-1)];        phoneLabel.text = [self.phoneArray objectAtIndex:(indexPath.row-1)];        [cell.contentView addSubview:nameLabel];        [cell.contentView addSubview:IDLabel];        [cell.contentView addSubview:phoneLabel];        [nameLabel release];        [IDLabel release];        [phoneLabel release];    }    else    {        for (int i = 0; i < 3; i ++) {            UILabel *label = [[UILabel alloc]initWithFrame:CGRectMake(90 * i + 40, 10, 70 , 30)];            NSArray *array = [NSArray arrayWithObjects:@"姓名",@"电话",@"ID", nil];            label.text = [array objectAtIndex:i];            label.backgroundColor = [UIColor clearColor];            [cell.contentView addSubview:label];            [label release];            label = nil;        }    }//    }    return cell;}- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section{    return [nameArray count] + 1;//注意这里，因为第一行不显示数据，返回要加一行}- (NSIndexPath*)tableView:(UITableView *)tableView willSelectRowAtIndexPath:(NSIndexPath *)indexPath{    if (indexPath.row == 0) {        return nil;//让第一行不能点击    }    else        return indexPath;}- (void)createTable//创建数据库中表的方法，利用封装好的库很简单{    NSFileManager *fileManager = [NSFileManager defaultManager];    if (![fileManager fileExistsAtPath:self.dbPath]) {        NSLog(@"表不存在，创建表");        FMDatabase *db =[FMDatabase databaseWithPath:self.dbPath];        if ([db open]) {            NSString *sql = @"CREATE TABLE 'USER'('id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 'name' VARCHAR(20),'phone' VARCHAR(20),'idcode' VARCHAR(30))    ";//sql语句            BOOL success = [db executeUpdate:sql];            if (!success) {                NSLog(@"error when create table ");            }else{                NSLog(@"create table succeed");            }            [db close];        }else{            NSLog(@"database open error");        }    }}- (void)getAllDatabase//从数据库中获得所有数据{    FMDatabase *db = [FMDatabase databaseWithPath:self.dbPath];    if ([db open]) {        NSString *sql = @"SELECT * FROM USER";        FMResultSet *rs = [db executeQuery:sql];        while ([rs next]) {            NSString *name = [rs stringForColumn:@"name"];            NSString *phone = [rs stringForColumn:@"phone"];            NSString *ID = [rs stringForColumn:@"idcode"];                        [self.nameArray addObject:name];            [self.phoneArray addObject:phone];            [self.IDArray addObject:ID];        }        [[dataFromDataBase shareFromDataBase].nameArrayFromClass arrayByAddingObjectsFromArray:self.nameArray];        NSLog(@"self.nameArray==%@",self.nameArray);        [db close];        [table reloadData];    }    }- (void)modifyDatabase//选中相应的行，进入更新界面，注意这里没有对数据库进行操作{    NSIndexPath *indexPath = [self.table indexPathForSelectedRow];        if (indexPath == nil) {        UIAlertView *alert = [[UIAlertView alloc] initWithTitle:@"提示"                                                        message:@"请选择要更新的项"                                                        delegate:self                                              cancelButtonTitle:@"好"                                              otherButtonTitles:nil];        [alert show];        [alert release];        return;    }    else{        AddUserInfo *modify = [[AddUserInfo alloc]init];        modify.operateType = 1;//下面的方法是将选中的行的数据存进单例，再传到另一个类里面        [dataFromDataBase shareFromDataBase].nameFromClass = [self.nameArray objectAtIndex:(indexPath.row-1)];        [dataFromDataBase shareFromDataBase].IDFromClass = [self.IDArray objectAtIndex:(indexPath.row-1)];        [dataFromDataBase shareFromDataBase].phoneFromClass = [self.phoneArray objectAtIndex:(indexPath.row-1)];        NSLog(@"datafromdatabase.nameFromClass==%@",[dataFromDataBase shareFromDataBase].nameFromClass);        [self.navigationController pushViewController:modify animated:YES];//跳转到修改页面        [modify release];    }}- (void)viewDidUnload{    [super viewDidUnload];    // Release any retained subviews of the main view.    // e.g. self.myOutlet = nil;}- (void)dealloc {    [nameArray release];    [phoneArray release];    [IDArray release];    [super dealloc];}- (void)viewWillAppear:(BOOL)animated{    NSString *document = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)objectAtIndex:0];    NSString *path = [document stringByAppendingPathComponent:@"USER.sqlite"];    self.dbPath = path;//注意以上三句话是获取数据库路径必不可少的，在viewDidload之前就已经准备好了    nameArray = [[NSMutableArray alloc]init];    phoneArray = [[NSMutableArray alloc]init];    IDArray = [[NSMutableArray alloc]init];    [self createTable];    [self getAllDatabase];}- (void)viewDidAppear:(BOOL)animated{    [super viewDidAppear:animated];}- (void)viewWillDisappear:(BOOL)animated{    [super viewWillDisappear:animated];}- (void)viewDidDisappear:(BOOL)animated{    [super viewDidDisappear:animated];}- (BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation{    // Return YES for supported orientations    return (interfaceOrientation != UIInterfaceOrientationPortraitUpsideDown);}@end@implementation dataFromDataBase//这个类专门用来保存数据@synthesize nameFromClass,phoneFromClass,IDFromClass;@synthesize nameArrayFromClass;static dataFromDataBase *sharedInstance = nil;+(dataFromDataBase*)shareFromDataBase//伟大的单例，{    if (sharedInstance == nil) {        sharedInstance = [[dataFromDataBase alloc]init];    }    return sharedInstance;}- (id)init {    self = [super init];    if (self) {        nameFromClass = @"";        phoneFromClass = @"";        IDFromClass = @"";        nameArrayFromClass = [[NSMutableArray alloc]initWithCapacity:0];    }    return self;}- (void)dealloc {    if (nameFromClass!= nil){    [nameFromClass release];        }    if (phoneFromClass!=nil){    [phoneFromClass release];    }    if (IDFromClass != nil){    [IDFromClass release];    }    if (nameArrayFromClass != nil) {        [nameArrayFromClass release];    }    [super dealloc];}@end复制代码下面是AddUserInfo.h文件复制代码#import#import "ViewController.h"@interface AddUserInfo : UIViewController{    int operateType;//保存操作类型，0是添加，1是修改}- (void)createTable;@property (retain,nonatomic)NSMutableArray *textFieldArray;@property (retain,nonatomic)NSString *dbPath;@property (retain,nonatomic)UITextField *nameTextField;@property (retain,nonatomic)UITextField *phoneTextField;@property (retain,nonatomic)UITextField *IDTextField;@property (nonatomic,assign)int operateType;@end复制代码AddUserInfo.m文件复制代码////  AddUserInfo.m//  tabbartest////  Created by changjian on 12-12-8.//  Copyright (c) 2012年 __MyCompanyName__. All rights reserved.//#import "AddUserInfo.h"#import "FMDatabase.h"#import "FMDatabaseQueue.h"#import "UserDetailInfo.h"@implementation AddUserInfo@synthesize textFieldArray;@synthesize dbPath;@synthesize nameTextField;@synthesize phoneTextField;@synthesize IDTextField;@synthesize operateType;- (id)initWithNibName:(NSString *)nibNameOrNil bundle:(NSBundle *)nibBundleOrNil{    self = [super initWithNibName:nibNameOrNil bundle:nibBundleOrNil];    if (self) {        textFieldArray = [[NSMutableArray alloc]init];    }    return self;}- (void)didReceiveMemoryWarning{    // Releases the view if it doesn't have a superview.    [super didReceiveMemoryWarning];        // Release any cached data, images, etc that aren't in use.}#pragma mark - View lifecycle- (void)viewDidLoad{    [super viewDidLoad];    NSString *doc = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) objectAtIndex:0];    NSString *path = [doc stringByAppendingPathComponent:@"user.sqlite"];    NSLog(@"path===%@",path);    self.dbPath = path;        NSArray *array = [NSArray arrayWithObjects:@"姓名",@"电话",@"ID", nil];    for (int i = 0; i < 3 ; i++)    {        UILabel *label = [[UILabel alloc]initWithFrame:CGRectMake( 70,i * 40 + 34, 100, 30)];        label.text = [array objectAtIndex:i];        [self.view addSubview:label];    }        nameTextField = [[UITextField alloc]initWithFrame:CGRectMake(150, 38, 100, 30)];    nameTextField.borderStyle = UITextBorderStyleRoundedRect;    nameTextField.placeholder = @"请输入姓名";    nameTextField.delegate = self;    [self.view addSubview:nameTextField];    phoneTextField = [[UITextField alloc]initWithFrame:CGRectMake(150, 78, 100, 30)];    phoneTextField.borderStyle = UITextBorderStyleRoundedRect;    phoneTextField.placeholder = @"请输入电话";    phoneTextField.delegate = self;    [self.view addSubview:phoneTextField];    IDTextField = [[UITextField alloc]initWithFrame:CGRectMake(150, 118, 100, 30)];    IDTextField.borderStyle = UITextBorderStyleRoundedRect;    IDTextField.placeholder = @"请输入ID";    IDTextField.delegate = self;    [self.view addSubview:IDTextField];    if (operateType == 1) {//operateType == 1时为修改        nameTextField.text = [dataFromDataBase shareFromDataBase].nameFromClass;        IDTextField.text = [dataFromDataBase shareFromDataBase].IDFromClass;        phoneTextField.text = [dataFromDataBase shareFromDataBase].phoneFromClass;        IDTextField.enabled = NO;        NSLog(@"datafromdatabase.nameFromClass=%@",[dataFromDataBase shareFromDataBase].nameFromClass);    }    NSLog(@"operateType==%d",operateType);    if (operateType == 0){    UIBarButtonItem *addBtn = [[UIBarButtonItem alloc]initWithBarButtonSystemItem:UIBarButtonSystemItemAdd target:self action:@selector(addNewUserInfo)];        self.navigationItem.rightBarButtonItem = addBtn;    }    if(operateType == 1){//这里是后来添加的，其实可以放到上面        UIBarButtonItem *addBtn = [[UIBarButtonItem alloc]initWithBarButtonSystemItem:UIBarButtonSystemItemSave target:self action:@selector(addNewUserInfo)];        self.navigationItem.rightBarButtonItem = addBtn;    }        // Do any additional setup after loading the view from its nib.}- (void)addNewUserInfo//添加用户信息的方法，用FMDB封装好的方法{    FMDatabase *db = [[FMDatabase alloc]initWithPath:self.dbPath];    NSString *mes = nil;    if ([db open]) {            if (nameTextField.text.length == 0||phoneTextField.text.length == 0||IDTextField.text.length == 0){                mes = @"请完成填写信息";            }else{                NSLog(@"姓名==%@,电话==%@,ID==%@",nameTextField.text,phoneTextField.text,IDTextField.text);                NSString *sql= nil;                if (operateType == 0){//执行插入操作                    sql = @"INSERT INTO USER (name,phone,idcode) VALUES (?,?,?) ";                }else if(operateType == 1)//执行更新操作                {                    sql = @"UPDATE USER  SET name = ? , phone = ? where idcode = ?";                                        NSLog(@"有没有执行？");                }                BOOL res = [db executeUpdate:sql,nameTextField.text,phoneTextField.text,IDTextField.text];                if (!res) {                    NSLog(@"error to insert data");                    mes = @"数据插入错误";                }else{                    NSLog(@"insert succeed");                    mes = @"数据插入成功";                }            }        }else{            NSLog(@"数据库打开失败") ;    }    UIAlertView *alert = [[UIAlertView alloc]initWithTitle:@"提示" message:mes delegate:nil cancelButtonTitle:@"确定" otherButtonTitles:nil, nil];    [alert setTag:101];    alert.delegate = self;    [alert show];    [alert release];    [db close];}- (void)alertView:(UIAlertView *)alertView clickedButtonAtIndex:(NSInteger)buttonIndex{    if (alertView.tag == 101 && buttonIndex == 0) {        if (operateType == 0)//如果是添加就留在该页，如果是修改就跳回上一页        {        [nameTextField resignFirstResponder];        [phoneTextField resignFirstResponder];        [IDTextField resignFirstResponder];        nameTextField.text = @"";        phoneTextField.text = @"";        IDTextField.text = @"";        }else{            [self.navigationController popViewControllerAnimated:YES];        }    }}- (void)touchesBegan:(NSSet *)touches withEvent:(UIEvent *)event{    [nameTextField resignFirstResponder];    [phoneTextField resignFirstResponder];    [IDTextField resignFirstResponder];}//让键盘隐藏- (void)viewWillAppear:(BOOL)animated{    [super viewWillAppear:YES];}- (void)viewDidUnload{    [super viewDidUnload];    // Release any retained subviews of the main view.    // e.g. self.myOutlet = nil;}- (void)dealloc {    [nameTextField release];    [phoneTextField release];    [IDTextField release];    [textFieldArray release];    [super dealloc];}-(void)viewWillDisappear:(BOOL)animated//页面将要消失的时候执行，将UITextField清空{    [super viewWillDisappear:YES];    nameTextField.text = nil;    phoneTextField.text = nil;    IDTextField.text = nil;}- (BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation{    // Return YES for supported orientations    return (interfaceOrientation == UIInterfaceOrientationPortrait);}@end复制代码下面是SearchInfo.h文件,一定要注意这个类是继承UITableViewController，不是UIViewController！！！复制代码////  SearchInfo.h//  tabbartest////  Created by changjian on 12-12-8.//  Copyright (c) 2012年 __MyCompanyName__. All rights reserved.//#import@interface SearchInfo : UITableViewController{    UISearchDisplayController *searchController;    NSString *namestr;    NSString *phonestr;    NSString *IDstr;}@property (retain,nonatomic)NSString *dbpath;@property (retain,nonatomic)NSMutableArray *searchResults;//用于保存搜索出姓名的结果@property (retain,nonatomic)NSMutableArray *searchPhoneResults;//用来保存搜索的电话信息@property (retain,nonatomic)NSMutableArray *searchIDResult;//用来保存搜索的ID信息@property (retain,nonatomic)NSMutableArray *nameArray;//保存搜索之前的姓名信息@property (retain,nonatomic)NSMutableArray *phoneArray;//保存搜索之前的电话信息@property (retain,nonatomic)NSMutableArray *IDArray;//保存搜索之前的ID信息@property (nonatomic,assign)BOOL searchWasActive;@property (nonatomic,assign)NSString *savedSearchTerm;//这个好像没用了@property (nonatomic,retain)NSString *namestr;@property (nonatomic,retain)NSString*phonestr;@property (nonatomic,retain)NSString*IDstr;- (void)getAllDatabase;@end复制代码SearchInfo.m文件复制代码////  SearchInfo.m//  tabbartest////  Created by changjian on 12-12-8.//  Copyright (c) 2012年 __MyCompanyName__. All rights reserved.//#import "SearchInfo.h"#import "FMDatabase.h"#import "ViewController.h"#import "UserDetailInfo.h"@implementation SearchInfo@synthesize dbpath;@synthesize searchResults,searchPhoneResults,searchIDResult;@synthesize nameArray,phoneArray,IDArray;@synthesize searchWasActive;@synthesize savedSearchTerm;@synthesize namestr,phonestr,IDstr;- (id)initWithNibName:(NSString *)nibNameOrNil bundle:(NSBundle *)nibBundleOrNil{    self = [super initWithNibName:nibNameOrNil bundle:nibBundleOrNil];    if (self) {        // Custom initialization    }    return self;}- (void)didReceiveMemoryWarning{    // Releases the view if it doesn't have a superview.    [super didReceiveMemoryWarning];        // Release any cached data, images, etc that aren't in use.}#pragma mark - View lifecycle- (void)viewDidLoad{    [super viewDidLoad];//搜索比较复杂，既要初始化UISearchBar，又要初始化UISearchDisplayController，然后还要写UITableViewDelegate里的-(UITableViewCell*)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath和-(NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section方法，还要设置一大堆代理，慢慢往下看    UISearchBar *search = [[[UISearchBar alloc]initWithFrame:CGRectMake(0, 0, self.view.bounds.size.width -50, 44)]autorelease];    search.placeholder = @"请输入姓名";    search.autocorrectionType = UITextAutocorrectionTypeNo;//不自动纠错，貌似没啥用    search.autocapitalizationType = UITextAutocapitalizationTypeAllCharacters;//所有字母大写 ，也没啥用        search.showsScopeBar = YES;    search.delegate = self;//UISearchBar设置代理    search.keyboardType = UIKeyboardTypeNamePhonePad;    self.tableView.tableHeaderView = search;    self.tableView.dataSource = self;    searchController = [[UISearchDisplayController alloc]initWithSearchBar:search contentsController:self];    searchController.active = NO;        searchController.delegate = self;//UISearchDisplayController设置代理        searchController.searchResultsDelegate=self;//还是代理        searchController.searchResultsDataSource = self;//有完没完    [search release];    NSString *document = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)objectAtIndex:0];    NSString *path = [document stringByAppendingPathComponent:@"user.sqlite"];    NSLog(@"path==%@",path);    self.dbpath = path;    self.tableView.delegate = self;//tableView的代理，为什么这么写，因为这个类是继承UITableView的，要注意！不是继承UIViewController的！    self.tableView.dataSource = self;    nameArray = [[NSMutableArray alloc]initWithCapacity:0];    phoneArray = [[NSMutableArray alloc]initWithCapacity:0];    IDArray= [[NSMutableArray alloc]initWithCapacity:0];        [self getAllDatabase];    [self.tableView reloadData];    // Do any additional setup after loading the view from its nib.}- (void)viewWillAppear:(BOOL)animated{    self.searchWasActive = [self.searchDisplayController isActive];    if (self.searchDisplayController.searchBar != 0)    {        self.searchDisplayController.searchBar.text = nil;        [self.searchDisplayController.searchBar resignFirstResponder];        [self.searchDisplayController setActive:NO];//在进入搜索页面之前将其设置为不活动，大家可以试试改成活动看看是什么样    }}- (void)getAllDatabase//要重新获取数据库信息，因为执行完删除之后数据库变了{    FMDatabase *db = [FMDatabase databaseWithPath:self.dbpath];    if ([db open]) {        NSString *sql = @"SELECT * FROM USER";        FMResultSet *rs = [db executeQuery:sql];        while ([rs next]) {            NSString *name = [rs stringForColumn:@"name"];            NSString *phone = [rs stringForColumn:@"phone"];            NSString *ID = [rs stringForColumn:@"idcode"];                        [self.nameArray addObject:name];            [self.phoneArray addObject:phone];            [self.IDArray addObject:ID];        }        self.searchResults = [[NSMutableArray alloc]initWithArray:nameArray copyItems:YES];        self.searchPhoneResults = [[NSMutableArray alloc]initWithArray:phoneArray copyItems:YES];        self.searchIDResult = [[NSMutableArray alloc]initWithArray:IDArray copyItems:YES];        NSLog(@"search from nameArray==%@",self.nameArray);        [db close];    }}#pragma mark -tableview--(UITableViewCell*)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath{//    self.tableView = tableView;    static NSString *cellIdentifier = @"cell";    UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:cellIdentifier];    if (cell == nil) {        cell = [[UITableViewCell alloc]initWithStyle:UITableViewCellStyleDefault reuseIdentifier:cellIdentifier];    }    cell.accessoryType = UITableViewCellAccessoryDisclosureIndicator;    if ([tableView isEqual:self.searchDisplayController.searchResultsTableView]) {        cell.textLabel.text = [searchResults objectAtIndex:indexPath.row];//        cell.detailTextLabel.text = [NSString stringWithFormat:@"电话：%@",[searchResults objectAtIndex:indexPath.row]];//不知道为什么不显示cell.detailTextLabel.text ，有人知道的话告诉我一下    }else{        cell.textLabel.text = [self.nameArray objectAtIndex:indexPath.row];    }    return cell;}-(NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section{    NSInteger row = 0;    if ([tableView isEqual:self.searchDisplayController.searchResultsTableView]) {//记住这个格式，如果当前的table就是用于显示所搜信息的table的话。因为UISearchDisplayController这货自带一个table        row = [self.searchResults count];    }else{        [self.nameArray count];    }    return row;}- (void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath{    UserDetailInfo *detailInfo = [[UserDetailInfo alloc]init];    detailInfo.nameStr = [self.searchResults objectAtIndex:indexPath.row];    detailInfo.phoneStr = [self.searchPhoneResults objectAtIndex:indexPath.row];    detailInfo.IDsStr = [self.searchIDResult objectAtIndex:indexPath.row];    NSLog(@"self.namestr==%@",self.namestr);    NSArray *array = [self.navigationController viewControllers];//先获取视图控制器数组    UINavigationController *nav = [array objectAtIndex:[array count] - 1];//获取当前的导航试图控制器    [nav.navigationController pushViewController:detailInfo animated:YES];//跳转到删除页面    [detailInfo release];}#pragma mark -UISearchControllerDisplay-//设置搜索范围//下面注意了，下面的方法是实现搜索功能的，后面两个长得很像的方法是UISearchControllerDisplay代理里的方法，我也搞不懂是干什么用的，他们的格式很固定，大家记住就行了。- (void)filterContentForSearchText:(NSString*)searchText scope:(NSString*)scope{    [self searchBarSearchButtonClicked:self.searchDisplayController.searchBar];    }- (void)searchBarSearchButtonClicked:(UISearchBar *)searchBar//从数据库搜索{    FMDatabase *db = [FMDatabase databaseWithPath:self.dbpath];    if ([db open]) {        [searchResults removeAllObjects];        [searchPhoneResults removeAllObjects];        [searchIDResult removeAllObjects];        NSString *sql = @"SELECT * FROM USER WHERE name like ?";        FMResultSet *rs = [db executeQuery:sql,searchBar.text];        while ([rs next]) {            self.namestr = [rs stringForColumn:@"name"];            self.phonestr = [rs stringForColumn:@"phone"];            self.IDstr = [rs stringForColumn:@"idcode"];            [self.searchResults addObject:namestr];            [self.searchPhoneResults addObject:phonestr];            [self.searchIDResult addObject:IDstr];        }        NSLog(@"searchResults == %@",searchResults);        NSLog(@"searchPhoneResults==%@",searchPhoneResults);        NSLog(@"searchIDResult==%@",searchIDResult);        NSLog(@"search===%@",searchBar.text);    }    [db close];}#pragma mark -#pragma mark UISearchDisplayController Delegate Methods设置代理方法- (BOOL)searchDisplayController:(UISearchDisplayController *)controller shouldReloadTableForSearchString:(NSString *)searchString{    [self filterContentForSearchText:searchString scope:    [[self.searchDisplayController.searchBar scopeButtonTitles] objectAtIndex:[self.searchDisplayController.searchBar selectedScopeButtonIndex]]];        // Return YES to cause the search result table view to be reloaded.    return YES;}- (BOOL)searchDisplayController:(UISearchDisplayController *)controller shouldReloadTableForSearchScope:(NSInteger)searchOption{    [self filterContentForSearchText:[self.searchDisplayController.searchBar text] scope:    [[self.searchDisplayController.searchBar scopeButtonTitles] objectAtIndex:searchOption]];        // Return YES to cause the search result table view to be reloaded.    return YES;}- (void)viewDidUnload{    [super viewDidUnload];    // Release any retained subviews of the main view.    // e.g. self.myOutlet = nil;}- (BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation{    // Return YES for supported orientations    return (interfaceOrientation == UIInterfaceOrientationPortrait);}- (void)dealloc {    [nameArray release];    [phoneArray release];    [IDArray release];    [searchController release];    [searchResults release];    [searchPhoneResults release];    [searchIDResult release];    [super dealloc];}@end复制代码最难的部分完了，接下来就简单多了！最后是删除信息界面UserDetailInfo.h复制代码@interface UserDetailInfo : UIViewController{

}

@property(retain,nonatomic)NSString *dbpath;

@property(retain,nonatomic)NSString *nameStr;

@property(retain,nonatomic)NSString *phoneStr;

@property(retain,nonatomic)NSString *IDsStr;

@end

复制代码

UserDetailInfo.m

复制代码

//

//  UserDetailInfo.m

//  tabbartest

//

//  Created by changjian on 12-12-10.

//  Copyright (c) 2012年 __MyCompanyName__. All rights reserved.

//

#import "UserDetailInfo.h"

#import "FMDatabase.h"

@implementation UserDetailInfo

@synthesize dbpath;

@synthesize nameStr,phoneStr,IDsStr;

- (id)initWithNibName:(NSString *)nibNameOrNil bundle:(NSBundle *)nibBundleOrNil

{

self = [super initWithNibName:nibNameOrNil bundle:nibBundleOrNil];

if (self) {

// Custom initialization

}

return self;

}

- (void)didReceiveMemoryWarning

{

// Releases the view if it doesn't have a superview.

[super didReceiveMemoryWarning];

// Release any cached data, images, etc that aren't in use.

}

#pragma mark - View lifecycle

- (void)viewDidLoad

{

[super viewDidLoad];

self.title = @"详细信息";

NSArray *array = [NSArray arrayWithObjects:@"姓名:",@"电话:",@"ID:", nil];

NSArray *array2 = [NSArray arrayWithObjects:self.nameStr,self.phoneStr,self.IDsStr, nil];

for (int i = 0; i < 3 ; i++)

{

UILabel *label = [[UILabel alloc]initWithFrame:CGRectMake( 70,i * 40 + 34, 100, 30)];

label.text = [array objectAtIndex:i];

[self.view addSubview:label];

UILabel *label2 = [[UILabel alloc]initWithFrame:CGRectMake(140, i * 40 +35, 100, 30)];

label2.text = [array2 objectAtIndex:i];

[self.view addSubview:label2];

[label release];

[label2 release];

}

NSString *document = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)objectAtIndex:0];

NSString *path = [document stringByAppendingPathComponent:@"USER.sqlite"];

self.dbpath = path;

UIBarButtonItem *deleteButton = [[UIBarButtonItem alloc]initWithTitle:@"删除" style:UIBarButtonItemStyleDone target:self action:@selector(deleteFromDatabase)];

self.navigationItem.rightBarButtonItem = deleteButton;

}

- (void)deleteFromDatabase//从数据库删除信息

{

FMDatabase *db = [FMDatabase databaseWithPath:self.dbpath];

NSString *mes = nil;

if ([db open]) {

NSString *sql = @"DELETE FROM USER WHERE name = ? and phone = ? and idcode = ?";

if (self.nameStr.length != 0&&self.phoneStr.length != 0&&self.IDsStr.length !=0){

BOOL rs = [db executeUpdate:sql,self.nameStr,self.phoneStr,self.IDsStr]; //后面跟的三个参数就是sql语句里的三个问号对应

if (rs) {

mes = @"删除成功";

}else{

mes = @"删除失败";

}

}

}

UIAlertView *alert = [[UIAlertView alloc]initWithTitle:@"提示" message:mes delegate:nil cancelButtonTitle:@"确定" otherButtonTitles:nil, nil];

alert.delegate = self;//别忘了代理

[alert show];

[alert release];

[db close];

}

- (void)alertView:(UIAlertView *)alertView clickedButtonAtIndex:(NSInteger)buttonIndex

{

if ( buttonIndex == 0) {

[self.navigationController popViewControllerAnimated:YES];

NSLog(@"点击了删除成功");

}

}

- (void)viewWillDisappear:(BOOL)animated

{

[super viewWillDisappear:YES];

}

- (void)viewDidUnload

{

[super viewDidUnload];

// Release any retained subviews of the main view.

// e.g. self.myOutlet = nil;

}

- (BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation

{

// Return YES for supported orientations

return (interfaceOrientation == UIInterfaceOrientationPortrait);

}

@end

最后编辑于 ：
©著作权归作者所有,转载或内容合作请联系作者
  • 人面猴
    序言：七十年代末，一起剥皮案震惊了整个滨河市，随后出现的几起案子，更是在滨河造成了极大的恐慌，老刑警刘岩，带你破解...
    沈念sama阅读 203,362评论 5赞 477
  • 死咒
    序言：滨河连续发生了三起死亡事件，死亡现场离奇诡异，居然都是意外死亡，警方通过查阅死者的电脑和手机，发现死者居然都...
    沈念sama阅读 85,330评论 2赞 381
  • 救了他两次的神仙让他今天三更去死
    文/潘晓璐 我一进店门，熙熙楼的掌柜王于贵愁眉苦脸地迎上来，“玉大人，你说我怎么就摊上这事。” “怎么了？”我有些...
    开封第一讲书人阅读 150,247评论 0赞 337
  • 道士缉凶录：失踪的卖姜人
    文/不坏的土叔 我叫张陵，是天一观的道长。 经常有香客问我，道长，这世上最难降的妖魔是什么？ 我笑而不...
    开封第一讲书人阅读 54,560评论 1赞 273
  • 港岛之恋（遗憾婚礼）
    正文 为了忘掉前任，我火速办了婚礼，结果婚礼上，老公的妹妹穿的比我还像新娘。我一直安慰自己，他们只是感情好，可当我...
    茶点故事阅读 63,580评论 5赞 365
  • 恶毒庶女顶嫁案：这布局不是一般人想出来的
    文/花漫 我一把揭开白布。 她就那样静静地躺着，像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上，一...
    开封第一讲书人阅读 48,569评论 1赞 281
  • 城市分裂传说
    那天，我揣着相机与录音，去河边找鬼。 笑死，一个胖子当着我的面吹牛，可吹牛的内容都是我干的。 我是一名探鬼主播，决...
    沈念sama阅读 37,929评论 3赞 395
  • 双鸳鸯连环套：你想象不到人心有多黑
    文/苍兰香墨 我猛地睁开眼，长吁一口气：“原来是场噩梦啊……” “哼！你这毒妇竟也来了？” 一声冷哼从身侧响起，我...
    开封第一讲书人阅读 36,587评论 0赞 258
  • 万荣杀人案实录
    序言：老挝万荣一对情侣失踪，失踪者是张志新（化名）和其女友刘颖，没想到半个月后，有当地人在树林里发现了一具尸体，经...
    沈念sama阅读 40,840评论 1赞 297
  • 护林员之死
    正文 独居荒郊野岭守林人离奇死亡，尸身上长有42处带血的脓包…… 初始之章·张勋 以下内容为张勋视角 年9月15日...
    茶点故事阅读 35,596评论 2赞 321
  • 白月光启示录
    正文 我和宋清朗相恋三年，在试婚纱的时候发现自己被绿了。 大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
    茶点故事阅读 37,678评论 1赞 329
  • 活死人
    序言：一个原本活蹦乱跳的男人离奇死亡，死状恐怖，灵堂内的尸体忽然破棺而出，到底是诈尸还是另有隐情，我是刑警宁泽，带...
    沈念sama阅读 33,366评论 4赞 318
  • 日本核电站爆炸内幕
    正文 年R本政府宣布，位于F岛的核电站，受9级特大地震影响，放射性物质发生泄漏。R本人自食恶果不足惜，却给世界环境...
    茶点故事阅读 38,945评论 3赞 307
  • 男人毒药：我在死后第九天来索命
    文/蒙蒙 一、第九天 我趴在偏房一处隐蔽的房顶上张望。 院中可真热闹，春花似锦、人声如沸。这庄子的主人今日做“春日...
    开封第一讲书人阅读 29,929评论 0赞 19
  • 一桩弑父案，背后竟有这般阴谋
    文/苍兰香墨 我抬头看了看天上的太阳。三九已至，却和暖如春，着一层夹袄步出监牢的瞬间，已是汗流浃背。 一阵脚步声响...
    开封第一讲书人阅读 31,165评论 1赞 259
  • 情欲美人皮
    我被黑心中介骗来泰国打工， 没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留，地道东北人。 一个月前我还...
    沈念sama阅读 43,271评论 2赞 349
  • 代替公主和亲
    正文 我出身青楼，却偏偏与公主长得像，于是被迫代替她去往敌国和亲。 传闻我的和亲对象是个残疾皇子，可洞房花烛夜当晚...
    茶点故事阅读 42,403评论 2赞 342

推荐阅读更多精彩内容

  • FMDB
    作者唯一QQ：228544117。。。。。 =========后面的都要新建一个文章 AppDelegate.h ...
    CC_iOS阅读 805评论 0赞 0
  • 操作数据库
    #import<Foundation/Foundation.h> #import #import "sqlTest...
    lichengjin阅读 402评论 0赞 0
  • iOS开发系列--UITableView全面解析
    概述在iOS开发中UITableView可以说是使用最广泛的控件，我们平时使用的软件中到处都可以看到它的影子，类似...
    liudhkk阅读 8,978评论 3赞 38
  • 面试题
    1.OC里用到集合类是什么？ 基本类型为：NSArray，NSSet以及NSDictionary 可变类型为：NS...
    轻皱眉头浅忧思阅读 1,359评论 0赞 3
  • 清晨
    因为周一，要上班，起了个大早，顶着一双红肿的眼睛，慢条斯理的收拾着，准备开始新的一周。 恩，春天似乎来了，行人都褪...
    迷人的hero阅读 176评论 0赞 0