COP 2800, Java Programming Assignment 12 (25 points)  You all have already created multiple tables and created records using Java codes

Subject:Computer SciencePrice:0 Bought3

Share With

COP 2800, Java Programming Assignment 12 (25 points) 
You all have already created multiple tables and created records using Java codes. Please write A Java Applications to do the following: 
• Show the content of the tables by using some "select query" statements — at least three different queries 
Be creative and you can decide on various query statement (at-least three different queries) 
Hint: Please go through all the lectures and you can use the examples as a template. You will have to also download the MySql database for completing the program. Please include your screen shots in the same document that you write your detailed Reflections and Challenges. 
You may have to create multiple programs. Make sure you upload screen shots of the working applications (ran program screenshots). You can use the class program templates but your program has to create different tables and insert at least 5-7 records and show result sets using select statements. 
Grade rubric: 
Legible screen shots of ran program 3 x 3 = 9 Program code file (.java) with detailed comments 10 Assessment/Reflection in detail 4 using technical terms and correct grammar Challenges 2 Total 25 
Submit your work in Assignment 12 folder. 
Purpose: The purpose of this assignment is to test your comprehension of putting together a Java program that uses a back end database — including creating database, inserting records, connecting to the database and running simple queries using Java program application. 

Also, please, add an assessment/reflection not to the program, but as written in a word document,. The assessment/reflection you can write about like what kind of  variables you used in this program?  
This would be an example of the assessment/reflection:  Assessment/Reflection:  In this program, I used double datatype to store the variables. Then created constructor to initialize the value ofa, while declaring antotateagagtp as static to be shared for all instance objects. Created gglflalfilgrgatvo to calculate the Monthly Interest created gSbig§05114000 method to return the balance after each monthly interest rate created Smaag,te, to modify the annflasite value. Finally created a program that contains the main method to test and run the methods by creating two instance objects and printing the results for both.