BookManager(ios)

//需要创建的类:
AddViewController:继承于UIViewController (xib)
UpViewController:继承于UIViewController(xib)
Book:继承于NSObject
FMDataBaseC:继承于NSObject
需要导入的第三方:MJRefresh(刷新):由于需要通过刷新添加数据

//最终效果通过表格展示

AppDelegate.h

//默认

AppDelegate.m

//AppDelegate.m#import "AppDelegate.h"#import "ViewController.h"@interface AppDelegate ()@end@implementation AppDelegate- (BOOL)application:(UIApplication *)application didFinishLaunchingWithOptions:(NSDictionary *)launchOptions {    // Override point for customization after application launch.    self.window.rootViewController = [[UINavigationController alloc] initWithRootViewController:[ViewController new]];    return YES;}

ViewController.h

//默认

ViewController.m

//ViewController.m#import "ViewController.h"#import "FMDataBaseC.h"#import "AddViewController.h"#import "UpViewController.h"#import "MJRefresh/MJRefresh.h"#import "Book.h"@interface ViewController ()<UITableViewDelegate,UITableViewDataSource,MJRefreshBaseViewDelegate>{    UITableView *theTableView;    NSMutableArray *arr;    MJRefreshFooterView *foot;    MJRefreshHeaderView *header;}@end@implementation ViewController- (void)viewDidLoad {    [super viewDidLoad];    // Do any additional setup after loading the view, typically from a nib.    //创建表格    theTableView = [[UITableView alloc] initWithFrame:[UIScreen mainScreen].bounds];    [self.view addSubview:theTableView];    theTableView.delegate = self;    theTableView.dataSource = self;    theTableView.separatorColor = [UIColor redColor];    //右按钮    self.navigationItem.rightBarButtonItem = [[UIBarButtonItem alloc] initWithTitle:@"+" style:UIBarButtonItemStylePlain target:self action:@selector(add)];    foot = [MJRefreshFooterView footer];    foot.scrollView = theTableView;    foot.delegate = self;    header = [MJRefreshHeaderView header];    header.scrollView = theTableView;    header.delegate = self;    [header beginRefreshing];}-(void)viewWillAppear:(BOOL)animated{    [super viewWillAppear:animated];    arr = [[FMDataBaseC shareData] getAll];    //刷新表格    [theTableView reloadData];}- (void)refreshViewBeginRefreshing:(MJRefreshBaseView *)refreshView{    if ([refreshView isKindOfClass:[MJRefreshHeaderView class]]) {        //2秒以后调用        dispatch_after(dispatch_time(DISPATCH_TIME_NOW, (int64_t)(2.0 * NSEC_PER_SEC)), dispatch_get_main_queue(), ^{            // 10     1            Book *book=[[Book alloc]init];            book.nameBook=@"秦时明月";            book.name=@"温世仁";            book.price=@"50";            [[FMDataBaseC shareData] insertData:book];           arr = [[FMDataBaseC shareData] getAll];            //刷新表格            [theTableView reloadData];            [header endRefreshing];        });    }    else{        dispatch_after(dispatch_time(DISPATCH_TIME_NOW, (int64_t)(2.0 * NSEC_PER_SEC)), dispatch_get_main_queue(), ^{            [arr removeObjectAtIndex:0];            [theTableView reloadData];            [foot endRefreshing];        });    }}//添加-(void)add{    AddViewController *add = [[AddViewController alloc] init];    [self.navigationController pushViewController:add animated:YES];}//表格行数-(NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section{    return arr.count;}//表格单元格内容-(UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath{    static NSString *cellID = @"cell";    UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:cellID];    if (!cell) {        cell = [[UITableViewCell alloc] initWithStyle:UITableViewCellStyleSubtitle reuseIdentifier:cellID];    }    Book *boo = arr[indexPath.row];    cell.textLabel.text = [NSString stringWithFormat:@"书名：%@\n",boo.nameBook];    cell.detailTextLabel.text=[NSString stringWithFormat:@"作者：%@\t\t价格：%@\n",boo.name,boo.price];   // cell.textLabel.numberOfLines = 0;    return cell;}//表格行高-(CGFloat)tableView:(UITableView *)tableView heightForRowAtIndexPath:(NSIndexPath *)indexPath{    return 44;}//修改-(void)tableView:(UITableView *)tableView didSelectRowAtIndexPath:(NSIndexPath *)indexPath{    UpViewController *up = [[UpViewController alloc] init];    up.boo = arr[indexPath.row];    [self.navigationController pushViewController:up animated:YES];}//删除-(void)tableView:(UITableView *)tableView commitEditingStyle:(UITableViewCellEditingStyle)editingStyle forRowAtIndexPath:(NSIndexPath *)indexPath{    Book *boo = arr[indexPath.row];    [[FMDataBaseC shareData] deleteData:boo];    [arr removeObjectAtIndex:indexPath.row];    [theTableView reloadData];}- (void)didReceiveMemoryWarning {    [super didReceiveMemoryWarning];    // Dispose of any resources that can be recreated.}

AddViewController.h

//默认

AddViewController.m

#import "AddViewController.h"#import "FMDataBaseC.h"@interface AddViewController ()@property (strong, nonatomic) IBOutlet UITextField *nameBookTF;@property (strong, nonatomic) IBOutlet UITextField *nameTF;@property (strong, nonatomic) IBOutlet UITextField *priceTF;@end@implementation AddViewController- (void)viewDidLoad {    [super viewDidLoad];    // Do any additional setup after loading the view from its nib.}//添加- (IBAction)addBtn:(id)sender{    Book *boo = [[Book alloc] init];    boo.nameBook = self.nameBookTF.text;    boo.name = self.nameTF.text;    boo.price = self.priceTF.text;    [[FMDataBaseC shareData] insertData:boo];    UIAlertView *alert=[[UIAlertView alloc]initWithTitle:nil message:@"保存成功" delegate:self cancelButtonTitle:nil otherButtonTitles:@"确定", nil];    [alert show];    [self.navigationController popViewControllerAnimated:YES];}- (void)didReceiveMemoryWarning {    [super didReceiveMemoryWarning];    // Dispose of any resources that can be recreated.}

AddViewController.xib

UpViewController.h

//UpViewController.h#import <UIKit/UIKit.h>#import "Book.h"@interface UpViewController : UIViewController@property(nonatomic , strong)Book *boo;@end

UpViewController.m

#import "UpViewController.h"#import "FMDataBaseC.h"@interface UpViewController ()@property (strong, nonatomic) IBOutlet UITextField *nameBookTF;@property (strong, nonatomic) IBOutlet UITextField *nameTF;@property (strong, nonatomic) IBOutlet UITextField *priceTF;@end@implementation UpViewController- (void)viewDidLoad {    [super viewDidLoad];    // Do any additional setup after loading the view from its nib.    self.nameBookTF.text = self.boo.nameBook;    self.nameTF.text = self.boo.name;    self.priceTF.text = self.boo.price;}//修改- (IBAction)upBtn:(id)sender {    Book *boo = [[Book alloc] init];    boo.ids = self.boo.ids;    boo.nameBook = self.nameBookTF.text;    boo.name = self.nameTF.text;    boo.price = self.priceTF.text;    [[FMDataBaseC shareData] upData:boo];    [self.navigationController popViewControllerAnimated:YES];}- (void)didReceiveMemoryWarning {    [super didReceiveMemoryWarning];    // Dispose of any resources that can be recreated.}

UpViewController.xib

将AddViewController.xib中添加改为修改

Book.h

//Book.h@interface Book : NSObject@property(nonatomic , assign)NSInteger ids;@property(nonatomic , strong)NSString *nameBook,*name,*price;@end

Book.m

//默认

FMDataBaseC.h

//FMDataBaseC.h#import <Foundation/Foundation.h>#import "Book.h"#import <FMDatabase.h>#import <FMResultSet.h>@interface FMDataBaseC : NSObject//单例+(instancetype)shareData;//添加-(void)insertData:(Book *)book;//删除-(void)deleteData:(Book *)book;//修改-(void)upData:(Book *)book;//查询-(NSMutableArray *)getAll;@end

FMDataBaseC.m

#import "FMDataBaseC.h"static FMDataBaseC *fm = nil;static FMDatabase *fmdb;@implementation FMDataBaseC//单例+(instancetype)shareData{    static dispatch_once_t onceToken;    dispatch_once(&onceToken, ^{        fm = [[FMDataBaseC alloc] init];        [fm initCre];    });    return fm;}+(instancetype)allocWithZone:(struct _NSZone *)zone{    if (!fm) {        fm = [super allocWithZone:zone];    }    return fm;}-(id)copy{    return self;}-(id)mutableCopy{    return self;}//创建数据库-(void)initCre{    NSString *str = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject];    NSString *path = [str stringByAppendingPathComponent:@"BookManagerSo.DB"];    fmdb = [[FMDatabase alloc] initWithPath:path];    if ([fmdb open]) {        [fmdb executeUpdate:@"create table BookInfoa(ids integer primary key autoincrement, nameBook text, name text, price text)"];        NSLog(@"创建成功");        [fmdb close];    }else{        NSLog(@"创建失败");    }}//添加-(void)insertData:(Book *)book{    [fmdb open];    BOOL insert = [fmdb executeUpdate:@"insert into BookInfoa values(null,?,?,?)",book.nameBook,book.name,book.price];    if (insert) {        NSLog(@"添加成功");    }else{        NSLog(@"添加失败");    }    [fmdb close];}//删除-(void)deleteData:(Book *)book{    [fmdb open];    NSString *str = [NSString stringWithFormat:@"delete from BookInfoa where ids = %ld",book.ids];    BOOL delete = [fmdb executeUpdate:str];    if (delete) {        NSLog(@"删除成功");    }else{        NSLog(@"删除失败");    }    [fmdb close];}//修改-(void)upData:(Book *)book{    [fmdb open];    NSString *str = [NSString stringWithFormat:@"update BookInfoa set nameBook = '%@', name = '%@',  price = '%@' where ids = %ld",book.nameBook,book.name,book.price,book.ids];    BOOL delete = [fmdb executeUpdate:str];    if (delete) {        NSLog(@"修改成功");    }else{        NSLog(@"修改失败");    }    [fmdb close];}//查询-(NSMutableArray *)getAll{    [fmdb open];    NSMutableArray *arr = [NSMutableArray array];    FMResultSet *fmset = [[FMResultSet alloc] init];    fmset = [fmdb executeQuery:@"select * from BookInfoa"];    while ([fmset next]) {        NSInteger ids = [fmset intForColumn:@"ids"];        NSString *nameBook = [fmset stringForColumn:@"nameBook"];        NSString *name = [fmset stringForColumn:@"name"];        NSString *price = [fmset stringForColumn:@"price"];        Book *boo = [[Book alloc] init];        boo.ids = ids;        boo.nameBook = nameBook;        boo.name = name;        boo.price = price;        [arr addObject:boo];    }    [fmdb close];    return arr;}