Create Java™ code that accesses a relational database, requests data, and then analyzes and displays a portion of that data.
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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:
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds