JAVA. I have to do a class assignment, I am half way done. Help me finish with O

Question

JAVA. I have to do a class assignment, I am half way done. Help me finish with ONE of the JAVA classes undone. Class to be done: SortSearch

Assignment Summary:

Payroll system, sing Structured Query Language (SQL) to generate and maintain the tables, sort and search methods:

Work Design:

Classes

Main

SQL

SortSearch

Calculations

Print

Methods

Main

Runs the program with user input

SQL

Initialize: initializes the database.

                  SQL commands

AddTable: creates a table by reading a user command.

InsertRow: adds an instance to a table using a user command.

RemoveRow: removes a row from a table.

PrintResultSet: prints a resultset to the user.

SQL Tables to be used (employeeID will be used as KeyID)Employees:

employeeID, name, SSN, address, hourly pay rate

WeekHours:

employeeID, hoursWorked, weekNum

EmployeeTotals:

employeeID, totalGrossPay, totalFederalTaxes, totalMedicareTaxes, totalStateTaxes, totalNetPay

Checks:

employeeID, amount, grossPay, deductFederal, Medicare, stateTaxes

SortSearch ?????

WHAT METHODS CAN BE USED IN FOR SORTING AND SEARCHING SQL by USING JAVA?

             Calculation:

Gross Pay

Number of hours worked * hourly pay rate

State

Net Pay

Gross Pay - Total Taxes

           Print

PrintCheck: print paycheck to console.

PrintPayReport: print payroll reports to console.

Explanation / Answer

You can use SQL query to sort and search through java program

}

Related Questions

Navigate

• Browse (All)
• Browse J
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.