如何使用flutter将dropdownbutton值插入数据库mysql

dependencies:
  mysql1: ^0.19.0

import 'package:mysql1/mysql1.dart';

Future<MySqlConnection> getConnection() async {
  final settings = ConnectionSettings(
    host: 'your_mysql_host',
    port: 3306,
    user: 'your_mysql_username',
    password: 'your_mysql_password',
    db: 'your_mysql_database',
  );

  return await MySqlConnection.connect(settings);
}

void insertData(String dropdownValue) async {
  final conn = await getConnection();

  try {
    await conn.query(
      'INSERT INTO your_table_name (column_name) VALUES (?)',
      [dropdownValue],
    );
    print('Data inserted successfully');
  } catch (e) {
    print('Error inserting data: $e');
  } finally {
    await conn.close();
  }
}

DropdownButton<String>(
  value: dropdownValue,
  onChanged: (String newValue) {
    setState(() {
      dropdownValue = newValue;
      insertData(dropdownValue); // 调用插入数据函数
    });
  },
  // 其他DropdownButton的属性
)