两张数据库表的关联操作
在实际的数据结构中难免会遇到两张数据表需要进行关联,比如通用的例子,公司有两个员工张三和李四,分别属于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
下图是两张表的关联结构
借助数据库软件打开存储在沙河里的数据库表,如下图所示
可以看到,两张表是通过主键进行关联的