应用重装后SQLite数据库导入失败问题求助及代码排查

问题描述 #

导出SQLite数据库用于应用重装后恢复，当前导出可成功完成，但重装应用后无法找到备份文件且无法访问；未卸载重装时导入功能正常。此外调用file.exists()显示文件存在，但实际未完成导入。

用户提供的导出代码：

public boolean exportDB() {
    StorageManager storageManager = (StorageManager) context.getSystemService(STORAGE_SERVICE);
    StorageVolume storageVolume = storageManager.getStorageVolumes().get(0);
    File folder = null;
    if (android.os.Build.VERSION.SDK_INT >= android.os.Build.VERSION_CODES.R)
        folder = new File(storageVolume.getDirectory().getPath() + "/Documents");
    boolean success = true;
    assert folder != null;
    if (!folder.exists())
        success = folder.mkdirs();
    if (success) {
        DirectoryName = folder.getPath() + File.separator + "MMS-" + new SimpleDateFormat("dd-MM-yyyy-HH-mm-ss", Locale.ENGLISH).format(new Date());
        folder = new File(DirectoryName);
        if (!folder.exists())
            success = folder.mkdirs();
        if (success)
            try {
                File dbFile = new File(context.getDatabasePath(DATABASE_NAME).getAbsolutePath());
                FileInputStream fis = new FileInputStream(dbFile);
                String outFileName = DirectoryName + File.separator + DATABASE_NAME ;
                OutputStream output = Files.newOutputStream(Paths.get(outFileName));
                byte[] buffer = new byte[1024];
                int length;
                while ((length = fis.read(buffer)) > 0)
                    output.write(buffer, 0, length);
                output.flush();
                output.close();
                fis.close();
            } catch (IOException e) {
                success = false;
            }
    } else
        Toast.makeText(context, "Cannot create folder.", Toast.LENGTH_SHORT).show();
    return success;
}

用户提供的导入代码：

public boolean importDB(String dbPath) throws IOException {
    String DB_FILEPATH = context.getDatabasePath(DATABASE_NAME).getAbsolutePath();
    close();
    File newDb = new File(dbPath);
    File oldDb = new File(DB_FILEPATH);
    if (newDb.exists()) {
        FileInputStream fromFile = new FileInputStream(newDb);
        FileOutputStream toFile = new FileOutputStream(oldDb);
        FileChannel fromChannel = null;
        FileChannel toChannel = null;
        try {
            fromChannel = fromFile.getChannel();
            toChannel = toFile.getChannel();
            fromChannel.transferTo(0, fromChannel.size(), toChannel);
        } finally {
            try {
                if (fromChannel != null)
                    fromChannel.close();
            } finally {
                if (toChannel != null)
                    toChannel.close();
            }
        }
        getWritableDatabase().close();
        return true;
    }
    return false;
}

问题根源 #

1. Android 10+ Scoped Storage限制：重装应用后，原应用创建的文件会被系统标记为私有，新应用无直接访问权限，导致找不到文件。
2. 路径获取不规范：直接拼接storageVolume.getDirectory().getPath() + "/Documents"不符合Scoped Storage规范，无法保证跨版本和重装后的访问性。
3. 导入逻辑缺陷：未确保数据库完全关闭，文件拷贝过程无完整性验证，异常未被有效捕获，导致file.exists()返回true但文件实际损坏。

解决方案 #

1. 修正导出逻辑，适配Scoped Storage #

优先使用**存储访问框架(SAF)**让用户选择备份保存位置，这是Android 10+推荐的跨应用/重装后访问文件的方式：

// 在Activity中启动SAF选择保存路径
public void startExport() {
    Intent intent = new Intent(Intent.ACTION_CREATE_DOCUMENT);
    intent.addCategory(Intent.CATEGORY_OPENABLE);
    intent.setType("application/octet-stream");
    String backupFileName = "MMS-" + new SimpleDateFormat("dd-MM-yyyy-HH-mm-ss", Locale.ENGLISH).format(new Date()) + ".db";
    intent.putExtra(Intent.EXTRA_TITLE, backupFileName);
    
    // 使用ActivityResultContracts处理返回结果
    registerForActivityResult(new ActivityResultContracts.StartActivityForResult(), result -> {
        if (result.getResultCode() == Activity.RESULT_OK && result.getData() != null) {
            Uri backupUri = result.getData().getData();
            boolean exportSuccess = performExport(backupUri);
            Toast.makeText(this, exportSuccess ? "导出成功" : "导出失败", Toast.LENGTH_SHORT).show();
        }
    }).launch(intent);
}

// 执行实际导出操作
private boolean performExport(Uri backupUri) {
    try {
        File dbFile = new File(getDatabasePath(DATABASE_NAME).getAbsolutePath());
        FileInputStream fis = new FileInputStream(dbFile);
        OutputStream output = getContentResolver().openOutputStream(backupUri);
        
        byte[] buffer = new byte[1024];
        int length;
        while ((length = fis.read(buffer)) > 0) {
            output.write(buffer, 0, length);
        }
        
        output.flush();
        output.close();
        fis.close();
        return true;
    } catch (IOException e) {
        e.printStackTrace();
        return false;
    }
}

若需使用公共Documents目录，需配置权限并兼容旧存储模型：

• 在AndroidManifest.xml中添加：

  <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
  <uses-permission android:name="android.permission.MANAGE_EXTERNAL_STORAGE" android:minSdkVersion="30" />
  
  <application
      ...
      android:requestLegacyExternalStorage="true">
  

• 修改导出路径获取：

  File docsFolder = Environment.getExternalStoragePublicDirectory(Environment.DIRECTORY_DOCUMENTS);
  String backupDirName = "MMS-" + new SimpleDateFormat("dd-MM-yyyy-HH-mm-ss", Locale.ENGLISH).format(new Date());
  File backupDir = new File(docsFolder, backupDirName);
  
  if (!backupDir.exists() && !backupDir.mkdirs()) {
      Toast.makeText(context, "无法创建备份目录", Toast.LENGTH_SHORT).show();
      return false;
  }
  
  String outFileName = new File(backupDir, DATABASE_NAME).getAbsolutePath();
  // 后续文件拷贝逻辑不变
  

2. 修复导入逻辑，确保文件完整导入 #

public boolean importDB(String dbPath) {
    String targetDbPath = context.getDatabasePath(DATABASE_NAME).getAbsolutePath();
    File backupFile = new File(dbPath);
    
    if (!backupFile.exists()) {
        return false;
    }
    
    // 先删除旧数据库，避免文件占用
    context.deleteDatabase(DATABASE_NAME);
    
    try (FileInputStream fromStream = new FileInputStream(backupFile);
         FileOutputStream toStream = new FileOutputStream(targetDbPath);
         FileChannel fromChannel = fromStream.getChannel();
         FileChannel toChannel = toStream.getChannel()) {
        
        long transferredBytes = fromChannel.transferTo(0, fromChannel.size(), toChannel);
        // 验证拷贝字节数是否一致
        if (transferredBytes != fromChannel.size()) {
            return false;
        }
        
        // 验证数据库完整性
        SQLiteDatabase db = SQLiteDatabase.openDatabase(targetDbPath, null, SQLiteDatabase.OPEN_READONLY);
        db.close();
        return true;
        
    } catch (IOException e) {
        e.printStackTrace();
        return false;
    }
}

• 使用try-with-resources自动关闭流，避免资源泄漏；
• 删除旧数据库防止文件被占用；
• 验证拷贝字节数，确保文件完整；
• 打开数据库验证完整性，避免导入损坏文件。

3. 处理重装后的文件访问 #

• 若使用SAF导出，导入时需再次通过SAF让用户选择备份文件，确保新应用获得文件访问权限；
• 若使用公共目录，需在应用启动时检查并申请MANAGE_EXTERNAL_STORAGE权限（Android 11+）；
• 不要仅依赖file.exists()判断文件可用性，应尝试打开文件流验证实际访问权限。

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