Flutter在Debian上的数据库操作如何实现

<code>dependencies:
  flutter:
    sdk: flutter
  sqflite: ^latest_version
  path_provider: ^latest_version</code>

<code>import 'package:path/path.dart';
import 'package:path_provider/path_provider.dart';
import 'package:sqflite/sqflite.dart';

Future<Database> initializeDatabase() async {
  // 获取应用文档目录
  Directory documentsDirectory = await getApplicationDocumentsDirectory();
  // 创建或打开数据库
  return openDatabase(
    join(documentsDirectory.path, 'my_database.db'),
    version: 1,
    onCreate: (Database db, int version) async {
      // 创建表
      await db.execute('''
        CREATE TABLE my_table(
          id INTEGER PRIMARY KEY,
          name TEXT NOT NULL
        )
      ''');
    },
  );
}</code>

<code>// 插入数据
Future<void> insertData(String name) async {
  Database db = await initializeDatabase();
  await db.insert('my_table', {'name': name});
}

// 查询数据
Future<List<dynamic>> queryData() async {
  Database db = await initializeDatabase();
  return db.query('my_table');
}

// 更新数据
Future<void> updateData(int id, String newName) async {
  Database db = await initializeDatabase();
  await db.update('my_table', {'name': newName}, where: 'id = ?', whereArgs: [id]);
}

// 删除数据
Future<void> deleteData(int id) async {
  Database db = await initializeDatabase();
  await db.delete('my_table', where: 'id = ?', whereArgs: [id]);
}</code>

<code>Future<void> closeDatabase(Database db) async {
  await db.close();
}</code>