CoreData的简单使用<二、CoreData两张数据库表的关联操作>

两张数据库表的关联操作

在实际的数据结构中难免会遇到两张数据表需要进行关联，比如通用的例子，公司有两个员工张三和李四，分别属于iOS和android部门，如果所有的员工属于一张表，所有的部门属于一张表，这两张表就必然会有联系。，在CoreData中如何做简单的表的关联，下面是我写的代码。

//
//  ViewController.m
//  CoreData
//
//  Created by YanFengZheng on 16/8/27.
//  Copyright © 2016年 fe. All rights reserved.
//

#import "ViewController.h"
#import <CoreData/CoreData.h>
#import "Employee.h"
#import "Deparment.h"
@interface ViewController ()
@property (nonatomic,strong) NSManagedObjectContext *context;
@end

@implementation ViewController

- (void)viewDidLoad {
    [super viewDidLoad];
    //1.创建模型文件［相当于数据库里的表］
    //2.添加实体   ［一张表］
    //3.创建实体类 ［相当于模型］
    //4.生成上下文 关联模型文件生成数据库
    //4.1上下文
    NSManagedObjectContext *context = [[NSManagedObjectContext alloc] initWithConcurrencyType:NSMainQueueConcurrencyType];
    //4.2持久化存储协调器
    NSManagedObjectModel *model = [NSManagedObjectModel mergedModelFromBundles:nil];
    NSPersistentStoreCoordinator *store = [[NSPersistentStoreCoordinator alloc] initWithManagedObjectModel:model];
    //4.3设置数据库路径
    NSString *doc = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];
    NSString *sqlitePath = [doc stringByAppendingPathComponent:@"company.sqlite"];
    NSLog(@"%@",sqlitePath);
    [store addPersistentStoreWithType:NSSQLiteStoreType configuration:nil URL:[NSURL fileURLWithPath:sqlitePath] options:nil error:nil];
    context.persistentStoreCoordinator = store;
    self.context = context;
    
    /*在写以上代码的时候，先初始化上下文，再初始化上下文需要的持久化存储协调器，再初始化持久化存储协调器所需要的模型文件，最后添加持久化类型和文件路径。个人感觉按照这个方法比较容易记忆。
     */
}

#pragma mark - 数据库操作 增、删、改、查
//1.插入数据
- (IBAction)insertData:(UIButton *)sender {
    //创建两个部门，一个iOS部门，一个android部门
    //创建两个员工，张三属于iOS部门，李四属于android部门
    Deparment *iosDepart = [NSEntityDescription insertNewObjectForEntityForName:@"Deparment" inManagedObjectContext:self.context];
    iosDepart.name = @"ios";
    iosDepart.number = @"001";
    iosDepart.creatDate = [NSDate date];
    
    Deparment *androidDepart = [NSEntityDescription insertNewObjectForEntityForName:@"Deparment" inManagedObjectContext:self.context];
    androidDepart.name = @"android";
    androidDepart.number = @"002";
    androidDepart.creatDate = [NSDate date];
    
    Employee *zhangsan = [NSEntityDescription insertNewObjectForEntityForName:@"Employee" inManagedObjectContext:self.context];
    zhangsan.name = @"张三";
    zhangsan.height = @178;
    zhangsan.birthday = [NSDate date];
    zhangsan.depart = iosDepart;
    
    Employee *lisi = [NSEntityDescription insertNewObjectForEntityForName:@"Employee" inManagedObjectContext:self.context];
    lisi.name = @"李四";
    lisi.height = @188;
    lisi.birthday = [NSDate date];
    lisi.depart = androidDepart;
    
    
    

    [self.context  save:nil];
}
- (IBAction)deleteData:(UIButton *)sender {
    //1:先查询到需要删除的数据(比如这里以删除员工张三的数据为例)
    //1.1:FectchRequest 抓取请求对象
    NSFetchRequest *request = [NSFetchRequest fetchRequestWithEntityName:@"Deparment"];
    //1.2:设置过滤条件
    NSPredicate *pre = [NSPredicate predicateWithFormat:@"name = %@",@"张三"];
//    request.predicate = pre;
    //1.3执行查询请求
    NSArray *emps = [self.context executeFetchRequest:request error:nil];
    //2:执行删除操作
    for (Employee *emp in emps) {
        [self.context deleteObject:emp];
    }
    
    //3:保存
    [self.context save:nil];
}
//更新数据
- (IBAction)upDateData:(UIButton *)sender {
    //1:先查询出需要更新的数据
    //1.1:FectchRequest 抓取请求对象
    NSFetchRequest *request = [NSFetchRequest fetchRequestWithEntityName:@"Employee"];
    //1.2:设置过滤条件
    NSPredicate *pre = [NSPredicate predicateWithFormat:@"name = %@",@"张三"];
    request.predicate = pre;
    //1.3执行查询请求
    NSArray *emps = [self.context executeFetchRequest:request error:nil];

    //2:更新数据
    for (Employee *emp  in emps) {
        emp.height = @3;
    }
    //3:保存
    [self.context save:nil];
}
//查询员工
- (IBAction)queryData:(UIButton *)sender {
    //1:FectchRequest 抓取请求对象
    NSFetchRequest *request = [NSFetchRequest fetchRequestWithEntityName:@"Employee"];
    //2:设置过滤条件
    NSPredicate *pre = [NSPredicate predicateWithFormat:@"depart.name = %@",@"ios"];
    request.predicate = pre;
    //3:设置排序
//    NSSortDescriptor *height = [NSSortDescriptor sortDescriptorWithKey:@"height" ascending:YES];
//    request.sortDescriptors = @[height];
    
    //4:执行请求
    NSArray *emps = [self.context executeFetchRequest:request error:nil];
    //遍历查询结果
    for (Employee  *emp in emps) {
        NSLog(@"名字：%@,身高：%@,生日：%@",emp.name,emp.height,emp.birthday);
    }
}














@end

下图是两张表的关联结构

借助数据库软件打开存储在沙河里的数据库表，如下图所示

可以看到，两张表是通过主键进行关联的