PRG 421 Week 5 Individual Assignment Coding a Program Containing JDBC//tutorfortune.com
PRG 421 Week 5 Individual Assignment Coding a Program Containing JDBC//tutorfortune.com Click on below link to buy https://tutorfortune.com/products/prg-421-week-5-individual-assignment-coding-a-program-containing-jdbc Resource: u2022t"Starter Code to Access Tables via JDBC" text file For this assignment, you will create Javau2122 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: u2022temployee_table: Emp idtFName tLNnametAddrtCitytStatetZip 100tJacktSmitht123 NorthtTopekat KSt66603 101tJoetApplet4 StreettDenvertCOt80202 111tNancytGoodt45 SWtHartfordtCTt06103 121tTomtWhatevert89 NEtDovertDEt19901 122tJimtThompsont789 W 95tAlbanytNYt12207 123tTommytBoysont154 BolttBostontMAt02201 125tJohntJonest47 WesttLincolntNEt68502 u2022tpayroll_table: Emp idtPayscht401ktSpouse 100tBiWktyestyes 101tBiWktyestyes 111tMonthlytnotno 121tWklytpendingtyes 122tWklytyestno 123tMonthlytpendingtno 125tMonthlytnotyes The credentials you will need to access the database which holds both of the tables are as follows: u2022tHost string = localhost:3306 u2022tUsername = student u2022tPassword = prg421 Copy and paste the linked Javau2122 "starter" code into the NetBeans editor and save as a JAVA file. Add Javau2122 statements to the file to accomplish the following: u2022tEstablish a connection to the database u2022tQuery the database, joining the two tables on the Emp_id field u2022tDisplay your name and today's date on the console along with the following returned database results: otemployee identification number otfirst and last name otstate otpayroll schedule ot401k plan u2022tClose 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: u2022tPRG421_Week5CodingAssignment_LastnameFirstname.txt. Submit your TXT file to the Assignment Files tab. Click on below link to buy https://tutorfortune.com/products/prg-421-week-5-individual-assignment-coding-a-program-containing-jdbc
★
★
★
★
★
38 views • 3 slides
