在Java中读取csv

Question

我有一个csv，我正试图读入一个对象数组。我一直得到以下错误。。。JAVAutil。输入不匹配异常我认为这是因为它读取的文件是按空格分割的，而不是按逗号分割的。我想我需要用绳子。split（）方法，但我不确定具体怎么做。任何建议。这是我到目前为止的代码。。。

public class Prog7
{
public static void main(String[] args)
{
    Part[] parts;
    int numParts;
    int partNumber;
    String description;
    double price;
    int quantity;
    String city;

    parts = new Part[100];
    numParts = 0;

    Scanner inFile = null;

    /*
     * open file
     */
    try
    {
        inFile = new Scanner( new File( "C:/COSC        210/Assignment#7/parts.txt" ) );
    }
    catch ( FileNotFoundException e )
    {
        System.err.println( "Error: file not found" );
    }

    /*
     * read file using each record to create a State object
     * and add that State object to the PopulationData object
     */
    while( inFile.hasNext() )
    {
        partNumber = inFile.nextInt();
        description = inFile.next();
        price = inFile.nextDouble();
        city = inFile.next();
        quantity = inFile.nextInt();


        Part p = new Part(partNumber, description, price, 
                          quantity, city);
        parts[numParts]= p;
        numParts++;

        for (int i = 0; i < numParts; i++)
        {
            System.out.println(parts[i].getPartNumber());
        }
    }
}
}

以下是我正在使用的文本文件：

12345,Left-Handed Bacon Stretcher,125.95,PGH,2

24680,Smoke Shifter,0.98,PGH,48

86420, Pre-dug Post Hole,2.49,ATL,34

25632,Acme Widget,98.29,LOU,342

97531,Anti-Gravity Turbine,895.29,ATL,3

24680,Battery-Powered Battery Charger,252.98,ATL,2

12345,Left-Handed Bacon Stretcher,125.95,LOU,35

97531,Anti-Gravity Turbine,895.29,PHL,8

00000,Glass Hammer,105.90,PGH,8

86420, Pre-dug Post Hole, 2.49,ATL,34

01020,Inflatable Dartboard,32.95,PGH,453

86420, Pre-dug Post Hole, 2.49,LOU,68

86420, Pre-dug Post Hole, 2.49,PGH,124

24680, Battery-Powered Battery Charger, 252.98, PHL, 5

Answer 1

默认情况下，扫描程序使用空格作为分隔符。使用扫描仪。在读取文件之前使用分隔符（“，”）。

尽管如此，这并不是傻瓜式的，因为内容本身可能有，“

如果是为了学习，那就没问题，否则你可以找一些已经这样做的图书馆。http://sourceforge.net/projects/opencsv/files/opencsv/

此外，不要使用固定长度的100数组，而是使用列表，因为如果记录超过100条，代码将异常中断。

Answer 2

使用scanner.use分隔符(",");

    Scanner inFile = new Scanner(new File
                          ("C:/COSC        210/Assignment#7/parts.txt" ));
    inFile.useDelimiter(",");
    while (inFile.hasNext()) {
        int partNumber = Integer.parseInt(inFile.next());
        String description = inFile.next();
        double price = Double.parseDouble(inFile.next());
        String city = inFile.next();
        int quantity = Integer.parseInt(inFile.nextLine().replaceAll(",", ""));
        if(inFile.hasNextLine()) inFile.nextLine();
        System.out.println(partNumber+","
                +description+","
                +price+","
                +city+","
                +quantity);
    }
    inFile.close();