使用RandomAccessFile修改CSV文件值时出现内容错乱问题求助

你用RandomAccessFile修改CSV时出现行内容拼接的问题，核心原因是没处理好换行符和行的实际字节长度，具体分析和解决方法如下：

问题根源 #

1. readLine()丢弃换行符：RandomAccessFile.readLine()会自动去掉行尾的\r或\n，你用line.length()获取的长度不包含换行符，导致写入时覆盖的范围比实际行（含换行）短，下一行的开头内容没被覆盖，就拼接到了修改行末尾。
2. 行长度变化处理不当：如果修改后的行长度和原行不一致，不管是更长还是更短，都会破坏后续行的结构——更长会覆盖下一行内容，更短会残留原行的多余字符（包括换行符）。
3. 未重新写入换行符：修改后没补换行符，直接导致两行合并。

解决方案 #

方案一：修正RandomAccessFile的使用逻辑 #

要准确计算每行的实际字节长度（包含换行符），写入时确保覆盖原行的所有字节，包括换行：

public static void updateVehicleData() {
    Scanner input = new Scanner(System.in);
    System.out.print("Please enter car number plate: ");
    String carPlate = input.nextLine();

    try {
        RandomAccessFile raf = new RandomAccessFile("vehicle.csv", "rw");
        String line;
        long currentPosition;
        while ((line = raf.readLine()) != null) {
            currentPosition = raf.getFilePointer();
            // 计算原行的实际字节数（包含被readLine丢弃的换行符）
            long lineStartPos = currentPosition - line.getBytes("ISO-8859-1").length;
            // 判断原文件的换行格式（Windows是\r\n，Linux是\n）
            int newlineLength = 0;
            if (currentPosition < raf.length()) {
                raf.seek(currentPosition - 1);
                byte b = raf.readByte();
                if (b == '\n') {
                    newlineLength = 1;
                    if (currentPosition > 1) {
                        raf.seek(currentPosition - 2);
                        b = raf.readByte();
                        if (b == '\r') {
                            newlineLength = 2;
                        }
                    }
                }
                raf.seek(currentPosition);
            }
            long totalLineLength = line.getBytes("ISO-8859-1").length + newlineLength;

            String[] vehicleData = line.split(",");
            if (carPlate.equals(vehicleData[0])) {
                final int CARSTATUS = 0;
                System.out.print("Please enter car sold price: ");
                String soldPrice = input.nextLine();

                // 构造带换行符的新行
                String updatedLine = carPlate + ","
                        + vehicleData[1] + ","
                        + vehicleData[2] + ","
                        + CARSTATUS + ","
                        + soldPrice;
                String updatedLineWithNewline = newlineLength == 2 
                    ? updatedLine + "\r\n" 
                    : updatedLine + "\n";

                // 回到原行开头写入新内容
                raf.seek(lineStartPos);
                raf.writeBytes(updatedLineWithNewline);

                // 若新行长度短于原行，用空格覆盖剩余字节避免残留
                long diff = totalLineLength - updatedLineWithNewline.getBytes("ISO-8859-1").length;
                if (diff > 0) {
                    for (int i = 0; i < diff; i++) {
                        raf.writeByte(' ');
                    }
                }

                raf.close();
                break;
            }
        }
        System.out.println("Successfully updated the vehicle data in vehicle.csv file.");

    } catch (IOException e) {
        System.out.println("An error occurred while updating vehicle data in vehicle.csv file.");
        e.printStackTrace();
    }
}

方案二：用临时文件修改（更稳妥） #

RandomAccessFile天生不适合处理文本文件的行修改（尤其是行长度变化的场景），更稳妥的方式是读取所有内容到内存，修改对应行后通过临时文件写回原文件：

public static void updateVehicleData() {
    Scanner input = new Scanner(System.in);
    System.out.print("Please enter car number plate: ");
    String carPlate = input.nextLine();

    File originalFile = new File("vehicle.csv");
    File tempFile = new File("temp_vehicle.csv");

    try (BufferedReader reader = new BufferedReader(new FileReader(originalFile));
         BufferedWriter writer = new BufferedWriter(new FileWriter(tempFile))) {

        String line;
        while ((line = reader.readLine()) != null) {
            String[] vehicleData = line.split(",");
            if (carPlate.equals(vehicleData[0])) {
                final int CARSTATUS = 0;
                System.out.print("Please enter car sold price: ");
                String soldPrice = input.nextLine();
                // 构造修改后的行
                String updatedLine = carPlate + ","
                        + vehicleData[1] + ","
                        + vehicleData[2] + ","
                        + CARSTATUS + ","
                        + soldPrice;
                writer.write(updatedLine);
            } else {
                writer.write(line);
            }
            writer.newLine(); // 保持换行格式
        }

        // 替换原文件
        if (!originalFile.delete()) {
            System.out.println("Failed to delete original file");
            return;
        }
        if (!tempFile.renameTo(originalFile)) {
            System.out.println("Failed to rename temp file to original");
        }

        System.out.println("Successfully updated the vehicle data in vehicle.csv file.");

    } catch (IOException e) {
        System.out.println("An error occurred while updating vehicle data in vehicle.csv file.");
        e.printStackTrace();
    } finally {
        // 清理未成功替换的临时文件
        if (tempFile.exists()) {
            tempFile.delete();
        }
    }
}

注意事项 #

• 方案二是处理文本文件修改的通用方式，避免了RandomAccessFile的编码和换行符兼容性问题。
• 实际开发中建议使用成熟的CSV库（如OpenCSV），可以处理复杂场景（比如字段包含逗号、引号的情况），避免手动拆分字符串出现问题。

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