Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Course ID: ACD37FA8E7624DEOB66345584B7B8350 CSCl 2469Lab6Pizza Store Backgraund For this ass gnment you'll write code to implement a pizza ordering system for a pizza store. Dowaload
Course ID: ACD37FA8E7624DEOB66345584B7B8350 CSCl 2469Lab6Pizza Store Backgraund For this ass gnment you'll write code to implement a pizza ordering system for a pizza store. Dowaload the starter Eclipse project from Blackboard. Unzip the project and import it into Eclipse. Stuoy the various files that comprise the projett. - Main.java - creates the ordering table in the database and then add sac rows to it representing the arder. Contains credentials for connecting, to the database. Check with your instructor to make sure the credentials are up ta date. - PizaOrder.java - class fer a pizza prde. - Pizzatapping.javi - enum far paza topaings - Pizat vpe.jars - enurn for pizza (crust) types - Pizcasize.java - enum lor pizza sizes - Pizastore.java - contains code for creating orcering table and inserting orders into the table. You will add your awn cadn here. Assigrrement You will complete the implementation of the Piezastore class. De the following: 1. Each student must have their cwn table for this lab in the Pizzastore database. The narne af your table will be based on your student e-mail address name if your email is ofenwickeesstudeot cscc.com set the value of 5 trine constant prefix to aftrinick2. When the program runs, it will create a table in the Pizzastare database narned afenwhek_ovaers. 2. Finish implementing the createordersTablelj methad. This method will first delete the orders table if it exists. It will then re create the table. This will allaw you to ruin the program multigle times with a fresh (empty) table each time. 3. Implement the placeOrderi'izindrder order] method. This method will take a PizzOrder as a parameter and create a corresponding row in the order table in the Pizzastore database. Use prepared statements in your code. When you uxecute the SQL get the number of rwws created and stare the number in the variahle nurnrows. Check numrows upon returrine to make sure that the method correctly created one row in the table. In the exception handling coce, be sure to print the exception methad and a stacktrace (see createOrtersTableli1. This will be useful for debueging your IDRC code. Upon eompletion, use the SLL Server Management Studid ta inspect pour thale and to verify that your pregram runs correctly Example Output Screenshot of SoL. Server Management Studio Copyright Notce: Columbus state Community College and its employees hold the copyright for this course material. This material is mades available to students for their persanal use valy and mily nat be tistributed far canmercial purpeses: without the College's express written corsent. Uploading this copgrighted material to "tutoring" or ather norr-Columbus State web sites is prohibited and may result in referral to the office of Stucent conduct and disciplinary action up to and induting dismissal. Adcitional infommation You will need to and a IDac driver to yeur project. Otherwise, you will get an expeption: Java.sol, Solexcertson: No suitahie deiver found for jolhe:sq1 spmer 1. Download the driver from Blackboard Assienment > Lab 5 2. Create a lib folder in your projent. Right-click an the project narne. Select New -> Folder- Type lib. 3. Cope the driver and paste it int the lib folder. 4. Pight-click on the project and select euild Path Coofigure Build Path 5. Select Llararies and then Classpath. Click on Add IAAs 6. Locate and select above jar file in lib folder and add to the Classpath pou can add multiple JARs to the path if required 7. Click Apply and Close To turn in your assignment, export pour Edipse project, zip the folder containing the project, and ugload the zipped file to Rlackboard for grading. Don't forget to include a ccmment in the code widh your name, date, and the purpose of the program
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started