FMDB的基本使用

// executeQuery:查询数据
//    [self.db executeQuery:(NSString *), ...];
    
    // 3. 更新
    // executeUpdate：除查询数据以外的其他操作
//    [self.db executeUpdate:(NSString *), ...]

// 1. 打开数据库
    NSString *path = [[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) lastObject] stringByAppendingPathComponent:@"shops.sqlite"];
    _db = [FMDatabase databaseWithPath:path];
    [_db open];

    // 2. 创表
    [_db executeUpdate:@"CREATE TABLE IF NOT EXISTS t_shop (id integer PRIMARY KEY, name text NOT NULL, price real);"];

// 得到结果集
    FMResultSet *set = [_db executeQuery:@"SELECT *FROM t_shop"];
    
    // 不断地往下取数据
    NSMutableArray *shops = [NSMutableArray array];
    while (set.next) {
        // 获得当前所指向的数据
        JYShop *shop = [[JYShop alloc] init];
        shop.name = [set stringForColumn:@"name"];
        shop.price = [set doubleForColumn:@"price"];
        [shops addObject:shop];
    }

[_db executeUpdateWithFormat:@"INSERT INTO t_shop(name, price) VALUES(%@,%f);",shop.name, shop.price];