Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Java OBJECTIVES Programmatic access to a MySQL database to add and display records PROBLEM: Student Management System A teacher needs the ability to store and

Java

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

student name;

three test scores;

average; and

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, 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/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.

getAllreads data from database, returns data in an arraylist of student objects

addwrites 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 textboxes.

Display button will read the data from the database and creates a report in 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 24th International Conference Dexa 2013 Prague Czech Republic August 2013 Proceedings Part 1 Lncs 8055

Authors: Hendrik Decker ,Lenka Lhotska ,Sebastian Link ,Josef Basl ,A Min Tjoa

2013 Edition

3642402844, 978-3642402845

More Books

Students also viewed these Databases questions

Question

=+ Are ballots compulsory?

Answered: 1 week ago