屏幕快照 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
