IOS开源项目--通讯录（附源代码）

前面介绍过FMDB以及SQLITE的基本操作具体参考前面的微博
FMDB:
http://blog.csdn.net/lee727n/article/details/71176162
SQLite：
http://blog.csdn.net/lee727n/article/details/71171120
下面我们通过FMDB来实现一个日常生活经常用到的的通讯录，代码结构如下，首先需要有一个tableview用来展示信息，还需要一个viewController来布局新建联系人的界面。需要一个person类，用于存放每个人的信息，还需要一个DBMnager类，用于存放FMDB所用的建表，增删改查等方法：

1.模型类person的实现

@interface Person : NSObject
@property (nonatomic)int pid;
@property (nonatomic, copy)NSString *name;
@property (nonatomic, copy)NSString *code;
@end

2.DBMnager类的实现
需要FMDatabase类的属性，需要4个方法增删改查。特别注意初始化数据库，以及创建表需要放在单例中实现。这样做的好处，1，生命周期覆盖整个app的生存时间 2，多页面使用数据库时无需传值，直接使用同一份数据。

@property (nonatomic, strong)FMDatabase *db;
+ (DBManager *)shareManager;

- (void)insertPerson:(Person *)person;

- (void)deletePerson:(Person *)person;

- (void)updatePerson:(Person *)person;

- (NSMutableArray *)queryPersons;

单例方法，初始化数据库以及建表

static DBManager *_manager;
@implementation DBManager
+(DBManager *)shareManager{

    if (!_manager) {
        _manager = [DBManager new];
        NSString *path = [NSHomeDirectory() stringByAppendingPathComponent:@"Documents/persons.db"];
        _manager.db = [FMDatabase databaseWithPath:path];

        if ([_manager.db open]) {
            NSLog(@"打开数据库文件成功");

        //注意主键的使用    
            if ([_manager.db executeUpdate:@"create table if not exists persons (name text,code text, pid integer primary key autoincrement)"]) {
                NSLog(@"创建表成功！");
            }else NSLog(@"创建表失败");


        }

    }

    return _manager;
}

实现增删改查方法

-(void)insertPerson:(Person *)person{
    //插入指定字段，第三个字段pid是主键，自动+1
    NSString *sql = [NSString stringWithFormat:@"insert into persons (name, code) values ('%@','%@')",person.name,person.code];
    if ([self.db executeUpdate:sql]) {
        NSLog(@"插入数据成功！");
    }else NSLog(@"插入数据失败");

}
-(void)deletePerson:(Person *)person{

    NSString *sql = [NSString stringWithFormat:@"delete from persons where pid=%d",person.pid];
    if ([self.db executeUpdate:sql]) {
        NSLog(@"删除数据成功！");
    }else NSLog(@"删除数据失败！");

}
-(void)updatePerson:(Person *)person{

    NSString *sql = [NSString stringWithFormat:@"update persons set name='%@', code='%@' where pid=%d",person.name,person.code,person.pid];


    if ([self.db executeUpdate:sql]) {
        NSLog(@"修改数据成功！");
    }else NSLog(@"修改数据失败！");

}

-(NSMutableArray *)queryPersons{

    NSMutableArray *persons = [NSMutableArray array];

    FMResultSet *result = [self.db executeQuery:@"select * from persons"];
    while ([result next]) {
        Person *p = [Person new];

        p.name = [result stringForColumn:@"name"];
        p.code = [result stringForColumn:@"code"];
        p.pid = [result intForColumn:@"pid"];

        [persons addObject:p];
    }

    return  persons;

}

新建联系人页面的实现：

- (void)viewDidLoad {
    [super viewDidLoad];
    self.title = @"新建联系人";
    self.navigationItem.rightBarButtonItem = [[UIBarButtonItem alloc]initWithBarButtonSystemItem:UIBarButtonSystemItemSave target:self action:@selector(saveAction)];


    if (self.person) {//修改
        self.nameTF.text = self.person.name;
        self.codeTF.text = self.person.code;
    }

}

保存方法对应的内容

- (void)saveAction {

      if (self.person) {//修改
        self.person.name = self.nameTF.text;
        self.person.code = self.codeTF.text;

        [[DBManager shareManager]updatePerson:self.person];

    }else{

        Person *p = [Person new];
        p.name = self.nameTF.text;
        p.code = self.codeTF.text;

        [[DBManager shareManager]insertPerson:p];
    }


    [self.navigationController popViewControllerAnimated:YES];


}

tableview界面的实现

- (void)viewDidLoad {
    [super viewDidLoad];

    self.title = @"通讯录";
    self.navigationItem.rightBarButtonItem = self.editButtonItem;

    self.navigationItem.leftBarButtonItem = [[UIBarButtonItem alloc]initWithBarButtonSystemItem:UIBarButtonSystemItemAdd target:self action:@selector(addAction)];

}

- (void)addAction {  
    PersonViewController *vc = [PersonViewController new];
    [self.navigationController pushViewController:vc animated:YES];

}

-(void)viewWillAppear:(BOOL)animated{
    [super viewWillAppear:animated];
    [self.tableView reloadData];
}

实现tableview代理方法

- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section {


    self.persons = [[DBManager shareManager]queryPersons];

    return self.persons.count;
}


- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath {
    UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:@"cell" forIndexPath:indexPath];

    Person *p = self.persons[indexPath.row];

    cell.textLabel.text = p.name;
    cell.detailTextLabel.text = p.code;


    return cell;
}

实现侧滑删除

- (void)tableView:(UITableView *)tableView commitEditingStyle:(UITableViewCellEditingStyle)editingStyle forRowAtIndexPath:(NSIndexPath *)indexPath {
    if (editingStyle == UITableViewCellEditingStyleDelete) { 
        Person *p = self.persons[indexPath.row];
        [[DBManager shareManager]deletePerson:p];

        [tableView deleteRowsAtIndexPaths:@[indexPath] withRowAnimation:UITableViewRowAnimationFade];
    } else if (editingStyle == UITableViewCellEditingStyleInsert) {
        // Create a new instance of the appropriate class, insert it into the array, and add a new row to the table view
    }   
}

实现tableview点击cell事件,通过属性传值，实现修改效果

-(void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath{
    Person *p = self.persons[indexPath.row];
    PersonViewController *vc = [PersonViewController new];
    vc.person = p;
    [self.navigationController pushViewController:vc animated:YES];  
}

程序源代码请通过github下载：
https://github.com/lee727n/address-book