flutter中sqllite中的多个参数

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

void main() async {
  // 打开数据库
  var database = await openDatabase(
    join(await getDatabasesPath(), 'my_database.db'),
    onCreate: (db, version) {
      // 创建表
      return db.execute(
        'CREATE TABLE IF NOT EXISTS my_table (id INTEGER PRIMARY KEY, name TEXT, age INTEGER)',
      );
    },
    version: 1,
  );

  // 插入数据
  await database.transaction((txn) async {
    var batch = txn.batch();
    batch.insert('my_table', {'name': 'John', 'age': 25});
    batch.insert('my_table', {'name': 'Jane', 'age': 30});
    await batch.commit();
  });

  // 查询数据
  var results = await database.rawQuery(
    'SELECT * FROM my_table WHERE age > ? AND age < ?',
    [20, 40],
  );

  // 输出结果
  results.forEach((row) {
    print('ID: ${row['id']}, Name: ${row['name']}, Age: ${row['age']}');
  });

  // 关闭数据库
  await database.close();
}