Create Java™ code that accesses a relational database, requests data, and then analyzes and displays a portion of that data.
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:
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
