Question

hey, this is a filei/o homework. um please show me how to do this (im using ONLY arraylist for the first part so please continue on that) i have put my work please fix some mistakes and continue on it. the file is named “tools.txt” its a text document file that i savedin the netbeansprojects file. um pleas euse netbeans and show me the output afterwards, make it simple and continue on what i have worked on whilw fixing some erros. ( please make it so good that when i put it in netbeans it runs beautifuly) and answer all. THANK U

works Price Mat ARC Date in ID Name Rubber Aluminum 14 9 13 true 920.0 05/02/1958 19/05/1965 12/01/1921 04/01/1971 17/02/1975 knife 7 10 9 true 4 680.0 handsaw 593 true 6 14 12 320.0 Iron steel wool Pump wood screw plane 452 8 true 4 6 450.0 Paper Paper Aluminum Gold 22 true 1 2 960.0 831 true 3 14 01/07/1914 910.0 585 12 14 12 true 22/09/1917 02/07/2007 10/10/1929 20/03/1934 17/04/1931 01/02/1990 11/03/1921 13/06/1962 15/10/1952 14/11/1998 03/10/1978 06/06/1929 26/11/1984 15/09/1969 23/04/1949 25/05/1922 260.0 894 screw true Plastic Gold 2 5 14 370.0 socket wrench 846 12 12 0 true pipe cutter wire stripper 240.0 559 0 12 13 true 800.0 Rubber 319 12 13 14 bolt 330.0 Rubber true 630 false vise 600.0 2 5 2 711 Stone Leather masonry bit paint roller circular saw 390.0 .1 7 3 true 817 990.0 3 12 15 9 9 Rubber Glass Fabric true 757 870.0 985 true Ruler 0.0 520 15 6 13 true level screwdriver bits 655 270.0 Rubber Fabric 7 2 12 true 140.0 310.0 1000.0 500 13 2 true Magnet 491 Steel false 14 10 4 Plastic フフ12 spanner Allen key 532 true 234 800.0 500.e 630.0 290.0 Steel Plastic 1 10 true T2 12 2 true 768 ax Wheel 386 08/11/1942 Rubber 8 5 11 true Bucket mallet 406 24/09/1944 26/01/1942 22/05/1942 01/05/1982 08/08/2011 25/05/1926 Fabric 7 10 13 true 772 30.0 Nood 10 12 13 true socket drill bit needle-nose pliers 515 770.0 Wood e 11 15 8 13 2 3 true 2 11 true true 26 540.0 580.0 Leather Rubber Plastic 2 13 true 420 hammer 159 738 400.0 2 glue gun 5ocket wrench level pipe cutter niter block ww.needle-nose pliers 17/03/1934 350.0 520.0 Gold Ceramic 6 14 12 true 55 3/11/1977 26/12/1942 270.0 Paper 28/10/1965 23/10/1932 23/01/1975 26/02/1938 19/08/1959 20/05/1905 05/08/ 197 9 10 4 true 114 9 3 12 true 378 172 90.0 Brass Plastic Wood Fabric Gold false e 10 16 320.0 e90.0 e10.0 10 11 4 true false 588 6 13 14 15 10 orace needle-nose piiers 632 445 true 660.0 650.0 200.0 13 2 2 false fretsa 210 Stone 15 7 tnue Sweepen phillips screwdeiven 790 Stone Do the following steps: 1. Download the data file: "lab02b-tools.txt" 2. Write a program with a while loop and switch structure and a menu with these tasks/options: a. Load file: reads the data file one line at a time and saves the respective values into appropriate arraylists (each column in a separate arraylist) or you could use parallel arrays or one 2D Object array b. Find number of tools. c. Find number of records for the same tool name. e.g How many Knives? d. Find all tools that> a price e. Find all tools that

Answer 1

Please find the code below with appropriate comments.

............................................................CODE STARTS HERE.................................................................

import java.util.*;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileWriter;

public class Lab02
{
    private static ArrayList<String> name = new ArrayList<>();
   private static ArrayList<Integer> id = new ArrayList<>();
   private static ArrayList<Integer[]> date = new ArrayList<>();
   private static ArrayList<Float> price = new ArrayList<>();
   private static ArrayList<String> material = new ArrayList<>();
   private static ArrayList<Integer> shelf = new ArrayList<>();
   private static ArrayList<Integer> row = new ArrayList<>();
   private static ArrayList<Integer> col = new ArrayList<>();
   private static ArrayList<Boolean> works = new ArrayList<>();
   private static FileWriter writer; // file writer used for writing to output file
   private static boolean isScreenOutput = true; // if output is printed to screen
   private static boolean isFileOutput = true; // if output is saved to file
  
   private static boolean load(String filename) // Object loader
   {
        File f1 = new File(filename); // Input file tools.txt
       try
       {
            Scanner fin = new Scanner(f1);
            fin.nextLine();
            fin.nextLine();
          
            while(fin.hasNext())
            {
                name.add(fin.next());
                id.add(fin.nextInt());
                String[] d = fin.next().split("/");
                Integer[] d1 = new Integer[3];
                d1[0] = Integer.parseInt(d[0]);
                d1[1] = Integer.parseInt(d[1]);
                d1[2] = Integer.parseInt(d[2]);
                date.add(d1);
                price.add(fin.nextFloat());
                material.add(fin.next());
                shelf.add(fin.nextInt());
                row.add(fin.nextInt());
                col.add(fin.nextInt());
                works.add(fin.nextBoolean());
            }
          
            fin.close();
            return true;
        }
        catch (FileNotFoundException e) {
            System.out.println("File not found");
            return false;
        }
   }
  
   private static int numTools()
   {
        Set<Integer> uniqueId = new HashSet<>();
        uniqueId.addAll(id); // Add all to a set, so duplicates are removed
        return uniqueId.size(); // Size of the set is the number of unique tools
   }
  
   private static int numRecords(String tool)
   {
        return Collections.frequency(name, tool); // In build function which returns the number of occurrences of a keyword
   }
  
   private static ArrayList<String> priceGreaterThan(float priceGiven)
   {
        ArrayList<String> newTools = new ArrayList<>();
        for(int i=0 ; i<price.size() ; i++) // Iterate over all rows
        {
            if (price.get(i) > priceGiven) // Check if price greater
            {
                newTools.add(name.get(i));
            }
        }
        return newTools;
   }
  
   private static ArrayList<String> priceLessThan(float priceGiven)
   {
        ArrayList<String> newTools = new ArrayList<>();
        for(int i=0 ; i<price.size() ; i++)
        {
            if (price.get(i) < priceGiven) // Check if price lesser
            {
                newTools.add(name.get(i));
            }
        }
        return newTools;
   }
  
   private static ArrayList<String> dateNewerThan(int year)
   {
        ArrayList<String> newTools = new ArrayList<>();
        for(int i=0 ; i<date.size() ; i++)
        {
            if (date.get(i)[2] > year) // Check if date newer
            {
                newTools.add(name.get(i));
            }
        }
        return newTools;
   }
  
   private static ArrayList<String> dateOlderThan(int year)
   {
        ArrayList<String> newTools = new ArrayList<>();
        for(int i=0 ; i<date.size() ; i++)
        {
            if (date.get(i)[2] < year) // Check if date older
            {
                newTools.add(name.get(i));
            }
        }
        return newTools;
   }
  
   private static ArrayList<String> dateBetween(int year1, int year2)
   {
        ArrayList<String> newTools = new ArrayList<>();
        for(int i=0 ; i<date.size() ; i++)
        {
            if (year1 < date.get(i)[2] && date.get(i)[2] < year2) // Check if date between
            {
                newTools.add(name.get(i));
            }
        }
        return newTools;
   }
  
   private static int age(int idGiven)
   {
        int pos = id.indexOf(idGiven);
        int d = date.get(pos)[2];
        int curYear = Calendar.getInstance().get(Calendar.YEAR); // Current year
        return curYear-d; // Age is 'current year - year'
   }
  
   private static ArrayList<String> onShelf(int shelfGiven)
   {
        ArrayList<String> newTools = new ArrayList<>();
        for(int i=0 ; i<shelf.size() ; i++)
        {
             if (shelf.get(i) == shelfGiven) // On same shelf
             {
                 newTools.add(name.get(i));
             }
        }
        return newTools;
   }
  
   private static ArrayList<String> onRow(int rowGiven)
   {
        ArrayList<String> newTools = new ArrayList<>();
        for(int i=0 ; i<row.size() ; i++)
        {
             if (row.get(i) == rowGiven) // In same row
             {
                 newTools.add(name.get(i));
             }
        }
        return newTools;
   }
  
   private static ArrayList<String> onColumn(int colGiven)
   {
        ArrayList<String> newTools = new ArrayList<>();
        for(int i=0 ; i<col.size() ; i++)
        {
             if (col.get(i) == colGiven) // In same column
             {
                 newTools.add(name.get(i));
             }
        }
        return newTools;
   }
  
   private static ArrayList<String> working()
   {
        ArrayList<String> newTools = new ArrayList<>();
        for(int i=0 ; i<works.size() ; i++)
        {
             if (works.get(i) == true) // Working!
             {
                 newTools.add(name.get(i));
             }
        }
        return newTools;
   }
  
   private static String tool(int idGiven)
   {
        int pos = id.indexOf(idGiven); // Gets the index of an element in the ArrayList
        return name.get(pos);
   }
  
   private static void print(String printString)
   {
        if (isScreenOutput) // If screen printing
        {
            System.out.println(printString); // print the string to console
        }
      
        if (isFileOutput) // If file printing
        {
            try
            {
                writer.write(printString); // write the string to the file
                writer.write("\n"); // Manually append a new line
            }
            catch(Exception e)
            {
                System.out.println("writer error");
            }
        }
   }
  
   public static void main(String[] args) {
        String opfile = "testop.txt";
      
       Scanner reader = new Scanner(System.in);
       int op;
       System.out.println("Enter command: ");
       op = reader.nextInt();
       try
       {
            writer = new FileWriter(opfile);
           while(op != -1) // Exit when the user inputs -1.
           {
                // Command is int value of the character in question. Eg. a->1, b->2, etc.
                switch(op)
                {
                    case 1:
                        load("tools.txt");
                        break;
                    case 2:
                        print("Total number of tools is " + numTools());
                        break;
                    case 3:
                        String toolName;
                        System.out.println("Enter tool name: ");
                        toolName = reader.next();
                        print("Number of records for " + toolName + " is " + numRecords(toolName));
                        break;
                    case 4:
                        float p;
                        System.out.println("Enter a price: ");
                        p = reader.nextFloat();
                        print("Tools > price: " + priceGreaterThan(p));
                        break;
                    case 5:
                        System.out.println("Enter a price: ");
                        p = reader.nextFloat();
                        print("Tools < price: " + priceLessThan(p));
                        break;
                    case 6:
                        int y;
                        System.out.println("Enter a date: ");
                        y = reader.nextInt();
                        print("Newer tools: " + dateNewerThan(y));
                        break;
                    case 7:
                        System.out.println("Enter a date: ");
                        y = reader.nextInt();
                        print("Older tools: " + dateOlderThan(y));
                        break;
                    case 8:
                        int y1, y2;
                        System.out.println("Enter a date range (y1 y2): ");
                        y1 = reader.nextInt(); y2 = reader.nextInt();
                        print("Tools between: " + dateBetween(y1, y2));
                        break;
                    case 9:
                        int idee;
                        System.out.println("Enter the id: ");
                        idee = reader.nextInt();
                        print("Age of the tool is " + age(idee));
                        break;
                    case 10:
                        int sf;
                        System.out.println("Enter shelf: ");
                        sf = reader.nextInt();
                        print("Tools on shelf: " + onShelf(sf));
                        break;
                    case 11:
                        int r;
                        System.out.println("Enter row: ");
                        r = reader.nextInt();
                        print("Tools in row: " + onRow(r));
                        break;
                    case 12:
                        int c;
                        System.out.println("Enter column: ");
                        c = reader.nextInt();
                        print("Tools in column: " + onColumn(c));
                        break;
                    case 13:
                        print("Working tools: " + working());
                        break;
                    case 14:
                        System.out.println("Enter the id: ");
                        idee = reader.nextInt();
                        print("Tool is " + tool(idee));
                        break;
                    case 15:
                        System.out.println("Enter op filename: ");
                        opfile = reader.next();
                        writer.close();
                        writer = new FileWriter(opfile);
                    case 16:
                        System.out.println("Enter 1 for true, 0 for false: ");
                        if (reader.nextInt() == 1)
                        {
                            isFileOutput = true;
                        }
                        else
                        {
                            isFileOutput = false;
                        }
                        break;
                    case 17:
                        System.out.println("Enter 1 for true, 0 for false: ");
                        if (reader.nextInt() == 1)
                        {
                            isScreenOutput = true;
                        }
                        else
                        {
                            isScreenOutput = false;
                        }
                        break;
                    default:
                        System.out.println("Enter correct command");
                        break;
                }
                System.out.println("Enter command: ");
                op = reader.nextInt();
           }
           writer.close(); // Always close the writer
       }
       catch(Exception e)
        {
            System.out.println(e);
        }
   }
}

............................................................................CODE ENDS HERE............................................................................

Sample output for a small file tools.txt I created just for demonstration:

tools.txt

Name id
...
knife 7 05/02/1958 920.0 Rubber 14 9 13 true
handsaw 593 19/05/1965 680.0 Aluminium 10 4 9 false

Command line output:

Enter command:
1
Enter command:
4
Enter a price:
60.5
Tools > price: [knife, handsaw]
Enter command:
4
Enter a price:
700.6
Tools > price: [knife]
Enter command:
13
Working tools: [knife]
Enter command:
-1

File output:

Tools > price: [knife, handsaw]
Tools > price: [knife]
Working tools: [knife]

..................................................................................................................................................................................

Feel free to ask any doubt or issue in the code and I'll be happy to help!