PRG 421 Week 5 Individual: Week Five Coding Assignment

0 items
PRG 421 Week 5 Individual: Week Five Coding Assignment
PRG 421 Week 5 Individual: Week Five Coding Assignment
$10.00
  • 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 idFNameLNnameAddrCityStateZip
100JackSmith123 NorthTopeka KS66603
101JoeApple4 StreetDenverCO80202
111NancyGood45 SWHartfordCT06103
121TomWhatever89 NEDoverDE19901
122JimThompson789 W 95AlbanyNY12207
123TommyBoyson154 BoltBostonMA02201
125JohnJones47 WestLincolnNE68502

  • payroll_table:

Emp idPaysch401kSpouse
100BiWkyesyes
101BiWkyesyes
111Monthlynono
121Wklypendingyes
122Wklyyesno
123Monthlypendingno
125Monthlynoyes

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.