- Description
PRG 421 Week 5 Individual: Week Five Coding Assignment
Resource:
“Starter Code to Access Tables via JDBC” text file
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:
PRG421_Week5CodingAssignment_LastnameFirstname.txt.
Submit your TXT file to the Assignment Files tab.