'Coding assignment tutorfortune' presentation slideshows

Coding assignment tutorfortune - PowerPoint PPT Presentation


PRG 421 Week 5 Individual Week Five Coding Assignment//tutorfortune.com

PRG 421 Week 5 Individual Week Five Coding Assignment//tutorfortune.com

PRG 421 Week 5 Individual Week Five Coding Assignment//tutorfortune.com Click on below link to buy https://tutorfortune.com/products/prg-421-week-5-individual-week-five-coding-assignment PRG 421 Week 5 Individual Week Five Coding Assignment Resource: u201cStarter Code to Access Tables via JDBCu201d 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: 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 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 Javau2122 u201cstarteru201d code into the NetBeans editor and save as a JAVA file. Add Javau2122 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 todayu2019s 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. PRG 421 Week 5 Individual Week Five Coding Assignment Click on below link to buy https://tutorfortune.com/products/prg-421-week-5-individual-week-five-coding-assignment

48 views • 4 slides



PRG 421 Week 1 Individual Week One Coding Assignment//tutorfortune.com

PRG 421 Week 1 Individual Week One Coding Assignment//tutorfortune.com

PRG 421 Week 1 Individual Week One Coding Assignment//tutorfortune.com Click on below link to buy https://tutorfortune.com/products/prg-421-week-1-individual-week-one-coding-assignment PRG 421 Week 1 Individual Week One Coding Assignment Resources: u201cLesson: Object-Oriented Programming Conceptsu201d on The Javau2122 Tutorials website Downloadable starter code from the Oracleu00ae website: Bicyle class and BicycleDemo class For this assignment, you will modify existing code to create a single Javau2122 program named BicycleDemo.java that incorporates the following: An abstract Bicycle class that contains private data relevant to all types of bicycles (cadence, speed, and gear) in addition to one new static variable: bicycleCount. The private data must be made visible via public getter and setter methods; the static variable must be set/manipulated in the Bicycle constructor and made visible via a public getter method. Two concrete classes named MountainBike and RoadBike, both of which derive from the abstract Bicycle class and both of which add their own class-specific data and getter/setter methods. Read through the u201cLesson: Object-Oriented Programming Conceptsu201d on The Javau2122 Tutorials website. Download the linked Bicycle class, or cut-and-paste it at the top of a new Javau2122 project named BicycleDemo. Download the linked BicycleDemo class, or cut-and-paste it beneath the Bicycle class in the BicycleDemo.java file. Optionally, review this weeku2019s Individual u201cWeek One Analyze Assignment,u201d to refresh your understanding of how to code derived classes. Adapt the Bicycle class by cutting and pasting the class into the NetBeans editor and completing the following: Change the Bicycle class to be an abstract class. Add a private variable of type integer named bicycleCount, and initialize this variable to 0. Change the Bicycle constructor to add 1 to the bicycleCount each time a new object of type Bicycle is created. Add a public getter method to return the current value of bicycleCount. Derive two classes from Bicycle: MountainBike and RoadBike. To the MountainBike class, add the private variables tireTread (String) and mountainRating (int). To the RoadBike class, add the private variable maximumMPH (int). Using the NetBeans editor, adapt the BicycleDemo class as follows: Create two instances each of MountainBike and RoadBike. Display the value of bicycleCount on the console. Comment each line of code you add to explain what you added and why. Be sure to include a header comment that includes the name of the program, your name, PRG/421, and the date. Rename your JAVA file to have a .txt file extension. Submit your TXT file to the Assignment Files tab. PRG 421 Week 1 Individual Week One Coding Assignment Click on below link to buy https://tutorfortune.com/products/prg-421-week-1-individual-week-one-coding-assignment

24 views • 2 slides


View Coding assignment tutorfortune PowerPoint (PPT) presentations online in SlideServe. SlideServe has a very huge collection of Coding assignment tutorfortune PowerPoint presentations. You can view or download Coding assignment tutorfortune presentations for your school assignment or business presentation. Browse for the presentations on every topic that you want.