//
// ViewController.m
// RealmForSqlite
//
// Created by 陈胜华 on 2017/2/8.
// Copyright © 2017年 oneyd.me. All rights reserved.
//
#import "ViewController.h"
#import "Person.h"
@interface ViewController ()<UITableViewDelegate,UITableViewDataSource>
@property (weak, nonatomic) IBOutlet UITextField *etxfName;
@property (weak, nonatomic) IBOutlet UITextField *etxfAge;
@property (weak, nonatomic) IBOutlet UITableView *etblList;
@property (strong,nonatomic) NSMutableArray<Person*> *dataList;
@property (strong,nonatomic) RLMRealm *realmManger;
@property (strong,nonatomic) Person *selctedPersonEntity;
@end
@implementation ViewController
- (void)viewDidLoad {
[super viewDidLoad];
_realmManger = [RLMRealm defaultRealm];
_dataList = [[NSMutableArray alloc]init];
//第一次初始化，读取数据，显示
RLMResults<Person*> *tempArray = [Person allObjectsInRealm:_realmManger];
[_dataList removeAllObjects];
for (Person *obj in tempArray) {
[_dataList addObject:obj];
}
//刷新数据
[_etblList reloadData];
}
//数据库--增
- (IBAction)onClickAdd:(id)sender {
if (_etxfName.text.length == 0 || _etxfAge.text.length == 0) return;
//对象
Person *person = [[Person alloc]init];
person.name = _etxfName.text;
person.age = [_etxfAge.text intValue];
//增
[_realmManger transactionWithBlock:^{
[_realmManger addObject:person];
[_realmManger commitWriteTransaction];
}];
//读取数据
RLMResults<Person*> *tempArray = [Person allObjectsInRealm:_realmManger];
[_dataList removeAllObjects];
for (Person *obj in tempArray) {
[_dataList addObject:obj];
}
//刷新数据
[_etblList reloadData];
}
//数据库--删
- (IBAction)onClickDelete:(id)sender {
__block BOOL isDelete = false;
RLMResults<Person*> *tempArray = [Person allObjectsInRealm:_realmManger];
if (_etxfName.text.length == 0 && _etxfAge.text.length != 0) {//以age方式delete
[_realmManger transactionWithBlock:^{
for (Person *obj in tempArray) {
if (obj.age == [_etxfAge.text intValue]) {
[_realmManger deleteObject:obj];
isDelete = true;
}
}
[_realmManger commitWriteTransaction];
}];
} else if (_etxfName.text.length != 0 && _etxfAge.text.length == 0) {//以name方式delete
[_realmManger transactionWithBlock:^{
for (Person *obj in tempArray) {
if ([obj.name isEqualToString:_etxfName.text]) {
[_realmManger deleteObject:obj];
isDelete = true;
}
}
[_realmManger commitWriteTransaction];
}];
} else if (_etxfName.text.length != 0 && _etxfAge.text.length != 0) {
[_realmManger transactionWithBlock:^{
for (Person *obj in tempArray) {
if (obj.age == [_etxfAge.text intValue] && [obj.name isEqualToString:_etxfName.text]) {
[_realmManger deleteObject:obj];
isDelete = true;
}
}
[_realmManger commitWriteTransaction];
}];
}
if (isDelete) {
_etxfAge.text = @"";
_etxfName.text = @"";
[self.view endEditing:YES];
}
//重新获取数据库表
tempArray = [Person allObjectsInRealm:_realmManger];
[_dataList removeAllObjects];
for (Person *obj in tempArray) {
[_dataList addObject:obj];
}
//刷新数据
[_etblList reloadData];
}
//数据库--查
- (IBAction)onClickSearch:(id)sender {
//读取数据
RLMResults<Person*> *tempArray = [Person allObjectsInRealm:_realmManger];
NSString *searchSqlite ;
/*---------------------------查询语句说明-------------------------------------*/
/* 查询语句的语法以 ‘NSPredicate’语法为准 */
/*---------------------------查询语句说明-------------------------------------*/
//完全匹配查询
//searchSqlite = [NSString stringWithFormat:@"name = '%@'",_etxfName.text];
//以某个条件开头的查询(半模糊查询)
//searchSqlite = [NSString stringWithFormat:@"name BEGINSWITH '%@' ",_etxfName.text];
//以某个条件结尾的查询(半模糊查询)
//searchSqlite = [NSString stringWithFormat:@"name ENDSWITH '%@' ",_etxfName.text];
//包含某些关键字
//searchSqlite = [NSString stringWithFormat:@"name CONTAINS[c] '%@' ",_etxfName.text];
if (_etxfName.text.length == 0 && _etxfAge.text.length == 0) {//查全部
tempArray = [Person allObjectsInRealm:_realmManger];
} else if(_etxfName.text.length == 0 && _etxfAge.text.length != 0 ){//查年龄
searchSqlite = [NSString stringWithFormat:@"age in {%@}",_etxfAge.text];
tempArray = [Person objectsWhere:searchSqlite];
} else if(_etxfName.text.length != 0 && _etxfAge.text.length == 0){//查姓名
searchSqlite = [NSString stringWithFormat:@"name CONTAINS[c] '%@'",_etxfName.text];
tempArray = [Person objectsWhere:searchSqlite];
} else if(_etxfName.text.length != 0 && _etxfAge.text.length != 0){//模糊查询
searchSqlite = [NSString stringWithFormat:@"name CONTAINS[c] '%@' && age in {%@}",_etxfName.text,_etxfAge.text];
tempArray = [Person objectsWhere:searchSqlite];
}
[_dataList removeAllObjects];
for (Person *obj in tempArray) {
[_dataList addObject:obj];
}
//刷新数据
[_etblList reloadData];
}
//数据库--改
- (IBAction)onClickModel:(id)sender {
if (!_selctedPersonEntity) return ;
//查询
RLMResults<Person*> *tempArray = [Person allObjectsInRealm:[RLMRealm defaultRealm]];
[_realmManger transactionWithBlock:^{
//修改
for (Person *obj in tempArray) {
if ([obj.name isEqualToString:_selctedPersonEntity.name] && obj.age == _selctedPersonEntity.age) {
obj.name = _etxfName.text ;
obj.age = [_etxfAge.text intValue];
}
}
[_realmManger commitWriteTransaction];
}];
_selctedPersonEntity = nil;
_etxfAge.text = @"";
_etxfName.text = @"";
[self.view endEditing:YES];
[_dataList removeAllObjects];
for (Person *obj in tempArray) {
[_dataList addObject:obj];
}
//刷新数据
[_etblList reloadData];
}
//数据库--清空列表
- (IBAction)onClickRemoveList:(id)sender {
RLMRealm *realm = [RLMRealm defaultRealm];
[realm beginWriteTransaction];
[realm deleteAllObjects];
[realm commitWriteTransaction];
[_dataList removeLastObject];
[_etblList reloadData];
}
//列表显示
- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section{
return _dataList.count;
}
- (UITableViewCell*)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath {
UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:NSStringFromClass([self class])];
if (!cell) {
cell = [[UITableViewCell alloc]initWithStyle:UITableViewCellStyleValue1 reuseIdentifier:NSStringFromClass([self class])];
}
cell.textLabel.text = [NSString stringWithFormat:@"姓名：%@",_dataList[indexPath.row].name];
cell.detailTextLabel.text = [NSString stringWithFormat:@"年龄：%@",@(_dataList[indexPath.row].age)];
return cell;
}
- (void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath {
_selctedPersonEntity = _dataList[indexPath.row];
_etxfName.text = _selctedPersonEntity.name;
_etxfAge.text = [NSString stringWithFormat:@"%@",@(_selctedPersonEntity.age)];
}
@end
#import <Realm/Realm.h>
@interface Person : RLMObject
@property (nonatomic,copy ) NSString *name;
@property (nonatomic,assign) int age;
@end
# platform :ios, ‘8.0’
target 'RealmForSqlite' do
pod 'Realm', '~> 2.2.0'
end
