Establish a connection to the database Query the database, joining the two tables on the Emp_id field Display yo
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:
- payroll_table:
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.
