从flutter中的DropDownButton捕获数据并将其发送到数据库

import 'package:flutter/material.dart';
import 'package:sqflite/sqflite.dart';
import 'package:path/path.dart';

class MyDropDownButton extends StatefulWidget {
  @override
  _MyDropDownButtonState createState() => _MyDropDownButtonState();
}

class _MyDropDownButtonState extends State<MyDropDownButton> {
  String selectedValue;
  List<String> options = ['Option 1', 'Option 2', 'Option 3'];

  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: Text('DropDownButton Example'),
      ),
      body: Center(
        child: DropdownButton<String>(
          value: selectedValue,
          onChanged: (String value) {
            setState(() {
              selectedValue = value;
              insertDataToDatabase(value); // 将数据插入到数据库
            });
          },
          items: options.map<DropdownMenuItem<String>>((String value) {
            return DropdownMenuItem<String>(
              value: value,
              child: Text(value),
            );
          }).toList(),
        ),
      ),
    );
  }

  Future<void> insertDataToDatabase(String value) async {
    // 连接到数据库
    final Future<Database> database = openDatabase(
      join(await getDatabasesPath(), 'my_database.db'),
      onCreate: (db, version) {
        // 创建数据库表
        return db.execute(
          'CREATE TABLE IF NOT EXISTS options(id INTEGER PRIMARY KEY, value TEXT)',
        );
      },
      version: 1,
    );

    // 插入数据到数据库表
    final Database db = await database;
    await db.insert(
      'options',
      {'value': value},
      conflictAlgorithm: ConflictAlgorithm.replace,
    );
  }
}

void main() {
  runApp(MaterialApp(
    home: MyDropDownButton(),
  ));
}