Flutter删除sqllite中的所有行

dependencies:
  sqflite: ^2.0.0
  path_provider: ^2.0.2

import 'package:sqflite/sqflite.dart';
import 'package:path_provider/path_provider.dart';
import 'package:path/path.dart';

Future<Database> openDatabaseConnection() async {
  final directory = await getApplicationDocumentsDirectory();
  final path = join(directory.path, 'your_database.db');

  return await openDatabase(
    path,
    version: 1,
    onCreate: (db, version) {
      // 在此处定义数据库表结构
    },
  );
}

// 调用打开数据库连接的函数
Database database = await openDatabaseConnection();

await database.delete('your_table');

await database.close();

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

void main() async {
  WidgetsFlutterBinding.ensureInitialized();
  final Database database = await openDatabaseConnection();
  await deleteAllRows(database);
  await database.close();
}

Future<Database> openDatabaseConnection() async {
  final directory = await getApplicationDocumentsDirectory();
  final path = join(directory.path, 'your_database.db');

  return await openDatabase(
    path,
    version: 1,
    onCreate: (db, version) {
      // 在此处定义数据库表结构
    },
  );
}

Future<void> deleteAllRows(Database database) async {
  await database.delete('your_table');
}