UOP PRG421 Week 5 Coding Assignment Latest 2020
PRG421 Java Programming II
Week 5 Assignment
Coding Assignment
Instructions:
For this assignment, you will create Java™ code that accesses a relational database, requests data, and then analyzes and displays a portion of that data.
Imagine a MySQL relational database schema named COMPANY_DB containing two tables, employee_table and payroll_table, such that the records in each of the tables is as follows:
employee_table:
|
Emp id |
FName |
LNname |
Addr |
City |
State |
Zip |
|
100 |
Jack |
Smith |
123 North |
Topeka |
KS |
66603 |
|
101 |
Joe |
Apple |
4 Street |
Denver |
CO |
80202 |
|
111 |
Nancy |
Good |
45 SW |
Hartford |
CT |
06103 |
|
121 |
Tom |
Whatever |
89 NE |
Dover |
DE |
19901 |
|
122 |
Jim |
Thompson |
789 W 95 |
Albany |
NY |
12207 |
|
123 |
Tommy |
Boyson |
154 Bolt |
Boston |
MA |
02201 |
|
125 |
John |
Jones |
47 West |
Lincoln |
NE |
68502 |
payroll_table:
|
Emp id |
Paysch |
401k |
Spouse |
|
100 |
BiWk |
yes |
yes |
|
101 |
BiWk |
yes |
yes |
|
111 |
Monthly |
no |
no |
|
121 |
Wkly |
pending |
yes |
|
122 |
Wkly |
yes |
no |
|
123 |
Monthly |
pending |
no |
|
125 |
Monthly |
no |
yes |
The credentials you will need to access the database which holds both of the tables are as follows:
Host string = localhost:3306
Username = student
Password = prg421
Copy and paste the linked Java™ “starter” code into the NetBeans editor and save as a JAVA file.
Add Java™ statements to the file to accomplish the following:
Establish a connection to the database
Query the database, joining the two tables on the Emp_id field
Display your name and today’s date on the console along with the following returned database results:
employee identification number
first and last name
state
payroll schedule
401k plan
Close the database connection
Identify and correct any compile-time errors that exist in the starter code.
Note: Because you will not be connecting to an actual database, some compiler errors will remain.
After you finish, rename your JAVA file with a .txt extension using the following naming convention:
Having Trouble Meeting Your Deadline?
Get your assignment on UOP PRG421 Week 5 Coding Assignment Latest 2020 completed on time. avoid delay and – ORDER NOW
