在Sqflite中插入多条记录

import 'package:sqflite/sqflite.dart';

Future<void> insertMultipleRecords(List<Map<String, dynamic>> records) async {
  Database database = await openDatabase('your_database.db');
  try {
    await database.transaction((txn) async {
      for (var record in records) {
        await txn.insert('your_table', record);
      }
    });
  } catch (e) {
    print('Error inserting records: $e');
  } finally {
    await database.close();
  }
}

void main() {
  List<Map<String, dynamic>> records = [
    {'name': 'Record 1', 'value': 10},
    {'name': 'Record 2', 'value': 20},
    {'name': 'Record 3', 'value': 30}
  ];

  insertMultipleRecords(records);
}