Flutter SQLite数据库 #

dependencies:
  sqflite: ^2.3.0
  path: ^1.8.3

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

Future<Database> initDatabase() async {
  final path = join(await getDatabasesPath(), 'app.db');
  
  return openDatabase(
    path,
    onCreate: (db, version) {
      return db.execute(
        'CREATE TABLE users(id INTEGER PRIMARY KEY, name TEXT, email TEXT)',
      );
    },
    version: 1,
  );
}

final db = await initDatabase();

await db.insert('users', {'name': 'John', 'email': 'john@example.com'});

final users = await db.query('users');

await db.update(
  'users',
  {'name': 'Jane'},
  where: 'id = ?',
  whereArgs: [1],
);

await db.delete('users', where: 'id = ?', whereArgs: [1]);