EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
9th Edition
ISBN: 9781337671385
Author: FARRELL
Publisher: CENGAGE LEARNING - CONSIGNMENT
bartleby

Videos

Expert Solution & Answer
Book Icon
Chapter 9, Problem 5PE

Explanation of Solution

Program:

File name: “SalespersonDatabase.java

//Import necessary header files

import java.util.*;

//Define a class named SalespersonDatabase

public class SalespersonDatabase

{

    //Define main method

    public static void main(String[] args)

    {

        //Create an array of objects

        SalesPerson[] salespeople = new SalesPerson[20];

        //Declare variables

        int x;

        int id;

        int count = 0;

        double sales;

        final int QUIT = 999;

        char option;

        String message = "";

        //Create an object for Scanner class

        Scanner keyboard = new Scanner(System.in);

        //Prompt the user to enter an option

        System.out.print("Do you want to (A)dd, (D)elete, or  (C)hange a record or (Q)uit >> ");

        option = keyboard.nextLine().charAt(0);

//While condition exists if option entered by the user is not equal to Quit

        while(option != 'Q')

        {

            //If option is to Add a record

            if(option == 'A')

                count = addOption(salespeople, count);

            //If option is to Delete a record

            else

            if(option == 'D')

                count = deleteOption(salespeople, count);

            //If option is to Change a record

            else

            if(option == 'C')

                changeOption(salespeople, count);

            //Invalid

            else

                //Print the result

                System.out.println("Invalid entry");

            //Prompt the user to enter an option

            System.out.print("Do you want to (A)dd, (D)elete, or (C)hange a record or (Q)uit >> ");

            option = keyboard.nextLine().charAt(0);

        }

    }

    //Define a method for add option

    public static int addOption(SalesPerson[] array, int count)

    {

        //Create an object for Scanner class

        Scanner keyboard = new Scanner(System.in);

        //Declare variables

        int id;

        double sales;

        boolean alreadyEntered;

        //Check if database is full

        if(count == array.length)

            //Print the result

    System.out.println("Sorry - array is full -- cannot add a record");

        //if database is not full

        else

        {

            //Prompt the user to enter the ID of the salesperson

            System.out.print("Enter salesperson ID >> ");

            id = keyboard.nextInt();

            alreadyEntered = false;

            for(int x = 0; x < count; ++x)

            //Check if ID number already exists

            if(array[x].getId() == id)

            {

                //Print the result

System.out.println("Sorry -- ID number already exists");

                alreadyEntered = true;

            }

            //Check if ID number does not exists

            if(!alreadyEntered)

            {

                //Prompt the user to enter the sales

                System.out.print("Enter sales >> ");

                sales = keyboard.nextDouble();

                array[count] = new SalesPerson(id, sales);

                //Increment the count

                ++count;

            }

        }

        //Display the database values

        display(array, count);

        keyboard.nextLine();

        //Return the value

        return count;

    }

    //Define a method for delete option

public static int deleteOption(SalesPerson[] array, int count)

    {

        //Create an object for Scanner class

        Scanner keyboard = new Scanner(System.in);

        //Declare variables

        int id;

        int position = 0;

        //Check if database is empty

        if(count == 0)

            //Print the result

System.out.println("Cannot delete - no records in database");

        //if database is not empty

        else

        {

            //Prompt the user to enter the ID of the salesperson

            System.out.print("Enter ID to delete >> ");

            id = keyboard.nextInt();

            boolean exists = false;

            for(int x = 0; x < count; ++x)

            //Check if ID number already exists

            if(array[x].getId() == id)

            {

                exists = true;

                position = x;

            }

            //if ID number does not exists

            if(!exists)

                //Print the result

System...

Blurred answer
Students have asked these similar questions
in C# Visual Studios Windows Form App (.Net Framework)   Population Database In the Chap12 folder of the Student Sample Programs, you will find a database file named PopulationDB.mdf. The database has a table named City. The City table has the following columns: (see image)   The City column stores the name of a city and the Population column stores the population of that city. The database has 20 rows already entered. Create an application that connects to the PopulationDB.mdf database and allows the user to perform the following: Use data-bound controls to add new rows to the database, change existing rows, and delete rows. Sort the list of cities by population, in ascending order. Sort the list of cities by population, in descending order. Sort the list of cities by name. Get the total population of all the cities. Get the average population of all the cities. Get the highest population. Get the lowest population.
Create a visitors application that prompts the user for the number of visitors each day for the past 5 days and then displays the average number of visitors per day. (use & to accept new value) Use PL/SQL Array  (NUMBER type basic composite array type )  and array has to have 5 members only.  The application output should look like same as following:   Test:  If you receive below numbers from user then your average should be 234. Display avarage on screen.   1:    150   2:    220   3:    180    4:    300   5:    320   The average number of visitors is:     234   Hint : Once you create  Array  DECLARE      TYPE    my_array_type  IS TABLE OF   number INDEX BY PLS_INTEGER;      v_n_array    my_array_type;   Then in the BEGIN and END block   accept new value for each array members.  DO NOT Use LOOP to accept new & as it is not design to get new value via loop..  Instead use separate 5 different &substitution value to get each values from user input   BEGIN…
True or FalseAn application works directly with a database, modifying rows, deleting rows, adding new rows, and so forth.
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
C - File I/O; Author: Tutorials Point (India) Ltd.;https://www.youtube.com/watch?v=cEfuwpbGi1k;License: Standard YouTube License, CC-BY
file handling functions in c | fprintf, fscanf, fread, fwrite |; Author: Education 4u;https://www.youtube.com/watch?v=aqeXS1bJihA;License: Standard Youtube License