ios FMDB

1.创建继承NSObject 文件.Model
2.h中

//数据库必须得有一个主键id
@property(nonatomic,assign)NSInteger classid;

@property(nonatomic,copy)NSString *title;//标题

@property(nonatomic,copy)NSString *url;//跳转url

3.m

//找不到key值放空
-(void)setValue:(id)value forUndefinedKey:(NSString *)key{
    
}

4.创建继承NSObject SqlData
5…h

#import <Foundation/Foundation.h>
#import "DataModel.h"
NS_ASSUME_NONNULL_BEGIN

@interface SqlData : NSObject
//单利方法
+(instancetype)initData;
//初始化数据库
-(void)initSql;
//初始化表格
-(void)initTable;
//添加数据
-(void)addData:(id)data;
//删除数据
-(void)deleteData:(NSInteger )theid;
//查询数据
-(id)getDataArray;
//关闭数据库
-(void)closeSql;
@end

6.m

#import "SqlData.h"
#import "FMDB.h"
#import "DataModel.h"

static SqlData *sql;
static FMDatabase *db;

@implementation SqlData

+ (instancetype)initData{
    if (!sql) {
        sql = [[SqlData alloc]init];
    }
    return sql;
}

- (void)initSql{
    //创建路径
    NSString *str = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)firstObject];
    //拼接路径
    NSString *file = [str stringByAppendingString:@"movies.db"];
    //创建数据库
    db = [[FMDatabase alloc]initWithPath:file];
    if ([db open]) {
        NSLog(@"数据库打开");
        [self initTable];
    }else{
        NSLog(@"数据库打开失败");
    }
}

- (void)initTable{
    /