SQLite

SQLiteTest.m

    // DB設定情報
    NSString *databaseName = @"main.db";
    NSString *path = @"/tmp";
    NSString *databasePath = [path stringByAppendingPathComponent:databaseName];
    FMDatabase *db  = [FMDatabase databaseWithPath:databasePath];

    // Query
    NSString *sql = @"select hoge1, hoge2 participants from hoge;";

    // Open DB
    [db open];

    // Execute Query
    FMResultSet *results = [db executeQuery:sql];
    
    // Output
    while ([results next]) {
        NSLog(@"%@, %@", [results stringForColumn:@"hoge1"], [results stringForColumn:@"hoge2"]);
    }
    
    // Release result set
    [results close];
    
    // Close DB
    [db close];