Ask a Question

PRG 421 Week 5 Individual Assignment Coding a Program Containing JDBC

Regular price $10.00


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.

 

 

 

Questions & Answers

Have a Question?

Be the first to ask a question about this.

Ask a Question