flutter中sqllite中的多个参数

import 'package:sqflite/sqflite.dart';

void insertData(Database db, String tableName, Map<String, dynamic> data) async {
  try {
    await db.insert(
      tableName,
      data, // 这里传递了一个Map，包含了多个参数
      conflictAlgorithm: ConflictAlgorithm.replace,
    );
  } catch (e) {
    print("Error inserting data: $e");
  }
}

void main() async {
  final database = await openDatabase(
    'my_database.db',
    version: 1,
    onCreate: (db, version) {
      return db.execute(
        "CREATE TABLE my_table(id INTEGER PRIMARY KEY, name TEXT, age INTEGER)",
      );
    },
  );

  Map<String, dynamic> newData = {
    'name': 'John Doe',
    'age': 30,
  };

  await insertData(database, 'my_table', newData);
}

await db.execute(
  "INSERT INTO my_table(name, age) VALUES(?, ?)",
  [newData['name'], newData['age']], // 使用列表传递多个参数
);