FMDB

//

//  AppDelegate.h

//  靠前瞎鸡儿信1

//

//  Created by 徐才茵 on 20/12/2018.

//  Copyright © 2018 徐才茵. All rights reserved.

//

#import

#import

@interface AppDelegate : UIResponder <UIApplicationDelegate>

@property (strong, nonatomic) UIWindow *window;

@property(readonly,strong)NSPersistentContainer*persistentContainer;

- (void)saveContext;

@end

//

//  AppDelegate.m

//  靠前瞎鸡儿信1

//

//  Created by 徐才茵 on 20/12/2018.

//  Copyright © 2018 徐才茵. All rights reserved.

//

#import "AppDelegate.h"

@interface AppDelegate ()

@end

@implementation AppDelegate

- (BOOL)application:(UIApplication*)application didFinishLaunchingWithOptions:(NSDictionary*)launchOptions {

    // Override point for customization after application launch.

    return YES;

}

- (void)applicationWillResignActive:(UIApplication*)application {

    // Sent when the application is about to move from active to inactive state. This can occur for certain types of temporary interruptions (such as an incoming phone call or SMS message) or when the user quits the application and it begins the transition to the background state.

    // Use this method to pause ongoing tasks, disable timers, and invalidate graphics rendering callbacks. Games should use this method to pause the game.

}

- (void)applicationDidEnterBackground:(UIApplication*)application {

    // Use this method to release shared resources, save user data, invalidate timers, and store enough application state information to restore your application to its current state in case it is terminated later.

    // If your application supports background execution, this method is called instead of applicationWillTerminate: when the user quits.

}

- (void)applicationWillEnterForeground:(UIApplication*)application {

    // Called as part of the transition from the background to the active state; here you can undo many of the changes made on entering the background.

}

- (void)applicationDidBecomeActive:(UIApplication*)application {

    // Restart any tasks that were paused (or not yet started) while the application was inactive. If the application was previously in the background, optionally refresh the user interface.

}

- (void)applicationWillTerminate:(UIApplication *)application {

    // Called when the application is about to terminate. Save data if appropriate. See also applicationDidEnterBackground:.

    // Saves changes in the application's managed object context before the application terminates.

    [selfsaveContext];

}

#pragma mark - Core Data stack

@synthesizepersistentContainer = _persistentContainer;

- (NSPersistentContainer *)persistentContainer {

    // The persistent container for the application. This implementation creates and returns a container, having loaded the store for the application to it.

    @synchronized (self) {

        if(_persistentContainer ==nil) {

            _persistentContainer = [[NSPersistentContainer alloc] initWithName:@"______1"];

            [_persistentContainer loadPersistentStoresWithCompletionHandler:^(NSPersistentStoreDescription *storeDescription, NSError *error) {

                if(error !=nil) {

                    // Replace this implementation with code to handle the error appropriately.

                    // abort() causes the application to generate a crash log and terminate. You should not use this function in a shipping application, although it may be useful during development.

                    /*

                     Typical reasons for an error here include:

                     * The parent directory does not exist, cannot be created, or disallows writing.

                     * The persistent store is not accessible, due to permissions or data protection when the device is locked.

                     * The device is out of space.

                     * The store could not be migrated to the current model version.

                     Check the error message to determine what the actual problem was.

                    */

                    NSLog(@"Unresolved error %@, %@", error, error.userInfo);

                    abort();

                }

            }];

        }

    }

    return_persistentContainer;

}

#pragma mark - Core Data Saving support

- (void)saveContext {

    NSManagedObjectContext *context =self.persistentContainer.viewContext;

    NSError *error =nil;

    if([context hasChanges] && ![context save:&error]) {

        // Replace this implementation with code to handle the error appropriately.

        // abort() causes the application to generate a crash log and terminate. You should not use this function in a shipping application, although it may be useful during development.

        NSLog(@"Unresolved error %@, %@", error, error.userInfo);

        abort();

    }

}

@end

//

//  Model.h

//  靠前瞎鸡儿信1

//

//  Created by 徐才茵 on 20/12/2018.

//  Copyright © 2018 徐才茵. All rights reserved.

//

#import

NS_ASSUME_NONNULL_BEGIN

@interface Model : NSObject

@property(nonatomic,assign)int ID;

@property (nonatomic,strong)NSString *imgsrc,*title;

@end

NS_ASSUME_NONNULL_END

//

//  Model.m

//  靠前瞎鸡儿信1

//

//  Created by 徐才茵 on 20/12/2018.

//  Copyright © 2018 徐才茵. All rights reserved.

//

#import "Model.h"

@implementation Model

- (void)setValue:(id)value forUndefinedKey:(NSString*)key{

}

@end

//

//  DataModel.h

//  靠前瞎鸡儿信1

//

//  Created by 徐才茵 on 20/12/2018.

//  Copyright © 2018 徐才茵. All rights reserved.

//

#import

NS_ASSUME_NONNULL_BEGIN

@interfaceDataModel :NSObject

+(DataModel*)sharedDataHandle;

//增

-(void)addOneMovie:(id)movie;

//删

-(void)deleteMovieByID:(int)delID;

//查

-(id)getAllMovies;

@end

NS_ASSUME_NONNULL_END

//

//  DataModel.m

//  靠前瞎鸡儿信1

//

//  Created by 徐才茵 on 20/12/2018.

//  Copyright © 2018 徐才茵. All rights reserved.

//

#import "DataModel.h"

#import"FMDB.h"

#import "Model.h"

staticDataModel*_defaulthandle =nil;

@interface DataModel ()

@property(nonatomic,strong)FMDatabase*fMDB;  //

@end

@implementation DataModel

+(DataModel*)sharedDataHandle

{

    if (_defaulthandle == nil) {

        _defaulthandle = [[DataModel alloc] init];

    }

    return _defaulthandle;

}

+(instancetype)allocWithZone:(struct_NSZone*)zone

{

    if (_defaulthandle == nil) {

        _defaulthandle= [superallocWithZone:zone];

    }

    return _defaulthandle;

}

-(FMDatabase *)fMDB

{

    if(!_fMDB) {

        NSString *path = [[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject] stringByAppendingPathComponent:@"movies.sqlite"];

        NSLog(@"path=====%@",path);

        _fMDB= [FMDatabasedatabaseWithPath:path];

        [selfinitTable];

    }

    return _fMDB;

}

// 初始化数据表

-(void)initTable

{

    [_fMDBopen];

    [_fMDB executeUpdate:@"CREATE TABLE movie (id INTEGER PRIMARY KEY AUTOINCREMENT,title TEXT,imgsrc TEXT)"];

    [_fMDBclose];

}

-(void)addOneMovie:(Model*)movie

{

    [self.fMDBopen];

    // [self.fMDB executeUpdate:@"insert into movie (name,actor,date,price) values(?,?,?,?)",movie.name,movie.actor ,movie.date ,movie.price];

    [self.fMDB executeUpdateWithFormat:@"insert into movie (title,imgsrc) values(%@,%@)",movie.title,movie.imgsrc ];

    [self.fMDBclose];

}

-(void)deleteMovieByID:(int)delID

{

    [self.fMDBopen];

    [self.fMDB executeUpdateWithFormat:@"DELETE FROM movie WHERE id = %d",delID];

    [self.fMDBclose];

}

-(NSArray*)getAllMovies

{

    [self.fMDBopen];

    NSMutableArray *arr = [[NSMutableArray alloc] init];

    FMResultSet *result = [self.fMDB executeQuery:@"SELECT * FROM movie"];

    while([resultnext])

    {

        Model*movie = [[Modelalloc]init];

        [arraddObject:movie];

        movie.ID= [resultintForColumnIndex:0];

        movie.title= [resultstringForColumnIndex:1];

        movie.imgsrc= [resultstringForColumnIndex:2];

    }

    [self.fMDBclose];

    return[arrcopy];

}

@end

//

//  ZDYTableViewCell.h

//  靠前瞎鸡儿信1

//

//  Created by 徐才茵 on 20/12/2018.

//  Copyright © 2018 徐才茵. All rights reserved.

//

#import

#import "Model.h"

#import "DataModel.h"

NS_ASSUME_NONNULL_BEGIN

@interfaceZDYTableViewCell :UITableViewCell

@property (weak, nonatomic) IBOutlet UIImageView *imgv;

@property (weak, nonatomic) IBOutlet UILabel *lable;

- (void)loadData:(Model*)mod;

@end

NS_ASSUME_NONNULL_END

//

//  ZDYTableViewCell.m

//  靠前瞎鸡儿信1

//

//  Created by 徐才茵 on 20/12/2018.

//  Copyright © 2018 徐才茵. All rights reserved.

//

#import "ZDYTableViewCell.h"

@implementationZDYTableViewCell

- (void)loadData:(Model*)mod{

    if(mod) {

        self.lable.text=mod.title;

        self.imgv.image=[UIImage imageWithData:[NSData dataWithContentsOfURL:[NSURL URLWithString:mod.imgsrc]]];

    }

}

- (void)awakeFromNib {

    [super awakeFromNib];

    // Initialization code

}

- (void)setSelected:(BOOL)selected animated:(BOOL)animated {

    [supersetSelected:selectedanimated:animated];

    // Configure the view for the selected state

}

@end

//

//  ViewController.h

//  靠前瞎鸡儿信1

//

//  Created by 徐才茵 on 20/12/2018.

//  Copyright © 2018 徐才茵. All rights reserved.

//

#import

@interfaceViewController :UIViewController

@end

//

//  ViewController.m

//  靠前瞎鸡儿信1

//

//  Created by 徐才茵 on 20/12/2018.

//  Copyright © 2018 徐才茵. All rights reserved.

//

#import "ViewController.h"

#import "Model.h"

#import "AFNetworking.h"

#import "ZDYTableViewCell.h"

#import "DataModel.h"

#import "xqViewController.h"

@interface ViewController ()<UITableViewDelegate,UITableViewDataSource>

@property (nonatomic,strong)UITableView *table;

@property (nonatomic,strong)NSMutableArray *data;

- (IBAction)gotoxq:(id)sender;

@end

staticNSString*oj =@"cell";

@implementation ViewController

- (void)viewDidLoad {

    [super viewDidLoad];

//    [self.table registerClass:[ZDYTableViewCell class] forCellReuseIdentifier:oj];

    [self.table registerNib:[UINib nibWithNibName:@"ZDYTableViewCell" bundle:nil] forCellReuseIdentifier:oj];

    self.data=[[NSMutableArray alloc]init];

    [self CreateAFNet];

    [self.viewaddSubview:self.table];

    NSArray *allData = [[DataModel sharedDataHandle] getAllMovies];

     _data= [NSMutableArrayarrayWithArray:allData];

    [self.table reloadData];

}

- (UITableView*)table{

    if(!_table) {

        _table=[[UITableView alloc]initWithFrame:self.view.frame];

        _table.delegate=self;

        _table.dataSource=self;

    }

    return _table;

}

- (NSInteger)tableView:(UITableView*)tableView numberOfRowsInSection:(NSInteger)section{

    return self.data.count;

}

-(UITableViewCell*)tableView:(UITableView*)tableView cellForRowAtIndexPath:(NSIndexPath*)indexPath{

    ZDYTableViewCell *cell=[tableView dequeueReusableCellWithIdentifier:oj];

    if(self.data.count>0) {

        Model*mod =self.data[indexPath.row];

        [cellloadData:mod];

    }

    returncell;

}

- (void)CreateAFNet{

    //  return;

    AFHTTPSessionManager *manager=[AFHTTPSessionManager manager];

    [managerGET:@"http://c.m.163.com/nc/article/headline/T1348647853363/0-20.html" parameters:nil headers:nil progress:^(NSProgress * _Nonnull downloadProgress) {

    }success:^(NSURLSessionDataTask*_Nonnulltask,id  _NullableresponseObject) {

        NSLog(@"%@",responseObject);

        for(NSDictionary*dicinresponseObject[@"T1348647853363"]) {

            Model*mod=[[Modelalloc]init];

            [modsetValuesForKeysWithDictionary:dic];

            [self.dataaddObject:mod];

        }

        [self.tablereloadData];

    }failure:^(NSURLSessionDataTask*_Nullabletask,NSError*_Nonnullerror) {

        NSLog(@"%@",error);

    }];

}

-(CGFloat)tableView:(UITableView*)tableView heightForRowAtIndexPath:(NSIndexPath*)indexPath{

    return 60;

}

-(void)tableView:(UITableView*)tableView didSelectRowAtIndexPath:(NSIndexPath*)indexPath {

    Model*mod =self.data[indexPath.row];

   [[DataModel sharedDataHandle] addOneMovie:mod];

    NSLog(@"添加了第%d行的数据",indexPath.row);

}

- (IBAction)gotoxq:(id)sender {

    xqViewController*xq=[xqViewController new];

    [self.navigationController pushViewController:xq animated:YES];

}

@end

//

//  xqViewController.h

//  靠前瞎鸡儿信1

//

//  Created by 徐才茵 on 20/12/2018.

//  Copyright © 2018 徐才茵. All rights reserved.

//

#import

NS_ASSUME_NONNULL_BEGIN

@interfacexqViewController :UIViewController

@end

NS_ASSUME_NONNULL_END

//

//  xqViewController.m

//  靠前瞎鸡儿信1

//

//  Created by 徐才茵 on 20/12/2018.

//  Copyright © 2018 徐才茵. All rights reserved.

//

#import "xqViewController.h"

#import "DataModel.h"

#import "Model.h"

#import "UIImageView+WebCache.h"

@interface xqViewController ()<UITableViewDelegate,UITableViewDataSource>

@property(nonatomic,strong)UITableView*table;

@property(nonatomic,strong)NSMutableArray*array;

@end

@implementationxqViewController

- (void)viewDidLoad {

    [super viewDidLoad];

    _table=[[UITableView alloc]initWithFrame:self.view.frame style:UITableViewStylePlain];

    _table.delegate=self;

    _table.dataSource=self;

    [self.view addSubview:_table];

    _array = [[DataModel sharedDataHandle] getAllMovies];

    [_table reloadData];

}

-(NSInteger)tableView:(UITableView*)tableView numberOfRowsInSection:(NSInteger)section{

    return_array.count;

}

-(UITableViewCell*)tableView:(UITableView*)tableView cellForRowAtIndexPath:(NSIndexPath*)indexPath{

    staticNSString*oj=@"cell";

    UITableViewCell*cell=[tableView dequeueReusableCellWithIdentifier:oj];

    if(!cell) {

        cell=[[UITableViewCell alloc]initWithStyle:UITableViewCellStyleDefault reuseIdentifier:oj];

    }

    Model*s  = [_arrayobjectAtIndex:indexPath.row];

    cell.textLabel.text= s.title;

    [cell.imageViewsd_setImageWithURL:[NSURLURLWithString:s.imgsrc]];

    returncell;

}

-(BOOL)tableView:(UITableView*)tableView canEditRowAtIndexPath:(NSIndexPath*)indexPath {

    return YES;

}

-(void)tableView:(UITableView*)tableView commitEditingStyle:(UITableViewCellEditingStyle)editingStyle forRowAtIndexPath:(NSIndexPath*)indexPath {

    Model*mod =self.array[indexPath.row];

    [[DataModel sharedDataHandle] deleteMovieByID:mod.ID];

    _array = [[DataModel sharedDataHandle] getAllMovies];

    [_table reloadData];

}

@end