美文网首页

作者: Wang99 | 来源:发表于2017-10-08 19:04 被阅读0次
    屏幕快照 2017-10-08 下午7.12.17.png 
    #import "ViewController.h"
#import "AddViewController.h"
#import "AppDelegate.h"
#import "Model.h"
#import "LoadData.h"
@interface ViewController ()<UIAlertViewDelegate>
@property (strong, nonatomic) UIButton *btn;
//邮件
@property (strong,nonatomic)UITextField *fieldMail;
//收货地址
@property (strong,nonatomic)UITextField *fieldAddress;
//收货人
@property (strong,nonatomic)UITextField *fieldConsignee;
//电话
@property (strong,nonatomic)UITextField *fieldPhone;
//备注
@property (strong,nonatomic)UITextField *fieldNote;
//点击添加信息

@end

@implementation ViewController
- (void)viewDidLoad {
    [super viewDidLoad];
    // Do any additional setup after loading the view, typically from a nib.
    self.title=@"请输入资料";
    self.view.backgroundColor=[UIColor whiteColor];
    // Do any additional setup after loading the view.
    UILabel *label1 = [[UILabel alloc]initWithFrame:CGRectMake(20, 64, 100, 30)];
    label1.text = @"姓名";//设置Label上的文字
    [self.view addSubview:label1];
    _fieldMail = [[UITextField alloc]initWithFrame:CGRectMake(200, 64, 100, 30)];
    _fieldMail.borderStyle = UITextBorderStyleRoundedRect;
    
    
    [self.view addSubview:_fieldMail];
    
    
    
    UILabel *label2 = [[UILabel alloc]initWithFrame:CGRectMake(20, 164, 100, 30)];
    label2.text = @"年龄";//设置Label上的文字
    [self.view addSubview:label2];
    _fieldAddress = [[UITextField alloc]initWithFrame:CGRectMake(200, 164, 100, 30)];
    _fieldAddress.borderStyle = UITextBorderStyleRoundedRect;
    [self.view addSubview:_fieldAddress];
    
    
    
    
    UILabel *label3 = [[UILabel alloc]initWithFrame:CGRectMake(20, 264, 100, 30)];
    label3.text = @"QQ";//设置Label上的文字
    [self.view addSubview:label3];
    _fieldConsignee = [[UITextField alloc]initWithFrame:CGRectMake(200, 264, 100, 30)];
    _fieldConsignee.borderStyle = UITextBorderStyleRoundedRect;
    
    [self.view addSubview:_fieldConsignee];
    
    
    
    UILabel *label4 = [[UILabel alloc]initWithFrame:CGRectMake(20, 364, 100, 30)];
    label4.text = @"手机";//设置Label上的文字
    [self.view addSubview:label4];
    _fieldPhone = [[UITextField alloc]initWithFrame:CGRectMake(200, 364, 100, 30)];
    _fieldPhone.borderStyle = UITextBorderStyleRoundedRect;
    
    [self.view addSubview:_fieldPhone];
    
    
    UILabel *label5 = [[UILabel alloc]initWithFrame:CGRectMake(20, 464, 100, 30)];
    label5.text = @"微信";//设置Label上的文字
    [self.view addSubview:label5];
    _fieldNote = [[UITextField alloc]initWithFrame:CGRectMake(200, 464, 100, 30)];
    _fieldNote.borderStyle = UITextBorderStyleRoundedRect;
    
    [self.view addSubview:_fieldNote];
    
    
    //初始化按钮，设置按钮类型
    self.btn = [UIButton buttonWithType:UIButtonTypeSystem];
    self.btn.frame = CGRectMake(self.view.frame.size.width/2-50, 600, 100, 50);
    self.btn.backgroundColor = [UIColor grayColor];
    [self.btn setTitle:@"保存" forState:UIControlStateNormal];
    [self.btn addTarget:self action:@selector(Method) forControlEvents:UIControlEventTouchUpInside];
    //将控件添加到当前视图上
    [self.view addSubview:self.btn];
    //定义按钮
    UIBarButtonItem *right = [[UIBarButtonItem alloc]
                              initWithTitle:@"查看全部" style:UIBarButtonItemStylePlain
                              target:self action:@selector(click)];
    //添加到导航调试
    self.navigationItem.rightBarButtonItem = right;

    
}
- (void)Method
{
    //初始化
    Model *mm = [Model  new];
    //链接
    mm.fieldMail =self.fieldMail.text;
    mm.fieldAddress =self.fieldAddress.text;
    mm.fieldConsignee =self.fieldConsignee.text;
    mm.fieldPhone =self.fieldPhone.text;
    mm.fieldNote =self.fieldNote.text;
    
    //添加到数据库
    [[LoadData  sharlLoadData]AddsharlLoadData:mm];
    //初始化AlertView
    
    }
- (void)click
{
    //初始化
    AddViewController *up = [AddViewController new];
    [self.navigationController pushViewController:up animated:YES];
  
}
- (void)didReceiveMemoryWarning {
    [super didReceiveMemoryWarning];
    // Dispose of any resources that can be recreated.
}
@end

    #import "AddViewController.h"
#import "LoadData.h"//业务处理 SQLite
#import "Model.h" //保存数据
#import "MyTableViewCell.h"//主控制器 cell

#import "AddViewController.h"//添加信息控制器

@interface AddViewController ()<UITableViewDelegate,UITableViewDataSource>{
    UITableView *tabele;
    NSMutableArray *marr;
}


@end

@implementation AddViewController
//将要显示
-(void)viewWillAppear:(BOOL)animated{
    //查询
    marr = [[LoadData  sharlLoadData]Marr];
    //刷新
    [tabele  reloadData ];
}


- (void)viewDidLoad {
    [super viewDidLoad];
    
    
    //初始化
    tabele = [[UITableView  alloc]initWithFrame:self.view.frame style:
              UITableViewStylePlain];
    //添加协议
    tabele.delegate =self;
    tabele.dataSource =self;
    //添加到试图上
    [self.view addSubview:tabele];
    
    }
-(void)click{
    //初始化
    AddViewController *add = [AddViewController  new];
    //跳转
    [self.navigationController  pushViewController:add animated:YES];
}
//行数
-(NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section{
    return marr.count;
}
-(UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath{
    //初始化
    MyTableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:@"CELL"];
    //复用池
    if (!cell) {
        //初始化‘
        cell = [[MyTableViewCell alloc]initWithStyle:
                UITableViewCellStyleSubtitle   reuseIdentifier:@"CELL"];
    }
    //初始化
    Model *mm =marr[indexPath.row];
    //添加到表格上
    cell.fieldMail.text = mm.fieldMail;
    cell.fieldAddress.text = mm.fieldAddress;
    cell.fieldConsignee.text = mm.fieldConsignee;
    cell.fieldPhone.text = mm.fieldPhone;
    cell.fieldNote.text = mm.fieldNote;
    
    //返回值
    return cell;
}
//删除
-(void)tableView:(UITableView *)tableView commitEditingStyle:(UITableViewCellEditingStyle)editingStyle forRowAtIndexPath:(NSIndexPath *)indexPath{
    //添加
    Model *mm  = marr[ indexPath.row];
    //删除
    [[LoadData  sharlLoadData]deleteharlLoadData:mm];
    [marr removeObjectAtIndex:indexPath.row];
    //刷新
    [tabele reloadData];
}
//跳转
-(void)tableView:(UITableView *)tableView
didSelectRowAtIndexPath:(NSIndexPath *)indexPath{
   
}

    #import <UIKit/UIKit.h>

@interface MyTableViewCell : UITableViewCell
//邮件
@property (nonatomic ,strong)UILabel *fieldMail;
//收货地址
@property (nonatomic ,strong)UILabel *fieldAddress;
//收货人
@property (nonatomic ,strong)UILabel *fieldConsignee;
//电话
@property (nonatomic ,strong)UILabel *fieldPhone;
//备注
@property (nonatomic ,strong)UILabel *fieldNote;

    
@implementation MyTableViewCell
//重写父类方法
-(instancetype)initWithStyle:(UITableViewCellStyle)style
             reuseIdentifier:(NSString *)reuseIdentifier{
    //判断
    if ([super initWithStyle:style reuseIdentifier:reuseIdentifier]) {
        //添加到
        [self.contentView  addSubview:self.fieldMail];
        [self.contentView  addSubview:self.fieldAddress];
        [self.contentView  addSubview:self.fieldConsignee];
        [self.contentView  addSubview:self.fieldPhone];
        [self.contentView  addSubview:self.fieldNote];
        
    }
    //返回值
    return self;
}

//懒加载-//邮件
-(UILabel *)fieldMail{
    //判断
    if (!_fieldMail) {
        //初始化
        _fieldMail = [[UILabel  alloc]initWithFrame:CGRectMake(5,5,80,44)];
    }
    //返回值
    return _fieldMail;
}
//懒加载-//收货地址
-(UILabel *)fieldAddress{
    //判断
    if (!_fieldAddress) {
        //初始化
        _fieldAddress = [[UILabel alloc]initWithFrame:CGRectMake(80,5,80,44)];
    }
    //返回值
    return _fieldAddress;
}
//懒加载=//收货人
-(UILabel *)fieldConsignee{
    //判断
    if (!_fieldConsignee) {
        //初始化
        _fieldConsignee = [[UILabel  alloc]initWithFrame:CGRectMake(155,5,80,44)];
    }
    //返回值
    return _fieldConsignee;
}
//懒加载--//电话
-(UILabel *)fieldPhone{
    //判断
    if (!_fieldPhone) {
        //初始化
        _fieldPhone = [[UILabel alloc]initWithFrame:CGRectMake(220,5,80,44)];
    }
    //返回值
    return _fieldPhone;
}
//懒加载
-(UILabel *)fieldNote{
    //判断
    if (!_fieldNote) {
        //初始化
        _fieldNote = [[UILabel alloc]initWithFrame:CGRectMake(305,5,80,44)];
    }
    //返回值
    return _fieldNote;
}
- (void)awakeFromNib {
    [super awakeFromNib];
    // Initialization code
}

- (void)setSelected:(BOOL)selected animated:(BOOL)animated {
    [super setSelected:selected animated:animated];

    // Configure the view for the selected state
}

@end

    #import <Foundation/Foundation.h>

@interface Model : NSObject
//定义属性
//邮箱
@property (nonatomic ,copy)NSString *fieldMail;
//收货地址
@property (nonatomic ,copy)NSString *fieldAddress;
//收货人
@property (nonatomic ,copy)NSString *fieldConsignee;
//电话
@property (nonatomic ,copy)NSString *fieldPhone;
//备注
@property (nonatomic ,copy)NSString *fieldNote;
//
@property (nonatomic ,assign)NSInteger ID;
@end

    #import <Foundation/Foundation.h>
#import "Model.h"
#import "FMDatabase.h"
@interface LoadData : NSObject
//单列类
+(instancetype)sharlLoadData;
//添加元素
-(void)AddsharlLoadData:(Model *)model;
//查询
-(NSMutableArray *)Marr;
//删除元素
-(void)deleteharlLoadData:(Model *)model;
//修改元素
-(void)UPsharlLoadData:(Model *)model;
@end

    #import "LoadData.h"
static LoadData *ld =nil;
static FMDatabase *fate;
@implementation LoadData
//单列类
+(instancetype)sharlLoadData{
    //静态
    static dispatch_once_t oneet;
    //初始化
    dispatch_once(&oneet, ^{
        ld = [[LoadData alloc]init];
        //定义初始化
        [ld initA];
    });
    //返回值
    return ld;
}
//初始化
+(instancetype)allocWithZone:(struct _NSZone *)zone{
    if (!ld) {
        //初始化
        ld = [super allocWithZone:zone];
    }
    return ld;
}
//浅复制
-(id)copy{
    return self;
}
//深复制
-(id)mutableCopy{
    return self;
}
//初始化数据库
-(void)initA{
    //创建沙盒
    NSString *Ste = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,
                                                         NSUserDomainMask,YES)objectAtIndex:0];
    //定义文件名
    NSString *path = [Ste stringByAppendingPathComponent:@"HousingInfo.sqlite"];
    //初始化
    fate = [[FMDatabase alloc]initWithPath:path];
    //判断
    if ([fate open]) {
        //初始化
        [fate  executeUpdate:@"create table class (ID integer primary key, fieldMail text, fieldAddress text , fieldConsignee text , fieldPhone text , fieldNote text)"];
        [fate  close];
        NSLog(@"成功");
    }else{
        NSLog(@"失败");
    }
}
//添加元素
-(void)AddsharlLoadData:(Model *)model{
    //开始
    [fate  open];
    //初始化
    NSString *str = [NSString  stringWithFormat:@"insert into class values (null , '%@','%@','%@','%@','%@')",model.fieldMail,model.fieldAddress,
                     model.fieldConsignee,model.fieldPhone,model.fieldNote];
    //BOOL值接受
    BOOL ii = [fate  executeUpdate:str];
    //判断
    if (ii) {
        NSLog(@"成功");
    }else{
        NSLog(@"失败");
    }
    //关闭
    [fate  close];
}
//查询
-(NSMutableArray *)Marr{
    //初始化
    NSMutableArray *marr = [NSMutableArray new];
    //开始
    [fate  open];
    //初始化
    FMResultSet *Set = [[FMResultSet alloc]init];
    //使用set接受
    Set = [fate  executeQuery:@"select * from class"];
    //判断
    while ([Set next]) {
        //初始化
        Model *mm = [Model new];
        //链接
        mm.fieldMail = [Set stringForColumn:@"fieldMail"];
        mm.fieldAddress = [Set stringForColumn:@"fieldAddress"];
        mm.fieldConsignee = [Set stringForColumn:@"fieldConsignee"];
        mm.fieldPhone = [Set stringForColumn:@"fieldPhone"];
        mm.fieldNote = [Set stringForColumn:@"fieldNote"];
        mm.ID = [Set intForColumn:@"ID"];
        //添加到数组
        [marr addObject:mm];
        
    }
    //关闭
    [fate close];
    //返回值
    return marr;
}
//删除元素
-(void)deleteharlLoadData:(Model *)model{
    //开始
    [fate open];
    //初始化
    NSString *str = [NSString stringWithFormat:@"delete from class where ID = '%ld' ",model.ID];
    //BOOL值接受
    BOOL ii = [fate executeUpdate:str];
    //判断
    if (ii) {
        NSLog(@"成功");
    }else{
        NSLog(@"失败");
    }
    //关闭
    [fate close];
}
//修改元素
-(void)UPsharlLoadData:(Model *)model{
    //开始
    [fate open];
    //初始化
    NSString *str = [NSString stringWithFormat:@"update class set fieldMail = '%@',fieldAddress = '%@',fieldConsignee = '%@',fieldPhone = '%@',fieldNote = '%@' where ID = '%ld'",model.fieldMail,model.fieldAddress,model.fieldConsignee,
                     model.fieldPhone,model.fieldNote,model.ID];
    //BOOL值接受
    BOOL ii = [fate executeUpdate:str];
    //判断
    if (ii) {
        NSLog(@"成功");
    }else{
        NSLog(@"失败");
    }
    //关闭
    [fate close];
}
@end

    相关文章

      网友评论

          本文标题：

          本文链接：https://www.haomeiwen.com/subject/krlyyxtx.html

          延伸阅读

          深度阅读

          • 您也可以注册成为美文阅读网的作者，发表您的原创作品、分享您的心情！

          栏目导航

          热点阅读

          关于我们|服务条款|联系我们||投稿指南|网站地图|RSS订阅|排版工具|手机版

          提供经典美文摘抄,优美散文欣赏,现代诗歌精选,短篇小说,心情随笔,表白情书范文,故事会在线阅读欣赏

          Copyright © 2014-2023 Haomeiwen.com All Rights Reserved. 好美文阅读网 版权所有

          备案信息：桂公网安备 45052102000051号 · 桂ICP备13007215号-3

          本站所收录作品、热点评论等信息部分来源互联网，目的只是为了系统归纳学习和传递资讯

          所有作品版权归原创作者所有，与本站立场无关，如不慎侵犯了你的权益，请联系我们告知，我们将做删除处理！