FMDB的使用方法

static FMDatabase * dataBase;

//sql语句+(instancetype)shardData{        static dispatch_once_t onceToken;        dispatch_once(&onceToken,^{                data = [[Data alloc]init];                [data initData];   });        return data;    }

+(instancetype)allocWithZone:(struct _NSZone*)zone{        if (data == nil){                data = [super allocWithZone:zone];            }   return data;      }

</pre><pre name="code" class="objc">//创建表<pre name="code" class="objc">-(void)initData{        //获取数据库的路径        NSString *strpath = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)[0];        //拼接路径        NSString *path = [strpath stringByAppendingString:@"FMDB.TABLE"];        //初始化数据表        dataBase = [[FMDatabase alloc]initWithPath:path];        //打开数据库        if ([dataBase open]) {                NSLog(@"打开成功");                [dataBase executeUpdate:@"create table Mondel(stu_id integer primary key autoincrement,name text,imageData text)"];    }    else   {        NSLog(@"打开失败");    }    }

//添加数据

-(BOOL)insertData:(Model *)mmoo{        //打开数据库        [dataBase open];        //创建插入语句        BOOL result = [dataBase executeUpdate:@"insert into Mondel(name,imageData)values(?,?)",mmoo.name,mmoo.imageData];        if (result) {        NSLog(@"添加成功");    }    else    {        NSLog(@"添加失败");    }        //关闭数据库        [dataBase close];        return result;}

//删除数据

-(BOOL)deleteData:(NSInteger)iidd{        //打开数据库        [dataBase open];        //创建删除语句        BOOL result =[dataBase executeUpdateWithFormat:@"delete from Mondel where stu_id = %ld",iidd];        if (result) {        NSLog(@"删除成功");    }        else    {        NSLog(@"删除失败");            }        //关闭数据库        [dataBase close];        return result;}

//修改数据

-(BOOL)updataData:(Model*)mmoo{        //打开数据库        [dataBase open];        //创建修改语句        BOOL result = [dataBase executeUpdateWithFormat:@"update Mondel set name = %@,imageData = %@ where stu_id = %ld",mmoo.name,mmoo.imageData,mmoo.stu_id];        if (result) {        NSLog(@"修改成功");    }    else    {        NSLog(@"修改失败");    }        //关闭数据库        [dataBase close];        return result;}

//查看数据

-(NSMutableArray *)selectData{        //打开数据库        [dataBase open];        //创建查找语句        FMResultSet *resultset = [dataBase executeQuery:@"select *from Mondel"];        NSMutableArray *Marr = [NSMutableArray array];        while ([resultset next]) {                Model *mon = [[Model alloc]init];                mon.stu_id = [resultset intForColumn:@"stu_id"];                mon.imageData = [resultset objectForColumnName:@"imageData"];                mon.name = [resultset stringForColumn:@"name"];                [Marr addObject:mon];            }        return Marr;}