Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am in need of a Java program that integrates MySQL: Purpose: Build an application to calculate an Employees Gross Pay. Problem: Build an application

I am in need of a Java program that integrates MySQL:

Purpose: Build an application to calculate an Employees Gross Pay.

Problem: Build an application that would allow a person to calculate an Employees Gross Pay. The person will enter the employees name, regular hours worked, overtime hours worked and hourly pay rate. The program then calculates and displays the employees name and Gross Pay (see both inputs and outputs listed in the tables below).

Assumptions: Gross Pay = (Regular hours* pay rate) + (Over Time hours * pay rate *1.5) Regular hours are less than or equal to 40

Languages: Java, JDBC, MySQL

Steps:

1) Create Employee Table in MySQL

2) Insert Data into Employee table (See Table #1 for Input data)

3) Read Data from Employee table and process in Java

4) Create in java a report (either on screen or in a file ie. Report.txt)

image text in transcribedimage text in transcribed

Data Requirements Fields Data-T Employee Info First Name Last Name: Hours Worked Pay Rate Strin Strin Double Currency or Double Processes Process Data to calculate Gross Pay Output See Table #3 for output Advanced Insert data using java code Table I TOE Chart Task Obiect Event Get the following information from the user txtID None Student's ID Close window cmdClose Click Data Requirements Fields Data-T Employee Info First Name Last Name: Hours Worked Pay Rate Strin Strin Double Currency or Double Processes Process Data to calculate Gross Pay Output See Table #3 for output Advanced Insert data using java code Table I TOE Chart Task Obiect Event Get the following information from the user txtID None Student's ID Close window cmdClose Click

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inference Control In Statistical Databases From Theory To Practice Lncs 2316

Authors: Josep Domingo-Ferrer

2002nd Edition

3540436146, 978-3540436140

More Books

Students also viewed these Databases questions

Question

Define procedural justice. How does that relate to unions?

Answered: 1 week ago