iOS开发系列--详细介绍数据存取

最后，在视图控制器中调用相应的服务层进行各类数据操作，在下面的代码中分别演示了增、删、改、查四类操作。

KCMainViewController.m

//
// KCMainTableViewController.m
// DataAccess
//
// Created by Kenshin Cui on 14-3-29.
// Copyright (c) 2014年 Kenshin Cui. All rights reserved.
//

#import "KCMainTableViewController.h"
#import "KCDbManager.h"
#import "KCDatabaseCreator.h"
#import "KCUser.h"
#import "KCStatus.h"
#import "KCUserService.h"
#import "KCStatusService.h"
#import "KCStatusTableViewCell.h"

@interface KCMainTableViewController (){
  NSArray *_status;
  NSMutableArray *_statusCells;
}

@end

@implementation KCMainTableViewController

- (void)viewDidLoad {
  [super viewDidLoad];
  [KCDatabaseCreator initDatabase];
  
//  [self addUsers];
//  [self removeUser];
//  [self modifyUserInfo];
  
//  [self addStatus];
  
  [self loadStatusData];
  
}

-(void)addUsers{
  KCUser *user1=[KCUser userWithName:@"Binger" screenName:@"冰儿" profileImageUrl:@"binger.jpg" mbtype:@"mbtype.png" city:@"北京"];
  [[KCUserService sharedKCUserService] addUser:user1];
  KCUser *user2=[KCUser userWithName:@"Xiaona" screenName:@"小娜" profileImageUrl:@"xiaona.jpg" mbtype:@"mbtype.png" city:@"北京"];
  [[KCUserService sharedKCUserService] addUser:user2];
  KCUser *user3=[KCUser userWithName:@"Lily" screenName:@"丽丽" profileImageUrl:@"lily.jpg" mbtype:@"mbtype.png" city:@"北京"];
  [[KCUserService sharedKCUserService] addUser:user3];
  KCUser *user4=[KCUser userWithName:@"Qianmo" screenName:@"阡陌" profileImageUrl:@"qianmo.jpg" mbtype:@"mbtype.png" city:@"北京"];
  [[KCUserService sharedKCUserService] addUser:user4];
  KCUser *user5=[KCUser userWithName:@"Yanyue" screenName:@"炎月" profileImageUrl:@"yanyue.jpg" mbtype:@"mbtype.png" city:@"北京"];
  [[KCUserService sharedKCUserService] addUser:user5];
}

-(void)addStatus{
  KCStatus *status1=[KCStatus statusWithCreateAt:@"9:00" source:@"iPhone 6" text:@"一只雪猴在日本边泡温泉边玩iPhone的照片，获得了"2014年野生动物摄影师"大赛特等奖。一起来为猴子配个词" userId:1];
  [[KCStatusService sharedKCStatusService] addStatus:status1];
  KCStatus *status2=[KCStatus statusWithCreateAt:@"9:00" source:@"iPhone 6" text:@"一只雪猴在日本边泡温泉边玩iPhone的照片，获得了"2014年野生动物摄影师"大赛特等奖。一起来为猴子配个词" userId:1];
  [[KCStatusService sharedKCStatusService] addStatus:status2];
  KCStatus *status3=[KCStatus statusWithCreateAt:@"9:30" source:@"iPhone 6" text:@"【我们送iPhone6了 要求很简单】真心回馈粉丝，小编觉得现在最好的奖品就是iPhone6了。今起到12月31日，关注我们，转发微博，就有机会获iPhone6(奖品可能需要等待)！每月抽一台[鼓掌]。不费事，还是试试吧，万一中了呢" userId:2];
  [[KCStatusService sharedKCStatusService] addStatus:status3];
  KCStatus *status4=[KCStatus statusWithCreateAt:@"9:45" source:@"iPhone 6" text:@"重大新闻：蒂姆库克宣布出柜后，ISIS战士怒扔iPhone，沙特神职人员呼吁人们换回iPhone 4。[via Pan-Arabia Enquirer]" userId:3];
  [[KCStatusService sharedKCStatusService] addStatus:status4];
  KCStatus *status5=[KCStatus statusWithCreateAt:@"10:05" source:@"iPhone 6" text:@"小伙伴们，有谁知道怎么往Iphone4S里倒东西？倒入的东西又该在哪里找？用了Iphone这么长时间，还真的不知道怎么弄！有谁知道啊？谢谢！" userId:4];
  [[KCStatusService sharedKCStatusService] addStatus:status5];
  KCStatus *status6=[KCStatus statusWithCreateAt:@"10:07" source:@"iPhone 6" text:@"在音悦台iPhone客户端里发现一个悦单《Infinite 金明洙》，推荐给大家! " userId:1];
  [[KCStatusService sharedKCStatusService] addStatus:status6];
  KCStatus *status7=[KCStatus statusWithCreateAt:@"11:20" source:@"iPhone 6" text:@"如果sony吧mp3播放器产品发展下去，不贪图手头节目源的现实利益，就木有苹果的ipod，也就木有iphone。柯达类似的现实利益，不自我革命的案例也是一种巨头的宿命。" userId:2];
  [[KCStatusService sharedKCStatusService] addStatus:status7];
  KCStatus *status8=[KCStatus statusWithCreateAt:@"13:00" source:@"iPhone 6" text:@"【iPhone 7 Plus】新买的iPhone 7 Plus ，如何？够酷炫么？" userId:2];
  [[KCStatusService sharedKCStatusService] addStatus:status8];
  KCStatus *status9=[KCStatus statusWithCreateAt:@"13:24" source:@"iPhone 6" text:@"自拍神器#卡西欧TR500#，tr350S～价格美丽，行货，全国联保～iPhone6 iPhone6Plus卡西欧TR150 TR200 TR350 TR350S全面到货 招收各种代理！[给力]微信：39017366" userId:3];
  [[KCStatusService sharedKCStatusService] addStatus:status9];
  KCStatus *status10=[KCStatus statusWithCreateAt:@"13:26" source:@"iPhone 6" text:@"猜到猴哥玩手机时所思所想者，再奖iPhone一部。（奖品由“2014年野生动物摄影师”评委会颁发）" userId:3];
  [[KCStatusService sharedKCStatusService] addStatus:status10];
}

-(void)removeUser{
  //注意在SQLite中区分大小写
  [[KCUserService sharedKCUserService] removeUserByName:@"Yanyue"];
}

-(void)modifyUserInfo{
  KCUser *user1= [[KCUserService sharedKCUserService]getUserByName:@"Xiaona"];
  user1.city=@"上海";
  [[KCUserService sharedKCUserService] modifyUser:user1];
  
  KCUser *user2= [[KCUserService sharedKCUserService]getUserByName:@"Lily"];
  user2.city=@"深圳";
  [[KCUserService sharedKCUserService] modifyUser:user2];
}

#pragma mark 加载数据
-(void)loadStatusData{
  _statusCells=[[NSMutableArray alloc]init];
  _status=[[KCStatusService sharedKCStatusService]getAllStatus];
  [_status enumerateObjectsUsingBlock:^(id obj, NSUInteger idx, BOOL *stop) {
    KCStatusTableViewCell *cell=[[KCStatusTableViewCell alloc]init];
    cell.status=(KCStatus *)obj;
    [_statusCells addObject:cell];
  }];
  NSLog(@"%@",[_status lastObject]);
}


#pragma mark - Table view data source

- (NSInteger)numberOfSectionsInTableView:(UITableView *)tableView {
  return 1;
}

- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section {
  return _status.count;
}

- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath {
  static NSString *identtityKey=@"myTableViewCellIdentityKey1";
  KCStatusTableViewCell *cell=[self.tableView dequeueReusableCellWithIdentifier:identtityKey];
  if(cell==nil){
    cell=[[KCStatusTableViewCell alloc]initWithStyle:UITableViewCellStyleValue1 reuseIdentifier:identtityKey];
  }
  cell.status=_status[indexPath.row];

  return cell;
}

-(CGFloat)tableView:(UITableView *)tableView heightForRowAtIndexPath:(NSIndexPath *)indexPath{
  return ((KCStatusTableViewCell *)_statusCells[indexPath.row]).height;
}

-(CGFloat)tableView:(UITableView *)tableView heightForHeaderInSection:(NSInteger)section{
  return 20.0f;
}
@end

								 
 7/14   首页 上一页 5 6 7 8 9 10 下一页 尾页