sqlite3 資料操作 添加

 sqlite3 * db = [Database openDB];

    sqlite3_stmt * stmt = nil;

    NSString * sqlString = [NSString stringWithFormat:@"insert into Student (name , age , gender ) values ('%@' , %ld ,'%@' )",studnt.name , (long)studnt.age ,studnt.gender];

    int result = sqlite3_prepare_v2(db, [sqlString UTF8String], -1, &stmt, nil);

    if (result == SQLITE_OK) {

           SQLITE_DONE 判斷語句執行完成.

        if (sqlite3_step(stmt) == SQLITE_DONE) {

            sqlite3_finalize(stmt);

            [Database closeDB];

            return YES;

        }

        NSLog(@"1錯誤");

    }

    NSLog(@"2錯誤");

    sqlite3_finalize(stmt);

    [Database closeDB];