java - ArrayIndexOutOfBoundsException

Question

我正在将一个 csv 的每一行与另一个 csv 的每一行进行比较以查找匹配项。然后，我需要添加第二个 csv 中的一些元素和第一个 csv 中的一些元素，并将其写入新文件。它适用于 csv 的第一行，然后获取 ArrayIndexOutOfBoundsException 。我了解数组的工作原理，并且检查了我的 csv，据我所知，我没有超出范围。

第一个 csv 有 8 个字段，包含所有客户信息。第二个有 15 个字段，保存客户的销售信息。如果有销售记录，前 2 个字段 [0] 和 [1] 在两个 csv 中是相同的。

如果有人可以快速浏览一下，我可能会错过一些愚蠢的东西。

Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 3
        at excel.parse.ExcelParse.main(ExcelParse.java:61)

package excel.parse;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.File;
import java.io.IOException;


public class ExcelParse {

/**
 * @param args the command line arguments
 */
public static void main(String[] args) {
    String csvFile2 = "\\\\SBS2011\\RedirectedFolders\\Josh.Hickinbotham\\My Documents\\Customer_Sales_Trends_Summary_by_Sales_Order_114641390.csv";
    String csvFile1 = "\\\\SBS2011\\RedirectedFolders\\Josh.Hickinbotham\\My Documents\\All_Customers_Listing_for_Rep_114337469.csv";
    BufferedReader br = null;
    BufferedReader br2 = null;
    BufferedWriter bw = null;
    String line = "";
    String line2 = "";
    String csvSplitBy = ",";
    Boolean match = false;

    try {

        br = new BufferedReader(new FileReader(csvFile1));
        bw = new BufferedWriter(new FileWriter("\\\\SBS2011\\RedirectedFolders\\Josh.Hickinbotham\\My Documents\\newcsv.txt"));
        while ((line = br.readLine()) != null) {

            // use comma as separator
            String[] customer = line.split(csvSplitBy);
            System.out.println(customer[1]);
            br2 = new BufferedReader(new FileReader(csvFile2));
            while ((line2 = br2.readLine()) != null) {
                String[] file2 = line2.split(csvSplitBy);

                if (customer[1].equals(file2[1])) {
                    match = true;                        
                    bw.write(customer[0] + "," + customer[1] + "," + customer[2] + "," + customer[3] + "," + customer[4] + ","
                        + customer[5] + "," + customer[6] + "," + customer[7] + ","+ file2[2] +","+ file2[3] + "," + file2[4] + "," + file2[5] + ","
                        + file2[6] + "," + file2[7] + "," + file2[8] + "," + file2[9] + "," + file2[10] + "," + file2[11] + "," + file2[12] + ","
                        + file2[13] + "," + file2[14]+"\r\n");
                    System.out.println(":::MATCH " +customer[1]+" : "+file2[1]+" :::");
                } else {
                    match = false;
                }
            }
            if (match == false) {
                bw.write(customer[0] + "," + customer[1] + "," + customer[2] + "," + customer[3] + "," + customer[4] + ","
                    + customer[5] + "," + customer[6] + "," + customer[7] + "," + "," + "," + "," + "," + "," + "," + "," + "," + "," + ","
                    + "," + ","+"\r\n");
            }
        }

    } catch (FileNotFoundException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    } finally {
        if (br != null) {
            try {
                br.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        if (br2 != null) {
            try {
                br2.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        if (bw != null) {
            try {
                bw.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }          
    }
    System.out.println("Done");
}
}

Answer 1

尝试在进入 if match == false 之前显示 customer 是什么。可能有助于了解您到底在处理什么。 :)