基础用法请移步：Flutter 数据持久化-SQLite Sqflite数据库基础使用

进阶用法

分页查询

// 使用到的api
Future<List<Map<String, Object?>>> query(String table,
      {bool? distinct,
      List<String>? columns,
      String? where,
      List<Object?>? whereArgs,
      String? groupBy,
      String? having,
      String? orderBy,
      int? limit,
      int? offset});

// 主要用到的参数
limit，
offset，

实际应用场景展示

// 查询分页日志信息
  Future<List> obtainMessages({int limit = 20, int offset = 0}) async {
    var dbClient = await database;
    var result = await dbClient.query(logTableName,
        columns: [localID, type, title, description, content, remark, createTime, modifiedTime], limit: limit, offset: offset);
      // var result = await dbClient.rawQuery('SELECT * FROM $logTableName');

    return result.toList();
  }