sqflite flutter中的AND语句

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

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

  // 查询年龄大于等于18且名字包含"John"的用户
  List<Map<String, dynamic>> users = await database.query(
    'users',
    where: 'age >= ? AND name LIKE ?',
    whereArgs: [18, '%John%'],
  );

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

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