Flutter无法打开外置存储Documents目录下SQLite数据库求助

在Flutter项目中，我尝试读取外置存储Documents目录（/storage/emulated/0/Documents/）下预创建的SQLite数据库（包含4张表，用于读取展示数据），但始终报错文件不可读。仅使用应用私有目录（/data/data/com.example.mininventory/databases）时正常，但该目录无法通过USB访问，需要让数据库位于Documents目录并正常访问。

Flutter依赖 #

dependencies:
  flutter:
    sdk: flutter
  path_provider: ^2.0.2
  sqflite: ^2.2.6
  toast: ^0.2.9
  overlay_support: ^2.1.0
  intl: ^0.18.1
  permission_handler: ^10.0.0

DBHelper代码 #

class InwentaryzacjDbHelper {
  static final _directoryPath = '/storage/emulated/0/Documents/';
  static final _databaseName = 'InwentaryzacjaDane.db';
  static Database? _db;

  Future<Database?> get db async {
    if (_db != null) return _db;
    _db = await initDB();
    return _db;
  }

  initDB() async {
    try {
      if (await Permission.storage.request().isGranted) {
        io.Directory? dir = await getExternalStorageDirectory();
        String path = join(dir!.path, _directoryPath, _databaseName);
        io.File file = io.File(path);
        var theDB = await openDatabase(path, version: 1);
        print("Znaleziono bazę danych");
        return theDB;
      } else {
        throw Exception("Storage permission not granted");
      }
    } catch (e) {
      print("Błąd inicjalizacji bazy danych: $e");
      rethrow;
    }
  }
}

错误日志 #

E/SQLiteLog( 7986): (14) cannot open file at line 38589 of [b2325a6e1c]
E/SQLiteLog( 7986): (14) os_unix.c:38589: (13) open(/storage/emulated/0/Documents/InwentaryzacjaDane.db) -
E/SQLiteDatabase( 7986): Failed to open database '/storage/emulated/0/Documents/InwentaryzacjaDane.db'.
E/SQLiteDatabase( 7986): android.database.sqlite.SQLiteCantOpenDatabaseException: Cannot open database '/storage/emulated/0/Documents/InwentaryzacjaDane.db': File /storage/emulated/0/Documents/InwentaryzacjaDane.db is not readable

已配置的权限和申请逻辑 #

AndroidManifest.xml权限 #

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.MANAGE_EXTERNAL_STORAGE" />

权限申请按钮代码 #

onPressed: () async {
  PermissionStatus _permisionStatus =
      await Permission.storage.request();
  if (_permisionStatus == PermissionStatus.granted) {
    ScaffoldMessenger.of(context).showSnackBar(
        const SnackBar(
            content: Text("Permission storage")));
  }

  if (_permisionStatus == PermissionStatus.denied) {
    ScaffoldMessenger.of(context).showSnackBar(
        const SnackBar(
            content:
                Text("This permisison is recommended")));
  }
  if (_permisionStatus ==
      PermissionStatus.permanentlyDenied) {
    openAppSettings();
  }
},

解决方案 #

1. 修复路径拼接错误 #

你的代码中getExternalStorageDirectory()返回的是应用私有外部存储目录（比如/storage/emulated/0/Android/data/com.example.mininventory/files），再拼接硬编码的/storage/emulated/0/Documents/会生成错误路径。直接使用公共Documents目录的正确路径：

// 替换原路径拼接逻辑
String path = join('/storage/emulated/0/Documents/', _databaseName);

// 或者用API获取标准公共Documents目录（推荐）
io.Directory? publicDocsDir = await getExternalStoragePublicDirectory(DirectoryType.documents);
String path = join(publicDocsDir!.path, _databaseName);

2. 适配Android 10+分区存储规则 #

从Android 10（API 29）开始，普通读写权限无法直接访问公共Documents下的手动放置文件，需做以下处理：

• 在AndroidManifest.xml中添加兼容配置：

<application
    ...
    android:requestLegacyExternalStorage="true"> <!-- 适配Android 10 -->
</application>

• 修改权限申请逻辑，针对Android 11+申请MANAGE_EXTERNAL_STORAGE权限：

onPressed: () async {
  PermissionStatus permissionStatus;
  if (Platform.isAndroid) {
    // Android 11+ 需要申请所有文件访问权限
    permissionStatus = await Permission.manageExternalStorage.request();
  } else {
    permissionStatus = await Permission.storage.request();
  }

  if (permissionStatus == PermissionStatus.granted) {
    ScaffoldMessenger.of(context).showSnackBar(
      const SnackBar(content: Text("存储权限已获取")));
  } else if (permissionStatus == PermissionStatus.denied) {
    ScaffoldMessenger.of(context).showSnackBar(
      const SnackBar(content: Text("建议授予存储权限以正常使用功能")));
  } else if (permissionStatus == PermissionStatus.permanentlyDenied) {
    openAppSettings();
  }
},

3. 验证文件状态 #

打开数据库前先检查文件是否存在且可读：

io.File file = io.File(path);
if (!await file.exists()) {
  throw Exception("数据库文件不存在");
}
if (!await file.canRead()) {
  throw Exception("数据库文件不可读，请检查文件权限");
}
var theDB = await openDatabase(path, version: 1);

4. 备选方案：使用存储访问框架（SAF） #

若不想申请MANAGE_EXTERNAL_STORAGE权限（避免Google Play审核问题），可让用户手动选择数据库文件：

// 引入file_picker依赖：file_picker: ^5.2.1
final result = await FilePicker.platform.pickFiles(
  type: FileType.custom,
  allowedExtensions: ['db'],
);
if (result != null) {
  String path = result.files.single.path!;
  var theDB = await openDatabase(path, version: 1);
  // 后续数据库操作
}

内容的提问来源于stack exchange，提问作者OnePanic