sqlite3 c api 的简单使用

#import <Foundation/Foundation.h>
#import <sqlite3.h>

int main(int argc, const char * argv[])
{

    @autoreleasepool {
        
        sqlite3 *dataBase;
        NSString *filePath = @"/Users/wer/Documents/school.db";
        if(sqlite3_open_v2([filePath UTF8String], &dataBase, SQLITE_OPEN_READWRITE|SQLITE_OPEN_CREATE, NULL))
        {
            NSLog(@"Can Not Open Database!!");
            NSLog(@"%s",sqlite3_errmsg(dataBase));
        }
        
        NSString *sql = @"create table students(id integer Primary key, name text not null,age integer);insert into students(name,age) values('wer',12);insert into students(name,age) values('hae',13);";
        
        char *msg;
        if(sqlite3_exec(dataBase, [sql UTF8String ], NULL, NULL, &msg) != SQLITE_OK)
            NSLog(@"%s",msg);
        
        sql = @"select * from students";
        char **resule;
        int row = 0, Column= 0;
        
        sqlite3_get_table(dataBase, [sql UTF8String], &resule, &row, &Column, &msg);
        NSLog(@"%d %d",row,Column);
        
        for(int i = 0; i <= row; i++)
            for(int j = 0; j < Column; j++)
                NSLog(@"%s",resule[Column * i + j]);
        
        sqlite3_stmt *stmt;
        sqlite3_prepare(dataBase, [sql UTF8String], (int)strlen([sql UTF8String]), &stmt, NULL);
        
        while(sqlite3_step(stmt) == SQLITE_ROW)
            NSLog(@"%s = %s,%s = %d",sqlite3_column_name(stmt, 1), sqlite3_column_text(stmt, 1),sqlite3_column_name(stmt, 1),sqlite3_column_int(stmt, 2));
        sqlite3_finalize(stmt);
        
        sqlite3_close(dataBase);
    }
    return 0;
}