Question

in Java and is for intro level class

A hotel salesperson enters sales in a text file. Each line contains the following, separated by semicolons: The name of the client, the service sold (such as Dinner, Conference, Lodging, and so on), the amount of the sale, and the date of that event. Write a program that reads such a file and displays the total amount for each service category. Display an error if the file does not exist or the format is incorrect.

Now that you have completed the above, modify as follows:

Write a program that reads a text file as described above, and that writes a separate file for each service category, containing the entries for that category (this is not the total, but each entry). Name the output files Dinner.txt, Conference.txt, and so on.

input Text(hotelSale.txt)

Gallman;Dinner;1900;10/23/2019
Tony;Lodging;200;02/02/2012
Steve;Conference;100;12/25/2016
Tony;Conference;500;01/01/2017
Banner;Dinner;1900;07/04/2006

output Text(Dining.txt, Lodging.txt, Conference.txt)

Answer 1

Java Program:

/* Java Program that reads data from hotel sales and writes outputs to respective files */

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

class HotelSalesPerson
{
   //Main method
public static void main(String[] args) throws FileNotFoundException
   {
       //Scanner class object for reading from file
       Scanner reader = new Scanner(new File("hotelSale.txt"));
  
       //Writer class objects for writing data
       PrintWriter diningOut = new PrintWriter("Dining.txt");
       PrintWriter lodgingOut = new PrintWriter("Lodging.txt");
       PrintWriter conferenceOut = new PrintWriter("Conference.txt");
      
       double dinnerTotal = 0, conferenceTotal = 0, lodgingTotal = 0;
      
       //Iterate entire file is processed
       while (reader.hasNext())
       {
           //Reading a line
           String line = reader.nextLine();
          
           //Splitting line on semicolon
           String[] cols = line.split(";");
          
           //Conference Type
           if(cols[1].equals("Conference"))
           {
               conferenceTotal += Double.parseDouble(cols[2]);
               conferenceOut.printf("%.2f ", Double.parseDouble(cols[2]));
           }
          
           //Lodging Type
           else if(cols[1].equals("Lodging"))
           {
               lodgingTotal += Double.parseDouble(cols[2]);
               lodgingOut.printf("%.2f ", Double.parseDouble(cols[2]));
           }
          
           //Dinner Type
           else if(cols[1].equals("Dinner"))
           {
               dinnerTotal += Double.parseDouble(cols[2]);
               diningOut.printf("%.2f ", Double.parseDouble(cols[2]));
           }
       }
      
       //Closing reader
       reader.close();
      
       //Writing output to respective files
       System.out.printf("\n Dinner Total Sale: $%.2f \n", dinnerTotal);
       System.out.printf(" Conference Total Sale: $%.2f \n", conferenceTotal);
       System.out.printf(" Lodging Total Sale: $%.2f \n", lodgingTotal);
      
       //Closing files
       diningOut.close();
       conferenceOut.close();
       lodgingOut.close();
      
       System.out.println("\n Data has been processed and output has been written to respective files.... \n");
}
}

____________________________________________________________________________________________________

Sample Run: