Friday, January 31, 2014

PLEASE HELP! Java Error! "main" java.lang.NumberFormatException
































































































































































































































































Hello, I am a newbie to Java and I need to answer this question:
































































































































































































































































A comma-separated values (CSV) file is a simple text format used to store a list of records. A comma is used as a delimiter to separate the fields for each record. This format is commonly used to transfer data between a spreadsheet or database. In this Programming Project, consider a store that sells five products abbreviated as A, B, C, D, and E. Customers can rate each product from 1–5, where 1 is poor and 5 is excellent. The ratings are stored in a CSV file where each row contains the customer’s rating for each product. Here is a sample file with three customer ratings:
































































































































































































































































A,B,C,D,E































































































































































































































































3,0,5,1,2































































































































































































































































1,1,4,2,1































































































































































































































































0,0,5,1,3
































































































































































































































































In this file format, the first line gives the products. The digit 0 indicates that a customer did not rate a product. In this case, the first customer rated A as 3, C as 5, D as 1, and E as 2. Product B was not rated. The third customer rated C as 5, D as 1, and E as 3. The third customer did not rate A or B.
































































































































































































































































Create a text file in this format with sample ratings. Then, write a program that reads in this text file and extracts each rating using the StringTokenizer class. Finally, the program should output the average rating for each product. Customers that did not rate a product should not be considered when computing the average rating for that product. Your program can assume there will always be exactly five products but it should work with an arbitrary number of customer ratings.
































































































































































































































































My answer in Java is:
































































































































































































































































import java.io.BufferedReader;































































































































import java.io.FileNotFoundException;
































































































































































































































































import java.io.FileReader;
































































































































































































































































import java.io.IOException;
































































































































































































































































import java.util.Scanner;
































































































































































































































































public class StringTokenizer
































































































































































































































































{
































































































































































































































































int A;
































































































































































































































































int B;
































































































































































































































































int C;
































































































































































































































































int D;
































































































































































































































































int E;
































































































































































































































































public static void main(String [] args)
































































































































































































































































{
































































































































































































































































String line;
































































































































































































































































String ratings[];
































































































































































































































































StringTokenizer sT[]=new StringTokenizer[50];
































































































































































































































































String fileName;
































































































































































































































































Scanner input=new Scanner(System.in);
































































































































































































































































try
































































































































































































































































{
































































































































































































































































System.out.println("enter the text file name that contains cutomer rating records(ex- record.txt)");
































































































































































































































































fileName=input.nextLine();
































































































































































































































































FileReader file=new FileReader(fileName);
































































































































































































































































BufferedReader f = new BufferedReader(file);
































































































































































































































































int i=0;
































































































































































































































































while((line=f.readLine())!=null)
































































































































































































































































{
































































































































































































































































line=line.trim();
































































































































































































































































ratings=line.split(",");
































































































































































































































































sT[i]=new StringTokenizer();
































































































































































































































































sT[i].A=Integer.parseInt(ratings[0]);
































































































































































































































































sT[i].B=Integer.parseInt(ratings[1]);
































































































































































































































































sT[i].C=Integer.parseInt(ratings[2]);
































































































































































































































































sT[i].D=Integer.parseInt(ratings[3]);
































































































































































































































































sT[i].E=Integer.parseInt(ratings[4]);
































































































































































































































































i++;
































































































































































































































































}
































































































































































































































































float avgA=0;
































































































































































































































































float avgB=0;
































































































































































































































































float avgC=0;
































































































































































































































































float avgD=0;
































































































































































































































































float avgE=0;
































































































































































































































































System.out.println("customer rating records:");
































































































































































































































































System.out.println("A\tB\tC\tD\tE");
































































































































































































































































for(int j=0;j<i;j++)
































































































































































































































































{
































































































































































































































































System.out.println(sT[j].A+"\t"+sT[j].B+"\t"+sT[j].C+"\t"+sT[j].D+"\t"+sT[j].E+"\t");
































































































































































































































































avgA=avgA+sT[j].A;
































































































































































































































































avgB=avgB+sT[j].B;
































































































































































































































































avgC=avgC+sT[j].C;
































































































































































































































































avgD=avgD+sT[j].D;
































































































































































































































































avgE=avgE+sT[j].E;
































































































































































































































































}
































































































































































































































































System.out.println("average rating of A= "+avgA/i);
































































































































































































































































System.out.println("average rating of B= "+avgB/i);
































































































































































































































































System.out.println("average rating of C= "+avgC/i);
































































































































































































































































System.out.println("average rating of D= "+avgD/i);
































































































































































































































































System.out.println("average rating of E= "+avgE/i);
































































































































































































































































}catch(FileNotFoundException ex)
































































































































































































































































{
































































































































































































































































}
































































































































































































































































catch(IOException ex)
































































































































































































































































{
































































































































































































































































}
































































































































































































































































}
































































































































































































































































}
































































































































































































































































































































































































I have the txt file in the same folder as the java project. But, I am keep getting this ERROR!!































































































































































































































































Exception in thread "main" java.lang.NumberFormatException: For input string: "A"































































































































































































































































at java.lang.NumberFormatException.forInputString(Unk nown Source)































































































































































































































































at java.lang.Integer.parseInt(Unknown Source)































































































































































































































































at java.lang.Integer.parseInt(Unknown Source)































































































































































































































































at StringTokenizer.main(StringTokenizer.java:68)































































































































































































































































And line 68 is:































































































































































































































































sT[i].A=Integer.parseInt(ratings[0]);































































































































































































































































PLEASE HELP! ='(






























































































































































































































































































































































































No comments:

Post a Comment