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"]);        }    }];}