将NSDictionary数组写入SQLite3数据库

// 导入SQLite3的头文件
#import <sqlite3.h>

// 打开数据库连接
sqlite3 *database;
NSString *databasePath = @"path_to_database_file";
if (sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {
    // 创建数据库表
    NSString *createTableSQL = @"CREATE TABLE IF NOT EXISTS MyTable (id INTEGER PRIMARY KEY, key TEXT, value TEXT)";
    sqlite3_exec(database, [createTableSQL UTF8String], NULL, NULL, NULL);
    
    // 准备SQL语句
    NSString *insertSQL = @"INSERT INTO MyTable (key, value) VALUES (?, ?)";
    sqlite3_stmt *statement;
    if (sqlite3_prepare_v2(database, [insertSQL UTF8String], -1, &statement, NULL) == SQLITE_OK) {
        // 遍历NSDictionary数组
        NSArray *dictionaryArray = @[NSDictionary1, NSDictionary2, ...];
        for (NSDictionary *dictionary in dictionaryArray) {
            // 绑定参数
            NSString *key = [dictionary objectForKey:@"key"];
            NSString *value = [dictionary objectForKey:@"value"];
            sqlite3_bind_text(statement, 1, [key UTF8String], -1, SQLITE_TRANSIENT);
            sqlite3_bind_text(statement, 2, [value UTF8String], -1, SQLITE_TRANSIENT);
            
            // 执行SQL语句
            sqlite3_step(statement);
            
            // 重置SQL语句，以便下次使用
            sqlite3_reset(statement);
        }
    }
    
    // 释放资源
    sqlite3_finalize(statement);
    sqlite3_close(database);
}