CIS355A Week 6 Lab Student Management System

Description

CIS355A Week 6 Lab Database Stocks4U Portfolio Management System
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.
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 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
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 as a SINGLE zip folder
all java files; and
the Lab report.
Follow assignment specification regarding class/method names.
Note that your Java file name must match class name (DO NOT rename).
SCREENSHOTS
SOLUTION
PAYMENT
The solution includes a zip file.
Attachments [Move over files to preview content of those files]
CIS355A_Week_6_Lab.zip (1.62 MB)
CIS355A-Week-6-Lab-Add-Student-Screenshot.jpg
CIS355A-Week-6-Lab-Display-Screenshot.png
CIS355A-Week-6-Lab-Exception-Screenshot.png
CIS355A-Week-6-Lab-Report-Screenshot.jpg
cis355a_lab_6_report.docx
Java code
GUI.java
Student.java
StudentDB.java
Netbeans project
CIS355ALab6
build
classes
.netbeans_automatic_build
.netbeans_update_resources
GUI.class
Student.class
StudentDB.class
build.xml
libs
com.mysql.jdbc_5.1.5.jar
manifest.mf
nbproject
build-impl.xml
genfiles.properties
private
private.properties
private.xml
project.properties
project.xml
src
GUI.java
Student.java
StudentDB.java
test
Preview GUI.java
}
@xxxxxxxxxxxxxxxx(“xxxxxxxxx”)
//
//xxx-xxxxx:xxxxxxxxxxxxxx
private void initComponents() {

nameLabel = new javax.swing.JLabel();
test1Label = new javax.swing.JLabel();
test2Label = new javax.swing.JLabel();
test3Label = new javax.swing.JLabel();
nameTextField = new javax.swing.JTextField();
test1TextField = new javax.swing.JTextField();
test2TextField = new javax.swing.JTextField();
test3TextField = new javax.swing.JTextField();
addButton = new javax.swing.JButton();
displayButton = new javax.swing.JButton();
xxxxxxxxxxxxxxxxxxxxxxxx(xxxxx.xxxxx.xxxxxxxxxxxxxxx.xxxx_xx_xxxxx);
xxxxxxxx(“xxxxxxx xxxxxx”);
xxxxxxxxx.xxxxxxx(“xxxx”);
Preview Student.java
xxxxxx xxxxxxx() {
}
// xxxxxxxxx xxxx xxxxxxxxxx
public Student(String name, double test1, double test2, double test3) { setName(name); setTest1(test1); setTest2(test2); setTest3(test3); }
public String getName() { return name; }
public void setName(String name) {
xxxx.xxxx = xxxx;
}
xxxxxx xxxxxx xxxxxxx1() {
xxxxxx xxxx1;
}
Preview StudentDB.java
xxxxxx xxxxx xxxxxxxxx {
xxxxxx xxxxx xxxxxx xxxx_xxxxxx = “xxx.xxxxx.xxxx.xxxxxx”;
xxxxxx xxxxx xxxxxx xx_xxx = “xxxx:xxxxx://xxxxx.xxxxx.xxx:4300/xxx355x_3210”;
// Database credentials static final String USER = “3210”; static final String PASS = “1234567890”; private static ArrayList
dbBackup = new ArrayList
();
public StudentDB() { dbBackup = new ArrayList
(); }
public static ArrayList
getAll() { Connection conn = null; Statement stmt = null;
xxxxxxxxx
xxxx = xxx xxxxxxxxx
();
xxx {
//xxxx 2: xxxxxxxx xxxx xxxxxx
xxxxx.xxxxxxx(“xxx.xxxxx.xxxx.xxxxxx”);
//xxxx 3: xxxx x xxxxxxxxxx
Preview GUI.java
}
@xxxxxxxxxxxxxxxx(“xxxxxxxxx”)
//
//xxx-xxxxx:xxxxxxxxxxxxxx
private void initComponents() {

nameLabel = new javax.swing.JLabel();
test1Label = new javax.swing.JLabel();
test2Label = new javax.swing.JLabel();
test3Label = new javax.swing.JLabel();
nameTextField = new javax.swing.JTextField();
test1TextField = new javax.swing.JTextField();
test2TextField = new javax.swing.JTextField();
test3TextField = new javax.swing.JTextField();
addButton = new javax.swing.JButton();
displayButton = new javax.swing.JButton();
xxxxxxxxxxxxxxxxxxxxxxxx(xxxxx.xxxxx.xxxxxxxxxxxxxxx.xxxx_xx_xxxxx);
xxxxxxxx(“xxxxxxx xxxxxx”);
xxxxxxxxx.xxxxxxx(“xxxx”);
Preview Student.java
xxxxxx xxxxxxx() {
}
// xxxxxxxxx xxxx xxxxxxxxxx
public Student(String name, double test1, double test2, double test3) { setName(name); setTest1(test1); setTest2(test2); setTest3(test3); }
public String getName() { return name; }
public void setName(String name) {
xxxx.xxxx = xxxx;
}
xxxxxx xxxxxx xxxxxxx1() {
xxxxxx xxxx1;
}
Preview StudentDB.java
xxxxxx xxxxx xxxxxxxxx {
xxxxxx xxxxx xxxxxx xxxx_xxxxxx = “xxx.xxxxx.xxxx.xxxxxx”;
xxxxxx xxxxx xxxxxx xx_xxx = “xxxx:xxxxx://xxxxx.xxxxx.xxx:4300/xxx355x_3210”;
// Database credentials static final String USER = “3210”; static final String PASS = “1234567890”; private static ArrayList
dbBackup = new ArrayList
();
public StudentDB() { dbBackup = new ArrayList
(); }
public static ArrayList
getAll() { Connection conn = null; Statement stmt = null;
xxxxxxxxx
xxxx = xxx xxxxxxxxx
();
xxx {
//xxxx 2: xxxxxxxx xxxx xxxxxx
xxxxx.xxxxxxx(“xxx.xxxxx.xxxx.xxxxxx”);
//xxxx 3: xxxx x xxxxxxxxxx
Price: $19
Buy Now
Checkout
Added to cart
Buy More Save More
Buy at least TWO items & save up to 30% OFF your ENTIRE order!
Rack up instant rebates in your shopping cart. Simply add items to your cart, and see the savings add up.
Discounts will automatically be applied on eligible orders.
CIS355A Week 6 Lab Student Management System – $15.00
CIS355A Week 7 Course Project Flooring Application User Manual and Application Code – $25.00
Add to Cart
Checkout
Added to cart
You May Also Like:
CIS355A Entire Course
CIS355A Week 6 Lab Database Stocks4U Portfolio Management System
CIS355A Final Exam Essay Questions
CIS355A Week 1 Lab Developing an OOP Console Application
CIS355A Week 2 Lab Developing a GUI Application
CIS355A Week 3 Lab BurgersRUs Point of Sale system
CIS355A Week 4 Course Project Flooring Application Analysis and Design
CIS355A Week 4 Lab Stocks4U Portfolio Management System
CIS355A Week 5 Lab File Processing Stocks4U Portfolio Management System
CIS355A Week 7 Course Project Flooring Application User Manual and Application Code