FMDB

//参数是一个block
-(void)executeSQL:(void (^)(FMDatabase *db))block{
    NSString *path = [NSString stringWithFormat:@"%@/Documents/db.sqlite",NSHomeDirectory()];
    FMDatabase *db = [[FMDatabase alloc] initWithPath:path];
    //打开开
    [db open];
    //执行sql语句
    block(db);
    //关闭
    [db close];
}

//创建数据库

- (IBAction)create:(id)sender {
    //创建table
    [self executeSQL:^(FMDatabase *db) {
        [db executeUpdate:@"create table if not exists userInfo(id integer primary key autoincrement,name varchar(256),age integer,image blob)"];
        //varchar
    }];

}

添加表格

- (IBAction)add:(id)sender {
    [self executeSQL:^(FMDatabase *db) {
        [db executeUpdate:@"insert into userInfo(name,age) values(?,?)", @"孙林泽", @"22"];
    }];
}

//删除

- (IBAction)delete:(id)sender {
    [self executeSQL:^(FMDatabase *db) {
        [db executeUpdate:@"delete from userInfo where name = ?", @"孙林泽"];
    }];
}

//修改

- (IBAction)modify:(id)sender {
    [self executeSQL:^(FMDatabase *db) {
        [db executeUpdate:@"update userInfo set name=?,age=?,image=? where name =?",@"李彩玉",@"18",@"孙林泽"];
    }];

}

//查询

- (IBAction)query:(id)sender {
    [self executeSQL:^(FMDatabase *db) {
        FMResultSet *result =[db executeQuery:@"select * from userInfo"];
        while ([result next]) {
            NSLog(@"name=%@",[result stringForColumn:@"name"]);
            NSLog(@"age=%d",[result intForColumn:@"age"]);
        }
    }];
}