Queen Essays

CIS355A Week 6 Lab—Database Connectivity

Objectives

· Programmatic access to a MySQL database to add and display records

Problem: Student Management System

A teacher needs the ability to store and retrieve student data. This includes the following.

· Student name

· Three test scores

· Average

· Letter grade

Functional Requirements

You can code the GUI by hand or use NetBeans GUI builder interface.

Create a GUI, which allows for input and display of student data.

It should include buttons to save a record and display all records.

Create a database and table to store student name and three test scores. (Note that average and grade are calculated by app.)

Student Class

Create a Student class to manage the student data. It should have private instance variables of

· student name; and

· three test scores.

The class must have the following methods.

· A default and parameterized constructor

· Sets and gets for all instance variables

· A get method to calculate and return the average

· A get method to calculate and return the letter grade

· toString to display the name of the student

StudentDB Class

Create a StudentDB class that is used to create a connection and interface with the database.

This class should have two methods.

· getAll—reads data from database, returns data in an arraylist of student objects

· add—writes a record to the database

GUI Class

Insert button will take the info from the GUI (student name and three test scores) and insert a record into the table. Input should be cleared from the text boxes.

Display button will read the data from the database and create a report in the console window, sample format below.

Name Test1 Test2 Test3 Avg Grade

Bruce Wayne 90 95 98 94.3 A

Clark Kent 65 70 90 75.0 C

Sample GUI

RUBRIC

Student class · It has all required functionality.	5
GUI class · Student record can be saved. · All student data can be displayed.	15
StudentDB class · Add method inserts a record into db. · Get method reads all records and returns an arraylist.	15
Code style	5
Total	40

Code Style Requirements

· Include meaningful comments throughout your code.

· Use meaningful names for variables.

· Code must be properly indented.

· Include a comment header at beginning of each file (example below).

/**********************************************************  Program Name: ProgramName.java  Programmer's Name: Student Name  Program Description: Describe here what this program will do  ***********************************************************/

Deliverables

Submit the following as a single zip folder.

· All Java files

Follow assignment specification regarding class and method names.

Note that your Java file name must match the class name (do not rename).

CIS355A Week 6 Lab Instructions Page 1

image1.png

,

CIS355

How to use MySQL Inside Azure DeVry University College of Engineering and Information Sciences

Preparation (has to be done before you start working on your query)

1. Login to your VM and open MySQLWorkbench.

Click MySQL Workbench

2. Close the welcome screen. Double-click on the local instance.

Click this.

3. Enter password devry123.

devry123

4. You are now inside your SQL editor and ready to create a new SQL schema (database). Click on the fourth icon to create a new schema.

Click the fourth icon to create a new schema.

5. When the window pops out, name your schema, then click Apply.

Name your schema here.

6. On the next review SQL script window, click Apply again.

Click

7. On the next applying page, click Finish.

Click

8. On your navigator window, you can now see your newly created schema.

Verify that your schema is created.

9. Click the first icon to create a new SQL tab for executing queries.

Click

10. Now we have the SQL editor ready for executing queries. Let‘s make sure we are working under the default schema. Right-click the schema to set it as default schema.

Set default schema first.

11. Now you are ready to write queries into the SQL editor window.

12. Execute the script by clicking the symbol

Click

Page 4 of 4

image1.png

image2.png

image3.png

image4.png

image5.png

image6.png

image7.png

image8.png

image9.png

image10.png

image11.png