reading amounts from a text file

[Raina Yukoma]

Hello, I am trying to modify the source code to read the sales amounts from a text file instead of the keyboard The code itself works and does that but it reads the text file and then asks me to input data. I am kind of a novice/intermediate so any advice would be greatly appreciated.
The purpose of this program:


Write a program that stores the weekly (Monday thru Friday) sales totals for three salespersons. Your program should read the sales amounts from a text file and print a sales report with headings, the daily totals for each salesperson (your two-dimensional array), the calculated weekly totals for each sales person and the calculated totals for the day of each salesperson. In addition, create a single-dimensional array of Strings representing the days of the week (Monday-Friday) using an initializer list.

Output Screen

Weekly Sales Report

Mon Tue Wed Thurs Fri Total

1 10.00 20.00 30.00 40.00 50.00 150.00
2 60.00 70.00 80.00 90.00 10.00 310.00
3 20.00 30.00 40.00 50.00 60.00 200.00
--------------------------------------------------------------
90.00 120.00 150.00 180.00 120.00 660.00

import java.io.* ;
import java.util.Scanner;

public class Sales {

    public static void main(String[] args) {
        int daysTotal = 0;
        int columnTotal = 0;
        int grandTotal = 0;
        //Array of 3 sales people for 5 days each
        int[][] a = new int[3][5];
        //Array of days
        String[] days = {"Monday", "Tuesday", "Wednesday", "Thursday", "Friday"};

        // The name of the file to open.
        String fileName = "input.txt";

        // This will reference one line at a time
        String line = null;

        try {
            // FileReader reads text files in the default encoding.
            FileReader fileReader =
                new FileReader(fileName);

            // Always wrap FileReader in BufferedReader.
            BufferedReader bufferedReader =
                new BufferedReader(fileReader);

            while((line = bufferedReader.readLine()) != null) {
                System.out.println(line);
            }

            // Always close files.
            bufferedReader.close();
        }
        catch(FileNotFoundException ex) {
            System.out.println(
                "Unable to open file '" +
                fileName + "'");
        }
        catch(IOException ex) {
            System.out.println(
                "Error reading file '"
                + fileName + "'");
            // Or we could just do this:
            // ex.printStackTrace();
        }



        //Scanner for input
        Scanner scan = new Scanner(System.in);

        //Loop through each salesperson
        for (int i = 0; i < a.length; i++) {
            int s = 0;
            //Loop through each day
            for (int j = 0; j < days.length; j++) {
                s += a[i][j];

                //Prompt for salesperson sales for specified day
                System.out.print("Enter " + days[j] + "'s Totals for Salesperson " + (i + 1) + ": ");
                //Get input
                int sales = scan.nextInt();
                //Assign in the array
                a[i][j] = sales;
            }


            System.out.println("Sales person" + (i + 1) + "Sales=" + s);
        }

        System.out.println(
            "\t" + "Mon" + "\t" + "Tue" + "\t" + "Wed" + "\t" + "Thu" + "\t" + "Fri" + "\t" + "Total\n");
        for (int k = 0; k < 3; k++) {
            System.out.print((k + 1) + "\t");

            for (int l = 0; l < 5; l++) {
                daysTotal = daysTotal + a[k][l];
                System.out.print(a[k][l] + "\t");
            }
            System.out.print(daysTotal + "\n");
            daysTotal = 0;

        }

        System.out.println("------------------------------------------------------");
        System.out.print("\t");

        for (int i = 0; i < 5; i++) {
            columnTotal = 0;

            for (int j = 0; j < 3; j++) {
                columnTotal += a[j][i];
            }

            System.out.print(columnTotal + "\t");
            grandTotal += columnTotal;
        }

        System.out.print(grandTotal);

    }
}

[Stuart A. Burkett]

Raina Yukoma wrote:..and then asks me to input data.

That's what the code starting at line 56 does. If you don't want that to happen, just take those lines out.

[Raina Yukoma]

Yes, but I also want the input data in the textfile be incorporated within similar output format in the sample I provided

[Stuart A. Burkett]

Use the String.split method to break up each line from the file into its constituent parts and then use Integer.parseInt to convert the substrings into integer values that you can store in your a array.