使用swipe - Sqflite从数据库中删除项目

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

void main() {
  runApp(MyApp());
}

class MyApp extends StatelessWidget {
  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      home: Scaffold(
        appBar: AppBar(title: Text('Swipe to Delete Example')),
        body: TodoList(),
      ),
    );
  }
}

class TodoList extends StatefulWidget {
  @override
  _TodoListState createState() => _TodoListState();
}

class _TodoListState extends State<TodoList> {
  List<Map<String, dynamic>> _todos = [];
  Database _db;

  @override
  void initState() {
    super.initState();
    _initDatabase();
  }

  Future<void> _initDatabase() async {
    _db = await openDatabase(
      'todos.db',
      version: 1,
      onCreate: (db, version) {
        return db.execute(
          'CREATE TABLE todos(id INTEGER PRIMARY KEY, title TEXT)',
        );
      },
    );
    _loadTodos();
  }

  Future<void> _loadTodos() async {
    final List<Map<String, dynamic>> todos = await _db.query('todos');
    setState(() {
      _todos = todos;
    });
  }

  Future<void> _deleteTodo(int id) async {
    await _db.delete(
      'todos',
      where: 'id = ?',
      whereArgs: [id],
    );
    _loadTodos();
  }

  @override
  Widget build(BuildContext context) {
    return ListView.builder(
      itemCount: _todos.length,
      itemBuilder: (context, index) {
        return SwipeAction(
          actions: <SwipeAction>[
            SwipeAction(
              title: 'Delete',
              onTap: () => _deleteTodo(_todos[index]['id']),
              color: Colors.red,
            ),
          ],
          child: ListTile(
            title: Text(_todos[index]['title']),
          ),
        );
      },
    );
  }
}