iOS-数据库-FMDB-第三方-插入数据列表-

iOS-数据库-FMDB-第三方-插入数据列表-

//
// ViewController.m
// UI18_FMDB
//
// Created by YIem on 16/3/4.
// Copyright © 2016年 YIem. All rights reserved.
//

import "ViewController.h"

import "DataBaseHandle.h"

import "Student.h"

@interface ViewController ()

@end

@implementation ViewController

(void)viewDidLoad {

[super viewDidLoad];
// Do any additional setup after loading the view, typically from a nib.
self.view.backgroundColor = [UIColor greenColor];

UIButton *openB = [UIButton buttonWithType:UIButtonTypeSystem];
openB.frame = CGRectMake(10, 10, 100, 100);
[openB setTitle:@"打开数据库" forState:UIControlStateNormal];
[openB addTarget:self action:@selector(openAction) forControlEvents:UIControlEventTouchUpInside];
[self.view addSubview:openB];

UIButton *closeB = [UIButton buttonWithType:UIButtonTypeSystem];
closeB.frame = CGRectMake(130, 10, 100, 100);
[closeB setTitle:@"关闭数据库" forState:UIControlStateNormal];
[closeB addTarget:self action:@selector(closeAction) forControlEvents:UIControlEventTouchUpInside];
[self.view addSubview:closeB];

UIButton *createTableB = [UIButton buttonWithType:UIButtonTypeSystem];
createTableB.frame = CGRectMake(10, 120, 100, 100);
[createTableB setTitle:@"创建表单" forState:UIControlStateNormal];
[createTableB addTarget:self action:@selector(createTableAction) forControlEvents:UIControlEventTouchUpInside];
[self.view addSubview:createTableB];
UIButton *dropTableB = [UIButton buttonWithType:UIButtonTypeSystem];
dropTableB.frame = CGRectMake(130, 120, 100, 100);
[dropTableB setTitle:@"删除表单" forState:UIControlStateNormal];
[dropTableB addTarget:self action:@selector(dropTableAction) forControlEvents:UIControlEventTouchUpInside];
[self.view addSubview:dropTableB];
UIButton *inserTableB = [UIButton buttonWithType:UIButtonTypeSystem];
inserTableB.frame = CGRectMake(10, 250, 100, 100);
[inserTableB setTitle:@"插入数据" forState:UIControlStateNormal];
[inserTableB addTarget:self action:@selector(insertAction) forControlEvents:UIControlEventTouchUpInside];
[self.view addSubview:inserTableB];

UIButton *updateTableB = [UIButton buttonWithType:UIButtonTypeSystem];
updateTableB.frame = CGRectMake(130, 250, 100, 100);
[updateTableB setTitle:@"更新数据" forState:UIControlStateNormal];
[updateTableB addTarget:self action:@selector(updateAction) forControlEvents:UIControlEventTouchUpInside];
[self.view addSubview:updateTableB];
UIButton *deletedateTableB = [UIButton buttonWithType:UIButtonTypeSystem];
deletedateTableB.frame = CGRectMake(10, 360, 100, 100);
[deletedateTableB setTitle:@"删除数据" forState:UIControlStateNormal];
[deletedateTableB addTarget:self action:@selector(deletedateAction) forControlEvents:UIControlEventTouchUpInside];
[self.view addSubview:deletedateTableB];

UIButton *selectTableB = [UIButton buttonWithType:UIButtonTypeSystem];
selectTableB.frame = CGRectMake(130, 470, 200, 100);
[selectTableB setTitle:@"查询分类数据" forState:UIControlStateNormal];
[selectTableB addTarget:self action:@selector(selectAction) forControlEvents:UIControlEventTouchUpInside];
[self.view addSubview:selectTableB];


UIButton *insertMoreB = [UIButton buttonWithType:UIButtonTypeSystem];
insertMoreB.frame = CGRectMake(130, 570, 200, 100);
[insertMoreB setTitle:@"(队列)数据" forState:UIControlStateNormal];
[insertMoreB addTarget:self action:@selector(insertMoreAction) forControlEvents:UIControlEventTouchUpInside];
[self.view addSubview:insertMoreB];

}
// 插入队列数据

(void)insertMoreAction
{
for (NSInteger i = 0; i < 100; i++) {

Student *stu = [[Student alloc] init];
stu.name = @"YIem";
stu.sex = @"m";
stu.age = 21;

[[DataBaseHandle shareDataBase] insertMoreStudent:stu];

}
}

// 查询分类

(void)selectAction
{
NSMutableArray *arr = [[DataBaseHandle shareDataBase] selectStuWithSex:@"男"];
NSMutableArray *stuArr = [NSMutableArray arrayWithArray:arr];
for (Student *stu in stuArr) {
```
NSLog(@"%@ %@ %ld", stu.name, stu.sex, stu.age);
```
}
}

// 删除数据

(void)deletedateAction
{

[[DataBaseHandle shareDataBase] deleteDataWithNum:2];

}

// 修改数据

(void)updateAction
{

Student *stu = [[Student alloc] init];
stu.name = @"YIem";
stu.sex = @"m";
stu.age = 99;
[[DataBaseHandle shareDataBase] updateWithStu:stu num:4];

}

// 插入数据

(void)insertAction
{

Student *stu = [[Student alloc] init];
stu.name = @"卞一";
stu.sex = @"男";
stu.age = 21;
[[DataBaseHandle shareDataBase] insertDataWithStu:stu];

}

// 删除表单

(void)dropTableAction
{

[[DataBaseHandle shareDataBase] deleteTable];

}

// 创建表单

(void)createTableAction
{

[[DataBaseHandle shareDataBase] createTable];

}

// 关闭数据库

(void)closeAction
{

[[DataBaseHandle shareDataBase] closeDB];

}

// 打开数据库

(void)openAction
{

[[DataBaseHandle shareDataBase] openDB];

}

(void)didReceiveMemoryWarning {

[super didReceiveMemoryWarning];
// Dispose of any resources that can be recreated.

}

@end